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 …
Corruption With Backup Compression And TDE In SQL 2017
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. …
Notes From A SQL 2017 Azure Install – Trace Flags
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 …
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 …
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 …
You Can Now Specify MAXDOP For DBCC CheckDB!
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: …
What Features Are Disabled Between Compatibility Levels In SQL Server?
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 …