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

Coping with the Pandemic (T-SQL Tuesday #132)

1 Comment
This post is part of the monthly TSQLTuesday blog event. This month’s topic is from Taiob Ali (b|t). Taiob asks how are we coping amid the pandemic. I have two thoughts overall about how well I’m coping Thought 1: Wow this is rough Thought 2: I am incredibly lucky and privileged, and it’s still rough My pandemic story started with an intercontinental move At the…

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…