How to Provision an Azure SQL Database

Aside from spinning up a SQL Server instance container, the free Azure SQL Database is another great tool for learning SQL. You can even use it for low-traffic or...

Monday Monitor Tips: The MCP Server

I have been experimenting with MCP servers in a few ways, and pressing on our Redgate Monitor team to add one to their system. They did, started adding tools,...

Take Time to Gain Perspective

Probably the best piece of advice I ever received is to take time to gain perspective.

The Fringe Festival

I was lucky enough to take a vacation a decade ago in Edinburgh with my wife. She came over to the UK with me for a quick trip. We...

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...