When ALTER TABLE doesn’t work

We’re all used to being able to change things whenever we want. Heck, I put on a different pair of socks just to write this blog post! They’re my bloggin’ socks. But, back to the topic at hand, we’re used to being able to use ALTER TABLE commands to change tables in SQL Server. And,…
Read More

Why use a GUID for a clustering key?

Conventional wisdom in the database world is that nobody should ever use a GUID for a clustering key. And the people who do are clearly awful people who hate kittens and everything good in the world. I’ve probably even gotten up in somebody’s business about this before. The problem with common knowledge is that it may…
Read More

Locking and Blocking and Immutable Data

Locking and blocking feel like a normal part of working with databases, right? Locking and blocking inevitably lead to deadlocks in our databases, too. A significant amount of both human and computer time is spent resolving these problems in the database. After all, if it weren’t for locking and blocking, database professionals would spend their…
Read More

Script Libraries and Version Control

Raise your hand if your collection of T-SQL scripts is sitting in a folder under My Documents. Why isn’t that script library in version control? You have version control at work, right? Not that kind of library Why should I version my scripts? There’s three big reasons that you should version your scripts. The first…
Read More
A plaque demonstrating conversions between one foot, two feet, an imperial yard, and a meter.

Using Tables for Fast Math

Convert all the things! Relational databases are great for storing structured data. But the data we store doesn’t have to be user entered data. What if we use tables in the database to precompute the output of some kind of calculation? Our Conversion Table In this case, we’re doing a simple unit of measure conversion…
Read More
A hippie practice twirly weights around and somehow not getting his filthy dreadlocks stuck in the weights.

Practice Writing Code

And that’s when my code hit me in the face If you want to get better at something, you should do it every day. At least that’s what the internet tells me. Coincidentally, this is why I still put on clothes and leave the house – just so I don’t forget how. So, how do…
Read More
The awesome people of Brent Ozar Unlimited

A New Adventure

Look at all of these awesome people! (Not pictured: Angie, who is also awesome) It’s time to start a new adventure! Over the last few years, I’ve had the pleasure to work with some really awesome people. Brent already wrote about the changes to the company, so I’ll leave that to him to explain. But,…
Read More

PowerShell Power for Presenters

As a presenter I frequently need to make sure that my laptop is not in low power battery saving mode. I also don’t want the screensaver to start up when I walk away from the computer and point at the screen. A while back, I showed you how to Control Power with PowerShell, but this…
Read More

Unsetting Key Bindings in emacs

I make use of emacs – my ability to customize the editor has made it easier for me to be productive. Switching between windows has always been a bit annoying in emacs. After reading Managing Emacs windows, I figured that I would give the ace-window library a try to see if it could solve my…
Read More
Menu