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

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

SQL Server 2014: Inside Hekaton Natively Compiled Stored Procedures

During the last period, I spent some time with several Microsoft ISVs around the world, talking and testing the amazing Hekaton new in-memory engine in SQL Server 2014. As often happens when a new technology appears on the stage, people do not fully understand all the implications and capabilities, and often concentrate only on a…

7