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

Upcoming Free Webinars on Database Development and Operations

Fall is in swing, and it’s officially webinar season! Here’s a bunch of free events I’ve got on my calendar.

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

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. I scored a little PASS-TV interview to talk about Redgate right before the keynote on the first day.

Continue reading