Quick Summary We received an on-call call from a client who had noticed something was running slowly over the weekend and decided to issue a KILL command. The KILL command did what it does – it started the KILL/ROLLBACK process. They had done that once or twice before, they thought, and didn’t remember it taking … Read more
A heaven? A gateway? A hope? Let’s continue the SQL Server Regrets series… The planned next post was about the cloud anyway, my reminder for this post was the really long day a lot of tech folks relying heavily on AWS experienced today… Another cloud-based DNS related outage/wave of interruptions. A heaven….. A hope?- Someone … 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
It’s been a while since we made some improvements to the public version of sp_CheckSecurity, but internally we’ve been busy fine tuning checks and adding even more to discover potential vulnerabilities in your SQL Server instances. Today we’re announcing a new version that includes additions, corrections, and a few other adjustments that should be helpful. … 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
With the recent data center fire and missing government data in South Korea, it felt like a good time to continue with the SQL Server Regrets series of blog posts. We’ll talk about the confusion of thinking you are covered for recoverability – when you just aren’t. This “Regret” comes up far too often when … 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