T-SQL Tuesday is a monthly blog party that is the brain child of Adam Machanic (b/t). This month the blog party is being hosted by James Anderson (b/t) and is focused on deploying database changes.


#tsql2sday

Database DevOps

DevOps has been a buzzed word in the IT space for a while now. In case you are unfamiliar, DevOps is the conceptual marriage between Developers and IT Operations. The idea behind DevOps is to facilitate communication and collaboration via cross department integration, which is a crude way of saying the barriers between operations and developers are being broken down/stripped. While the concept of DevOps is not new, bringing databases into DevOps is (or rather, maybe to me it is).

From a production DBA standpoint, it can be difficult to wrap your mind around how to apply DevOps concepts to your existing environment. This is where one should perhaps watch a webinar or catch a session at a SQLSaturday. I caught Steve Jones presentation on DevOps at the Colorado Springs SQL Saturday which really helped me wrapped my around it, as well as gave some ideas on how to apply it.  One of the DevOps concepts that has really resonated with me is source control.

Source Control

DBAs have a ton of scripts that are used from report building to performance tuning, and what ever else that they can solve. Over the years, and over teams, these scripts get updated and changed. Source control is an excellent way to keep versions as well as share across the team. It’s an even better way to maintain scripts when multiple team members are working together to develop a stored procedure(s) or large piece of code.

While I am very much new to DevOps and source control. I am definitely working towards understanding its nuances and figuring out how to implement it at the office. I have managed to setup both a repository at both GitHub and Visual Studios Team Services through Dev Essentials. Although now that I have the repositories setup, I still need to find the bandwidth to figure out how to check code in and out via SSMS. Once I have that completed and throughly tested, I can take that information to my team and begin using source control in the office.

 

Garland MacNeill, MSIT
Student of SQL – both as a DBA and a Developer
I am passionate about learning about databases.. After completing my graduate degree, my focus has been on gaining knowledge and skill as a SQL DBA, as well as a database developer.