I have turned off comments on this site. All existing comments have been removed. Even the nice ones from awesome people, and the helpful ones, and the ones answering...
2022-09-16
53 reads
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 Kehayias. The chart has...
2022-08-15 (first published: 2022-08-03)
335 reads
Information — in the form of data — usually stored as binary 1s and 0s in an electronic data store, is not immutable. Even the hardiest data storage designed...
2022-05-25
23 reads
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...
2022-04-27
18 reads
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...
2022-04-20
22 reads
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...
2022-04-13
58 reads
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...
2022-04-06
15 reads
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 amount of time I’ve...
2022-03-30
17 reads
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...
2022-03-23
15 reads
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...
2022-03-16
166 reads
By Steve Jones
Today’s coping tip is to write down three things you appreciate about yourself. I...
By Zikato
Scary Scalar Functions series overview Part One: Parallelism Part Two: Performance Part Three: The Cure Part Four: Your...
Last month (I ran just a little bit late writing this, it was meant...
How can we encrypt the database in Azure. Research story. Thank you
Migration of simple SPs from 120 to 150 COMPATIBILITY_LEVEL issue. Execution time for the...
Ask SSC