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.

 

Schulungstermine

3 Tage
CHF 2700.- *

Ausbilder

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

(*) Preise ohne Mehrwertsteuer angezeigt

SOUG (Swiss Oracle User Group) Die Mitglieder des Soug (Swiss Oracle User Group) profitieren von einem 5% Rabatt.

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

Topics

  • 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

Method

  • 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 - Anfrage & Information

Sie möchten, dass dbi services in Ihrer Organisation einen "On-Site" Workshop durchführt? Sie haben spezielle Anforderungen im Bezug auf Inhalt, Dauer, Zeitpunkt oder Teilnehmerzahl? Wir haben gute Nachrichten für Sie: Unsere dbi InSite Workshops passen sich Ihren Bedürfnissen flexibel an! Füllen Sie einfach das folgende Formular aus. Wir werden sobald wie möglich Kontakt mit Ihnen aufnehmen. Sie können sich mit dem Formular auch über die künftigen Termine unserer dbi InSite Workshops informieren.
Falls Sie sich für einen dbi InSite Workshop mit aktuellem Datum einschreiben möchten, benutzen Sie bitte unsere Buchungsseite.





Bitte kontaktieren Sie mich :

 per E-Mail telefonisch

Woher kennen Sie dbi services?


captcha

Pierre-Yves Brehier
Pierre-Yves Brehier

Region Manager







captcha