Corruption in a SQL database is when the database becomes damaged or corrupted, making it unable to be used or accessed. This can happen for a number of reasons, such as hardware failure, software bugs, or even human error. When …
New Course – Preparing for Corruption in SQL Server Read more »
In 2015, around the time I started Stedman Solutions LLC, I created the Database Corruption Challenge as a way to share knowledge of how to repair corrupt databases and to provide options to running REPAIR_ALLOW_DATA_LOSS. Today the lessons from the …
This week I completed another successful corruption repair. Here is what the client had to say when the database was repaired: Stedman Solutions were no less than amazing! We were in a major bind; we had corruption in a …
This weekend the Stedman Solutions team had the opportunity to help a new client repair their corrupt database. By Sunday evening we had their database completely recovered and up and running. I certainly didn’t get enough sleep over the weekend, …
Today I had the opportunity to present on Database Corruption at the PASS Summit 2017 conference. You can download the presentation as a PDF here: Summit 2017 Corruption.pdf Here is the agenda from the corruption presentation. What is Database Corruption Causes …
Database Corruption Presentation at Pass Summit 2017 Read more »
This weeks episode of the is Episode 90 released today. Episode Quote “I would say that the bigger issue is probably going to be something like snapshot space for your disk” “When the rubber hits the road I’m still running …
What 2015 meant to me and my business. Stedman Solutions, LLC – Startup After unexpectedly leaving a regular full time employment position on March 31st 2015, the very next day April 1st 2015, Stedman Solutions, LLC was launched. Looking back, …
Statistics IO and Statistics Time are another SQL Server Performance Tuning Tip to help you better understand performance bottlenecks. Have you ever wanted to know exactly how long it took for a query to run? Have you ever wondered how …
Using Statistics Time for Performance Tuning in SSMS Read more »
If you are looking for more info on the corrupt database with Week 10 of the Database Corruption Challenge, you can take a look at the week 10 Challenge Details. With this being the final competition of the Database Corruption Challenge, I …
Solution to Week 10 Part 1 Database Corruption Challenge Read more »
After 10 weeks (or almost weekly) of corrupt databases, missing data and a challenging competition the Database Corruption Challenge finally comes to an end. As part of the last week of the challenge I created a short blog interview for the participants. This …
Patrick Flynn Interview – Database Corruption Challenge Read more »