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

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