Azure ARM: SQL Server High-Availability and Multi-Datacenter Disaster Recovery with Internal Load Balancers (ILB)

Introduction I already posted in my blog several articles related to high-availability (HA) and disaster recovery (DR) for SQL Server in Azure Virtual Machines (VM), what I’m going to discuss in this new article is the Azure Resource Manager (ARM) evolution of the same HA/DR architecture based on AlwaysOn Availability Groups (AG) and Azure Internal…

1

Configure an ILB listener for SQL Server AlwaysOn Availability Groups in Azure ARM

This blog post is essentially a porting to Azure Resource Manager (ARM) of the article below, specifically focused on Internal Azure Load Balancer (ILB), where Azure Service Manager (ASM) was originally used: Configure an ILB listener for AlwaysOn Availability Groups in Azure https://azure.microsoft.com/en-us/documentation/articles/virtual-machines-sql-server-configure-ilb-alwayson-availability-group-listener The steps below assume you have already configured: At least a Resource…

24

SQL Server in Azure: Compare PaaS (SQLDB) and IaaS (Virtual Machine)

During the last year, Azure SQLDB team made a great job in porting an amazing number of new features into the platform, thus reducing the surface area gap with box product version of SQL Server. Today, deciding between IaaS and PaaS for SQL Server solution is pretty easy since fewer aspects need to be considered…

5

Multi-Terabyte SQL Server Database Backup Strategies for Azure Virtual Machines

With the advent of DS-SERIES and GS-SERIES with Premium Storage, now running big databases in Azure Virtual Machines (VM) is a reality, something that was not fully achievable until few months ago. You now have the power to run up to use up to 64 x 1TB disks and use 32 cores horse-power, with about…

7

Efficient SQL Server in Azure VM Backup Strategies using DS-SERIES and Premium Storage

With the advent of DS-SERIES and GS-SERIES with Premium Storage, now running big databases in Azure Virtual Machines (VM) is a reality, something that was not fully achievable until few months ago. You now have the power to run up to 64 x 1TB disks and use 32 cores horse-power, with about half Terabyte of memory,…

0

Azure SQLDB and SQL Server VM – How to make an equal cost comparison

Azure SQLDB is one of my favorite technologies and I often have to talk and work with my partners around features, performances, scaling, high-availability and disaster recovery. A key part of the deal is related to the cost, sooner or later in the preliminary discussion, I always expect comments like these: “Azure SQLDB is nice, we…

5

UPDATED: New White-Paper on SQL Server 2014 and Azure Blob storage integration

Last April I published, with my colleague Francesco Cogno, a big white paper on SQL Server 2014 and Azure Blob storage, explaining the benefits, new enabled scenarios, proposing a new Failover Cluster – like mechanism and internal mechanics. After two months, we received many feedbacks, both externally and internally in Microsoft, then I’m glad to…

3

Microsoft Azure Universal Storage for SQL Server 2014

I finally decided to write this blog post after the recent announcement, at last US TechEd in May, of a new Azure Storage feature called “Azure Files”, that is the possibility to mount Azure Blob storage as SMB shares inside Azure IaaS Virtual Machines (VM). Now, you have three different way (Azure Files, Azure Disks,…

4

New White-Paper on SQL Server 2014 and Azure Blob storage integration

This required a long work with my good friend and colleague Francesco Cogno (Twitter: @MindFlavor), but finally we have published this white paper, hope you will find it useful. Thanks to Silvano Coriani (Twitter:@SCoriani) from the Azure CAT team, Francesco Diaz (Twitter: @Francedit) and Pradeep M.M for the patience demonstrated in reading the entire content….

1