Expert SQL Server Consulting

We invest in you before you invest in us.

Learn More

DBA as a Service

Remote, senior DBAs on your team, not on your payroll.

Read More

Cloud

We can plan and execute your move to the cloud.

Read More

Upgrades

Expert, painless, set-it-and-forget-it SQL Server upgrades.

Read More

We Sell Green Checkmarks

We’re SQL Server experts who can solve your database problems and keep them from coming back.

How are we different?

Your account manager is your technologist.

Your account manager is empowered.

Your account manager is responsive.

Your account manager is not time-keeping.

Database management has never been this easy. The Straight Path team is full of database gurus who can help you speed it up, sort it out or set it up right. And they do it with a pleasant attitude (in a world where unpleasant exchanges are all too common). Fast, flexible and armed with state-of-the-art tools and knowledge, database issues are no match. We’ve had the pleasure of working with Straight Path on behalf of multiple of our clients and they’ve become a key partner of ours. A growing business means a growing system – and a growing need to keep the systems properly optimized. 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. I don’t know what we’d do without them.

Dean Tammam, Red Key Solutions

how to audit sql server database backup chains

Audit Your Database Backup Chain!

All database administrators know that safeguarding data is paramount and having a strong restore strategy is crucial. In this post, I would like to add another tool to your arsenal that I have found helpful in auditing server health and configurations as it pertains to backups and the backup chain. A backup chain is important … Read more

How to Enable Transparent Data Encryption for Databases in Your Availability Group

Transparent data encryption is the built-in method for at-rest data encryption in SQL Server. Taking steps towards security has always been important, but it is becoming even more important every day as there is a looming cyber threat industry hungry for easy high-profit data. We should also remember that not all threats are from the … Read more

How to Provision a Low-Cost SQL 2022 Testing Lab

This month we will be covering some features in SQL 2022. Specifically, I will create a new SQL 2022 Development instance and connect it to Azure Arc. Azure Arc is not primarily for SQL 2022, but connecting it to on-premises and cross-cloud SQL servers is a very useful skill to have for managing hybrid environments, … Read more
sql server transaction log myths

7 Common SQL Server Transaction Log Myths

SQL Server is a complicated piece of software, so it’s understandable that some of us have some misconceptions about what the transaction log is and what it does. This post is designed to not just tell you about these myths, but also to show you a few ways how to prove (or rather disprove) some … Read more