TempDB – Do This and Don’t Do That
Today I am presenting my “TempDB – Do This and Don’t Do That” session at SQL Saturday Redmond. Here is the download of the presentation… Read More »TempDB – Do This and Don’t Do That
Today I am presenting my “TempDB – Do This and Don’t Do That” session at SQL Saturday Redmond. Here is the download of the presentation… Read More »TempDB – Do This and Don’t Do That
The TL;DR summary: Life is good, business is good, and I am loving it. Ready to roll with Year 2 of Stedman Solutions, LLC.

It has been an interesting year. I officially formed the business about 3 years ago, but never worked at it regularly until April 1, 2015. Prior to April 1, 2015 had a full time position at a company in Bellingham.
My long term plan had originally been to go full time at Stedman Solutions, LLC in June of 2016 at which point my wife would have completed her schooling to become a nurse, and we would have had some additional family income to help while I got things rolling with Stedman Solutions, LLC.
In life, things don’t always work the way you plan. At the end of March 2015, my full time position came to an end due to what the company called a “lay-off”, one person in the lay-off, that’s me. I learned later that the employees there had been told by management that I had left of my own accord. Can you smell something fishy with that? Things are awesome today, and I am so glad every single day that I no longer work there.
So there I was March 31th, 2015 in a position felt much like that of a historic military leader who burned the ships after landing on the shore to prevent the troops from retreating. The point of no return, I was all in (or out depending on the perspective). I knew what I wanted to do, but I certainly wasn’t entirely ready; no business structure, no marketing plan, and no client leads. That was a very scary point in time, but I knew what I wanted to do, I was going to be an independent consultant focused on SQL Server.
With my 25 years of SQL Server database and programming background, at that point in time I was certainly up to the challenge technically. I was an overly skilled self-proclaimed consultant with no clients.
Read More »A year in review – The first year of Stedman Solutions, LLC.
It can be a bit time consuming to work through the the SQL Server Management Studio (SSMS) user interface to check on the agent job… Read More »TSQL Script to Display Agent Job History
Back in 2012 when I was writing my Common Table Expressions book, I came up with the following CTE in a function to split a… Read More »CTE to Split a String in a function SplitString
The check for excessive sysmaintplan_logdetail has be added to the Database Health Monitor – Quick Scan Report. If you haven’t had a maintenance plan to clean… Read More »SQL Server – sysmaintplan_logdetail
The check for Cost Threshold for Parallelism check has be added to the Database Health Monitor – Quick Scan Report. The Cost Threshold For Parallelism setting in… Read More »SQL Server – Cost Threshold For Parallelism
With the updated release of Database Health Monitor yesterday, here is the updated list of documentation on the Quick Scan Report. All of the following… Read More »Database Health Monitor Quick Scan Report
The check for MAX DEGREE OF PARALLELISM has be added to the Database Health Monitor – Quick Scan Report. The max degree of parallelism setting… Read More »SQL Server MAX DEGREE OF PARALLELISM
With over 7500 downloads worldwide to date, I have just released the next installment of the FREE Database Health Monitor application.
Here what one person had to say about it “Excellent – It’s the first tool I open every morning to see what is going on in my production environment! Thanks for the great work!”
Download today:
Released March 20th, 2016.
It has been about 3 months since the last release, and I have added several new features, and many bug fixes.
Today I released another beta release of SchemaDrift. Part of this release was some redesign of the main screen, as shown here. I had some great… Read More »Beta release 1.2 of SchemaDrift – the database schema comparison tool