SQL Server alwayson - part 2

explanation is good, but try to make all things fast. it is very slow.

i liked the way you covered all aspects !! Very helpful share. - thanks

Great JOB...

Kindly provide your email id.

Do we need to create windows cluster before installing SQL SERVER on both the nodes?

Nice presentation, really helpfull

Nice explanation...... THANK YOU

its very nice.. thanks for sharing...

Great effort and super explanation.....A Big Thank You

Very well explained for beginners, Thx

explain by hear !! thanks :)

thanks very much very useful!

Great tutorial! Would I be able to fail over to my secondary in DR site if my main data center which has the Windows Cluster configured goes down? Thank You.

Hi Sir.i would like to know more on SQL DBA concepts..could you please confirm that can you please provide me the online training?please revert me on [email protected] waiting for your revert..

good teacher , no doubt , like the style very simple

Kindly provide your email id.

All your videos are Superb - cleared so many doubts.
Thanks a lot..!

KUDOS Man ---/\---

Great video - thanks for making this available. I saw that n the demo, the read-only application intent connection went to the primary replica. I have also seen that when connecting in SQLCMD (-k switch) when the database being connected to is not in the availability group (master in your case). The initial connection needs to reference a database in that availability group then it works :).

gr8 tutorial !!! 👍

I have a question that since it is at database level, what about both servers' master database copies. isn't it has to be same? if yes or no ? please explain. It is wonderful explaining

how application will have credential on secondary replica ? how we can configure applications for AlwaysOn technology
what if master database is corrupted, can we failover on secondary replica while we restore master db on primary

what about if we have added more users ? how on secondary replica, new users will have authentication ? is it a manual job we need to perform ?

Good Lectures but you just stretched thing :(

Great stuff

EXCELLENT

Great Tutorial...Super

This is Called -- Deep Dive Always On ..

Hello, i have Windows Server 2016 with SQL 2016 Enterprise. We have a failover cluster configuration.
We have 2 nodes , SQL01 and 02.
We have created an availability group which has 3 db's inside it.
It is with Synchronous and readable on Secondary for both SQL servers. Automatic failover has been configured.
currently jobs have been created on the SQL01 only. No jobs have been created on SQL02.

Now when the failover happens:
1. Will it start writing data on the secondary SQL02 ? If yes , will that data be synchronized to SQL01 ?
2. What happens to the jobs ? if the jobs are processed will the data be replicated back to SQL02 ?

Please help as i am trying to find a solution for this.

thanks very much that is amazing lecture!!!

good one but there is so much redundant information, repeating same statements.. had slept off twice :D

Hi thanks a lot for detailed explanation on Always on .Just wanted to Address something here at the last few seconds there was some confusion in application intent being read only and while running select @@servername why the name of the primary server is being displayed .According to me the issue is not with the settings but with the query the query is being run on the master database and system database cannot be in an AG if it was a query related to a table which is part of a database in AG then it may have directed it to VSQL instead of Node 3.

please upload recent tutorials in respective chapters Thanks a lot

Really good thorough explanation, thank you

great job but poor presentation...totally disappointed

Well Explained ... Thank you so much,

Some disappointment with your presentation. important things u skip like Backup preference,listeners etc. Many imp points u r skipping.Needs improvement.

Can you please tell me how have you created cluster instance

Sir speed is very less...

How many times you will keep repeating same lines

Excellent training. Very nicely taught and explained. Some folks may find your style of presentation orthodox, but I personally loved it and it gave me a feel of being in a class room in a live training. Thank you.

Good one. I have a video on configuring the AlwaysOn setup in Azure . It will brief you about the ateps and requiremebts and walk you through my setup. Do visit if it interests you 😊

Hi

Thanks Ramu sir... Very well explained....

can you make video for AG 2017, new features

Very Nicely described thanks. May i know your name plz

Hi Sir y you don’t post anything on this channel..

Excellent Explanation

windows cluster do not show after restart of windows ? why ? Windows server 2019 Data center edition

tha18.12Wash.ia/ilamb.aoAg.oa/Stigma./eEiaLand.Mi*xn.worLd.//nd.D