How to Create Snapshot Replication in SQL Server - SQL Server 2016 DBA Tutorial

Scenario:

You are working as SQL Server DBA. You are asked to perform Snapshot Replication in SQL Server 2016. What steps you will follow to perform Snapshot Replication setup?

Solution:

Video demo explains all the important points those are required to perform Snapshot Replication in SQL Server 2016. Demo covers


  • What is Snapshot Replication in SQL Server
  • When you use Snapshot Replication
  • What are the reasons we need to use Snapshot Replication
  • How Snapshot Replication works
  • What are Snapshot Agent, Distribution Agent and Merge Agent
  • Go through Security Best Practices for Snapshot Replicaiton Setup
  • How to use Replication Monitor in SQL Server
  • How to use Replication Monitor in SQL Server for Snapshot Replication


How to setup Snapshot Replication in SQL Server 2016

How to create Merge Replication in SQL Server 2016 - SQL Server 2016 DBA Tutorial

Scenario:

How to create Merge Replication in SQL Server 2016?

Solution:

In this video demo, you will learn how to create Merge Replication in SQL Server 2016.


1. What is Merge Replication in SQL Server 2016?
2. How to setup Merge Replication in SQL Server 2016?
3. How to setup Merge Replication using separate Distributor?
4. What are security best practices of Merge Replication?
5. How to monitor Merge Replication using Replication Monitor?


How to setup Merge Replication in SQL Server 2016

How to setup Transactional Replication in SQL Server 2016 - SQL Server 2016 DBA Tutorial

Scenario:

How to setup Transactional Replication in SQL Server 2016?

Solution:

In this demo, you will learn how to setup Transactional Replication in SQL Server 2016. Demo covers below topics

1. What is Transactional Replication in SQL Server 2016?
2. How to setup Transactional Replication in SQL Server 2016 step by step?
3. What are the Security Best Practices of Replication?
4. How to Setup Transactional Replication in SQL Server 2016 using different Distributor?
5. How to monitor Transactional Replication using Replication Monitor?
6. How to Troubleshoot replication issues using Replication Monitor?
7. Resolution to the error “Server is not enabled as a publisher on the Distributor”



How to setup Transactional Replication in SQL Server 2016

Understanding Replication in SQL Server 2016 - SQL Server 2016 DBA Tutorial

Scenario : 

What is Replication in SQL Server?

Solution :

This video demo can be used to Understanding Replication in SQL Server 2016. It explains all the components for Replication step by step.

Demo covers below points
1. What are replication components in SQL Server?
2. What is Publisher?
3. What is Distributor?
4. What is Subscriber?
5. Overview of Replication Agents
Snapshot Agent
Distribution Agent
Merge Agent
Log Reader Agent
Queue Reader Agent
6. Replication Jobs on SQL Server 2016 Agent
7. How to troubleshoot Replication using Replication Agents Jobs?


What is Replication in SQL Server, What are important components of Replication in SQL Server.

How to find Number of Processors, Cores and Logical Processors on Machine

Scenario:
You need to find the Number of CPUs, Cores and Logical Processors on a computer, how would you do that?

Solution:

There are multiple ways you can find Number of CPUs, Number of Cores and Number of Logical Processors.

1) Go to Start and then in Run type msinfo32 and hit Enter.

You will see detail information about System. Look for Processor and you will be able to see information like below depending upon your computer configuration.


2) You can also go to Command Prompt and then paste below statement, you will get same information.


WMIC CPU Get DeviceID,NumberOfCores,NumberOfLogicalProcessors



How to Install SQL Server 2016 in Cluster Mode - SQL Server 2016 DBA Tutorial

Scenario:

You are working as SQL Server DBA, you are asked to install SQL Server 2016 in cluster mode, what steps you will take to perform the installation?

Solution:

In this video demo, you will learn all the steps you need to take to install SQL Server 2016 in cluster mode.

Video demo covers
  1. What are pre-requisites of Installing SQL Server 2016 in cluster mode? 
  2. How to Prepare Cluster nodes to install SQL Server 2016 in cluster mode?
  3. How to check SQL Server 2016 pre-requisites
  4. What is shared storage and how to configure Shared Storage 
  5. Best practices to configure Shared Storage in SQL Server 2016
  6. How to Add Shared Storage to the windows 2012 Server?
  7. Best practices of installing SQL Server 2016 in cluster mode?


Part 1 - How to install SQL Server 2016 in Cluster Mode


Part 2- How to install SQL Server 2016 in Cluster Mode

How to setup Distributed Availability Group in SQL Server 2016 - SQL Server 2016 DBA Tutorial

Scenario:

You are working as SQL Server DBA and you are asked to setup Distributed Availability Group in SQL Server 2016, What steps would you follow?

Solution:

The video demo, will explain all the steps you need to take to configure Distributed Availability Group. Demo covers below items

  • What is Distributed Availability Group in SQL Server 2016?
  • What are pre-requisites of Distributed Availability Group in SQL Server 2016?
  • How to create availability groups on different clusters to use in Distributed AG?
  • How to create Availability Group with Automatic seeding
  • How to create Listener in Availability Group
  • How to setup Distributed Availability Group using two different listeners?
  • How to Join Secondary cluster in Distributed Availability Group?
  • How to check status of Distributed Availability Group
  • Troubleshooting Distributed Availability Group


Part 1



Part 2



Part 3