Redmond SQL Server User Group

Next Meeting




Using Columnstore indexes in real life. Lessons learned!


The Analytics service in Azure DevOps Services provides all-over insights to your DevOps data: work item tracking, CI/CD pipelines, testing process etc. Built on top of columnstore indexes, the Analytics service has to deal with 100s of millions records and daily growth in 10s of millions, only a few minutes delay from operation store, sub second query performance for in-product experiences as well as 3rd party extensions, Power BI integration and ad-hoc queries. Working on it, I've learned a lot of DOs and DON'Ts about columnstore indexes. Session covers how to: * partition columnstore indexes in a multitenant environment * maintain columnstore indexes in case of updates and/or purge to keep segment elimination possible * evolve database schema without downtimes and maintenance windows * design to benefit from predicate and aggregation pushdown * deal with edge case like ad-hoc queries for raw data and paging * choose between CCI and NCCI based on usage patterns.


Konstantin is an industry expert who loves optimizing the performance at least in 10x. More data - more fun. Konstantin is a Principal Software Engineer at Azure DevOps Services, where he works on moving the Analytics for software engineering to a completely new level. Konstantin was born and had been working in Ukraine for a long time, passionately sharing his knowledge with Ukrainian and other European data communities. Before joining Microsoft in 2012, he was a Data Platform MVP for many years.

Our Sponsor:

Food and drinks is provided.

Here's the agenda for your reference:
5:30 PM - 6:00 PM Networking with beverages and snacks
6:00 PM - 6:10 PM User Group updates
6:10 PM - 6:30 PM Sponsor Spotlight & Speaker Introduction
6:30 PM - 7:30 PM Featured presentation
7:30 PM - 8:00 PM Q&A and continued networking

Join us on January 8th, 2020 in Microsoft Building 34 Quinault
Room. Look for the SQL User Group sign outside the building.

We look forward to seeing you on Wednesday, January 8th. - bring a friend, or three!




Back to Top