Press "Enter" to skip to content

Category: Learning

Hugo Kornelis In Memoriam

Hugo Kornelis has passed away:

Unfortunately, this will be the final post on my father’s blog. Yesterday, Hugo passed away peacefully, on November 3rd at 9:45 AM. He really wanted to prepare this final blog himself, but time caught up to him. I cannot write as eloquently as he could, but I will try my best to share his final two weeks here. I will write openly about what was going on with Hugo, as that is how he would have written it. I want to repeat the earlier warning my father used to add to all posts about his leukemia, especially these final moments may be hard to read. 

It’s sad that we lost such a great man in the SQL Server world. I am glad that Hugo was able to complete his masterpiece before then, and that it will continue beyond him.

Hugo presented for our SQL Server user group (the Triangle Area SQL Server Users Group) twice, in 2024. One talk was on the internals of a hash spill, and the other was about debugging without a debugger.

Thank you for all you ever did, Hugo.

1 Comment

Thoughts on Blog Relevance

I’m at PASS Summit this week, so it’s a good thing Jeff Iannucci teed up a topic for me. Jeff, of course, has the honor of putting together the full round-up, but this topic has drawn quite a bit of interest and I get to link to a lot of people.

Andy Brownsword has thoughts on who your reader is, and how that has shifted over the years.

Niko Neugebauer answers in the negative but adds a few caveats.

Mike Walsh says they are, so long as you’re willing to take the time and effort.

Reitse Eskens says yes, especially for the writer.

Marlon Ribunal says yes, and that AI assistance can make the experience better.

Brent Ozar thinks about how relevance has shifted and brings up a good point about managers: blogs provide a signal of your quality to people, including the people who might hire you.

Chad Callihan asks, what’s in it for you?

Mala Mahadevan focuses on a critical aspect: originality. Not necessarily in topic, but in how you present information and what questions you’re asking.

Rob Farley sees writing as more relevant than reading.

Lee Markum uses illicit cat technology to brainwash people into reading his blog. And also has some good thoughts on the relative cost of blogging versus other skill-sharing activities.

Andy Yun takes a trip down memory lane.

Andy Levy digs into history as well, and notes where human experiences can augment (or supplant) technical documentation.

In short, this might amaze you, but most bloggers think that blogging is still relevant.

Leave a Comment

The Continuing Relevance of Blogs

Aaron Bertrand lays out an argument:

I read fewer technical blog posts than I used to. This is partly because I find information differently, and partly because I’m 30 years into this. My reading habits say more about where I am in my career than about the value of blogging.

I write fewer technical blog posts than I used to, too. This is mostly a function of time and juggling work and life priorities, rather than a lack of ideas or perceived value in sharing them.

I still value blogs as places to learn, share ideas, and express opinions.

Given my entire schtick of finding and linking to interesting blog posts, I am naturally inclined to agree with Aaron’s points.

Leave a Comment

For the Love of Markdown

Louis Davidson explains an opinion:

I had no idea what the three tick marks “` meant until soon after I left there because all my recent experience had been with use the Mammoth Word Document converter. It works pretty nice overall, but it had been something I had struggled with over the years trying to get other people’s documents into to work just right. (Ok, and my documents too.)

It worked by mapping styles in a Word Document to a style in a WordPress page. To do it well, I had my template with all the styles set up in the Word template with shortcut keys, which I used an Elgato Stream Deck to remember all the keys. I still use a stream deck for editing, which I will share about some day.

So when I started my own site, I tried hard to replicate that experience but better. Until recently, you couldn’t support plugins in WordPress without spending quite a bit more money than I was willing to spend on this site so I started trying to find the best way to work offline and then (more or less) paste in my text.

Click through for a bit of Louis’s journey. Also, Louis mentions being confused by the name and thinking it was “markup.” That’s because HTML is the Hypertext Markup Language, and John Gruber meant the name as a pun on heavier markup languages like HTML and XML, as Markdown involves much less marking up of the text.

Comments closed

The Perfect Trick to Speed Up Databases

Louis Davidson becomes a cracker jack developer:

This week, I want to sell you on two ideas. First, that you can make any query faster with:

  • Zero hardware changes
  • Zero index changes
  • Zero structure
  • Just a few simple character changes in every one of your queries

This change I will guarantee will make your queries screamingly faster. Never will your customer’s wait on query results again. You will have no blocking, no latch waits, no waiting whatsoever.

He probably should sell this as a training course, along with its administrator equivalent: databases hate date, and you can’t have data problems if you don’t have any data.

Comments closed

The Importance of Testing Received Wisdom

Mark Wilkinson lays out an argument:

Life is full of “absolutes”. For example, the Star Trek: The Next Generation episode “The Measure of a Man” is often cited as the best episode of the series, and many folks will tell you that you should never adjust max worker threads. But once you take the time to dig in, you realize that “Darmok” is in FACT the best episode of ST:TNG, and you’ll also find a small cohort of folks adjusting max worker threads on all of their SQL Server instances. Are these people just abnoxious contrarians? No. They just did their own testing to validate the common wisdom.

Click through for an example from Mark around 64K allocation unit sizes for NTFS volumes. And I’ll give one on max worker threads. I had a consulting client at one point which had per-customer databases. Each customer was, in general, quite small, so they had thousands of databases on the instance. They also wanted high availability on the system, so they wanted each database mirrored to a different server.

If they didn’t spike max worker threads to extreme levels, the server would have fallen over simply from the weight of all of the open database mirroring connections. The actual server workload was fine and it could handle all of the open worker threads because the large majority were doing nothing. But if a zealous problem-solver popped in, ran a diagnostic, saw that they were violating “best practices,” and “fixed” the problem, that would have been a bad day.

Unrelated but similar story: the one time they did need to fail over due to an emergency, it was also a bad day. Because even if the instances can handle 2500+ databases, it turns out that having them all fail over at the same time on low-powered Azure hardware was not a pleasant experience.

Comments closed

Solving Kusto Detective Academy Case 4

Tom Zika wears a trench coat and works out of a run-down office in a mess of a town, all in black and white:

Someone hacked into Digitown’s municipality, stole classified documents, and vanished. All we have is 30 days of router logs and a lookup table. Time to find a needle in 45 million rows of hay.

I really like the work the Kusto team has put into Kusto Detective Academy. Tom’s blog post is a spoiler if you want to answer it yourself, of course.

Comments closed

Gotchas for a Move On-Premises

Brent Ozar lists three pain points:

For T-SQL Tuesday #199, Koen Verbeeck posed an excellent question: if your company moved up to the cloud, but after migrating, had to come back on-premises, what would be the big problems?

I’ve had clients in this exact situation! Here are some of my favorite gotchas from those experiences.

Click through for those three. I’d say that the first one is a major issue and will probably be one for the next couple of years—unless the bottom drops out sooner than I expect and we suddenly have a rush of used hardware from highly unprofitable organizations hit the market.

Comments closed

The Importance of Working with People

Mark Wilkinson hits migration from a different angle:

I haven’t written a blog post (here) in over 5 years, so what better time to start things back up than a T-SQL Tuesday? Big shout out to Koen Verbeeck for hosting this month, and picking a great topic: Back to on-prem?

As someone that just ended a 10+ year stint managing a hybrid environment, this topic is very near and dear to me. I went back and fourth on what to write about for this one. There are a lot of great topics. Reliability and observability almost won out but instead I landed on maybe an unexpected topic: soft skills.

Regardless of whether your company is fully on-prem, fully in the cloud, fully hybrid, or fully without a clue, Mark’s advice hits home. And is also one of those things I’ve struggled with.

Comments closed