Microsoft SQL Server 2014 Update
Course
Online
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.
Reviews
Subjects
- SQL
- IT
- Server
Course programme
This module will introduce In-Memory OLTP data structures and Natively-compiled stored procedures which have been added in Microsoft SQL Serevr 2014.
Columnstore IndexesThis 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.
SecurityThis 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 InternalsThis module will cover the update Resource Governor and a new feature Buffer Pool Extensions.
Cloud IntegrationThis 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