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

free sql server dba tool sp_CheckSecurity

Introducing sp_CheckSecurity

Are your SQL Server instances secure? With new threats to your data emerging every day, it’s a difficult question to answer. And what is even included in the word “secure”? Sure, maybe you’re confident you have security against hacking (or maybe not?), but what about internal security? Are you protected against oops moments? Are there … Read more
sql server consultancy core values guiding principles

Building a Consultancy: More Principles

A couple of weeks ago, I started blogging about part of the journey of creating our SQL Server Consulting firm. I may someday work on more posts on the journey from full-time DBA to doing some side work to leaving with an “anchor client” to going off on my own (and my adventures with Linchpin … Read more
sql server consultancy core values guiding principles

Building a SQL Server Consultancy

Principles and Values First In 2011, I set out to be an independent SQL Server consultant. At the time, if you told me I’d be looking back 13 years later as a “CEO” with a team of 15+ FTEs I would have laughed at you, I think. But it happened. I’ve been reflecting back on … Read more
How to Optimize SQL Server Performance by Separating Workloads

How to Optimize SQL Server Performance by Separating Workloads

I wrote this to share a series of scripts that help identify if workloads are appropriately separated on the SQL Server host. The main reason we look for this is to avoid I/O contention and waits, which is a challenge that can significantly impact performance. If you are unsure if your server is experiencing I/O … Read more
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
12389 Next