dbatools Command Failing: “The Parameter is Incorrect”
October 31, 2025
This week’s case of the week post comes from Jack Corbett. Quick Summary When attempting to use Copy-DBACredential in dbatools, I received the error “The parameter is incorrect,” yet other commands connecting to the same servers worked. Context I was working with a client to do an upgrade/migration from SQL Server 2016 to SQL Server … Read more
Hyper-V and SQL Server Best Practices: What We Wish You Knew
October 29, 2025
If you’ve ever asked yourself, “Why does my SQL Server seem slower on Hyper-V than it should be?!”, this post might help. And if you asked me about Hyper-V ten years ago, I’d probably have laughed. Maybe even less than that. But here’s the thing: it scales, it works, and with the Broadcom/VMware “fun” squeezing … Read more
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