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 …
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 …
Don’t miss my upcoming IDERA Geek Sync, How To Be The DBA When You Don’t Have A DBA, this Wednesday, March 17, 2021. This webinar is for the “Accidental DBA”: …
In the war over Identities vs GUIDs as clustered indexes, one of the arguments in favor of Unique Identifiers is that you may run out of numbers when using a …
This post is more of an FYI, and to remind myself in case I run into it again down the road. Here at work we have a very large, very …
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 …
Last week I spent a good bit of time dealing with a corruption issue, and as it turns out I may actually have found a bug in SQL Server 2017. …
Like most Database Administrators, I have a standard set of Trace Flags that I implement on my SQL Servers. These are my tried and true trusty companions, used to help …
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 …
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 …
I just stumbled on this today. According to the DBCC CheckDB documentation, as of SQL Server 2014 Service Pack 2 you can now specify MAXDOP when running DBCC CheckDB! The documentation states: …
Have you ever wondered what features may or may not be available when your database is running in a different compatibility level than your SQL Server version? I recently came …