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...
2026-08-12 (first published: 2026-07-29)
255 reads
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...
2026-08-12 (first published: 2026-07-29)
192 reads
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.
2026-08-11
18 reads
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...
2026-08-11
17 reads
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...
2026-08-11
17 reads
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin. When we are rejected, whatever the situation, many of us want to know why. We...
2026-08-10
19 reads
I wrote earlier this week about the SQL MCP Server using the Data API Builder. In that post I showed how to query the MCP server from VSCode, but...
2026-08-10 (first published: 2026-07-29)
347 reads
I was recently trying to handle a simple task with a few AI tools to see how well things worked. I realized that AI isn’t great for everything and...
2026-08-10
21 reads
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against a local Azure SQL Database Developer container — the same engine as the cloud, running...
2026-08-10 (first published: 2026-07-26)
734 reads
It’s been some time since I provided a car update, so I decided to showcase a few things I’ve learned about my cars since the last one. In this...
2026-08-07
69 reads
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
By Steve Jones
This month we have a new host, which I am grateful for. So many...
I needed to do some research because there is more to #temp tables than...
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item Building Great Software
Comments posted to this topic are about the item The Range of Customers
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers