Demo for Parameter Sniffing and Memory Grant Feedback

Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo subscription cost. This was meant for a private demo so I can learn more about...

A Guatemalan's Guide to Drinking Coffee Properly

My mugI grew up surrounded by coffee farms in Guatemala and somehow spent most of my adult life drinking whatever was closest, usually instant, usually while standing over the...

Claude finds two cryptographic weaknesses (but the sky isn’t falling)

If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview) to find cryptographic weaknesses in two algorithms. However, this doesn't impact anything anyone has in...

Generate Embeddings in SQL with Aurora and Bedrock

Most embedding pipelines on AWS have the same shape: a job reads rows out of the database, calls Amazon Bedrock, and writes the vectors back. That is a second...

My Social Media Rules

I developed these rules a while back, before COVID. I had a period of self-reflection when I realized I was spending time wastefully arguing with folks on the various...

T-SQL Tuesday #201 - Temp Tables, Friend or Foe?

T-SQL Tuesday is a monthly blog party hosted by a different community member each month. This month, Jeff Taylor
(blog) asks us for our take on temp tables:

So, do you...

Why Use TRY_PARSE(): #SQLNewBlogger

Someone asked why I would use TRY_PARSE after I posted a question at SQL Server Central: Getting the Average. Isn’t is slower? A fair question. This quick post looks...

Excellent article on securing msdb

Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's why you should read it if you're a DBA or security professional.

T-SQL Tuesday #201: Temp Tables

This month we have a new host, which I am grateful for. So many people have stopped blogging that it’s a challenge to keep this going. Jeff Taylor has...

When Do You Reach For A #temp Table?

I needed to do some research because there is more to #temp tables than simply creating one and using it. As I started digging into the topic, I realized...