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.

Database Reliability Engineering (22 minute video)

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.

Online, Resumable, and WAIT_AT_LOW_PRIORITY operations in SQL Server

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.

What would you say you do here?

What would you say you do 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.

Links and Resources from "How to Architect Successful Database Changes"

Links and Resources from "How to Architect Successful Database Changes"

Group exercises beginning around the room 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 great group of folks who asked terrific questions, made thoughtful comments, and interacted throughout the day. Here are some links and resources from the day… Suggestion for configuration option to make SQL Server Developer Edition act like Standard Edition This has been requested by the community for many years, but now is the right time to please vote up this suggestion.
Why I Make Animated Gifs for Presentation Demo Backups

Why I Make Animated Gifs for Presentation Demo Backups

PASS Summit 2019 starts up next Monday with pre-conference sessions. I’ve got my schedule all set, and I’m going to be busy: I’m speaking in two full-day pre-conference sessions, giving two regular sessions, judging the ever-exciting Speaker Idol competition, and also spending time at the Redgate booth in the expo hall. Oh, and I scored a little PASS-TV interview to talk about Redgate right before the keynote on the first day.
Thinking About Robert Davis

Thinking About Robert Davis

It’s been more than a year and a half since Robert Davis passed away. I wrote a bit about Robert’s passing last April. I haven’t written about him since, but I think about Robert a lot. I think about Robert when I work on a tough problem that he would have found interesting, when chatting about database nerdery on Twitter, when preparing for a conference or training that I know he would have been excited to attend.
Building my schedule for PASS Summit 2019

Building my schedule for PASS Summit 2019

It’s just ten days until PASS Summit 2019 begins in Seattle. The schedule is up and there are loads of good sessions. Here’s what I’m putting on my calendar to make sure that I don’t miss it – along with some things that I wish I could attend that I’ll be sure to catch the videos of afterwards.

Setting a Custom Variable in an Azure DevOps Pipeline with PowerShell

Setting a Custom Variable in an Azure DevOps Pipeline with PowerShell

Here’s a quick post on something simple which stumped me for a while, in the hopes that search engines help someone else who gets confused in the same way.

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.

Key Findings for Database Professionals from the Accelerate State of DevOps Report 2019

Key Findings for Database Professionals from the Accelerate State of DevOps Report 2019

The Accelerate: State of DevOps Report 2019 has just been published. This report is the latest in six years of research. With more than 31,000 survey responses, Accelerate is the longest running study of DevOps in academia or industry. In the 2019 edition, research continues to show that DevOps drives business value: high performers at DevOps are “twice as likely to meet or exceed their organizational goals.” While this isn’t a new finding, it’s very important that this continues to be true: why invest in improving at DevOps if it doesn’t drive business value?
Managing Cross-Database Dependencies in Builds (Redgate video)

Managing Cross-Database Dependencies in Builds (Redgate video)

Building your database code is an essential practice to ensure that it compiles from source and that dependencies are met. But things can get tricky when you have objects in some databases which is dependent upon objects in other databases – or even circular dependencies.