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

3
3

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

Azure VM Resizing and SKU Change in ASM and ARM

4
4

One of the major benefit of the Cloud is the possibility to dynamically change the type and size of your VMs (scale-up/down) and have more/less power to support your workload and at the same time reducing the cost for the resources you will use. Azure provides several VM SKUs and many different sizes, each one…

12

Hub&Spoke, Daisy-Chain and Full-Mesh VNET topologies in Azure ARM using VPN (V1)

IMPORTANT: This is an old version using Azure PowerShell ARM module earlier than 1.0.0 release. If you want/need PowerShell version later than 1.0.0, please use the article below. Hub&Spoke, Daisy-Chain and Full-Mesh VNET topologies in Azure ARM (V2) http://blogs.msdn.com/b/igorpag/archive/2016/02/11/hub-amp-spoke-daisy-chain-and-full-mesh-vnet-topologies-in-azure-arm-v2.aspx Introduction One of the key benefit of Azure VPN is the flexibility in arranging almost any…

11

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…

6

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

Register an Azure VM Image from VHDs

During my recent activities for one of my partners, an interesting request raised: how we can export or publish or share a VM image between different subscriptions? In the ISV/CSV world is pretty common to have the possibility to create an image in a “factory” subscription and then use it in different subscriptions, whenever owned…

2