Running SQL Server 2014 on a Scale Out File Server
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.
André is a freelance SQL Server specialist. He has done a lot of DBA work on 100’s of servers where he discovered his love for Powershell, architecting SQL Server solutions, building and tuning ETL processes (with BIML), and even implementing PDW.
André is a SQL Server MPV, Dutch PASS Chapter Leader and organiser of SQL Saturday Holland