Yikes! Cannot recover the master database!
Recently, during patching for a 2019 SQL Server, the SQL services refused to start after the patching. It was throwing the following heart attack inducing error: Cannot recover the master …
PowerShell: Compare Users’ AD Groups
When it comes to user logins and permissions in SQL Server, I typically prefer to use Active Directory groups. The problem with that is that you don’t always know what …
SQL Server Crashes When Hitting 80 Percent RAM Usage
I recently ran into a situation where a new SQL Server would crash hard every time it would get under a load. Here is a synopsis of what we were …
SQL Scripts: How To Find A Database’s Compatibility Level
One thing that a lot of DBAs, especially Accidental DBAs such as myself, don’t seem to realize is that just because a database is sitting on a specific version of …
Generating A Database Snapshot For DBCC CHECKDB
Many people don’t realize that DBCC CHECKDB actually uses an internal database snapshot of the database to run the consistency checks on. (See the “Internal Database Snapshot” section of the …
SQL Scripts: How To Find Index Usage
This post is part of an ongoing SQL Scripts series, in which I list useful queries that I use in my day to day database administration. If you are interested in code …
SQL Scripts: How To Find Index Fragmentation
This is the first post in an ongoing SQL Scripts series, in which I list useful queries that I use in my day to day database administration. What Is Index Fragmentation? …
Fixing “Possible Date Calculation Spin For Schedule” Error
I recently ran into a strange error when trying to modify a SQL Agent job. This was an existing job that had been created a year or so ago, and …
Persist And Aggregate Index Stats Across Server Restarts
(This script is part of my SQL Server Metrics Pack project that is now available on GitHub. If you like the code below and find it useful, I encourage you to check …
Change The Isolation Level Of An Availability Group Database
I recently needed to change the Transaction Isolation Level of one of our databases in an Availability Group. As it turns out, this is not as straight forward as you …
Discover Which Deprecated Features Are Being Used
With each new release of SQL Server comes a list of new features, along with a list of features that have been deprecated. These deprecated features are not immediately disabled …