Curious Case of SQL Server Shutting Down Whenever a Job Runs.

SQL Server case study of the week

This is a post in our new Case of the Week series — short write-ups from the real SQL Server issues our team of 17 SQL Server experts helps clients solve every day. Case of the Week: . Quick Summary A client reported that their SQL Server service was “randomly shutting down”. They would restart … Read more

SQL Server Partition Management Job Failure After Migration to Availability Group.

SQL Server case study of the week

This is the first post in our new Case of the Week series — short write-ups from the real SQL Server issues our team of 17 SQL Server experts helps clients solve every day. Case of the Week: SQL Server Partition Job Failure after Migration from AWS FCI to AWS AG. Quick Summary A client … Read more

SQL University – Troubleshooting Week

I was about to write another bunch of comments on why I think troubleshooting skills are important. I’ve changed my mind – I’ve done that before. So let’s start SQL University Troubleshooting week off with a couple reminders from past posts that say what I wanted to say this week already. If You Can’t Troubleshoot … Read more

Avoid Using Those Troubleshooting Skills

When I re-read yesterday’s blog post on troubleshooting steps, I felt guilty. Instantly. Why? Because I had failed to mention something to you in that post and failed to follow advice I just gave in my SQL Rally presentation. *In my own defense, I did mention that one of the bullets I used in that … Read more