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.
Events IT
Next conferences and community meetups – fall 2019
This fall will be quite hot in terms of public speaking events, so I thought about borrowing an idea from a real expert (kudos to you, @GenioDelMale)… And so I’m now writing a recap post about where you can find me during next months, and where you can find materials Read more…
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…
IT SQL Server
Securing the SQL DR lab environment
This article is a part of a series which describes the implementation steps I used to implement a SQL Server DR scenario on Azure based on AlwaysOn Availability Groups. Other parts are available here: As you may have noticed deploying the lab environment, access to VMs is gained via RDP connection on Read more…
IT SQL Server
SQL Server DR with AlwaysOn AVG between different Azure data centers
This is the first of a series of articles where you can find instructions to reproduce the lab environment I used for my demo @ Technical Cloud Day 2017 conference. Other parts of this series are available here: In my session I talked about SQL Server disaster recovery technologies available for hybrid Read more…