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
Guidance on Query Optimization
I received this question from someone visiting the blog, and realized that rather than just replying to them, it might be good to put the… Read More »Guidance on Query Optimization
OUTPUT Clause with an insert statement
So often I run into examples where someone is inserting a row and trying to get one of the values from that row that was… Read More »OUTPUT Clause with an insert statement
Prize giveaway at the February webinar presentation
At our February webinar presentation on Database Corruption, Stedman Solutions will be giving away 3 daily checkup subscriptions one 3-month subscription, one 6-month subscription and… Read More »Prize giveaway at the February webinar presentation