This event is now over
|Pre-Con Title||In-Memory technologies in SQL Server – from 0 to Operational Analytics Master|
Since SQL Server 2016 Service Pack 1, most programming features have been available in all editions, including the two In-Memory technologies: Columnstore Indexes and In-Memory OLTP.
Columnstore indexes, which have been existing since SQL Server 2012 (actually PDW v2008), are mainly optimized for big amounts of data (millions of rows) and offer blazingly fast OLAP-style queries, which is made possible by their special structure (columnar storage), sophisticated compression, and batch-mode processing for much more efficient CPU-usage than traditional row-store-queries.
The In-Memory OLTP engine, which will be the second topic of this full day, came into the product with SQL Server 2014 and has since then been extensively improved in terms of both scalability and T-SQL language support, taking away many of the relevant limitations for adaption of version 1 in a similar way as the Columnstore technology over the course of its development.
Thirdly, the so-called In-Memory Operational Analytics are supported by the ability to create Columnstore Indexes on memory optimized tables!
All those improvements will make In-Memory technologies a viable option in many projects. For Datawarehouses, many say that Columnstore will become the default storage type for all objects in the near future. And it can be foreseen that over the years the same will happen for OLTP-tables that have to support highly concurrent workloads, which will all be based on memory optimized tables.
It’s time to extend your skills to embrace those technologies, and learn how to implement and support those new types of storage that are coming to our databases, addressing the challenge of ever more data being stored and queried and performance demands and (real time) analytic requirements going up.
During this full-day training session, Microsoft Certified Master for the Data Platform Andreas Wolter, familiar with SQL Server’s In-Memory technologies from the early bits on, will give a complete picture on the current state of technology. Attendees will learn how and where to use either In-Memory OLTP or Columnstore or even both for efficient queries and data storing, but also which problems still exist in real-worldprojects that sometimes make it hard to find the right solution design to profit from those technologies, and cover the important bits and pieces both from a developer’s and administrator’s perspective.
|What Is Included?||
|Date||August 16, 2017|
|Time||9:00 am to 5:00 pm IST|
|Location||Davanam Sarovar Portico Suites
(4 Star Deluxe Suite Hotel)
Hosur Main Road, Opp Madiwala Police station, Bengaluru, Karnataka 560068
(Near Silk Board)
PS: Prices might change without any prior notice
August 16, 2017
9:00 am to 5:00 pm
Davanam Sarovar Portico Suites
Hosur Main Road, Opp Madiwala Police station
Near Silk Board