Over the last couple of months I was lucky enough to be involved in writing a chapter for the free e-book SQL Server on Azure Virtual Machines. The chance to collaborate with a fantastic group of MVPs was something that I could not pass up.
Covering all the key information that you need to know in order to move SQL Server workloads from on-premises to Azure IaaS Virtual machines, it is a walk through helping you start from scratch understanding what the Azure IaaS offering is and how to get started, through to putting the right configuration in place for Windows and Linux and the underpinning Azure infrastructure.
I cover some of the options for moving workloads from on-premises to Azure. This includes scoping, planning, analysis, and migration activities. I make mention of some useful tools such as the DBATools PowerShell module by Chrissy et-al (t|b). as well as WorkloadTools from Gianluca Sartori (t|b). Then of course there is DMA/DMS from Microsoft to help make it happen.
Chapter 1: Introduction to SQL Server on Azure Virtual Machines – Louis Davidson
Chapter 2: Getting started with SQL Server on Azure Virtual Machines – Allan Hirt
Chapter 3: Hero capabilities of SQL Server on Azure Virtual Machines – Joey D’Antoni
Chapter 4: SQL Server on Linux in Azure Virtual Machines – Anthony Nocentino
Chapter 5: Performance – Tim Radney
Chapter 6: Moving workloads to SQL Server on Azure Virtual Machines – John Martin
Chapter 7: Hybrid Scenarios (Microsoft SQL IaaS) – Randolph West
This is the first time I have actually been involved in writing part of a book as opposed to a whitepaper or similar material.
What I found interesting is just how much effort goes into this behind the scenes when it comes to editing, with both technical reviews and editing as well as copy editors. I got good feedback from both of these which I hope to include in more of my writing for blogs, whitepapers, and other technical documentation. This ranged from pure readabiliy through to the use of inclusive terms for tech. This post from Matthew Roche (t|b) “Don’t tell me it’s easy” covers a very important aspect to inclusive language that I was only vaguely aware of. It really conveys that we need to think about the audience and how we communicate with them. I wish I had been able to read it sooner.
Overall it took a little over three months to go from saying yes to this being published on the Microsoft site. That puts it into stark relief when thinking about how people write whole books of this length in months as opposed to years. It boggles my mind.
I was very lucky in that the topic I was covering what one that I have a real interest in. I have been doing upgrades and migrations for years and I really enjoy the challenge that comes with it. This meant that I did not feel that his was a slog or tiresome and I do think that was a lucky break.
Overall it was an interesting experience and one that I hope I get a chance to repeat. Would I write a whole book? Probably not, I don’t think I am up to it but that might change in the future. Would I contribute to another multi-author book? Certainly.
So if you are looking to learn the core concepts of migrating SQL Server workloads to IaaS VMs in Azure then I would suggest checking this out. It is free and available from the Microsoft website.
Also, I hope that if you have a similar opportunity come up that you give it serious consideration. The support was there to help me achieve the objective and I am very grateful for that.
This book is FREE to download from the Microsoft website here.