Quick Summary We received an on-call call from a client who was attempting to run a failover from on a SQL Server Failover Cluster Instance to another but the failover wouldn’t move to the secondary. They tried things, were using the things we had taught them about failing over for their patching or for other … Read more
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 SQL … Read more
Sometimes people install Office onto a SQL Server to get the drivers for the ability to import data from Excel into SQL Server Tables. This should never be done on a production, or any, server because it can cause many other problems for SQL, one of which is the purpose of this blog. For example, … Read more
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
The best EMTs and Medics are the ones who realize, “This isn’t my emergency,” early enough. You’ll be a better DBA or technologist the quicker you learn the freedom that comes from that line of thought. (Also, a warning – in this post, I talk about – in vague terms and no medical specificity about … Read more
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
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