Sql-Source-Control

Tag: sql-source-control

Make Database Code Reusable in SQL Source Control with Deployment Filters

Make Database Code Reusable in SQL Source Control with Deployment Filters

When I first began working with databases, I was lucky to land a job at a little start-up which had solid development and operations processes: all our code, including database code, was in version control. We had a strong database architect who instilled good coding practices into the way we managed database code as well: code was expected to be reusable whenever possible.

Continue reading

A First Look at the Redgate Hybrid Model for SQL Source Control and SQL Change Automation (Video)

A First Look at the Redgate Hybrid Model for SQL Source Control and SQL Change Automation (Video)

About This Video

In this 70 minute livestream recording, I kick the tires of a fresh new Azure DevOps demo environment showing Redgate’s Hybrid Model for SQL Source Control and SQL Change Automation.

Continue reading

Controlling Who Commits Code to a Given Database Schema in Git with Azure DevOps

Controlling Who Commits Code to a Given Database Schema in Git with Azure DevOps

One of most the fun things about working as an Advocate at Redgate is getting to help clients determine their preferred workflow for database DevOps.

Teams often have unique requirements and are using different combinations of tooling, so figuring out the best way to accomplish what they need typically involves leveraging what I already know, collaborating with my coworkers and the client to generate ideas, researching and prototyping solutions, and then getting feedback from everyone.

Continue reading

Resolving Merge Conflicts in SQL Source Control: The Basics (Video)

Resolving Merge Conflicts in SQL Source Control: The Basics (Video)

In this 35 minute livestream recording, I commit conflicting code to a Git repo in Azure DevOps Services using Redgate’s SQL Source Control, then step through options to fix the conflict.

We first run through an example where we hit a conflict when pushing to the master branch and resolve that. Then we run through an example where we are using a feature branch and identify the conflict when doing a pull request to merge the change into master.

Continue reading

Kendra Breaks and Fixes SQL Source Control in 9 Minutes

Kendra Breaks and Fixes SQL Source Control in 9 Minutes

I love breaking technology.

I love breaking technology on purpose, in a place where it’s not going to slow anyone else down. It’s a great way to learn more about how everything works and what your options are to fix the situation when things go sideways.

Continue reading