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
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
I’m not going to let another #mememonday pass without a post – one thought came to mind. The theme this month is – What gift do you want Microsoft to leave under the tree this year? I don’t want much. Bill Gates is already taking care of the world, so no beauty pageant wish there. … Read more
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
Is your SQL Server Linked Server Query running slow? Check your permissions. Maybe this is old news to you but it wasn’t for me –> It was a good day. We had finally migrated onto brand new hardware (and saw a 250% improvement in run times of most warehouse jobs). I had finally cleaned up … Read more
(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
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