One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups. The ability to leverage the snapshot capabilities of modern storage arrays to take application consistent...
2026-09-21 (first published: 2026-09-11)
185 reads
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced! We’re kicking off at 1pm UTC on August 20th…here’s the schedule: – N.B. – If...
2026-06-26 (first published: 2026-06-15)
140 reads
Next up in my series talking about The Burrito Bot is diving into the different distance metrics used to calculate how a vector generated from a query compares to...
2026-06-15 (first published: 2026-05-28)
196 reads
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)
283 reads
A while back I posted about a couple of side projects that I’ve been working on when I get the chance. One of those was the Burrito Bot…a bot...
2026-04-06 (first published: 2026-03-27)
392 reads
EightKB is back again for 2026! The biggest online SQL Server internals conference is back…it’s all happening on August the 20th! We’ve open our call for speakers, you can...
2026-03-27 (first published: 2026-03-18)
237 reads
A while back I wrote a quick post on setting up key mappings in Visual Studio Code…they make presenting (and generally working) in Visual Studio Code really smooth. But...
2026-02-27 (first published: 2026-02-20)
667 reads
I was messing around performing investigative work on a pod running SQL Server 2025 in Kubernetes the other day and noticed something…the sqlservr process is no longer PID 1...
2026-02-02 (first published: 2026-01-23)
291 reads
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is Ireland’s free, community led, Microsoft Data Platform event. We had a fantastic event this year...
2025-12-16
79 reads
Following on from my last post about Getting Started With KubeVirt & SQL Server, in this post I want to see if I can improve the performance from the...
2025-12-11
125 reads
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Comments posted to this topic are about the item Building a SQL Server Fleet...
Comments posted to this topic are about the item Smart AI Agents and Data...
Comments posted to this topic are about the item RegEx Functions IV
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', 'i') AND BusinessEntityID IN (7,8)See possible answers