Using DATABASEPROPERTYEX to Find Last Good DBCC CHECKDB Time
For decades, a pain point for SQL Server administrators has been determining when the last known DBCC CHECKDB was run against a database.
For decades, a pain point for SQL Server administrators has been determining when the last known DBCC CHECKDB was run against a database.
The SQL Vulnerability Assessment (VA) feature in now available in SSMS (SQL Server Management Studio)!
In this post I will show you how to audit SQL Server jobs. If anyone adds, deletes, or modifies a job you can track who did what, and when.
I did not think it was possible to view the contents of a BACPAC file. However, last month while at SQL Bits I was reminded about this one weird trick to view the contents of a BACPAC file.
It is perfectly valid for a DBA (or their manager) to assign KPIs to the servers and databases they administer. KPIs are unique for every shop, and for every role.
I will be presenting at SQL Konferenz in Darmstadt, Germany next month. If you are in, or near, Darmstadt in February I hope you take the time to join us at SQL Konferenz!