SQL Server 2014 Features - SQL Server Training

Introduction

This 1-day SQL Server 2014 Performance Enhancements Training course is designed for Managers and Individual Contributors. During this course individuals will be provided with an in-depth understanding of all the features and functions of this software, which has been designed to streamline operations to reduce costs and improve business agility.

Pre-Requisites

There are no pre-requisites prior to attending this course

Who Should Attend

This course is suitable for:

• Those responsible for SQL Server performance tuning and optimisation.

Course Outline

• Updating columnstore indexes
• Managing Transactions, Locks and Latches
• Creating and Modifying Native Stored Procedures
• Extending the buffer pool onto an SSD
• "Hekaton" concurrency model
• Working with In-Memory OLTP Tables
• Investigating underlying structures
• Improving indexing to solve performance problems
• SQL Server 2014 Performance Features
• Leveraging the AMR Tool
• Creating an In-Memory table
• Administering "Hekaton" databases
• Controlling concurrency for disk-based tables
• Persisting In-Memory tables on physical storage
• Taking advantage of delayed durability
• Monitoring and Troubleshooting SQL Server 2014
• Exploiting optimiser changes
• Avoiding memory pressure