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
common sql server migration pitfalls

6 Common Pitfalls of SQL Server Migrations and Upgrades

If you’ve ever tried migrating a SQL Server database from one server to another, you know it can be a white-knuckle ride from start to finish. You need to wait forever while you backup and restore, change all your connection strings to point to the new server, and forget to change the data sources for … Read more
sql server high availability data recovery hadr webinar

SQL Server HA/DR Webinar

On Tuesday, 12/13/22, we presented a webinar about HA/DR (high availability and disaster recovery). Join Team Straight Path as we discuss what HA is, what DR is, and how they are different. We talked about the ways to achieve HA and DR. We’ll talk about the things we’ve learned about HA and DR along the … Read more

Data Migration Assistant

It’s upgrade season. Here at Straight Path, we have more than a couple of clients in the process of upgrading their SQL Environments to a more modern version. With the support door slamming shut soon for SQL 2008 (waaaay overdue), and others on 2012 (really not in a much better position – support wise) clients … Read more

How to Save Money on SQL Server Licensing by Upgrading

If you have SQL Server instances that are out of support, which is any version prior to SQL Server 2014, then I’m sure you have your reasons for not upgrading to a newer version. Let’s take a quick look at those reasons and then examine one reason you might not have considered. My hope is … Read more
Previous 1…1415161718…98 Next