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
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
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