Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


SQL Server 2014 New Features

(this is an on-demand video)

Sponsored by - Quest

Webcast Abstract

This session will be aimed at database professionals with a working knowledge of SQL Server, and will provide a short introduction to what's new in SQL Server 2014, covering new features particularly in the database engine. On the agenda is an overview and demonstration of Hekaton - or more precisely, in-memory table optimization, the new feature taking on Hadoop and MongoDB for sheer speed; coverage of the new SQL Azure integration capabilities; improvements in existing features such as AlwaysOn and columnstore indexing; and an exciting new DMV called sys.dm_exec_query_profiles, which can be used as a "progress bar" for real-time query execution monitoring. Along the way we'll look at Resource Governor changes that allow physical throttling of disk IOPS, how to extend the buffer pool onto solid-state disk, and the contentious new 'delayed durability' feature allowing (almost) asynchronous transaction processing, and more.

Speaker - Derek Colley

Derek Colley works as a self-employed SQL Server Database Administrator for clients across the UK. Degree-educated and a Microsoft Certified Professional, he has administered both Oracle and SQL Server databases for multi-nationals, start-ups, public and private sector businesses, dotcoms and service providers. He specialises in SQL query and database performance optimisation, and also has a strong interest and academic background in creating artificially-intelligent applications. In his spare time he enjoys playing Scrabble, reading and spending time with his three children.

To access materials please fill out the form below.

  I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.

More SQL Server Solutions

Learn more about SQL Server tools