Recent Updates to setting up SQL Server Availability Groups in Azure VM with AAD Domain Services

Reviewed by: Dimitri Furman, Kun Cheng This blog is an extension to the one that was published in February 2017 . In these eight months there has been some notable improvements to AAD Domain Services (AAD DS) and Azure Virtual Network (VNET) capabilities. Now, it’s even more easier and convenient to leverage AAD DS for… Read more

SQL Server Availability Groups in Azure VM setup with AAD Domain Services

Reviewed by: Steven Schneider, Sanjay Mishra, Mike Weiner, Kun Cheng, Dimitri Furman, Arvind Shyamsundar, Mahesh Unnikrishnan, Luis Carlos Vargas Herring and Nimesh Nedungadi Deploying SQL Server Availability Groups in Azure VMs typically involved provisioning two additional VMs to host an Active Directory Domain Controller. With Azure Active Directory (AAD) Domain Services (aka managed domain services… Read more

SQLSweet16!, Episode 2: Availability Groups Automatic Seeding

Reviewed by: Denzil Ribeiro, Murshed Zaman, Mike Weiner, Kun Cheng, Luis Vargas, Girish Mittur V, Arvind Shyamsundar, Mike Ruthruff If you have been using Availability Groups (or Database Mirroring prior to that), you are probably used to backing up the primary and restoring (with norecovery) the secondary (first a full database backup, followed by transaction… Read more

Extending AlwaysOn Availability Group to Remote Azure Datacenter (PowerShell)

Author: Steven Schneider Reviewers: Sanjay Mishra, Shep Sheppard, Mike Weiner, Kun Cheng, Rama Ramani, Yorihito Tada, Hongyi Wang If you are looking for multi region continuous availability, by extending your current availability group to a remote Azure datacenter, then this blog is for you. We start with an existing availability group already setup within Azure,… Read more

AlwaysOn Availability Groups, Listener, Named Instances, Port Numbers, etc.

Author: Sanjay Mishra Reviewers: David P. Smith (Active Network), Mike Ruthruff (Bungie Studios), Matt Neerincx, Luis Carlos Vargas Herring, Piyush Ranjan, Steven Schneider   My job provides me opportunity to work across different sections of customers – some customers who like all defaults (default instances, default port numbers, etc.), and some customers who don’t like… Read more

AlwaysOn Availability Group in Windows Azure VM: Client Connectivity Scenarios

Author: Sanjay Mishra Contributors: Piyush Ranjan, Steven Schneider Reviewers: Ed Muth, Chuck Heinzelman, Silvano Coriani, Rama Ramani, Juergen Thomas, Cephas Lin, Lori Clark, Luis Carlos Vargas Herring Once you have created AlwaysOn Availability Groups in Windows Azure VM (tutorial) and created the Availability Group Listener (tutorial), it is important to know how the applications will… Read more

SQL Server 2012 AlwaysOn High Availability and Disaster Recovery Design Patterns

This is one of the popular blog posts on sqlcat.com. Reposting (with updated links) here after sqlcat.com is de-commissioned.   Author: Sanjay MishraContributors: Justin Erickson, Mike WeinerReviewers: Prem Mehra, Juergen Thomas, Steve Howard, Chuck Heinzelman, Jimmy May   SQL Server 2012 AlwaysOn provides flexible design choices for selecting an appropriate high availability and disaster recovery… Read more

SQLCAT.Com – eBook Downloads

As of September 1, 2013 we decided to remove SQLCAT.COM site and use MSDN as the primary vehicle to post new SQL Server content. This was done to minimize reader confusion and to streamline content publication.  MSDN SQLCAT blogs already includes most SQLCAT.COM Content and will continue to be updated with more SQLCAT learnings.  You can also… Read more

SQLCAT.com consolidated index of Whitepapers

In an effort to migrate as much content as possible from SQLCAT.com to the MSDN SQL CAT site we have consolidated all of the Whitepapers published over the last few years.   While all of the content actually exists on Technet and MSDN download sites, SQLCAT was a great resource to start looking.  Hopefully this will… Read more

AlwaysOn Availability Groups Generate Network Traffic with No User Activity

  Author: Kevin Cox Contributors:  Min He,Steve Lindell Reviewers: Sanjay Mishra, Juergen Thomas, Jimmy May   Creating an availability group needs pings and status checks across the different servers involved. This accounts for approximately 500 bytes per database in the group.  The PerfMon counter used to track the activity is “Bytes Received from Replica/sec”.  Books Online… Read more