SQL Server Migration Considerations from a Jr. DBA
November 16, 2022
SQL Server migrations are a necessary and expected part of keeping a modern SQL Server deployment. We have worked with many clients on migration projects, and I have organized some considerations for you and your team before, during, and after your SQL Server migration. We recommend working with a SQL server DBA on these kinds … Read more
PASS Prayers – The 12th?
November 13, 2022
It’s time again for the PASS (data community) Summit again! In fact, true to form – I am typing this from the lounge at the airport while I wait for my delayed plane to bring me to Seattle. What follows after the short announcement is a paste from last time (2019 – obviously, this gathering … Read more
SQL Server Health Check Worst Offenders
November 1, 2022
After performing hundreds of SQL Server Health Checks over the years, we wanted to share the most common repeat offenders we find time and again. These are: This topic is part of our monthly SQL Server webinar series. Webinar registrants get access to the entire recording, which includes the office hours Q&A. If you would … Read more
Parameter Sniffing – Alerting in SQL Server Using Automatic Tuning
October 31, 2022
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
A Simple SQL Server Security Checklist
July 20, 2022
This month I am providing a 12-point checklist of scripts to check your SQL server’s current security posture. Use these scripts to get an idea of where you are, so that you can make plans for the places you may want to go. The paradigms of least privilege and defense in depth are important to … Read more
Security, Ransomware, and the DBA
July 19, 2022
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
A Simple SQL Server Health Checklist
June 30, 2022
Being part of a consulting team has given me experience with many environments, and part of the work I do every week is to check for the various best practices and monitor server health across over 20 environments. This post condenses the tools that can help and the configurations that are most likely to cause … Read more
SQL Server Health Checks Webinar
June 22, 2022
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
June 10, 2022
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
Jeff and Geoff – We’re growing.
April 8, 2022
Hey!!! The last team announcement post was about our good friend and Senior Consultant, Joe Fleming moving on to the scary world of independent consulting. I cannot tell you how great it is to be working at a company that cares so much about the team, that we’ll even help make someone have a soft … Read more