Thanks! So when the new SQL Server gets built i would like to do automating service account. How is this possible?

The trigger needs to be deployed on all servers whenever the new SQL Server gets created right?

Can you setup mirroring from SQL 2012 to SQL Server 2014? Primary on SQL 2012 and mirror on SQL 2014. Is that possible?

Thanks again. I agree with you about mirroring deprecated feature. However, lot of applications are not really supporting for AG group setup until SQL 2016.

Thanks! I am familiar with fail over for DR. However, the principal database will be on 2 node cluster. What happens when the failover happened on Principal server side, like...

Why. SQL Server 2012 does have database mirroring.
So my primary server would be part of SQL Server clustering and mirror would be in DR. So you saying the add...

Thanks. However, the principal database would be part of N way SQL Server cluster. I have question what is the difference between two node cluster and N-Way cluster? Also, when...

Thanks for the reply.
Sorry if i wasn't clear with my question.I am looking to configure a mirroring for the database which is part of Always on FailOver Clustering Server....

Thanks again!
Do you see any issue setting up Availability group in SQL 2014?

Thanks. Do you know when Microsoft is planning to stop supporting database mirroring?

So DTC is part of windows operating system right? Distributed transaction has nothing to do with SQL Server right?
What version of SQL Server did you configure Always on...

Thanks John for the info! However, i have been doing lot of learning on my side as well, just wanted some clarification on DTC. There were no much information posted...

I was looking to setup always on availability group in SQL Server 2014. Found that distributed transactions are not supported in prior to SQL 2016. Distributed transactions are used by...

I am assuming the replication is already configured. So you can truncate and reseed the table and all the changes would be replicated to subscriber. I don't think you would...

I am trying to implement a better process when the new SQL Server is built in the network then i should get notified? Something like sql server inventory. Other than...