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
SQL Server Case of the Week: Windows Server 22 Update Possibly Breaking SQL Agent & SSIS Packages
January 9, 2026
We started receiving alerts that a client’s SQL Server Agent was not running. Upon further investigation, we found that the server was recently restarted after Windows updates were applied. While reviewing the installed updates, we encountered an issue with KB5071547 on Windows Server 2022. After some troubleshooting, which included trying to start the agent from … Read more
A Look at the Straight Path Ahead
January 7, 2026
I have been wavering for two weeks between one big, Walsh-sized, long post trying to wrap up our 2025 and talk a bit about the early tea leaves for 2026 and beyond, and two separate posts. But this will be fun – I’m going to try and sum up a year and talk about some … Read more
T-SQL Tuesday #193 – Notes To Ourselves (Recap Post)
January 6, 2026
I didn’t participate this year – but I would probably have something to say learn more about the cloud, spend a lot more time looking at your own feet/hands and ahead a bit and don’t worry so much about the things that scare you. Be curious and explore. This recap is pretty late so there … Read more
SQL Server Case of the Week: SQL Server Audit Errors – Resolving a Common Error
December 19, 2025
When SQL Server Audits Fail – Quick Summary SQL Server Audits – they’re running in the background, but what happens when something goes wrong? There is an alert that we have encountered that, if you follow the information in the error, typically does not lead you to the solution. What do you do then? Every minute the audit is … Read more
SQL Server Case of the Week: The Transaction Log of Your Snapshot Replication Publisher Database Won’t Truncate… But Why?
December 12, 2025
Quick Summary When snapshot replication is configured with schema replication enabled, DDL changes are sometimes marked for replication but never marked for truncation, creating a false “undistributed command” that prevents log truncation and causes uncontrolled growth. The solution was to add a log reader agent using sp_addlogreader_agent on the publisher to mark all replicated commands for truncation. Context The SQL … Read more