SQL Server 2016 DTC Support In Availability Groups

In this post I’ll discuss the new support for Distributed Transactions in SQL Server 2016, how this is made possible and show a brief example of a distributed transaction from TSQL and a simple COM Application against a database in an Availability Group and a stand alone database. What is MSDTC? The Microsoft Distributed Transaction…

4

SQL Server 2012 Cumulative Updates

SQL Server 2012 has just had 2 new CUs released, if you are still running on SQL Server 2012 SP2 then there is CU10, if you are on SQL Server 2012 SP3 then it’s CU1 and in a departure from the previous process of needing to register to download the CU installer they are free…