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

Installing Redgate SQL Toolbelt with Chocolatey (Video with Transcript)

Chocolatey is a package manager that helps you install, upgrade, and uninstall packages (applications) on Windows quickly and easily from the command line.

Spoilers:

• The command I show in the video is simply: choco install sqltoolbelt
• Fun fact, you can also upgrade: choco upgrade sqltoolbelt
• And uninstall: choco uninstall sqltoolbelt

Continue reading

My Git CLI Cheat Sheet

I created a cheat sheet for the Git Command Line Interface to go along with my Git tutorial for SQL Change Automation video.

I find the Git CLI to be very friendly and easier to learn than a GUI interface.

Continue reading

Links and Resources from How to Architect Successful Database Changes

Steve Jones and I had a great time today talking about source control for databases and release patterns for performance and availability in Seattle. We had a group of folks who asked terrific questions, made thoughtful comments, and interacted throughout the day.

Continue reading

Workshop Report: Overcoming Obstacles on the Journey to Continuous Delivery for Databases (Video with Transcript)

In this video, Freyja the puppy and I talk about a recent workshop which I facilitated at the IDC DevOps conference in London.

Continue reading

Setting a Custom Variable in an Azure DevOps Pipeline with PowerShell

Recently, I was doing a bit of work in Azure DevOps Services, preparing a demo for an upcoming webinar. I ran into a simple but frustrating problem.

Continue reading

Git Command Line Tutorial with SQL Change Automation for SSMS (Video)

I’m excited for Redgate’s new SQL Change Automation plugin for SQL Server Management Studio (SSMS).

SQL Change Automation lets DBAs and developers use a migrations-first approach to create precise scripts to apply changes to your database. If you’re curious about what I mean by “migrations-first”, read more about this approach, and how it compares to a state-first approach here.

Continue reading