SQL Server on VM’s in my Lab

SQL Server on VM’s in my Lab

I’m trying to automate as much as possible in my lab and part of that is building SQL Servers.  I’ve taken to trying to scripting this out.  For me, that involves using PowerShell to build out this machine.  

I’m sure that there are 50 or 60 things I’m missing because I’m not a DBA.  If you have recommendations, please let me know.  I’d be glad to include them.


Sidebar:  It was asked why I didn’t just templatize this and deploy it repeatedly.  Mostly it’s because what I’m supposed to do is build several servers that are *wrong.*  Like I need to have everything on the C:\ Drive.  Then I need to have data and logs cohabitate.  Then I need to have TempDB and Data cohabitate.  Then I need to try it without a page file.  Then I need to do the exact same build, but for SQL on Linux.  The number of permutations gets out of hand and creating a template for each would be overly time consuming.  It’s a cost/benefit thing for me.

1 thought on “SQL Server on VM’s in my Lab

Leave a Comment