Infrastructure at your Service

SQL Server 2014 New Features workshop

dbi InSite Workshops

You have little or no experience in Microsoft SQL Server 2014 database administration and want to know what is new in the latest version of SQL Server? Then you should attend our SQL Server 2014 New Features workshop training. In this three-day course, you will learn all about the SQL Server 2014 new features and tools, changes, and enhancements – including In-Memory OLTP, Columnstore Indexes, backup and restore, Resource Governor, Hybrid Cloud, and SQL Server Data Tools.

Training’s dates

3 days
CHF 2700.- *


  • Stéphane Haby
    Stéphane Haby
  • David Barbarin
    David Barbarin

(*) Prices are to be considered per participant and without VAT

SOUG (Swiss Oracle User Group) The members of the SOUG (Swiss Oracle User Group) benefit from a 5 % reduction.

Training objectives

  • Understand the new features of SQL Server 2014
  • Experience the new Hybrid Cloud enhancements such as backup and restore, data files, and AlwaysOn
  • Learn all about In-Memory OLTP with Memory Optimized Objects, Metadata, and Concurrency Control
  • Experience the Resource Governor enhancements, the Buffer Pool extension, the incremental statistics, and many other novelties
  • Understand the SSDT changes


  • In-Memory OLTP: Memory Optimized Objects, Metadata, and Concurrency Control
  • New Columnstore Index features
  • Backup encryption
  • Resource Governor enhancements: IO resource governance, PerfMon counters, extended events, and DMV extensions
  • Partitioning enhancements: Managing lock priority of oline operations, rebuild partition online
  • Incremental statistics and Buffer Pool extension: benefits, architecture, and management
  • New design for cardinality estimation
  • Licensing rules
  • Hybrid Cloud: hosting an SQL Server database or data files in Azure, backup and restore into/from Azure, and AlwaysOn enhancements
  • Schema and data comparison with SSDT


  • Presentation with countless practical exercises and trainings
  • Case studies, live demos, discussions
  • Networking during coffee break, lunch, and apéro on last day (included in price, except for on-site workshop courses)

Target groups

  • Database administrators (DBA) as well as network, system, and application administrators responsible for or supporting SQL Server databases

Language & documentation

  • Workshop training normally held in English; French or German possible instead as course languages
  • Documentation: content details, scripts, case study solutions as PDF file (in English)

dbi InSite Workshop on-site - request & information

You want dbi services to hold an "on-site" workshop inside your organisation? You have special requirements, e. g. regarding the content, the duration, the date, or the number of participants?
We have good news for you: Our dbi InSite Workshops can be flexibly adapted to your needs! Please just fill in the form below and we will come back to you as soon as possible. You may also use this form to inquire on the future dates of our dbi InSite Workshops.

Please contact me via :

 E-mail Phone

Where did you know dbi services ?