SQL Server 2014 Administration New Features
Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. This course takes a tour of the basic new features that were introduced, including backup, security, column store enhancements, Resource Governor, General Administration, Azure integration, extensions with SQL Server 2014 and more.
What you'll learn
Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. This course takes a tour of the basic new features that were introduced, including backup, security, column store enhancements, Resource Governor, General Administration, Azure integration, extensions with SQL Server 2014 and more. To get the most out of this course, viewers should be familiar with SQL Server and database concepts.
Table of contents
- Introduction 1m
- Columnstore Index Enhancements 2m
- Generic Columnstore Characteristics 2m
- Columnstore Characteristics - SQL Server 2012 2m
- Columnstore Characteristics - SQL Server 2014 3m
- Demo: Nonclustered Columnstore Index 5m
- Demo: Clustered Columnstore Index 2m
- Demo: Clustered Columnstore Index Advanced 6m
- Demo: Columnstore Index and Performance 4m
- Demo: Columnstore Index and Storage 3m
- Columnstore Internals 2m
- Columnstore Architecture 3m
- Demo: Columnstore Internals 5m
- Summary 1m
- Introduction 1m
- Real World Remarks 1m
- Online Operations With SQL Server 2012 3m
- Changes With SQL Server 2014 With Online Operations 2m
- Managed Lock Priority Options 1m
- Demo: SQL Server 2012 Online Index Operation 3m
- Demo: SQL Server 2014 Online Index Operation 3m
- Demo: Managed Lock Priority Options 4m
- Demo: SQL Server 2014 Online Partition Operation 6m
- Summary 1m
- Introduction 1m
- Backup Scenario Today 1m
- Backup Scenario on Cloud 2m
- Encrypted Backup and Restore Scenario to Cloud 2m
- Advantages of Backup With Azure 2m
- Backup to URL 1m
- Prerequisite 2m
- Demo: Prerequisite Setup 4m
- Demo: Manual Backup to Azure 6m
- Demo: Manual Backup to Azure With Encryption 7m
- Demo: Manual Restore From Azure With Encryption 4m
- What Is Automated Managed Backup? 2m
- Sequence for Automated Managed Backup 2m
- Demo: Automated Managed Backup 2m
- Demo: Managed Backup at Database Level 8m
- Demo: Managed Backup at Instance Level 5m
- SQL Server Data Files in Windows Azure 3m
- Demo: SQL Server Data Files in Windows Azure 8m
- Summary 1m
- Introduction 1m
- Online Index Rebuilding Operations 1m
- Partition Problem Statement 2m
- Online Index Rebuilding for a Single Partition 1m
- Demo: Online Index Rebuilding for a Single Partition 5m
- Live Plans for Long Running Queries 1m
- Demo: Live Plans for Executing Queries 3m
- Transaction Durability 1m
- Full Transaction Durability 1m
- Delayed Transaction Durability 2m
- Visual Explanation: Delayed Durability 1m
- Demo: Delayed Durability 4m
- New Cardinality Estimation 2m
- Demo: New Cardinality Estimation 3m
- In Memory OLTP Optimization 2m
- Demo: In Memory OLTP Optimization 4m
- Summary 1m
About the author
Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 81 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.