pass data community summit Archives

01Aug 2024 by Grant Fritchey 2 Comments

Kilt Day!

This is a quick blog post to announce that I am reviving Kilt Day at PASS Data Community Summit. Over the last few years... ah hell, let's just say it. I'm old. Without equivocation, no reserve, I love PASS Summit. But holy smokes it's exhausting. Especially the last few years. What's changed? Me. I'm getting old. So, I looked around at things I could trim, stuff I could avoid, ways I could be both be a bit more comfortable and just take some load off my shoulders. Kilt Day. I tried to get others to "run" it. No one did. It's a bit inexplicable because, there's nothing to it. Announce it. Advertise it (this is the "hard" part). Keep advertising it. Show up in a kilt. That's pretty much it.…

31Oct 2022 by Grant Fritchey No Comments

Weaponizing Query Store

SQL Server

I may have occasionally talked about the importance of Query Store, but today I want to emphasize just how much Microsoft is weaponizing query store. Of course, I don't mean they're creating the Death Star or something, I simply mean they're taking the information that Query Store gathers and using that to enable a number of new performance enhancements within SQL Server. Intelligent Query Processing Starting back in SQL Server 2017, Microsoft started making improvements to how queries get processed. The early stuff was mostly about interleaved execution, basically allowing for the ability to adjust an execution plan on the fly. This was expanded quite a bit in 2019. Follow the link for a great graphic showing how this stuff has progressed. SQL Server 2022, releasing soon I'm sure (no,…

11Oct 2022 by Grant Fritchey No Comments

Query Store at PASS Data Community Summit

SQL Server, T-SQL

While Query Store has been out for quite some time now, released in 2016, there's still quite a lot of missing understanding of what Query Store can do for you, and, how it does it. I've put together a new presentation on the Query Store, "Using Query Store to Understand and Control Query Performance", incorporating the latest stuff from 2022, but still showing you all the goods from 2016, for the PASS Data Community Summit. Why Query Store I've been in love with Query Store since it was released. If you look through my blog, I've been talking about Query Store a lot. I provided a little help to Tracy Boggiano on her book (yes, emphasis on hers, because it is, I just helped), Query Store for SQL Server 2019.…

28Sep 2022 by Grant Fritchey No Comments

Query Tuning At PASS Data Community Summit

PASS

The all new, in-person, PASS Data Community Summit is in just a few weeks. Since I'm shortly going to be publishing a 100% rewritten book on query tuning, I decided to take a look at what kind of sessions on the topic are going to be available at the Summit. Query Tuning With The Best You can search through the published sessions here. I didn't even bother typing in "query tuning". Far too lazy. I just typed "query" and already saw some amazing stuff. In no particular order... One of the people I've ALWAYS learned from, Kimberly Trip is delivering a precon, Indexing for Performance. That's going to be a great day of good learning. Kim is insanely knowledgeable and a fantastic presenter. Well worth your time. Erin Stellato, another…

Tag: pass data community summit