2023-02-06 (first published: 2023-02-01)
749 reads
2023-02-06 (first published: 2023-02-01)
749 reads
2021-04-09
476 reads
This is a data quality script that locates unused Database Roles for maintenance purposes
2012-07-24 (first published: 2012-07-05)
1,380 reads
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
This is part of a series of new job blog posts. You can find...
By Will Assaf
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...
Back in December 2019, I started presenting my session on mental health with lots...
what I want is to apply some filter patterns to search the data. For...
Hi All, Using Tsql query I want to know currently running sql agent jobs...
Hi All, Want to know what are the SQL Agent Jobs scheduled for today...