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.

Cloud

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

Upgrades

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

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

Managing Orphaned Users in SQL Server with sp_FindOrphanedUser

September 26, 2024

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

SQL Server: Standard vs Enterprise Edition

December 1, 2020

Do you need SQL Server Enterprise Edition? Maybe. Maybe not. This blog post will help you figure out if you can make the move from SQL Server Enterprise Edition to SQL Server Standard. Lately, we’ve been finding more and more folks who can answer that probably not. I’ve lost track of the number of clients … Read more

Cluster Validation – BEWARE!!!

June 27, 2020

Subtitle: SHAME ON YOU MICROSOFT! This is not a new behavior. It’s not a new risk. It’s the same old risk that’s been in Windows Failover Clustering for quite some time. But it’s worse for SQL Server environments that use a Windows failover cluster for an Availability Group – since you are not sharing storage … Read more

Inspect Early. Inspect Often.

April 16, 2020

I almost didn’t get to write this post tonight about a lesson from my farm life for us DBAs. I could have been dealing with a massive headache or a hurt daughter – or worse. But. I get to write it so that you can learn from our near incident… First A Question How are … Read more

SQL Server In Place Upgrades: Too Expensive?

April 9, 2020

About eight years ago, I wrote a (kind of long) answer to a DBA. Stackexchange question, “Are SQL Server In-Place upgrades as ill-advised as they used to be?” My summary answer on the top of my tome was: Short Answer – In Place is okay. You can review your configuration afterward and implement the best practices … Read more

Previous 1…22 232425 26…98 Next