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

Where I’ve Been – 2010 Wrap Up

This was a good year in a lot of ways both personally, professionally and with spiritual growth. I still have far to go and plenty of goals to whip together for 2011 but a quick rundown of where I’ve been. These thoughts are my own, and don’t speak for my employer. the next post will … Read more

Prepare For the Disaster Before The Disaster

Kind of like some previous common sense posts inspired by mundane tasks (Day Job Tips learned from the garden, a dump trip, etc.), I was hit with another blog thought today. This goes well with my post – Plan To Fail or Don’t Expect To Succeed. Updated: Added a sound piece of advice in the … Read more

On The 11th Day of SQL

What’s This? Brent Ozar had another good Idea (I lost track of how many he’s had). This time it is to take the folks who attended the first free-con (his guinea pigs) and ask us what posts we enjoyed in 2010 from folks who weren’t at this first free-con gathering. We’d wrap up 12 of … Read more

Merry Christmas 2010

I wrote a longer post for last Christmas. I shared some Bible verses that are usually on my heart and in messages around that time of year. Rather than do a replica, let me direct you to what I wrote last Christmas in my post, “For Unto Us a Child Is Born” That post rings … Read more