Category Archives: Troubleshooting

SQL University Troubleshooting Week: Having a Plan for Every Situation

Today’s SQL University post will highlight the need to have a methodology to address issues that we as IT professionals may encounter in the course of our day. We will start off by looking at why we need to have a plan for every situation, and then we will dig into a methodology that I have developed by stealing bits and pieces of other people’s approaches over my career. Continue reading

Posted in SQL University, Troubleshooting | Tagged , , | 5 Comments

SQL University Troubleshooting Week: Keeping an Open Mind

Having a good attitude is key to success in the information technology field. Keeping an open mind is central to that. By going with the flow and looking at issues from the right perspective we can solve problems faster while becoming known for our skill and professionalism. Continue reading

Posted in SQL University, Troubleshooting | Tagged , , | Leave a comment

SQL University Troubleshooting Week: Communication

It should come as no surprise that the first topic I am covering this week is communication because the first thing I think anyone should do is communicate that they are troubleshooting an issue. This post will cover why we should communicate then dig into how to put together an initial alert. The rest of the post will be spent talking about how to communicate updates and the resolution. Continue reading

Posted in SQL University, Troubleshooting | Tagged , , | 2 Comments

SQL University Troubleshooting Week: Syllabus

I am honored to close out the final week of the Spring 2011 semester with a topic that I really enjoy: Troubleshooting. I really enjoy solving problems and that has caused me to get pulled into many situations where I could use and develop my troubleshooting skills. I hope to share the things I have learned here this week to speed everyone along in the process, hopefully avoiding some of the pitfalls that I had along the way. Continue reading

Posted in SQL University, Troubleshooting | Tagged , , | Leave a comment

Stop Forgetting the DAC

We no longer have to blindly restart SQL, hoping that we are not setting up a situation where our most important database will be in recovery for minutes or hours. We now have the tools to accurately diagnose a problem the first time it happens. We just have to remember to use them. Continue reading

Posted in Troubleshooting | Tagged , , | 1 Comment

Can Deadlocks be Resolved by Adding an Index?

Can Deadlocks be Resolved by Adding an Index? Yes. Really, I’m not kidding. Here, I’ll show you how. Continue reading

Posted in Troubleshooting | Tagged , , , , , , , | 4 Comments