We Sell Green Checkmarks

Expert SQL Server Consulting

Straight Path SQL offers Microsoft SQL Server database troubleshooting, monitoring and maintenance, migrations, and upgrades from small businesses to large enterprises.

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 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. 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 on your team, not on your payroll.

Read More

Cloud

We can plan and execute your move to the cloud. We can optimize your costs.

Read More

Upgrades

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

Read More

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.

Learn More
sp_FindOrphanedUser

Managing Orphaned Users in SQL Server with sp_FindOrphanedUser

Addressing orphaned users is an important piece of SQL Server security management. When left unchecked, you can accumulate an overwhelming number of users that exist in a database but do not have a correlating login in the master database, thus preventing access to the server or the database at all. There are dbatools PowerShell modules … Read more

Hey DBA – Don’t Rely on Your Chaps, But Get a Pair Anyway

I almost earned a trip to the Emergency Room. I didn’t because I had one last line of defense, but is that a success or a fail? I think a little of both. Let’s talk about it and see what we can learn as DBAs and consultants in our day jobs. You see. I bought … Read more

DBA Lessons From a Snowy Winter

I live in New England. I expect snow in the winter. This winter, though, has been a bit of an anomaly from recent winters for us. We started out with very little snow, abnormally little snow. But then it came (and it is still coming) all at once. Over about 4ish weeks we had a … Read more

2014 – Wow, What a Year!

I once heard someone say that as you get older – time seems to go by faster. 2014 was a busy year for me in a lot of ways. But it was the first year that I really felt like the year was just a tiny ripple of time.  It’s that time of year when … Read more

PASS BoD Thoughts

I can’t make the PASS Board Q&A this year at the Summit. I had to fly out early. I spoke with a few board members off and on, though. I wanted to put some thoughts down about an organization that I do care about and have gained much from. Will it be looked at before … Read more