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

Best Practices: Explain and Understand Them!

Stop expecting people to blindly follow your advice. Stop blindly following the advice of others. I’m borrowing a lesson from the man who proclaimed he knew exactly when the world would end (last weekend October 21st now). If you only have a minute, my point is simple and I’ve hit it before here – For … Read more

Are You Planting Asparagus?

Working in the garden another thought/illustration hit me. A question actually – Are You Planting Asparagus? We love to eat the stuff. Why not research planting it and plant it with this year’s vegetable garden. We learned a few things doing that research: It’s Perennial & can produce for decades. It is picky about its … Read more

On Feedback… And a Plea To Event Organizers

I really like presenting. I’ve blogged about some tips for others thinking about starting before. In those posts, I share how I started out terrified of speaking in public. One of the reasons I am enjoying it to date? Good feedback. Don’t read that as “positive” (though there has been more of that than I’ve … Read more

Avoid Using Those Troubleshooting Skills

When I re-read yesterday’s blog post on troubleshooting steps, I felt guilty. Instantly. Why? Because I had failed to mention something to you in that post and failed to follow advice I just gave in my SQL Rally presentation. *In my own defense, I did mention that one of the bullets I used in that … Read more