Actions Panel

SQL Server 2014 Performance Tuning Day

By SQL Server Ireland User Group

When and where

Date and time

Location

Hilton Hotel, Charlemont 2 Charlemont Pl Dublin Ireland

Map and directions

How to get there

Refund Policy

Contact the organiser to request a refund.

Description

SQL Server 2014 has arrived with many new features for the relational database engine. Bring your skills up to date on the latest platform changes.

Klaus Aschenbrenner Klaus Aschenbrennerprovides with his companySQLpassion independent SQL Server Consulting Services across Europe and the US. Klaus works with SQL Server 2005/2008/2012/2014 from the very beginnings. Klaus has also written the book Pro SQL Server 2008. Further information about Klaus you can find on his homepage athttp://www.SQLpassion.at

He also tweets athttp://twitter.com/Aschenbrenner

In this 1 day long precon we cover all the various performance improvements that are part of the new SQL Server 2014 release. You will learn in which scenarios you can use the various features, and how it will improve the throughput of your SQL Server workload. We will cover the following areas in more details throughout the day:

  • Buffer Pool Extensions
  • Resource Governor
  • Lock Priorities
  • Delayed Transactions
  • Cardinality Estimation
  • Clustered ColumnStore Indexes
  • In-Memory OLTP (Hekaton)