2023-07-12
395 reads
Database Roles
2023-02-06 (first published: 2023-02-01)
876 reads
2021-04-09
482 reads
Finding Unused Database Roles
This is a data quality script that locates unused Database Roles for maintenance purposes
2012-07-24 (first published: 2012-07-05)
1,412 reads
Retrieving SQL Server Fixed Database Roles for Disaster Recovery
We ran into a case recently where we had the logins and users scripted out on my SQL Server instances, but we didn't have the fixed database roles for a critical database. As a result, our recovery efforts were only partially successful. We ended up trying to figure out what the database role memberships were for that database we recovered but we'd like not to be in that situation again. Is there an easy way to do this?
2011-02-23
3,104 reads
Blogs
SQL Server Wait Stats
By Kevin3NF
Everything in SQL Server is waiting for something…this is by design. And most people...
FabCon 2025 Recap
By DataOnWheels
Hey fellow data friends! Wow, March was an absolutely crazy month (in the best...
Privacy Policy
We value your privacy. This policy explains what personal data we collect and why. What...
Forums
Why would using a variable vs Hard Value impact a Query's Performance
Why would using variables in place of hard coded numbers impact a query's performance? ...
XML data import with poor stored procedure performance (needs optimization)
Hello SSC! I have been tasked with optimizing a stored procedure the imports data...
Trouble accessing hidden XML download link on Blazor-based government site
Hey everyone, I'm trying to access an XML file download from a government website...
Question of the Day
Importing Flat Files
What types of sources can be used with the Import Flat File Wizard in SQL Server Management Studio (SSMS)?
See possible answers