IDC DevOps Conference – Virtual Event September 24, 2020 – info

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 that even the spelling and capitalization of the name is a topic of disagreement.

Thoughts As Pride Month 2020 Comes to a Close

1 Comment
I’ve begun working on developing a couple of small habits this month, thanks largely to Andy Mallon‘s helpful advocacy. Becoming more consistent in sharing my pronouns My pronouns are “she/her.” I only became aware of why it’s helpful to share your pronouns in the last year. Before that, I hadn’t given much thought to it. Andy gives a great explanation of why this is helpful…

New Free Course: The Dirty Secrets of NOLOCK

No Comments
I’m excited to begin moving over courses from SQL Workbooks and making the material available here. The first course up for grabs is The Dirty Secrets of NOLOCK. A little bit about the course What happens when you use NOLOCK hints in your code, or set your isolation level to READ UNCOMMITTED in SQL Server? In 50 minutes of online videos, you will learn what…

How to “Rename” the Master Branch to Main in Git in Azure DevOps

No Comments
I believe that language matters, and that it is worth our effort to move away from language associated with slavery and racism whenever possible. Azure DevOps doesn’t technically allow you to rename branches– but you can work around the issue by creating a new branch from master, setting the new branch as the default branch, and deleting the master branch. Here’s the Microsoft documentation on…

Create a Build with YAML for SQL Change Automation in Azure DevOps

No Comments
I used to make fun of YAML because I was scared of it. I still make fun of YAML, but I’m not scared of it anymore now that Rob Sewell showed me how to avoid having to write it myself. In this 11 minute video, I show how to set up a YAML build pipeline in Azure DevOps. My build is configured using a Local…