Skip Main Navigation
Page Content

Save This Event

Event Saved

#LADataPlatform (a.k.a. #SQLMalibu) - Wednesday, October 16, 2019

LA Data Platform (a.k.a. SQL Malibu)

Wednesday, October 16, 2019 from 7:00 PM to 8:00 PM (PDT)

#LADataPlatform (a.k.a. #SQLMalibu) - Wednesday,...

Ticket Information

Type Remaining End Quantity
#LADataPlatform 37 Tickets 1d 19h 15m Free  

Share #LADataPlatform (a.k.a. #SQLMalibu) - Wednesday, October 16, 2019

Event Details

AVAILABLE ONLINE via Microsoft Teams

Join Microsoft Teams Meeting

+1 347-941-2594   United States, New York City (Toll)

Conference ID: 411 346 32#

Featured Presentation: Using Columnstore indexes in Azure DevOps Services. Lessons learned by Konstantin Kosinsky

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 of 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. The 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

About Konstantin:

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.

Have questions about #LADataPlatform (a.k.a. #SQLMalibu) - Wednesday, October 16, 2019? Contact LA Data Platform (a.k.a. SQL Malibu)
Attendee List Sort by: Date | First Name
Show More

Save This Event

Event Saved

When & Where

Online via Microsoft Teams

Los Angeles, CA 91367

Wednesday, October 16, 2019 from 7:00 PM to 8:00 PM (PDT)

  Add to my calendar


LA Data Platform (a.k.a. SQL Malibu)

The LA Data Platform (a.k.a. SQL Malibu SQL Server User Group) is the informal meeting of a group of Microsoft Data Professionals enthusiasts in the Greater Los Angeles area. This group is intended to facilitate knowledge and expertise sharing through community and expert SQL Server practitioners, in the full range of SQL Server topics, including Business Intelligence. Through these meetings we encourage professional networking.  The meetings are FREE of charge and held the third (3rd) Wednesday of every month, built based on the community for the community.

Subscribe to LA Data Platform (a.k.a. SQL Malibu) Email Marketing Campaigns or use QR code below

  Contact the Organizer

Interested in hosting your own event?

Join millions of people on Eventbrite.

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.