
Author Introduction and prerequisite (knowledge expectation) before going with this Advance course.
What is HADR and Type of HADR
Compare with Privious version solution
Types of High Availability and Disastrous Recovery Solution
Installation of Named Instance / Multiple Instance on same Box.
Named Instance Installation & Configuration to showcase HADR Solution.
•Log Shipping – About Log shipping – A overview
•Advantage of Log Shipping
•Configuration of log shipping – Adding / Removing Database
•Monitor Log Shipping
•Managing Log Shipping
•Failover to Secondary – Log shipping
•Changing roles of log shipping between servers / Instances
•Log Shipping Tables and stored procedure
•Removing of Log Shipping
•Industry Perspective – When & Why to use Log shipping
1.Enable Log shipping configuration
2.Configure Backup Setting on Primary
3.Add Secondary Server for Log Shipping
4.Configuring log shipping monitoring Server
5.Configuring log shipping copy/Restore Operation
6.Log shipping Transaction records with an example
7.Remove database from log shipping
8.Bring Database online
Validation & Cleanup - Log shipping
•Definition , Benefits ( Advantage ) of Replication – Publisher , Subscriber , Replication Agent
•Types of Replication
•Snapshot replication
•Transaction Replication
•Merge Replication
•Configuration of Replication
•Subscribe to Replication
•Managing replication configuration
•Validation replication
•Monitor Replication Agent
•Replication snapshot agent
•Log Reader Agent
•Replication associate Jobs
•Push Subscription
•Pull Subscription
•Delete/Remove Subscription
Configuration of Snapshot Replication
Configuration of Transaction Replication
Explore how Always On availability groups manage primary and secondary replicas, failover scenarios, synchronization modes, and data validation to ensure consistent, available SQL Server databases.
Explore how to monitor and validate SQL Server Always On availability groups, including role switch, automatic failover, listener connectivity, and synchronization modes.
Note : Resource Governor topic doesn't have relevance with this course material therefore I have included only overview part and couldn't illustrate with demo or with real world scenario. However I have included Resource governor in detail in my other course with best fit "SQL Server DBA 2017x - Performance Tuning and Advance Utility" . Thanks
Hello aspiring Learner,
Greetings and Thank you for reading this course landing page !
Here I am industry veteran having experience of 18+ years having expertise in SQL server as Architect DBA , Introducing one more new job oriented course which will help you to introduce yourself as SQL Server DBA in industry as level 2 or Level 3+ level. Microsoft SQL DBA is traditional database technology which are very popular in IT space.
Industry are using this technology since year 1997 when Microsoft came out with release of their first version of SQL server.
I would encourage and recommended to aspiring learners to go ahead with this Advance Level course who would like to learn more about Sql server and would like to deep dive in Sql server technology and want to build career as Advance level SQL DBA .
I would also recommend for those who are working as SQL DBA and having more than 2+ years of experience.
Who should take this course -
1. Those who would like to build their career as SQL Server DBA OR Students /IT Graduates/MBA/MCA with basic computer knowledge and Basic SQL Server Skill. Please go with my other course for Beginners to Moderate level professional.
2. Existing DBA/IT professional who would like to learn advance level of SQL server as Database professional
3. Any other professional with Beginners level SQL server skills.
What aspiring learner will achieve after completion of this course -
1. He/She Will be professional Advance Level DBA or 2+ Level and 3+ Level DBA
2. Complete course to enter in an organisation as Sr. SQL Server DBA Professional ( L2 & L3+)
3. Free additional recommendation by instructor those who will enrol for this course upon request
Please visit to my course page to know more
Advantage : Upon your request enrolled professional or students can get free career guidance for limited period as a promotional activity and will guide them with most frequently asked questions and best answers with data bank.
Many Thanks.
Course Design, developed & Instruct by
Rakesh Jain | Leenetics