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… Read More »New Course – Preparing for Corruption in SQL Server
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… Read More »Database Corruption Challenge
This week I completed another successful corruption repair. Here is what the client had to say when the database was repaired: Stedman Solutions were… Read More »Another Successful Corruption Repair
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… Read More »Corruption Repair Complete
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… Read More »Database Corruption Presentation at Pass Summit 2017
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… Read More »Podcast Episode 90: DBCC CheckDB
What 2015 meant to me and my business. Stedman Solutions, LLC – Startup After unexpectedly leaving a regular full time employment position on March 31st… Read More »2015 Review
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 many I/O reads or writes were caused by your query? With Statistics IO and Statistics TIME you can understand both of these.
This post is on using statistics TIME to analyze query performance. There is another post on using Statistics IO for performance tuning.
Another SQL Server Performance Tuning Tip to help you better understand performance bottlenecks.
This is a simple step to get performance statistics on about any query you are writing in SSMS.
Let’s take the following query as an example:
Read More »Using Statistics Time for Performance Tuning in SSMS
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 had to make it more difficult than the others, so I added 3 different types of corruption. This challenge was about the equivalent of any 3 of the other challenges.
I have split the solution to the Week 10 Challenge into 3 different posts, with each post explaining how to fix one of the three specific corrupt areas.
WARNING: DBCC WritePage is a dangerous command, that should never be used on any production database. It may invalidate your ability to get support from Microsoft on issues that arise with that database going forward. It is not my intention to encourage anyone to use DBCC WritePage ever. This is just what I used to create a corrupt database, and since creating corrupt databases is not part of the role of most DBAs, you should not use DBCC WritePage. Consider yourself warned.
Read More »Solution to Week 10 Part 1 Database Corruption Challenge
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 interview is Patrick Flynn.
Patrick placed in third with a 3 way tie for third overall in the the Database Corruption Challenge scoring 21 points.
Here are the overall statistics for Patrick in the Database Corruption Challenge
Read More »Patrick Flynn Interview – Database Corruption Challenge