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 to announce that the Indexing episode was released today, well at lease half of it. After we finished the recording, we realized that there was too much content to fit it in to our normal …
Podcast Episode – The Long Awaited Index Episode Read more »
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 Blob Storage”. Making use of good disaster recovery fundamentals and modern off-site storage, you will learn how to back up and restore a full database backup using Azure Blob Storage, even if your version of …
Bellingham SQL Server Users Group November Meeting Read more »
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. The Details 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 …
A year in review – The first year of Stedman Solutions, LLC. Read more »
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. Week 1 of the Database Corruption Challenge was won by Brent Ozar, his solution is posted here. Also there is an alternate solution provided by Andre Kamman. Week 2 of the Database Corruption …
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 …
Week 3 – Corruption Challenge – The Winning Solution Read more »