Posts

Managing Drift in Automated Deployments to SQL Server Databases

Managing Drift in Automated Deployments to SQL Server Databases

One big gotcha that teams often encounter when automating deployments for databases is that it’s difficult– or sometimes impossible – to ensure that all changes to the production database are performed through the automation pipeline.

These out-of-band changes case the production database to “drift” away from the schema as defined in version control.

My Sketchnotes from Redgate's Level Up Week 2021

My Sketchnotes from Redgate's Level Up Week 2021

Redgate regularly holds an internal conference called Level Up week. In 2020 and 2021, this conference has been scaled to include multiple Redgate offices using a remote learning approach.

While this is an internal conference, I can share my drawings and notes from sessions I attended. I hope these inspire you with ideas on how you can contribute to learning in your own organization – or perhaps simply inspire you to give sketchnoting a try.

Moving From WordPress to an Azure Static Site with Hugo

Moving From WordPress to an Azure Static Site with Hugo

I’ve moved from WordPress to an Azure Static website built with Hugo. The conversion, including grooming all my old posts and a special setup for my free courses took up most of my personal time for a week (including a 4 day weekend).

Here’s why I made the change. I’ll also share the basic components I chose for my site, the tools and steps I used in the conversion, and some lessons learned from the implementation.

Ten Ideas to Improve Online Tech Conferences

Ten Ideas to Improve Online Tech Conferences

Amid the global pandemic, online tech conferences have had a natural surge in popularity. I’ve attended quite a few of these in 2020 across several technical areas (database tech, DevOps, privacy, tech research). The conferences have been both large and small, both free and paid, and have been held across a few different regions and time zones.

Down Tools Week 2020 (10 minute video/podcast episode)

Down Tools Week 2020 (10 minute video/podcast episode)

It’s Down Tools Week at Redgate.

In this episode, I share what “Down Tools Week” is, what I’m working on this week, and why I think it’s a terrific experience for fostering creativity, innovation, and teamwork. In closing I share some thoughts on variations of this kind of project which you might use in your own organization.

How to Spell and Capitalize tempdb for SQL Server

How to Spell and Capitalize tempdb for SQL Server

No matter what I write in this post, some of y’all are going to tell me I’m wrong. That’s inevitable, because I’m writing about tempdb: a database so complex and mysterious in SQL Server, that even the spelling and capitalization of the database name is a topic of great disagreement. Note: nearly everyone has been inconsistent about this You might think, “This is easy, just check Microsoft’s documentation to find the answer.