An keyboard and mouse

Just one more thing, an essay on troubleshooting

Over the weekend I watched — for the first time in my life — an episode of the long-running ABC and NBC police show Columbo, starring Peter Falk. I originally knew him from the film The Princess Bride (fun fact: I acted in a film directed by Buttercup herself, Robin Wright). I’ve been hearing a
-> Continue reading Just one more thing, an essay on troubleshooting

Chocolatey logo - 11 years old

Choco upgrade, y’all

Chocolatey is a package manager for Windows, like the built-in package managers on Linux, and third-party ones on macOS like Homebrew and MacPorts. The idea is this: when you’re setting up a machine, you don’t want to have to think about which applications you need installed to get up and running. This could be a
-> Continue reading Choco upgrade, y’all

Azure SQL logo

If I can’t use PWDENCRYPT, how am I supposed to use HASHBYTES?

For this week, here is a short post about reinventing the wheel. An interesting conversation happened on Twitter where Dave Dustin asked: “Does anybody have an example of using HASHBYTES() to replace PWDENCRYPT() per the documentation that the latter is deprecated?” – Dave Dustin Dave is referring to the Microsoft Docs page for PWDENCRYPT(), which
-> Continue reading If I can’t use PWDENCRYPT, how am I supposed to use HASHBYTES?

Western Digital WD Red internal HDD sliced in half on pink surface

You can’t secure your network with spite

I wrote a post a couple weeks ago about not changing port 1433 for security reasons. I received this comment, which is not visible on that page because it warrants a lengthy response. I have redacted the name of the commenter. I disagree. Hundreds companies around the world were victims of ransomware attack even they
-> Continue reading You can’t secure your network with spite

git logo

How do I merge a small part of a Git repo into another repo?

At my new day job, one of the things we want to do is migrate a portion of a really large Git repository (over 20GB) which I’ll call LargeRepo, into a much smaller repository (< 2GB) which I’ll call SmallRepo, because when we commit new files to the larger one, the build process takes a
-> Continue reading How do I merge a small part of a Git repo into another repo?

Padlock

Don’t change your default SQL Server port for security reasons

Since we’re on a recent theme of revising long-held best practices that are not, here’s a timely one for you: Don’t change your default SQL Server port for security reasons. In SQL Server Configuration Manager, you can set a custom port for your SQL Server instance. If you’re running named instances, you might even find
-> Continue reading Don’t change your default SQL Server port for security reasons