Over the past few months I’ve had a couple of customers ask me, “Now that SQL 2016 doesn’t include SSMS how am I supposed to automate the installation?”. Typically my response is you shouldn’t be installing it on your servers as its just an additional item that will require patching. However there are times its necessary and often times customers have dedicated management servers where they want to automate the installation or you want to automate it on your workstation. Either way DSC is here to assist, installing any .exe or .msi with DSC is relatively simple with the Package resource which is included with DSC. There are likely other pieces of software you may want to automate on your SQL installations also. Here I am providing a code example of specifically how SSMS can be installed but it can be modified for other uses. This is again “Sample Code” so you will notice I am allowing for the use of plain text passwords, not something you would want to do in a production environment.