Best Practices

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

Alerting on Bad Parameter Sniffing 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 parameter sniffing issues. These days, any time I work on a parameter sniffing issue … Read more

Security, Ransomware, and the DBA

I hope you joined us for our monthly webinar and team discussion about SQL Server Health Checks in June! Our web guy should have the recording for that and some other posts from it soon. Check it out! This month – on Thursday, 7/21/2022, we’ll be discussing Security and Ransomware. Why are we talking about … 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

[Webinar] SQL Server Healthchecks: The Worst Repeat Offenders

This month, the team here at Straight Path Solutions will be kicking off our monthly webinar series with “The Worst Repeat Offenders on SQL Server Health Checks”. We hope you’ll join us for the 30-ish minute presentation and the panel discussion/Q&A after. The Worst Repeat Offenders on SQL Server Health Checks Every time we onboard … Read more

How to Assess Your SQL Server Environment

Give me six hours to chop down a tree and I will spend the first four sharpening the axe. Abraham Lincon Welcome back to the Two Weeks to A Healthy SQL Server series of posts! This is the official “Day One” post. This first step may not be the most glamorous or the biggest payoff, … Read more