Query to Find Free Space on All Databases
Occasionally you need to take inventory of how much free space each database has. You can find this quickly and easily in Database Health Monitor,… Read More »Query to Find Free Space on All Databases
Data Paging with CTEs
The following is chapter 7 from my Common Table Expressions book in its entirety. I can remember the first time that I worked on data paging code. I… Read More »Data Paging with CTEs
10 Year Anniversary of Database Health Monitor
Steve Stedman and the Stedman Solutions Team celebrate the 10 year anniversary of Database Health Monitor. Kiana talks to Steve about this tool he built,… Read More »10 Year Anniversary of Database Health Monitor
February 2021 Blog Posts Wrap Up
Here’s a quick and easy link to review all blog posts written by Steve Stedman in February 2021. Enjoy! SQL Server – Backing up a… Read More »February 2021 Blog Posts Wrap Up
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
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