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

One Week Down – ActiveAugust

Last week I posted my kickoff of my ActiveAugust (Twitter Search) routine and a weigh in in “And So It Begins…”. I said I would come back and post weekly throughout ActiveAugust. I also think I will continue posting at least monthly just to keep this in my mind. How did week 1 go? The Good … Read more

Benchmarking… Who Needs It?

All of our SQL Server instances need benchmarks! So the title is somewhat of a trick question… I hear and sense a lack of priority around taking periodic benchmarks in a system with a lot of folks. How often do you take benchmarks? Do you know what “normal” means for your system? Do you know … Read more

And So It Begins..(ActiveAugust)

It is August First. The opening day of #active august (twitter search, my initial post on it). There are several others participating which makes it good for encouragement and accountability. I am going to weigh in every Saturday and try and keep the daily progress notes on twitter. I have not done a SQL blog … Read more

Romans 7, meet Romans 6 (part 1)

I occassionally post some blog entries about my faith and family or both. These posts may or may not touch on SQL Server and this is one of them. I discussed this when I first blogged about Jesus’ last words on the cross (Tetelestai). I welcome you to read or skip and I won’t be … Read more