Tags » AlwaysOn

Read This Before Implementing AlwaysOn for BizTalk Server 2016

One of the major news in BizTalk Server 2016 is the full support for SQL AlwaysOn Availability Groups (AGs). When Microsoft announced this, the crowd cheered, and they moved on to the next slide. 551 more words


AlwaysOn 2016 – New and Improved

–by Ginger Keys

AlwaysOn Availability Groups made its debut in SQL Server 2012 as a new feature that enhanced the existing technologies of database mirroring and failover clustering to provide an option for high availability and disaster recovery. 2,060 more words

SQL Server

Setting up Always On Availability Groups for SQL Server in Azure

Almost all organisations rely on data, be it in the form of files or databases (SQL, Oracle…). The most challenging aspect of managing data for any organisation is high-availability and disaster recovery. 3,637 more words


Strange Behavior in Identity Columns in SQL Server 2012


A couple of years ago, after a successful migration from SQL Server 2008 to SQL Server 2012 a colleague from the DEV team gave me a call soon after a failover process involving an AlwaysOn Availability Group. 514 more words

How to move AlwaysON AG Databases ?

Back in 2011, we have seen how to move a database which is participating in DB Mirroring here. In this blog post, let’s see how to move a database which is participating in a AG to a new drive(location). 249 more words

AlwaysOn Availability Groups

T-SQL Tuesday #080: Change Always On Endpoint Ports

Thanks to Chris Yates for hosting this month’s T-SQL Tuesday (https://chrisyatessql.wordpress.com/2016/07/06/t-sql-tuesday-080/)! This month’s topic is fairly broad (a SQL-related present so I wanted to put together a quick post whose information definitely would have saved me some time if it had existed a few years ago. 383 more words


Azure Infographic: SharePoint with SQL Server AlwaysOn

The Deploy SharePoint with SQL Server AlwaysOn infographic from Microsoft provides a really good visual representation of how to design a SharePoint solution in Microsoft Azure. 47 more words