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

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
Adding SQL Server Access When You're Locked Out

Adding SQL Server Access When You’re Locked Out

As consultants we are sometimes asked the following question: “We have an old version of SQL that we can’t turn off and no one has access to it. Is there a way to create an account on a server you don’t have access to?” The answer is YES, and it isn’t as difficult as you … Read more

Maximizing SQL Server ROI in M&A

The Hidden Goldmine: SQL Server Due Diligence in Acquisitions Whenever I’m chatting with folks in the investment world, especially those eyeing product or “… as a service” companies that use Microsoft SQL Server, I’ve realized there’s a real need for clear, actionable insights on what to look for in a SQL Server environment. It’s not … Read more
sql server maintenance tasks every dba sould know

Essential Database Maintenance Tasks Every DBA Should Know

Database maintenance is a critical aspect of the DBA role, ensuring the smooth operation of SQL Server environments. In this blog post, we will explore key tasks and areas of focus for SQL Server DBAs, accompanied by practical tips and insights gained from our experience. From backup and recovery to performance optimization and security, let’s … Read more
easy sql server database restores

Make SQL Server Database Restores Easy With sp_DatabaseRestore

If you’ve read the Straight Path blog for any period of time, you’ve probably noticed more than a few posts about database backups. You may have also noticed we’re big fans of the Ola Hallengren Maintenance Solution for backups, which creates stored procedures and jobs to handle your regular backups. These scripts and jobs are … Read more