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
CTEs Instead of Derived Tables
The following is Chapter 3 from my Common Table Expressions book it its entirety. CTEs Instead of Derived Tables One time I was handed an… Read More »CTEs Instead of Derived Tables
SQL Daily Checkup service… What is it?
SQL Daily Checkup from Stedman Solutions, LLC. We provide monitoring tools that alert us and you when there is an issue so that we can… Read More »SQL Daily Checkup service… What is it?
SQL Configuration Manager Missing
On a number of recent installs of SQL Server that I have worked on, I have noticed that the SQL Configuration Manager has been missing… Read More »SQL Configuration Manager Missing