by Steve Stedman and the Stedman Solutions Team
Database Corruption vs Drive Failure Explained
Thu, 25 Mar 2021
If you don’t know the difference between server corruption and drive failure then this video is for you. It will all be explained in this quick 6 min video. Transcription: Steve Stedman 0:10Now, one of the things that when w Read more…
Possible Causes of Database Corruption – Video
Tue, 23 Mar 2021
Easy listen – 6 minute video describing possible server corruption scenarios that’s actually happened. Help yourself and avoid these mistakes. Presented by Steve Stedman and Derrick Bovenkamp. Transcription: Steve Stedman 0:03Now, imagine with this picture, if that was your fibe Read more…
Detecting Database Corruption – Video
Thu, 18 Mar 2021
You don’t have to be Sherlock Holmes to detect Server Corruption. Steve Stedman and Derrick Bovenkamp share valuable information on how to spot server corruption before the damage is irreversible. And we are always here for guidance or complete corruptio Read more…
Transactional Replication – is it keeping up?
Wed, 17 Mar 2021
Working with Transactional Replication with many of our SQL Server clients, one of the big questions that we are always asking is replication keeping up? Recently when deleting a few hundred million rows from a large table that is synce Read more…
Your Database is Corrupt – Here’s Your “Now What?” Video
Tue, 16 Mar 2021
Do you know what to do when corruption hits? You should watch this quick 10 min video first if you plan on fixing it yourself? Steve Stedman and Derrick Bovenkamp wants to save you from making a big mistake. I Read more…
SQL Daily Checkup – New Report Added
Sun, 14 Mar 2021
I added a new report to the daily monitoring email, showing the error log over time. What is interesting about this is that it is tracked by hour, so if there is something that changes on your system that suddenl Read more…
SQL Daily Checkup – News added
Sat, 13 Mar 2021
On the SQL Daily Checkup report I have added a new report section called news which we can use to show new features related to the daily checkup email. We provide monitoring tools that alert us when there is a Read more…
Preventing Server Corruption – Video
Thu, 11 Mar 2021
Anyone who’s experienced database corruption knows they do not want it to happen again. Corruption repair is stressful and could require money and downtime you can’t afford. In some cases, there is no “repair” just rebuild. Unfortunately, no database i Read more…
Query to Find Free Space on All Databases
Wed, 10 Mar 2021
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, but if you want to get it programmatically you can do it with the followin Read more…
Data Paging with CTEs
Sun, 07 Mar 2021
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 had to page through web site search results 20 at a time on a give Read more…
10 Year Anniversary of Database Health Monitor
Tue, 02 Mar 2021
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, how it’s evolved, why its useful and its plans for it in the future. G Read more…
February 2021 Blog Posts Wrap Up
Mon, 01 Mar 2021
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 database Sat, 27 Feb 2021 If you are a pro at SQL server I a Read more…