Blog Archives

Database Health Monitor version 2.1 Just Released

I have just released version 2.1 of Database Health Monitor, this release involved 2 months of development since version 2.0 was released in July. People often times ask me if this is free, or free to use in production, or

Posted in Uncategorized Tagged with: , , , , , , ,

DBCC CheckDB All Databases

If you use the SQL Server maintenance plans to run DBCC Check DB, you are not allowed to include TempDB in your DBCC CheckDB sequence. For a while I was using maintenance plans, and ending up adding a separate job

Posted in Uncategorized Tagged with: , , ,

Blog hosting trouble while on vacation

This last weekend I went on vacation to the San Juan islands for 4 nights. Our annual family trip to the islands for some good family time, and fishing. Here are some photos from the trip.    

Posted in Uncategorized Tagged with: ,

Website Outage

Last night my website (this site) experienced an outage. Sometime during the night the Mysql process hosting my WordPress website crashed. Too bad there isn’t a WordPress solution that uses a SQL Server database. Things are back now, and the

Posted in Uncategorized Tagged with:

System Outage… How do you communicate with your customers?

While watching a movie tonight, the Amazon Prime video system had an outage, no Amazon videos would play on my Amazon Fire TV Device. Netflix and Hulu worked fine, other internet traffic worked fine, just no Amazon Prime videos. After

Posted in Uncategorized Tagged with: , ,

TSQL JOIN Types Poster (version 4.1)

After someone reported a small bug in the “two INNER JOINs” diagram, I have created an update to the poster. This is update 4.1, only a minor version upgrade due to only a small change. The think I love about

Posted in Uncategorized Tagged with: , , , , , , ,

Database Corruption Challange 6 – Coming Soon

Hello everyone, the last week I have not been able to keep everyone as up to date on the Database Corruption Challenge as I would like to. Life has just turned really busy in the last 10 days, but I

Posted in Uncategorized Tagged with: ,

Week 5 – Alternate Solution

Here is how I solved Week 5 of the Database Corruption Challenge. The following steps were tested and confirmed working on SQL Server 2008R2, SQL Server 2012, and SQL Server 2014.   To oversimplify, here are the steps: Restore the

Posted in Uncategorized Tagged with: , , , , , ,

Week 5 – Winning Solution – Database Corruption Challenge

Find out more about the Week 5 Challenge on the overview blog post. The winning solution, was submitted by Patrick Flynn, just 3 hours and 18 minutes after the challenge was posted. Patrick provided me with the following steps, and TSQL

Posted in Uncategorized Tagged with: , , ,

An Awesome Day at SQL Saturday Redmond

Yesterday was SQL Saturday Redmond. It was a great day, I learned lots, met some great new people, and had a chance to catch up with some old friends. When most people hear about SQL Saturday for the first time,

Posted in Uncategorized Tagged with: , , , ,

SQL Server Performance Tuning

Need help with SQL Server Performance Tuning, contact Steve at Stedman Solutions, LLC for help, or take a look at the performance tuning page at the blog. We can help with tuning a single query or with figuring out why your SQL Server is running slow. Free 30 minute consultation.

Newsletter Signup

Stay informed of Database Corruption Challenge events, and other things happening at with my newsletter.
Newsletter signup form.

Stedman Solutions