We Sell Green Checkmarks
Our consultants are SQL Server experts who can solve your SQL Server problems and keep them from coming back.
“Database management has never been this easy. The Straight Path team is full of SQL Server database gurus who can help you speed it up, sort it out or set it up right. Client satisfaction has increased because problems are solved and workflows are positively impacted. As a result, I am sleeping like a baby knowing our databases are being watched and managed diligently by our SQL Server consulting team. I don’t know what we’d do without them.”
– Dean Tammam, Red Key Solutions
SQL Server Consulting Services
DBA as a Service
Remote, senior DBAs and SQL Server consultants are on your team, not your payroll. 15-minute P1 SLA. Priced per hour, not by instance.
sp_check – Free SQL Server Resources
Our SQL Server consultants have developed a set of community tools that help keep your SQL Server secure and healthy. They’re free, easy to use, and ungated. We use them in our own consulting engagements – you can use them also.
Learn MoreSQL Server Blog Posts
Should a SQL Server DBA Know Windows Clustering?
November 5, 2025
Should a SQL Server DBA know how a Windows cluster works, and or how to create a Windows cluster, or troubleshoot a cluster? Or should we, as DBAs, stay in our lane? In some organizations, a line is drawn between what a DBA can and can’t do and the System Administrator (SA) has the Infrastructure … Read more
Good, Clean, Fair: It’s Time for a Slow Data Movement
November 3, 2025
When you sit down at Rick Bayless’ Topolobampo restaurant, you aren’t rushed into a menu. Instead, you start on a narrated journey. You hear about Chef’s own experience of Mexico. You are told and can read about that journey. As you go on this vicarious journey, it’s brought to life before you with each thoughtfully … Read more
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