Tags » AlwaysOn

Strange Behavior in Identity Columns in SQL Server 2012

Hi,

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

AlwaysOn

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

Infrastructure

SQL Saturday #531 - I'm Speaking!

I’m honored to have been selected to speak at SQL Saturday #531 in Louisville, KY on August 6. I’ll be presenting the session that accompanies the first blog post on this site ( 79 more words

AlwaysOn

Configuring Alerts for SQL Server Using Dynamic SQL

Here is a dynamic SQL query, which will generate a script that you can use to create new alert(s) for each error number you specify. 593 more words

Microsoft SQL Server

Citrix XD 7.9 Install – [Extra] Installing SQL Always On For XD 7.9 [Part 1]

During the deployment of Citrix XenDesktop, we are often asked to provide a redundant database solution. As of now, XenDesktop 7.9 officially supports Database Mirroring… 565 more words

Microsoft