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:

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