Some of you might know me because of the Max Server Memory Matrix, a chart I created based off a decade-old algorithm developed by Jonathan… Read More »Max server memory recommendations are just a suggestion
Over the weekend I watched — for the first time in my life — an episode of the long-running ABC and NBC police show Columbo,… Read More »Just one more thing, an essay on troubleshooting
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… Read More »If I can’t use PWDENCRYPT, how am I supposed to use HASHBYTES?
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… Read More »You can’t secure your network with spite
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)… Read More »How do I merge a small part of a Git repo into another repo?
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… Read More »Don’t change your default SQL Server port for security reasons
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… Read More »The denial-of-service attack is coming from inside the house
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… Read More »Checking accessibility in your day-to-day work
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… Read More »Database Projects 101 in Azure Data Studio (Calgary Data User Group)
(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… Read More »Don’t optimize for ad hoc workloads as a best practice