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
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
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
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
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
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
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