What’s new in SQL Server 2014 for DBA’s
[Edit 2014-03-04: André has re-written the description of his training day on his own blog. Please read that for an alternative view of what this session will contain, who it is aimed at and what you will learn. http://andrekamman.com/sql-server-2014-precon-at-sqlsaturday-exeter-2014/]
This new version has way too many features to cover in just one day.
We’ll concentrate on the new engine and manageability features.
Besides the obvious cool stuff like Always On and Hekaton there are a lot of other features which we will spend a lot of time on.
A whole number of these new features should not be tied to the Enterprise Edition, but we’ll find out about that when the product is released.
Besides Always On & Hekaton, we’ll cover the Resource Governor for IO, Improved cardinality estimator, separation of duties enhancements, Sysprep enhancements, Windows Server 2012R2 improvements like online VHDX resize, ReFS support & storage tiering.
We’ll try to cover as many improvements and new features as time will allow. The only things I will skip or barely mention will be the BI & Azure related stuff.
I dislike creating Powerpoint slides as much as you like to look at them the whole day, therefore you can expect as many demo’s as I can cram in a day.
I’m a SQL Server consultant based in the Netherlands. I’m a SQL Server MVP and I’m the co-founder and current chairman of the Dutch PASS Chapter and a member of the volunteer team for the Dutch SQL Saturday’s. I’ve done a whole lot of pure DBA work managing 100’s of servers and learning something new every day.
These days I spend a lot of time on just a few servers containing some large databases and the better part of the day is spent with SSIS. In both roles I’ve been using Powershell a lot. I joke sometimes that I replaced myself with a powershell script when leaving the DBA role, but these days I automate so much that I have to watch myself and not actually do just that