Columnstore Indexes in SQL Server 2022 and Azure SQL Database
Columnstore indexes were introduced in SQL Server 2012 and with each version since then have seen significant improvements. Analytic workloads can see immense performance gains by making effective use of them.
SQL Server 2022 and Azure SQL Database offer additional improvements. What are they? How do they work? When should I use them?!
This session provides a dive into how columnstore indexes work, with a focus on the newer features and how they further boost this superhero feature!
About Ed:
Ed Pollack is a Microsoft Data Platform MVP with a passion for learning how the Microsoft Data Platform works and sharing that knowledge with the community. His experiences in data architecture, database design, performance optimization, and data security are motivation for public speaking, writing, coding, and other community activities.
Ed has spoken at SQL Saturday events, SQL Bits, PASS Summit, EightKB, and many other regional and international events. Ed is the organizer of the Capital Area SQL Server Group and SQL Saturday Albany, as well as a co-organizer of SQL Saturday New York City, and Future Data Driven. He has published a number of books, including "Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server", "Expert Performance Indexing in Azure SQL and SQL Server 2022", and "Analytics Optimization with Columnstore Indexes in Microsoft SQL Server: Optimizing OLAP Workloads". Ed is also an active contributor of content to SimpleTalk.
In his free time, Ed enjoys video games, traveling, cooking exceptionally spicy foods, and hanging out with his amazing wife and sons.
