Central Management Server Daily Script
These are scripts I run each morning on my registered CMS servers to check immediate health.
2012-06-04 (first published: 2012-05-09)
2,843 reads
Sandy Skaar
Security Audit Db_DataReader
Uses sp_MsForEachDb, locates members in db_datareader with permissions other than Select and Connect.
2011-04-14 (first published: 2011-03-29)
1,070 reads
Blogs
SQL Saturday Denver 2023–VCS Primer for the Database slides
By Steve Jones
My slides are here: VCS Primer Denver 2023 This was an overview of what...
Future Data Driven 2023 is This Week
By Steve Jones
The Future Data Driven 2023 virtual conference is coming on Wednesday, September 27. Register...
Opening the SQL Prompt Command Palette
By Steve Jones
A few years ago SQL Prompt added a command palette to let you search...
Forums
How to organize your wardrobe and make it maximum effective?
When I thought about how to organize my wardrobe, I couldn’t even think that...
How can you have a good rest?
To be honest, usually the ndb contains the amount that must be deposited. But,...
post steps for Table PARTIONING
Any one did Table partitioning in Prod, please list steps here. we have a...
Ask SSC