Multiple CTEs in a Query
The following is chapter 6 from my Common Table Expressions book in its entirety. READER NOTE: Please run the CTEBookSetup.sql script in order to follow along with the examples in… Read More »Multiple CTEs in a Query
February 2021
SQL Server – Backing up a database
If you are a pro at SQL server I am sure you already know how to backup a database, but for someone who is new… Read More »SQL Server – Backing up a database
Introduction to Database Corruption Full Presentation
Take a look at the video on our Youtube channel. After repairing dozens of corrupt databases over the last 6 years we are going to… Read More »Introduction to Database Corruption Full Presentation
New cumulative update for SQL Server 2017
Microsoft has just release an cumulative update for SQL Server 2017 CU 23. I am always interested in fixes to DBCC CHECKDB and DBCC CHECKTABLE.… Read More »New cumulative update for SQL Server 2017
Hierarchical Queries
Creating a SQL Server hierarchical query can be incredibly useful, but also very difficult without the right tools. The following is chapter 5 from my Common… Read More »Hierarchical Queries
NO DEK Update for File ID
Since installing SQL Server 2019 CU9, I have been getting lots of errors about NO DEK Update for almost every file. Here is an excerpt… Read More »NO DEK Update for File ID
CTE Book Sample Code
As part of the CTE book there is a sample database that all the queries use. You can download the create script for that sample… Read More »CTE Book Sample Code
Introduction to Corruption Slide Deck
The attached PDF is the slide deck for my Introduction to Corruption presentation from Feb 17th 2021. I hope you enjoyed the session.
Introduction to Database Corruption
We are 2 days away from the Introduction to Database Corruption free presentation. On February 17, 2021 at 6:00pm Pacific time we will be presenting… Read More »Introduction to Database Corruption
Recursive CTEs
The following is chapter 4 from my Common Table Expressions book in its entirety. READER NOTE: Please run the CTEBookSetup.sql script in order to follow… Read More »Recursive CTEs