Winding down
Normally I write these posts on a Friday evening. Sometimes it’s later than that, but always before Monday so that my editor can give it some attention before I publish. On Friday though, I spent… Winding down
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… Just one more thing, an essay on troubleshooting
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… Choco upgrade, y’all
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… If I can’t use PWDENCRYPT, how am I supposed to use HASHBYTES?
A new book is on its way
I am thrilled to announce that Microsoft Press (Pearson) has agreed to let us do another Inside Out book this year. This news is so fresh I haven’t even gotten the advance yet! The working… A new book is on its way
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… You can’t secure your network with spite
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 (<… How do I merge a small part of a Git repo into another repo?
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,… Don’t change your default SQL Server port for security reasons
The denial-of-service attack is coming from inside the house
A short post this week. While I was helping some friends recently, we experienced a curious thing where as soon as an application was started up, it was immediately followed by a denial-of-service attack that… The denial-of-service attack is coming from inside the house
Checking accessibility in your day-to-day work
Last year I wrote a series of posts about accessibility as it relates to presentations, and one aspect which I didn’t cover is within the documents themselves. We create slides with wonderful typeface choices, clear… Checking accessibility in your day-to-day work
Database Projects 101 in Azure Data Studio (Calgary Data User Group)
On Wednesday February 23rd, 2022, the Calgary Data User Group will be hosting our first user group session of the year, featuring Warwick Rudd. The topic is an introduction to Database Projects in Azure Data… Database Projects 101 in Azure Data Studio (Calgary Data User Group)
Don’t optimize for ad hoc workloads as a best practice
(This post was co-authored by Erik Darling.) The more things stay the same, the more they change… No, that’s not a mistake. In fact, it’s a reference to long-held belief systems that don’t take new… Don’t optimize for ad hoc workloads as a best practice
Join me in Germany in June
I have been selected to speak at the DataGrillen conference later this year. I will be presenting my session How Does SQL Server Store That Data Type?, which I debuted during last year’s EightKB online conference. This… Join me in Germany in June
A new chapter begins
In 2012 when I originally founded Born SQL, I never imagined I would find myself a five-time recipient of the Microsoft Data Platform MVP award, let alone be offered a job to work for Microsoft alongside… A new chapter begins