Microsoft SQL Server 2014 Update

Course

Online

Price on request

Description

  • Type

    Course

  • Methodology

    Online

Microsoft SQL Server 2014 enhances the previous product in its use of In-Memory OLTP storage, enhanced columnstore, new hybrid cloud scenarios, enhanced security in server and database access, and backup encryption. This workshop-style course is designed for IT professionals who are interested in learning how to implement these new features.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • SQL
  • IT
  • Server

Course programme

In-Memory OLTP

This module will introduce In-Memory OLTP data structures and Natively-compiled stored procedures which have been added in Microsoft SQL Serevr 2014.

Columnstore Indexes

This module will introduce the new important changes to the Columnstore Indexes, first introduced in Microsoft SQL Server 2012. The major change is that new structures are clustered and allow updates directluy against the tables.

Security

This module will cover the updates to security on Microsoft SQL Server 2014 and will include changes to permissions available at the server and database levels. Also included in the module is a discussion of the need to encrypt backup databases and the new feature to allow this natively with requiring TDE.

SQL Engine Internals

This module will cover the update Resource Governor and a new feature Buffer Pool Extensions.

Cloud Integration

This module will cover the updates within Microsoft SQL Server 2014 look at making use of the Microsoft Azure platform. This includes holding data files within Windows Azure, backing up to Windows Azure using normal backup routines and the new Managed Backup and lastly using a Windows Azure VM as an Always-On failover partner.

Microsoft SQL Server 2014 Update

Price on request