mssqltips logo

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












download





get free sql tips

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.



Learn more about SQL Server tools