Podcast Episode – The Long Awaited Index Episode
For a couple of months we have had requests on the SQL Data Partners Podcast to do an episode on indexing. It is my pleasure… Read More »Podcast Episode – The Long Awaited Index Episode
For a couple of months we have had requests on the SQL Data Partners Podcast to do an episode on indexing. It is my pleasure… Read More »Podcast Episode – The Long Awaited Index Episode
Bellingham SQL Server Users Group (Pass Chapter) – November 30th at 6:00pm. Features Presentation by Randolph West: “Back up and Restore your Database with Azure… Read More »Bellingham SQL Server Users Group November Meeting
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.
Lately several people have asked me for the solutions to the corruption challenge, so I thought it would be a good time to recap the last 7 weeks.
Find out more about the Week 3 Challenge on the overview blog post.
The winning solution, was submitted by Randolph West with the following steps:
I created a dummy database with the same name, set it offline, deleted the files, dropped in your LDF, brought it back online, and did a tail of the log backup with NO_TRUNCATE to bypass the error.
Then I followed a standard full restore with NORECOVERY, the three transaction logs you supplied, plus my tail, and set WITH RECOVERY to bring it into my shiny 2008 R2 instance.
Read More »Week 3 – Corruption Challenge – The Winning Solution