Recently I had the opportunity to work on a project were I needed to create a custom SQL Server image for use with Azure VMs. The process was a little more challenging than I initially anticipated. I think this is mostly because I was not familiar with the process of preparing a SQL Server image. Perhaps this isn’t much of a challenge for an experienced SQL Server DBA or IT Pro. For me, it was a great learning experience.
Why a Custom SQL Server Image?
The Azure VM image gallery already contains a SQL Server image. It’s very easy to create a new SQL Server VM using this image. However, doing so has a few important trade-offs to consider:
- Unable to fully customize the base install of SQL Server. This is a template/image after all – you get a VM configured the way the image was configured.
- Unable to use your own SQL…
View original post 1,149 more words