Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine until an auditor or an incident review asks for something older. Until now the usual...
2026-09-02
32 reads
I was updating my session for the Data API Builder (DAB) recently, mostly to work with the MCP server capabilities. As I was trying to get this working, I...
2026-09-02
64 reads
I am excited to host T-SQL Tuesday for the first time. I want to hear about that one outage that stands out in your memory. We all have incidents...
2026-09-01
129 reads
Redgate had some Claude training recently, which I went through as my knowledge has been gained in bits and pieces and is fragmented. I wasn’t sure I’d get a...
2026-08-31
60 reads
gnossienne– n. the awareness that someone you’ve known for years still has a private and mysterious inner life. One of the things I’ve learned throughout my life is that...
2026-08-28
42 reads
How I used AI for this postChatGPT to generate images based on info specifically provided by me,including examples.Grammarly to catch grammar and sentence construction errors. I did a presentation...
2026-09-09 (first published: 2026-08-27)
141 reads
A few months ago I started using Deepstash. Deepstash breaks books into the key ideas, usually 10-12 per book. If I am thinking about reading a book, I check...
2026-08-27
48 reads
Do you have a case where you have a named instance you'd like to migrate to a default instance? Is there pushback on doing so? Are there concerns that...
2026-09-07 (first published: 2026-08-26)
281 reads
I’ve been running this blog on Hugo for a long time, and like most blogs with real history, it’s accumulated some tech debt. Some of it is my own...
2026-08-26
32 reads
I was trolling the docs and noticed the SIGN() function. I have never written this in production code, but it is an interesting function. This post looks at where...
2026-09-07 (first published: 2026-08-26)
398 reads
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
Comments posted to this topic are about the item The Costs of Multiple Platforms
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers