Blog Archives

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: , , , , , , ,

Week 6 – Database Corruption Challenge

Welcome to the Week 6 Corruption Challenge.  If you have seen the t-shirt that I designed for the winner at the end of the 10 week period, please take a look.   For this challenge, any version of SQL Server

Posted in Corruption 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: , , , , , ,

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: , , , ,

When Corruption Strikes – Online Presentation Wed May 13th

On Wednesday May 13th I will be presenting to the PASS DBA Virtual Chapter Meeting, at Noon Mountain time (convert to your time zone). The session is titled “When Database Corruption Strikes“, and the event has been sponsored by Dell Software

Posted in Corruption Tagged with: , ,

TSQL JOIN Types Poster (Version 4)

So many times I have been asked for help with a query, where the question really comes down to the understanding of the difference between INNER and LEFT or RIGHT JOINs. I created this poster a few years ago and

Posted in TSQL Tagged with: , , , , , , ,

Stedman Solutions: Remote, Skilled DBA Services

Do you need some help with your SQL Server, but perhaps don’t need another full time DBA? Do you need some help to cover your DBA being out on vacation? Do you need help assessing the health of your SQL

Posted in Corruption Tagged with: , , ,

Bellingham SQL Server Users Group – May 20th

The Bellingham SQL Server Users Group will be having its next meeting on May 20th at 6:00pm. This is free event for the local SQL Server community. What is the Bellingham SQL Server Users Group? PASS Chapters are local user

Posted in Corruption, PASS Chapter Tagged with: , , , , ,

TSQL – Change Data Capture

You have a need to keep track of all insert, update and delete actions on a table, or multiple tables. As you consider solutions, you might think about using a trigger, however triggers have their own baggage. You consider using

Posted in 70-464 Training Tagged with: , ,

Deadlock and Trace Flags 1204 and 1222

When you are looking for deadlocks there are, like most things in SQL Server, more than one way to find the deadlocks. This article is specifically focused on using the SQL Server ERRORLOG file located in the LOG directory for

Posted in DBA Tagged with: ,

Newsletter Signup

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

Stedman Solutions


Common Table Expressions Book