SQLBits 2015

Columnstore Indexes in SQL 2014: Flipping the DW Faster Bit

This presentation includes an overview of SQL Server 2012 & a deep dive into SQL Server 2014 columnstore indexes, including a review of the architecture, as well as the challenges, workarounds, travails, & big wins at customer sites

Columnstore indexes were introduced in SQL Server 2012 & have been wholly re-architected & optimized in SQL Server 2014. Columnstore indexes are optimized for data warehouse workloads & are a hybrid technology leveraging the best of off-disk & in-memory capabilities. Transparent to the app, columnstore has been shown to render queries at sub-second response times which heretofore took many minutes or longer. This presentation includes an overview of SQL Server 2012 & a deep dive into SQL Server 2014 columnstore indexes, including a review of the architecture, as well as the challenges, workarounds, travails, & big wins at customer sites & inside MSIT. The presentation is rich in demos, including leveraging IaaS—Columnstore in The Cloud. Learn whether columnstore can change your users' world & why columnstore may be a compelling reason to upgrade. Learn how columnstore indexes flip the DW faster bit & why columnstore manifests my motto, “Change the world or go home!”

Fusion-io's previous sessions

Columnstore Indexes in SQL 2014: Flipping the DW Faster Bit

This presentation includes an overview of SQL Server 2012 & a deep dive into SQL Server 2014 columnstore indexes, including a review of the architecture, as well as the challenges, workarounds, travails, & big wins at customer sites

Learn about SQL Server Buffer Pool Extension, flash storage

Learn more about use cases and limitations for buffer pool extension. We will also cover the performance gains it can bring to your environment.

SQL Server In-Memory OLTP and Flash

Learn how flash storage accelerates In-Memory OLTP performance. We will also cover limitations with SQL Server In-Memory OLTP.

Quantifying the cost of Compression

In this session, we will use Grade of the Steel type workloads to quantify the CPU cost of enabling different types of compression. Using CPU profiling, we will try to quantify the cost of this feature.

Fusion ioN Data Accelerator - software defined storage

ioN Data Accelerator software transforms industry-leading open server platforms into powerful shared acceleration devices for multiple applications or clusters. Come learn how and why.

Myths and Monsters of Flash

Steve will explore some of the characteristics of NAND flash, introduce the mechanics and debunk some myths along the way.

Jimmy May's previous sessions

To The Cloud, Infinity, & Beyond: Top 10 Lessons Learned

Microsof IT's Cloud strategy involves migrating hundreds of applications to Azure. The scale on which it is being done may be unprecedented. Lessons Learned are numerous. This session exposes the most important—& painful—ones.

SQL Server on Flash: Re-Thinking Best Practices

Flash storage is a game changer for virtually every app in which it is used. Whether used locally, for tiered storage, or all-flash arrays, flash is turning what we thought we knew about SQL Server best practices on its head.

Columnstore Indexes in SQL 2014: Flipping the DW Faster Bit

This presentation includes an overview of SQL Server 2012 & a deep dive into SQL Server 2014 columnstore indexes, including a review of the architecture, as well as the challenges, workarounds, travails, & big wins at customer sites