Introducing sp_CheckSecurity

free sql server dba tool sp_CheckSecurity

Are your SQL Servers secure? With new threats to your data emerging daily, it’s a difficult question to answer. And what is even included in the word “secure”? Sure, maybe you’re confident you have security against hacking (or maybe not?), but what about internal security? Are you protected against oops moments? Are there elevated permissions … Read more

Maximizing SQL Server ROI in M&A

The Hidden Goldmine: SQL Server Due Diligence in Acquisitions Whenever I’m chatting with folks in the investment world, especially those eyeing product or “… as a service” companies that use Microsoft SQL Server, I’ve realized there’s a real need for clear, actionable insights on what to look for in a SQL Server environment. It’s not … Read more

6 Common Pitfalls of SQL Server Migrations and Upgrades

common sql server migration pitfalls

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 HA/DR Webinar

sql server high availability data recovery hadr 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

Parameter Sniffing – Alerting in SQL Server Using Automatic Tuning

sql server parameter sniffing

IMPORTANT NOTE: This requires SQL Server 2017 or newer, Query Store and Enterprise/Developer edition. In SQL Server 2016, we were given the Query Store feature, and all the perf tuners rejoiced. Finally we had a great tool to help us with SQL Server parameter sniffing issues. These days, any time I work on a parameter … Read more

SQL Server Health Checks Webinar

Hey there! This post is the “Summary/Recap” for our Webinar on Thursday 6/23 at Noon US EDT. If you’ve not already registered for it please do so at the big REGISTER button below this. We’ll be talking about the things we see on SQL Server health checks at Straight Path that we don’t think we’d … Read more