SQL Server 2016

Step by Step SQL Server 2016 DBA Tutorial

Introduction  

1. What's New in SQL Server 2016
2. SQL Server 2016 Enhancements from SQL Server 2014
3. How to install SQL Server 2016 CTP
4. What is Data Stretch in SQL Server 2016 and how to Enable It
5. What is Query Store In SQL Server 2016 and How to Enable It
6. What are new options in SQL Server 2016 Databases
7. How to use Query Store Feature in SQL Server 2016

Installation:

1. How to install SQL Server 2016 Enterprise Engine Services step by step
2. How to install SQL Server 2016 in Cluster Mode Step by Step
3. How to install and Configure SQL Server 2016 Enterprise Reporting Services 
4. How to Install and Configure SQL Server 2016 Analysis Services
5. How to Install SQL Server 2016 Management Studio
6. How to Install and Configure SQL Server 2016 Master Data Services

AlwaysOn Availability Group

1. How to Configure Availability Group in SQL Server 2016
2. How to Add Contained Databases in SQL Server 2016 Availability Group
3. How to Create Availability Group with Automatic Seeding in SQL Server 2016
4. How to setup Distributed Availability Group in SQL Server 2016 Step by Step

Replication 

1. Understanding Replication in SQL Server 2016
2. How to Create Snapshot Replication in SQL Server 2016
3. How to setup Transactional Replication in SQL Server 2016
4. How to create Merge Replication in SQL Server 2016
5. How to create Peer to Peer Replication in SQL server 2016

Mirroring

1. How to setup / create Database Mirroring in SQL Server 2016
2. How to remove Database Mirroring in SQL Server 2016