Having the ability to deploy Azure VMs starting from images hosted in a gallery is lovely if you need to create a new virtual machine from scratch quickly. Unfortunately, you often need to customize them, and being able to do it during the deployment phase can save you a lot Read more…
Azure Shared Disks and Distrubuted Network Names are the game-changers for SQL Server Failover Clusters on Azure VMs. Let’s see how they work!
Quickly and easily gain hands-on experience on SQL Server High Availability solutions with Azure VMs, by deploying my lab templates.
I faced some troubles in executing cmdkey.exe on a PowerShell remote session, while I was trying to automate the creation of a SQL Failover Cluster Instance on Azure VMs, using Azure Premium File Share (PFS) as shared storage. You need cmdkey.exe since you must persist Azure PFS access credentials on Read more…
An overview of high availability scenarios for Azure IaaS SQL Server environments, with some hints about cost-saving techniques.
The use of SQL VM on Azure IaaS is often abused, with customer unhappy with their performance or their costs. This kind of implementation has its place in SQL on Azure offering: let’s see when you should use them, and how to size them efficiently.
When you decide to migrate your SQL Server workloads on Azure, you must define which services will host them. In this first article of a series, I give an overview of different IaaS and PaaS approaches, and when you should use one instead of the other.
In the context of serverless automation, Azure Functions are a great and enabling tool also for SysOps like me, at least since PowerShell support reached a reasonable maturity even while in preview. Since you’re probably using Azure Functions for administrative tasks, it’s essential to raise the level from the security Read more…
Azure Functions written in PowerShell are an exciting feature for the ITPro who intend to create some serverless automation. Anyhow, during preview, it can be difficult to find documentation on every biding; in this article, I’m trying to fill the gap for the SendGrid binding.
I needed a demo environment for my PASS Global Italian Virtual Group session on SQL Server HA on Azure IaaS, to explain some topics regarding SQL Server 2016 Always On Basic Availability Group. To create simple environment with 2-nodes cluster, you have to: Prepare a basic infrastructure (AD, vnet and Read more…