REAL WORLD DEMO of where AlwaysON connection gets established in different configurations

In this video I demonstrate how always on redirects connections under various failover scenarios. This is especially important considering readable replicas and secondary replicas that are available in newer versions of Microsoft SQL server. I create a dummy website and then fail over the database to demonstrate how the website reacts under different scenarios. In SQL 2019 Microsoft has created the ability for databases to fail over and the connection string to automatically re direct to the new primary this is demonstrated towards the end of the video. For more comprehensive explanation of AlwaysOn please check out my other videos in the playlist.

Need more information?
Visit https://www.enabledbusiness.com

To know more about Jayanth Kurup visit www.jayanthkurup.com

Jayanth is a Microsoft SQL Server trainer / consultant with over 15 years experience. He has worked with companies like Microsoft, IBM, HCL , Wipro , WellFargo , Zeomega and many more. He is based out of Bangalore and a very active member of the SQL Server Community.

In this channel he covers complex topics related MS SQL Server , PowerBI , Azure , AWS , Powershell, SSIS , SSAS , SSRS , Machine Learning , AI , etc

You can also reach Jayanth via his LinkedIn profile below
https://www.linkedin.com/in/jayanth-kurup-653a407/?originalSubdomain=in

music from HAAWK

Видео REAL WORLD DEMO of where AlwaysON connection gets established in different configurations канала Jayanth Kurup