SQL Server 2014 Performance Tuning Day
Date and time
Location
Hilton Hotel, Charlemont
2 Charlemont Pl Dublin IrelandRefund Policy
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 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)
Organised by
The SQL Server Ireland User Group was founded in 2006 to foster & grow the Irish SQL Server community while providing networking opportunities & sharing experiences using SQL Server.
This group is a local chapter of PASS - The Professional Assosciation for SQL Server (www.sqlpass.org)
Meetings are held most months, usually in the evening of the first Tuesday of the month. We do collaborate with others to support larger conference events from time to time; including the highly successful SQL Saturdays.