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

How to Spell and Capitalize tempdb for SQL Server

No Comments

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…

Learn TSQL for free online – starting today

No Comments
Thanks to the support of Redgate, I’ve launched a new course which teaches you the basics of TSQL. The course is totally free, no logins required — we don’t even ask for the email address. Check out the course on Redgate University The course is here: Each week has an embedded video for the course, along with a link to the syllabus and scripts.…

Learner’s Guide to SQL Server Query Tuning

No Comments
Following on from my Learner’s Guide to SQL Server Performance Triage, I’m tackling Query Tuning. In this guide, I’m experimenting with an outline style rather than expanding each paragraph. In this post… Why do we need query tuning?Who needs to do query tuning? Who doesn’t?What skills are involved in query tuning?Popular built-in query tuning tools and how they work togetherTough problemsIs testing in production required?Automated…

Join the Best Worst Code Contest today at 5pm BST / Noon Eastern #BestWorstCode

No Comments
I have an idea! Let’s have a “Worst Code Contest.” Why do this? Bad code is really fun — at least, when you write it on purpose. And other people’s bad code is even more fun. But seriously, I’ve needed to write a lot of bad code over the years when creating demos and reproducing various scenarios. It uses your brain in an unusual way,…