(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)
I’m very proud to announce that I will speak at the SQLSaturday #310 in Dublin. On September 19 I will do a full-day long precon about Performance Tuning Enhancements in SQL Server 2014. I will also present one regular session on Saturday about Plan Caching in SQL Server. Here’s the agenda and the break-down for my precon on Friday:
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)
