Fox Valley Microsoft Data Platform

 Welcome to FoxPASS, the SQL Server community for Northeast Wisconsin! 

Next Meeting

Wednesday,

June

05

What Else Can Indexes Do?

Event Sponsor
Watch onlineTwitch:

Please join us for the presentation on June 5th at Secura Insurance (East Building) where we will have special guest Erik Darling from Erik Darling Data. (Erik will be remote for this session)

Erik Darling started using SQL Server after a dispute with Excel over a vlookup. Since then he's had some terribly boring DBA jobs, and been a consultant for Some Guy You've Never Heard Of™(Brent Ozar). He enjoys public arguments with optimizer and wine photography. You can find out more on his official website: https://erikdarlingdata.com/

A little bit about the discussion:
"Lots of sessions about indexes give you technical, but not practical information. It's not that the information is bad, it's just that you can't take it and apply it to your problems. In this session, we're gonna dive deep into how queries use indexes, and the warning signs you'll see when you have a problem indexing can solve. We're going to be looking at query plan stuff like memory grants, spools, and lookups. We're also going to look at how indexes can give you a leg up on locking. And best of all, you'll learn how to stop worrying about fragmentation and start fixing real problems."

Signup: https://www.meetup.com/Fox-Valley-Microsoft-Data-Platform/events/261511274/?isFirstPublish=true

If you missed our previous meetups you can always catch them on our Fox Pass Youtube channel!

Link: https://www.youtube.com/channel/UCIMxqUC98A69Cm8t4GFwuSw

Featured Presentation:

What Else Can Indexes Do?

Erik Darling, Managing Director Erik Darling Data

Lots of sessions about indexes give you technical, but not practical information. It's not that the information is bad, it's just that you can't take it and apply it to your problems. In this session, we're gonna dive deep into how queries use indexes, and the warning signs you'll see when you have a problem indexing can solve. We're going to be looking at query plan stuff like memory grants, spools, and lookups. We're also going to look at how indexes can give you a leg up on locking. And best of all, you'll learn how to stop worrying about fragmentation and start fixing real problems.

About Erik:
Erik Darling started using SQL Server after a dispute with Excel over a vlookup. Since then he's had some terribly boring DBA jobs, and been a consultant for Some Guy You've Never Heard Of™. He enjoys public arguments with the optimizer and wine photography.

Bronze Sponsors

 

Hosts

 

Other Sponsors

PASSChapterLogo100.jpg 

 

sql_micro_sm.gif 

sql_ca_sm.gif 

 

Brent Ozar Unlimited

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids