red-gate.com red-gate.com

SQL Agent Job Generator: Creating A Set Of Working Jobs

In this entry in the SQL Agent Job Generator system series, we are going to turn the corner and actually start producing working SQL Agent jobs. We will start with simple, standalone T-SQL jobs, that you can kick off or schedule (and that is how I have labeled them, as scheduled since that is how they will be implemented in the next entry.) Triggering one job from another, and on-demand jobs will also follow on later. The entire...

red-gate.com red-gate.com

SQL Agent Job Generator: Building the Base Rig and Managing Categories

In the previous entry in this series, I implemented Environment Variables that will let me have one code base that can easily generate jobs in DEV, PROD, or whatever environment you desire. In this entry, we are going to implement the basic building blocks of the process. I will build: A file with defaults for my configuration The file to launch the job creation process A function to create a job, which will call multiple other...

red-gate.com red-gate.com

Implementing Environmental Variable Values in PowerShell

As a relative neophyte to PowerShell (something I will remind readers of every time I start a blog in this series!), I am not always sure I have the best way of doing things. In this blog, I am going to lay a bit of foundation for my job creation system, by building a set of functions I will use to variablize things like servers, database names, etc. I had often seen this done using Json files in presentations and blogs (and as I noted...

wintellect.com wintellect.com

Automating SQL Server 2019 Docker Deployments

In a previous article, I walked through deploying to SQL Server 2017 containers and provided an overview of deploying DACPACs and BACPACs in containers. Since that time, SQL Server 2019 has been released; this requires a few changes to the approach. In this article, we’ll look at what changes you need to make to deploy to a 2019 container. Let’s start with the code, then examine what’s changed. FROM...