Blog Archives

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 Saturday Redmond

I am attending and speaking at SQL Saturday Redmond today. My presentation is at 2:45pm and on SQL JOIN Types,  and the following topics will be covered: —Basic SELECT —INNER JOIN —LEFT OUTER JOIN —RIGHT OUTER JOIN —LEFT OUTER JOIN

Posted in Uncategorized Tagged with:

A Query Walks Into A Bar

Posted in Uncategorized

MySQL JOIN Types for LinuxFest Northwest

Today I had the opportunity to present at LinuxFest Northwest on MySQL Join Types, using the MySQL JOIN Types poster in the presentation. It was a good session, about 30 people in attendance. Lots of great questions were asked. Here

Posted in Uncategorized

Another Corruption Challenge This Weekend.

As the weekend approaches and we head for another Database Corruption Challenge (DBCC) I want to remind everyone who is interested of being notified of the next event to sign up for my newsletter. Just click here to find out

Posted in Uncategorized Tagged with:

Introducing Stedman Solutions, LLC.

As of today, March 31st 2015, I am off on a new adventure in my life. As of today I am 100% focused on my new business. Here are the details. FOR IMMEDIATE RELEASE: Stedman Solutions, LLC. To Offer SQL

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

FULL OUTER JOIN vs CROSS JOIN

As I have been working on the SQL Server JOIN Types poster, I have received several questions around the difference between a CROSS JOIN, and a FULL OUTER JOIN. After looking at the Venn diagrams for the two, they are

Posted in Uncategorized Tagged with: , , , ,

Newsletter Signup

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

Stedman Solutions

StedmanSolutionsRemoteSkilledDBA

Common Table Expressions Book

Paperback:

Kindle: