A monthly meeting of professional and enthusiast software developers, discussing all things .NET (Microsoft and open source), as well as languages, web frameworks, IoT, cloud, back end, testing, mobile and other related topics. Find out more at https://www.adnug.net
We're going to look at index internals using pens rather than a computer. This means we'll consider heaps v clustered indexes v non-clustered indexes, composite indexes, key choices (guid v int), page splits, fragmentation, as well as seeks and scans, sargability and residual predicates, and a bit on columnstore index internals too. It's stuff I think all developers should know even if you're not creating indexes, because it will impact your choices when you interact with your data.
Rob Farley does SQL & BI consulting through LobsterPot Solutions. He's run the Adelaide Data & Analytics UG since 2005 and moonlights as Father Christmas and as a stand-up comedian. He's an Microsoft Certified Master and Microsoft MVP. Reach him at r[masked]
Thanks to Encode Talent and Taptu!
This is an in-person event. A decision will be made closer to the date whether to record and/or offer a live stream.