Realtime Analytics: OLAP & OLTP in the mix! [DBA]

Stijn Wynants
75 minutes
Perform
DBA, Database Developer, BI/Analytics Practitioner
200
Since SQL Server 2016 it is possible to have an OLTP & OLAP workload together. This can be achieved using columnstore indexes. We will start off with a brief history on how the columnstore indexes evolved in the different SQL Server versions. Then we will take a deepdive on how the columnstore works, explaining what a delta store is, how delete and update operations work, what batch mode processing is, what the different kind of segments are & how to maintain your columnstore indexes. We will conclude by showing you how to combine OLTP & OLAP workload on a database as seen in the field. Showing you issues you might face & how to make it fit for your environment
Basic knowledge about SQL Server.

Share
cage-aids
cage-aids
cage-aids
cage-aids