Blogs

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

Why You Should Take the 2020 State of Database DevOps Survey Today (Video)

In this six minute video, I explain why you should take the 2020 State of Database DevOps Survey. The survey is open for a few more days – we’ve had a record number of responses, but we want YOUR input as well!

Continue reading

Database Reliability Engineering (22 Minute Video)

I was fascinated yesterday to come across the term, “Database Reliability Engineering,” which I hadn’t seen before.

In this 22 minute whiteboarding session, I talk about why we need new terms for “Database Administration,” and my initial understanding of what Database Reliability Engineering means by comparison.

Continue reading

Online, Resumable, and WAIT_AT_LOW_PRIORITY Operations in SQL Server

ONLINE operations in SQL Server were simple to understand for years – we got ONLINE index rebuilds in SQL Server 2005. That was it for a while.

Then, things got more complicated: we got more types of indexes. We got ONLINE options for schema changes that don’t involve indexes. We got more options for managing things like blocking, because online operations are really only mostly online: generally there’s going to be at least a short period where an exclusive lock is needed to update metadata. We now have some RESUMABLE operations coming in, too, for those big operations that are tough to handle.

Continue reading

What Exactly Would You Say You Do Around Here?

The other day, I was looking back at an excellent blog post my colleague Jamie Wallis wrote about what Product Marketing Managers do at Redgate. I really like the chart he created which explains how Product Marketing Managers work with Product Managers – what each role focuses on, and where they collaborate.

I realized that my own role as an Advocate can also be hard to understand.

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