SQL Server 2014

SQL Server 2014 is chock full of changes and new features. We’ll help you sort through the good and bad, and find some hidden gems along the way.

What’s New in SQL Server 2014

Learn almost everything you need to know about SQL Server 2014 in Brent’s rundown of new features in SQL Server 2014.

Jeremiah explains that SQL Server licensing rules are a changin’.

Memory Changes in SQL Server 2014

SQL Server 2014 Standard Edition lets you use up to 128GB of memory— double what SQL Server 2012 allowed. And if you don’t have memory, there’s also the new…

Buffer Pool Extensions Performance Tests – When should you use the new Buffer Pool Extensions, and how can you expect them to perform?

How much memory does SQL Server need? Jeremiah explains how to calculate it for SQL 2014 and prior.

Performance Improvements in SQL Server 2014

Kendra shows you a very cool hidden gem in 2014: tempdb will do more in memory without being so eager to rush to do physical IO.

SQL 2014 eats bad T-SQL for breakfast. Kendra demonstrates the new cardinality estimator in that post, and for even more details, Jeremiah shows you the best white paper.

Does the new in-memory technology automatically make in-memory table variables way better than old school temporary tables? Learn more in Kendra’s article on table variables vs temporary tables.

Indexing Clustered Columnstore Indexes – yo dawg, Brent heard you like indexes, so he shows you how to do something Books Online says can’t be done.

SQL Server 2014 AlwaysOn Availability Groups

Stack Overflow’s Recovery Strategy – Brent Ozar updates you on how they’re using AlwaysOn AGs for higher performance and availability.