Patch your SQL Server instance today
On 14 February 2023, Microsoft released updates for all supported versions of SQL Server in the form of a General Distribution Release (GDR). A GDR… Read More »Patch your SQL Server instance today
Deadline for Microsoft MVP contributions is 20 March 2023
Since changing to the new MVP renewal model, Microsoft MVPs have had until 31 March each year to provide the list of their annual contributions.… Read More »Deadline for Microsoft MVP contributions is 20 March 2023
You can run a SQL Server Docker container on Apple M1 and M2 Silicon
Previously the only way to run SQL Server on Apple Silicon was via QEMU emulation or Colima (hat tip to Anthony Nocentino). Docker released beta… Read More »You can run a SQL Server Docker container on Apple M1 and M2 Silicon
Max server memory recommendations are just a suggestion
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
Data is not immutable
Information — in the form of data — usually stored as binary 1s and 0s in an electronic data store, is not immutable. Even the… Read More »Data is not immutable
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… Read More »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,… Read More »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… Read More »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… Read More »If I can’t use PWDENCRYPT, how am I supposed to use HASHBYTES?
On bias
Last week saw the second month of my employment at Microsoft. I admit that I’m enjoying my job, and I can’t deny that the reduced… Read More »On bias
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… Read More »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… Read More »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)… Read More »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… Read More »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… Read More »The denial-of-service attack is coming from inside the house