AlwaysOn Master Series Class1|| Difference Between HA and DR in Sql Server || Contact +91 9902590140

If anyone is looking for Sql DBA, Azure Sql DBA Training, PowerBi, Tableau, Oracle DBA, Linux, Azure and AWS DevOps Real Time Trainings and Online Job Support, Interview Support, Videos, Notes Please Whatsapp me @ 9902590140 or Send an Email to [email protected] Thank You Always On master sessions Topics To be Covered 1. Introduction to Always On 2. Legacy Architecture: Database Mirroring for High Availability and Log Shipping for Disaster Recovery 3. AlwaysOn Availability Groups for High Availability and Disaster Recovery 4. Deployment Planning and Considerations a. Topology Prerequisites i. Unit of Failover ii. Considerations for Replacing Log Shipping for DR 5. Quorum Model and Node Votes 6. Always On Demo and Configurations a. Creating VMs b. Setting up the Windows Cluster 7. Setting up Different Types of Always On a. Traditional Always On b. Multi Subnet Always On c. Clusterless Always On d. Distributed availability groups e. SQL 2022 new feature contained availability groups 8. Patching Always On Replicas 9. Upgrading and Migrating Always On Instances 10. Adding and Removing the Database in AG setup 11. Adding files with the same path and different paths in the AG setup 12. AG Database Refresh Activity 13. Setting up TDE on AG Databases 14. Working with CDC on AG databases 15. Table Portioning on AG databases 16. Setting up Replication on AG databases 17. Common Issues on Always On a. Login Failures on Secondary b. Job Failures c. Shrinking Log file of the AG databases d. Synchronization issues e. Performance issues with AG setup f. Configuration failures g. Failed to add database to the alwayson h. Failed to create listener 18. Alwayson performance internals and troubleshooting a. How alwayson synchronization works in synchronous and asynchronous replicas b. Alwayson worker pool or worker threads c. High log send queue latency d. High redo latency 19. Configure alwayson in IaaS and setup listener in Azure IaaS (load balancer) 20. Interview Questions on AG 21. Best Practices with AG 22. Extended Events 23. Query store 24. DMVs for alwayson Date : 2nd December 2023 Time : Saturdays and Sundays Morning 7 to 9 IST Duration : 1 – 1 and half Months Mode of Language : English Recordings and Notes Also Provided