T-SQL Tuesday #110 – Automate All the Things

Garry Bargsley (b|t) is hosting this month’s T-SQL Tuesday, a monthly blog party for the SQL Server community. Garry Bargsley kicks the year off right asking the following questions:

Kicking off the T-SQL Tuesday season for 2019, I would like to ask, what does “Automate All the Things” mean to you?

 

So technically there are two tasks for this month:

  • What do you want to automate or what automation are you proud of completing
  • What is your go-to technology for automation?

 

“Automate All the Things” is a methodology, a change in perspective. I recently had a friend ask me which came first consistency or automation. It’s a valid point. I believe automation is the what is accomplished as a result of consistency. That consistency is built by defining processes and having discipline to keep those processes. Consistency not only makes it easier to standardize processes (and train new employees), but it also means that I’m less likely to make mistakes.

One of my first automation projects was to implement continuous integration for database deployments. However, I did not realize how automation was going to fundamentally change how I see software development. When picking my tools I considered what tools were already used for our application deployment. I ended up using Visual Studio, SSDT, TeamCity, Octopus Deploy, and PowerShell to create, build, and deploy database projects.

Once realized the power of automation, I couldn’t get enough. My next goal is to get more familiar with PowerShell and dbatools to not only automate creating a distributed Availability Group but also building and configuring the VMs necessary to create my home lab.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: