2012-01-25 (first published: 2011-11-09)
1,259 reads
Jon McGhee
2010-04-30 (first published: 2010-04-26)
3,200 reads
ServerProperty query with case function
Returns all properties from ServerProperty, also has a case function for EditionID and EngineEdition.
2010-03-08 (first published: 2010-02-18)
1,243 reads
Blogs
Daily Coping 21 Jan 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Using dbachecks for CIS Security Checks
Well back at the end of 2019 I finished writing most of the checks...
How to tell if Change Data Capture (CDC) is working as expected
By DesertDBA
I’m not sure how many of you use Change Data Capture (CDC) on your...
Forums
List of all the Users who have Access to Schema of a Particular Database.
This Question is for an Azure PaaS Database. Does anybody has a Good Script...
Restore is not progressing at all . Please kindly help
Hi All , I need to restore database 1.2 TB .. bak files are...
Server Consolidation
Hello All, Our entire domain is on VM.The CPU's usage rarely goes above 20%.Is...
Ask SSC