OpenClaw- Agentic Engineering
This week has training on AI – Cyber security experts – Omar Santos and Aamir Lakhani- with great knowledge . during the session learned about OpenClaw and more. I...
2026-04-29 (first published: 2026-04-17)
371 reads
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to delve into visualisation of vector embeddings that were generated from the restaurant data pulled from...
2026-04-29 (first published: 2026-04-17)
269 reads
The Intersection Between DevOps and FinOps
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster, deploy faster. But while we accelerate delivery, why not shorten the expense lifecycle as well?...
2026-04-17
28 reads
GROUP BY ALL – Is it ALL you ever need?
You have probably seen a couple of cool GROUP BY features that came with Oracle Database 26ai. You can check out the short video below but since you’re on...
2026-04-17
53 reads
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB as the source) that I’ve managed to run into, twice. I’ve set up mirroring by...
2026-04-27 (first published: 2026-04-15)
268 reads
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an example of why it can behave weirdly. This post looks at something you might not...
2026-04-27 (first published: 2026-04-15)
210 reads
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards or optimisation scripts. Tools can highlight waste, but culture determines whether anyone acts on it....
2026-04-24 (first published: 2026-04-15)
191 reads
The Rise of “Post Regret”: Why More Teams Are Regretting Their SQL Server to Postgres Migration
As a data nerd who’s spent the last 25+ years helping organizations keep their databases running smoothly, I’ve had this conversation more times than I can count: “We’re moving...
2026-04-14
41 reads
Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable
Hello, dear blog reader. Today’s post is coming to you straight from the home office, ready to talk about a topic that comes up more than you’d think: storing...
2026-04-22 (first published: 2026-04-14)
625 reads
The OneLake catalog in Fabric: Explore, Govern, Secure
Once your Fabric tenant grows past a few workspaces, data discovery gets weird fast. Duplicates multiply. People stop trusting what they find. And security teams start hearing things like,...
2026-04-14
38 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
Question of the Day
RegEx Functions II
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