The Memory Hub - Public Tours
The Memory Hub - Public Tours
Thu, Dec 15, 11:00 AM
The Memory Hub • Seattle, WA
Free
Actions Panel
Columnstore and Memory-Optimised Workshop
When and where
Date and time
Location
Microsoft Campus Redmond Microsoft Building 20 Redmond, Washington WA 98052
Map and directions
How to get there
Refund Policy
Contact the organizer to request a refund.
Description
Discover the two of the most important & revolutionary technologies for Data Warehousing, Operational Analytics and OLTP - the Columnstore Index and In-Memory Tables!
Columnstore Indexes - starting with SQL Server 2012 the revolutionary technology of Columnstore Indexes started to appear across all versions (the regular Enterprise Edition and Parallel Data Warehouse). Step by step you will learn the most detailed differences in the architectures as well as the usage cases and troubleshooting for the reporting and analytics. Diving into the storage internals and compression methods, we shall review all possible options and t-sql commands to take control and enable the full speed of the columnstore indexes.
With practical examples of data loading optimisations, we shall take a detailed look into the transaction log behaviour and the reasons for it. With the help of the different DMV's and Extended Events we go to identify the problems with Columnstore Indexes and apply available solutions.
We´ll focus a significant part of the Columnstore Indexes learnings on the SQL Server 2016, but we shall be using Azure SQLDatabase very extensively, since the Columnstore Indexes are not only up to date, but they are be even in front of the most recent on-premises release, including Operational Analytics and Memory-Optimised Operational Analytics.
The Batch execution mode and its details will be another important aspect of the Columnstore part of the workshop.
Memory Optimised Tables - starting with SQL Server 2014 the revolutionary technology of memory-optimised tables helped the OLTP workloads and some processes within Data Warehousing to reach brand new level of performance.
With SQL Server 2016 already released and having Memory Optimised Tables in Azure SQLDatabase in preview, this workshop will focus on the internal structures of the indexes, advantages & limitations as well as the solutions for the limitations of the available versions.
Using the DMV's and Extended Events, we shall show how to automate the current problems determination, such as wrong bucket numbers or inefficient scanning strategies because of the wrong index type selection. The file system maintenance is another important aspect that will be part of our workshop.
In this 3-day workshop, you will spend one day on the Columnstore Indexes internals, one day on the Memory-Optimised Tables internals and one day on the practical solutions involving both technologies.
The main areas of the workshop will be :
- Clustered & Nonclustered Indexes from SQL Server 2012 to SQL Server 2016 and from Azure SQLDatabase to Azure SQLDW.
- Batch Execution Mode
- Operational Analytics and Memory-Optimised Operational Analytics
- Memory-Optimised Tables, their limitations and their incredible usefulness in SQL Server 2014, 2016 and Azure SQLDatabase
Target:
This workshop is targeting everyone who is working with high performance workloads - from OLTP to Data Warehousing and from Operational Analytics to heavy ETL, and using SQL Server from version 2012 and higher (with a strong preference for SQL Server 2014 and higher or Azure SQLDatabase). Database Administrators, Business Intelligence Professionals, as well as the Software Architects and OLTP Developers will find this workshop very useful and practical.
Reguirements:
Basis knowledge about Indexing, Execution Plans, DMVs and Tracing (Profiler or Extended Events).
Our Columnstore & Memory-Optimised Tables Expert
Niko Neugebauer works as a Consultant at OH22 and specializes on the Performance Tuning & the Data Warehouse. 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 organiser of the first SQLSaturday outside of North America – #78 Portugal, Niko presented all around the world at such events as PASS Summit, SQLRally, SQLBits & SQLSaturdays, between many others.
He loves sharing and is an author of blog series with 90+ posts on the Columnstore Indexes, plus the free & open-sourced CISL library helping to work with Columnstore Indexes. This library includes t-sql scripts for idenitfiying and helping migrate your RowStore workloads to Columnstore Indexes, plus it performs the necessary maintenance on the Columnstore Indexes. The library (version 1.4 to be released in early October 2016) inlcudes setup for the Extended Events and the support for the PDW & Azure SQLDW.
FAQs:
Is my registration/ticket transferrable?
Yes, you will need to contact the organizers at least 48 hours in advance.
What is the cancelation policy?
We reserve the right, to cancel our event under extraordinary reasons.
You could cancel your participation until 21days before the workshop starts with free of charge. Otherwise we guard 50% of you attendance fee.