—Introduction
0m 44s
—Evolution of SQL Server
1m 53s
—What Is This Course About?
0m 49s
—What Is in This Course?
6m 41s
—Summary
1m 5s
Backup Enhancement
- 23m 21s
—Introduction
0m 55s
—Prerequisite Software
3m 0s
—Backup Encryption
1m 37s
—Understanding Prerequisites
1m 25s
—Demo: Prerequisites
0m 51s
—Demo: Backup Encryption
5m 2s
—Demo: Restoring Encrypted Backup
2m 45s
—Demo: Backup Encryption - Advanced
6m 52s
—Summary
0m 50s
Security Enhancements
- 24m 25s
—Introduction
1m 1s
—Scenario - Visiting Auditor
1m 20s
—Demo: Enhancement of User Object Permissions
6m 13s
—Scenario - Case of Impersonation
1m 24s
—Demo: Traditional Impersonation
5m 53s
—Demo: Impersonation of System Admin
4m 13s
—Demo: Enhancement of Impersonation Permission
3m 26s
—Summary
0m 51s
Columnstore Index Enhancements
- 41m 12s
—Introduction
1m 8s
—Columnstore Index Enhancements
1m 36s
—Generic Columnstore Characteristics
1m 59s
—Columnstore Characteristics - SQL Server 2012
1m 51s
—Columnstore Characteristics - SQL Server 2014
2m 36s
—Demo: Nonclustered Columnstore Index
5m 26s
—Demo: Clustered Columnstore Index
2m 20s
—Demo: Clustered Columnstore Index Advanced
6m 26s
—Demo: Columnstore Index and Performance
3m 55s
—Demo: Columnstore Index and Storage
3m 2s
—Columnstore Internals
2m 3s
—Columnstore Architecture
2m 46s
—Demo: Columnstore Internals
5m 11s
—Summary
0m 47s
Online Database Operational Enhancements
- 24m 41s
—Introduction
0m 47s
—Real World Remarks
0m 50s
—Online Operations With SQL Server 2012
2m 42s
—Changes With SQL Server 2014 With Online Operations
1m 49s
—Managed Lock Priority Options
1m 16s
—Demo: SQL Server 2012 Online Index Operation
3m 26s
—Demo: SQL Server 2014 Online Index Operation
3m 19s
—Demo: Managed Lock Priority Options
3m 31s
—Demo: SQL Server 2014 Online Partition Operation
6m 8s
—Summary
0m 49s
Enhancements With Microsoft Azure
- 1h 3m
—Introduction
1m 14s
—Backup Scenario Today
1m 3s
—Backup Scenario on Cloud
1m 58s
—Encrypted Backup and Restore Scenario to Cloud
1m 54s
—Advantages of Backup With Azure
1m 47s
—Backup to URL
1m 24s
—Prerequisite
2m 10s
—Demo: Prerequisite Setup
3m 56s
—Demo: Manual Backup to Azure
6m 11s
—Demo: Manual Backup to Azure With Encryption
7m 25s
—Demo: Manual Restore From Azure With Encryption
4m 14s
—What Is Automated Managed Backup?
1m 50s
—Sequence for Automated Managed Backup
1m 52s
—Demo: Automated Managed Backup
2m 28s
—Demo: Managed Backup at Database Level
7m 40s
—Demo: Managed Backup at Instance Level
5m 4s
—SQL Server Data Files in Windows Azure
2m 46s
—Demo: SQL Server Data Files in Windows Azure
7m 45s
—Summary
0m 59s
Buffer Pool Extension
- 12m 17s
—Introduction
0m 41s
—Why Buffer Pool Extension?
1m 41s
—Benefits of Buffer Pool Extension
0m 51s
—How Buffer Pool Extension Works
1m 16s
—Buffer Movement and Eviction
2m 8s
—Demo: Buffer Pool Extension
4m 42s
—Summary
0m 54s
Resource Governor IO Enhancements
- 21m 51s
—Introduction
0m 53s
—Why Resource Governor?
2m 46s
—Resource Governor IO Control
1m 43s
—Syntax
1m 29s
—Demo: Resource Governor Setup
3m 57s
—Demo: Resource Governor IO Control
3m 49s
—Demo: Resource Governor IO Control DMV
2m 30s
—Demo: Resource Governor IO Control and Backup
3m 57s
—Summary
0m 44s
Miscellaneous Enhancements
- 34m 56s
—Introduction
1m 12s
—Online Index Rebuilding Operations
0m 53s
—Partition Problem Statement
1m 52s
—Online Index Rebuilding for a Single Partition
1m 18s
—Demo: Online Index Rebuilding for a Single Partition
4m 38s
—Live Plans for Long Running Queries
1m 0s
—Demo: Live Plans for Executing Queries
3m 29s
—Transaction Durability
0m 34s
—Full Transaction Durability
1m 15s
—Delayed Transaction Durability
1m 50s
—Visual Explanation: Delayed Durability
1m 23s
—Demo: Delayed Durability
4m 5s
—New Cardinality Estimation
1m 39s
—Demo: New Cardinality Estimation
3m 18s
—In Memory OLTP Optimization
1m 52s
—Demo: In Memory OLTP Optimization
3m 40s
—Summary
0m 51s