Description

This course offers you a focus on the new features of SQL Server 2014 that are essential for efficient and secure use. You will see in particular the latest developments in terms of administration, optimization, security, high availability as well as the new components of the SQL Server BI solution.

Who is this training for ?

For whom ?

Administrators, DBAs and developers of database solutions who plan to upgrade to SQL Server 2014.

Prerequisites

Training objectives

Discover the main contributions of the 2014 version of SQL Server Understand major improvements for administration and security Get an overview of new features intended to improve performance Understand the purpose of using In-Memory OLTP in 2014 and how it works Understand the principles and purposes of high availability with SQL Server 2014 See the new components of the SQL Server BI solution in 2014

Training program

• Overview of SQL Server 2014
  • Overview of the main features of version 2014.
  • Migrate from previous versions.
  • Integration with Windows Server 2012.
  • What's new in SQL Server Management Studio.
  • Practical work Migrating from a previous database.
• New features for administration and security
  • New features in backups: encryption and integration with Windows Azure.
  • New features in extended events (Xevents).
  • New features in the resource governor for inputs/outputs.
  • Using Storage Spaces with Windows Server 2012.
  • Improvements to support network shares in SMB 3: SMB Transparent Failover, SMB Direct.
  • New permissions.
  • Practical work Use of extended events, encryption of backups.
• New for performance
  • Clustered ColumnStore index: columnstore indexes on write-enabled tables.
  • The new cardinality estimation engine.
  • Controlling the durability of the transaction.
  • Extending the data cache on SSD disk.
  • Incremental statistics calculation.
  • Practical work Creation of a table with index ColumnStore, Checking the durability of the transaction.
• In-Memory OLTP
  • What is In-Memory OLTP? What are the use cases? Creating in-memory tables.
  • Interoperability with traditional tables.
  • Creation of hash indexes and b-tree indexing.
  • Creation of native compiled stored procedures.
  • Practical work Creation and use of In-Memory tables .
• High availability
  • The principles of high availability with SQL Server 2014.
  • Always On Availability Groups.
  • Enhancements since SQL Server 2012.
  • Integration with Windows Azure.
• New features for business intelligence
  • A few reminders about business intelligence with SQL Server.
  • The tabular model.
  • Integration with Hadoop, HDInsight connectors.
  • Power View for Excel.
  • Power BI for Office 365.
  • Power Query for Excel 2013.
  • Power Map for Excel 2013.
  • Practical work Demonstration of an HDInsight connection.