SQLBits 2014

Running SQL Server 2014 on a Scale Out File Server

In this session I will show you how to use Storage Spaces and Auto Tiering and some other features to build a highly available, fast, scale out file server. And then we'll use it to host SQL Server data & log files on it.
A few years ago when someone would suggest to run SQL Server on a file share I would protest and start a rant about latency versus throughput etc. But today I think that some of the coolest new features of SQL Server 2014 are actually Windows Server 2012 R2 features. In this session I will show you how to use Storage Spaces and Auto Tiering and some other features to build a highly available, fast, scale out file server. And then we'll use it to host SQL Server data & log files on it. Which is fully supported when using SQL  Server 2014.