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.
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.