Hero Image
After (lot of ) Hacks - A working way to deploying Azure SQL on Virtual Machine using terraform

I am very new with terraform. I was trying out terraform to deploy an SQL VM to Azure. SQL VM in Azure has undergone many changes recently from using SqlVmIaasExtension to manage SQL VM instance to a new resource type Microsoft.SqlVirtualMachine/SqlVirtualMachines To implement the best practice of SQL, we had to fall to PowerShell DSC. Now Azure natively support disk management(new Storage Type) via SqlVirtualMachine resource type. I wanted to get new Storage type implemented via terraform azurerm_mssql_virtual_machine. This resource in terraform under module azurerm supports everything except new storage types.

Monday, May 25, 2020 | 3 minutes Read
Hero Image
Grant SQL Server account access to Lock Pages in Memory using PowerShell DSC.

Lock Pages in Memory is a setting that can be set on 64-bit operating systems that essentially tell Windows not to swap out SQL Server memory to disk. I was implementing SQL server hardening via PowerShell DSC and one of the requirement was to have Lock Pages In Memory enabled for SQL Service account. There was a powershell script created and available from blog post by keepingitgeek. I converted this to a DSC module for my use. The code snippet is added below.

Tuesday, March 7, 2017 | 1 minute Read