To Kill a SPID or Not To Kill a SPID
October 24, 2025
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
Temptation – When The Cloud Looks Like Heaven (but isn’t…)
October 21, 2025
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
Curious Case of SQL Server Shutting Down Whenever a Job Runs.
October 17, 2025
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
Updates and improvements to sp_CheckSecurity
October 15, 2025
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
SQL Just Stops When Running OPENROWSET Query
October 15, 2025
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
SQL Server Backups and the Illusion of Safety: Confusion
October 14, 2025
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
SQL Server Partition Management Job Failure After Migration to Availability Group.
October 10, 2025
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
Joining Straight Path Solutions as Chief Data Officer
October 10, 2025
Recently, I announced that after almost 20 years at Microsoft, I was moving to a new company and role. I’ve been in the Information Technology industry for over 40 years, and I believe that experience, combined with the various companies, organizations, and roles I have held, has led me to this place. Why Straight Path … Read more
The Age of Data Advocates Has Begun
October 7, 2025
I watched Bob Ward demo vector search in SQL Server at the NYC PASS road show in late August, and I have a confession that I’m not proud of. I felt that little knot in my stomach that every DBA knows too well. His pre-recorded PowerPoint videos typed a few commands, asked questions in natural … Read more
Our Next Chapter – Welcoming Buck Woody and Launching CDO as a Service
October 6, 2025
You can also read from Buck in his own words in this post, published here. “Oh, hi, don’t mind us – we’re just having a little conversation about SQL Server. I’m so glad you can join us. There are seats up front here…” That was the first time I ever heard words from Buck Woody … Read more