Learn more about SQL Server tools

mssqltips logo
 

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

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

SQL Server 2014 New Features

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.



































By submitting this data you are accepting to receive newsletters, account updates and special offers about SQL Server from MSSQLTips and our sponsors. We respect your privacy and you can unsubscribe at any time.



More SQL Server Solutions











Learn more about SQL Server tools