Flash Storage For The SQL Server Professional

2017

TL; DR

The storage industry is at one of the greatest inflection points in its history. Learn the basics of flash storage and how conventional wisdom needs to change and how best to leverage what is fast becoming the main stream storage technology.

Session Details

The storage industry is at one of the greatest inflection points in its history, in this session you will learn the basics of flash storage and what this means for the DBA and developer in terms of what conventional wisdom needs to change and how best to leverage what is soon to become the main stream storage technology in terms of:

IOPS/GB is going down with old protocols such as SAS, however help is at hand in the form of the new storage protocol on the block
How to test flash storage
New capabilities that flash storage opens up such as bulk loading at speed and running OLTP and OLAP applications on the same storage
Compression was invented for the world of spinning disk, how does it behave with spinning disk
...and more !!!

3 things you'll get out of this session

Chris Adkin's previous sessions

Advanced Azure DevOps With Containers and Pipeline As Code

You are a developer and you want to leverage the 'Power' features in Azure DevOps via YAML pipeline as code, then this session is for you !

Probelm Solving Using The In-Memory Engine

The in-memory OLTP engine has been around since version 2014 of the database engine, do you need to be a SaaS provider processing billions of transactions a day to use this ?, the short answer is absolutely not and this session will show you why.

An Introduction To Column Store Indexes and Batch Mode

This session is a primer on column store indexes and SQL Server batch mode, it delves into the background behind the performance gains achieved by batch mode and includes demos on things that can be done to further enhance batch mode performance.

Superscaling SQL Server 2014 Parallel Insert

This session will take a look at how parallel select into can be scaled to the nth degree in SQL Server such that all available hardware resources are utilised as fully as possible.

Column Store Index and Batch Mode Scalability Deep Dive

A deep dive into batch mode scalability with column store index and SQL 2014.

Scaling Out SSIS With Parallelism

An introduction to scaling out packages using parallelism with the "Work pile" pattern, balanced data distributor and "Roll your own" techniques.