SQL Server

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

[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

Microsoft Loves Your Big Data

This week at the SQL PASS Summit, Ted Kummert – Corporate Vice President of the Business Platform Division at Microsoft (think SQL Server) made an announcement in Wednesday’s keynote presentation. It is an awesome announcement for companies who have “big data” (think semi structured or even unstructured large data sets. Think data that is perhaps … Read more

SeacoastSQL First Meeting Recap

(Written the night of the meeting, edited and posted after) Wow. I just got home from a really great night with a fun group of people. The first meeting (hopefully of many more) was a success (more on what that means from my point of view below) and we had an amazing turnout – By … Read more

SQL Server Presentations

Our Team Can Speak at Your Next SQL Server Event The Straight Path team is made up of talented SQL Server and Microsoft cloud data platform professionals. You’ve probably read our blogs or witnessed our contributions on SQLServerCentral.com, DBA.Stackexchange.Com, SQLTeam, and other forums/groups. [lgc_column grid=”50″ tablet_grid=”50″ mobile_grid=”100″ last=”false” class=”speaking”]   [/lgc_column] [lgc_column grid=”50″ tablet_grid=”50″ mobile_grid=”100″ last=”true”] … Read more