2019-04

Salt Moves to 2.0

Hello! Earlier today i started work on deploying a SQL Agent Job, and so it made sense to eat my own dog food and have a go at deploying the SQL Agent job using saLt. It all worked great! Until I realised that there is a bug when deploying T-SQL-based job steps. You see when I wrote saLt it was primarily for SSIS Execution and T-SQL and PowerShell jos step types were thrown in for good measure.

2019-04-03

Salt 2 - Now With SMO Nuget Download Built In

Hello! No time like the present: I have added two new functions to salt - Install-SaltNuget and Install-SaltSmo. These can be used to download Nuget and SMO respectively. So in your deploy pipeline for salt a script like the one below can be used to deploy a SQL Agent Job. It is worth noting that Install-SaltNuget is executed by Install-SaltSmo, but there is no reason why it could not be used externally.

2019-04-03