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.
(no tags)
Presented by Andre Kamman at SQLBits XII
MP4 Video HD 533 MB