Azure IaaS IT PowerShell SQL Server
A new era for SQL Server FCI on Azure VMs
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!
Azure IaaS IT PowerShell SQL Server
SQL Server High Availability Solutions on Azure VMs
Quickly and easily gain hands-on experience on SQL Server High Availability solutions with Azure VMs, by deploying my lab templates.
Azure IT PowerShell SQL Server
Executing CMDKEY via a PowerShell remote session
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…
Events IT PowerShell SQL Server
Upcoming webinar about SQL Server and PowerShell
I’m honored to contribute again to the PASS Global Italian Virtual Group, where I’ll deliver a webinar about “SQL Server and PowerShell: from Zero to Hero!” on 29/01 at 18:00 (UTC+1). In 60 minutes, we’ll see how to use PowerShell to assess, manage and migrate instances, thanks to SQL Server Read more…
Azure IaaS IT SQL Server
SQL Server on Azure IaaS: HA and cost savings
An overview of high availability scenarios for Azure IaaS SQL Server environments, with some hints about cost-saving techniques.
Azure IaaS IT SQL Server
SQL Server on Azure: Why an IaaS VM?
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.
Azure IT SQL Server
SQL Server on Azure: journey to the Cloud!
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.
Azure IaaS IT SQL Server
Creating a lab environment on Azure IaaS to test SQL Server 2016 Basic Availability Group
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…
Azure IaaS IT SQL Server
Creating a lab environment on Azure IaaS to test SQL Server 2016 Always On Failover Cluster Instance with Storage Spaces Direct
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 FCI on top of Windows Server 2016 S2D technology in an hyperconverged configuration. To create simple environment with 2-nodes cluster, Read more…
IT SQL Server
Create an automation runbook to force a SQL Server AVG failover
This article is the third part of a series which describes the lab environment I prepared for my demo @ TCDIT2017 conference. Other parts of the series are available here: In this post I’ll try to summarize the steps you need to implement in order to create an Azure Automation Read more…