SQL Server 2016 Administration

• Introduction to SQL Server 2016 New Features and Administration

• 1 Downloads and apps

• 2 Creating a VM with Windows OS

• 3 Installing sql 2016

• 3 Installing sql 2016 part 2

• 4 Installing SSMS

• 4a Installing SSMS

• 5 Installing sample dbs

• 6 Dynamic Data Masking

• 6 Dynamic Data Masking part 2

• 7 Row Level Security

• 8 Stretch database

• 9 Reasons to create stretch database

• 10 Cost of Azure

• 10b Create an Azure account

• 11 Stretch Demo

• 11a restoring stretch db

• 12 Live Query Statistics

• 13 Temporal Tables

• 13a Temporal Table part 2

• 14 Query Store

• 14a Query Store part 2

• 15 Forced Plan

• 15a Forced Plan

• 16 What is In Memory OLTP

• 17 In Memory OLTP demo

• 17a In Memory OLTP demo part 2

• 18 Determining memory tables

• 19 Restart services

• 20 Demo of performance and IO

• 21 Polybase

• 22 Azure Blob storage setup

• 22a Azure Blob storage setup

• 23 set up polybase

• 24 delete azure account

• 25 R technology

• BONUS VIDEO AND DOCS