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

Unrelated Relationship Ramblings

It’s Tuesday somewhere when this post goes up. In fact when this goes live it will be sometime around Tuesday afternoon or evening in Adelaide Australia. Why there? This month’s “T-SQL Tuesday” is being hosted by Rob Farley over at his place. His topic is “relationships”. He talks about the history of T-SQL Tuesday over … Read more

SQL Saturday, Seacoast SQL and January

Where does the time go?! January was an incredibly busy month with the day job, home, a battle with the flu and the wrap up of the holidays. It went felt like it took a week to go by but some good news came in January as well. This first week in February, I hope … Read more

StraightPath Solutions – A Year in Review

As we approach the end of 2009,  I want to give myself a review on where I have been, what I have done and where I can grow next year from a SQL Server consultant point of view. Part Time – Enough Time For Fun As I have posted before and explain on the about … Read more

For Unto Us a Child Is Born

Merry Christmas! StraightPath Solutions wishes you and your family a blessed Christmas season and a safe New Years celebration. I won’t have any other posts this week and will have a couple end of year wrap up posts next week, back to regular posting in January. I hope you enjoy the joy that this season … Read more