I would like to get involved and contribute to the SQL Server community, earn and keep MVP status, and be a solid resource for SQL Server professionals who are just...

For AlwaysOn AG synchronization, the following article explains it well: https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/availability-modes-always-on-availability-groups
For mirroring synchronization, the following article explains it well: https://docs.microsoft.com/en-us/sql/database-engine/database-mirroring/database-mirroring-operating-modes

Proving, without any doubt, that you are NOT a mature nor a professional person. Have fun figuring it out on your own.

Service packs are not released specific to the services they patch. There is one patch for all the services, including SSRS. So, just grab the appropriate patch for the version...

Sorry, I got lost looking for the answer--it won't work on your present environment. Windows Server 2016 is the first platform that allows the WSFC to span more than one...

I don't know all the "pros and cons", but it is possible with Windows Server 2016 and SQL Server 2016, as described in this article: https://blogs.technet.microsoft.com/dataplatforminsider/2015/12/15/enhanced-always-on-availability-groups-in-sql-server-2016/

It looks like this question has been asked before, and it looks like you "can" achieve this, but it will require some work and further research. I found the question...

@ Bmg002: +1
Yes, I agree that cursors are evil ( 😀 ), but they do have their uses occasionally. Very cool answer!!
It would be really cool to see...

@jason - I checked out the linked article about "security theater" and tested what the writer claimed to be a "security hole", which was in fact an edge...

AlwaysOn Availability Groups are what mirroring + replication should have always been...and is the cross-breeding of HA and DR. With Enterprise Edition of SQL Server, you can have 2 synchronous...

@bill - Keep in mind that SQL Server 2014 and higher has a Developer Edition that is completely free, and downloadable from Microsoft's site(s). So...you could go with...

Michael is completely correct...all of the Microsoft HA offerings will take about 30 seconds to failover when an event causes the primary to fail and the secondary becomes the new...