€99

Optimised Analytics: Tune your Data Warehouse with Columnstore Indexes with...

Event Information

Share this event

Date and Time

Location

Location

Microsoft Iberica

Parque empresarial La finca

28223 Pozuelo de Alarcon

Spain

View Map

Refund Policy

Refund Policy

Refunds up to 30 days before event

Event description

Description

Como parte del evento SQLSaturday Madrid 2018 (www.sqlsaturday.com/798), os presentamos una de las preconferencias que se celebrarán el día anterior, 19 de Octubre, con uno de los mejores ponentes actualmente, Niko Neugebauer, Experto mundial en Data platform ademas de MVP desde hace 20 años, a precio de comunidad, 99€. Una oportunidad excepcional para aprender de SQL Server y BI.

Abstract

Learn Columnstore Indexes in just 1 day starting with basics of the structure and stepping into the internal details, learning how to load data into them and finishing with advanced concepts of Batch Mode processing and performance tuning.

Microsoft added first implementation for the Columnstore Indexes in SQL Server 2012 with Nonclustered Columnstore, and SQLServer 2014 brought us updatable Clustered Columnstore Indexes, while SQL Server 2016 has added 2 new areas with the updatable Nonclustered Columnstore Indexes - Operational Analytics and Operational Analytics InMemory. The little (but still incredibly important details) in SQL Server 2017 made Columnstore Indexes a definitive default for Data Warehousing & Business Intelligence solutions, and given the current announcements some of the best things are still to come! Improve your Data Warehouse by implementing and optimising Columnstore Indexes that can bring you the new era of performance.

This training day is all about differences in implementations, their advantages and limitations and how to get the best out of the all types and incarnations of the Columnstore Indexes.

El workshop durará 4.5 horas con un descanso de 30 minutos. Comienza desde las 9:00 hasta las 14:00.

Prerequisitos:

- No hay prerequisitos

Precio: 99€

Ponentes

Niko Neugebauer

Niko Neugebauer works at OH22 as a BI Consultant. A SQL Server MVP with over 20 years of experience in IT, he is passionate about Data Platform and Community.

Founder of the Portuguese SQL Server User Group, the main organizer of the first SQLSaturday outside of North America – #78 Portugal, Niko presented at a lot of events such as PASS Summit, SQLRally, SQLBits, SQLSaturdays around the world. He loves sharing and is an author of blog series with 120+ posts on the Columnstore Indexes, plus the free & open-sourced CISL library helping everyone to work with Columnstore Indexes.

Blog http://www.nikoport.com

Twitter: https://twitter.com/nikoneugebauer

Share with friends

Date and Time

Location

Microsoft Iberica

Parque empresarial La finca

28223 Pozuelo de Alarcon

Spain

View Map

Refund Policy

Refunds up to 30 days before event

Save This Event

Event Saved