EightKB Summer 2021 Edition
The schedule for EightKB Summer 2021 Edition has been announced! Here’s the schedule: – N.B. – I particularly like that if you click on the session on the website,...
2021-07-02 (first published: 2021-06-15)
209 reads
The DBA Who Came In From The Cold
Running a SQL Server container from scratch
I’ve been interested (obsessed?) with running SQL Server in containers for a while now, ever since I saw how quick and easy it was to spin one up. That...
2021-05-24 (first published: 2021-05-17)
659 reads
Converting a SQL Server Docker image to a WSL2 Distribution
Windows Subsystem for Linux is probably my favourite feature of Windows 10. It gives us the ability to run full blown linux distributions on our Windows 10 desktop. This...
2021-04-15 (first published: 2021-04-13)
320 reads
Creating presentations with Reveal and Github pages
I really don’t like Powerpoint. I’ll do pretty much anything to avoid writing a presentation in it. Thankfully for the last few years there’s been a service called GitPitch...
2021-02-26 (first published: 2021-02-21)
253 reads
EightKB is coming!
The next EightKB is coming on January 27th, kicking off at 2pm UTC. Once again we have 5 mind melting sessions on 5 in-depth SQL Server internals topics, from...
2021-01-13 (first published: 2021-01-07)
524 reads
Provisioning storage for Azure SQL Edge running on a Raspberry Pi Kubernetes cluster
In a previous post we went through how to setup a Kubernetes cluster on Raspberry Pis and then deploy Azure SQL Edge to it. In this post I want...
2020-12-16 (first published: 2020-12-07)
171 reads
Updating my Kubernetes Raspberry Pi Cluster to containerd
There’s been a lot of conversations happening on twitter over the last couple of days due to the fact that Docker is deprecated in Kubernetes v1.20. If you want...
2020-12-03
127 reads
Building a Raspberry Pi cluster to run Azure SQL Edge on Kubernetes
A project I’ve been meaning to work on for a while has been to build my own Kubernetes cluster running on Raspberry Pis. I’ve been playing around with Kubernetes...
2020-12-11 (first published: 2020-11-30)
572 reads
Differences between using a Load Balanced Service and an Ingress in Kubernetes
What is the difference between using a load balanced service and an ingress to access applications in Kubernetes? Basically, they achieve the same thing. Being able to access an...
2020-12-02 (first published: 2020-11-23)
260 reads
EightKB is back!
We’re back! The first EightKB back in July was a real blast. Five expert speakers delivered mind-melting content to over 1000 attendees! We were honestly blown away by how...
2020-11-30 (first published: 2020-11-18)
385 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
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