Azure Kubernetes Service Error – LoadBalancer type service external IP stays pending
Last week I was working on my Azure Kubernetes Service cluster when I ran into a rather odd issue. I’d...
2019-01-30
366 reads
The DBA Who Came In From The Cold
Deploying SQL Server to Kubernetes using Helm
In previous posts I’ve run through how to deploy sql server to Kubernetes using yaml files. That’s a great way...
2019-01-29 (first published: 2019-01-16)
2,689 reads
A shell for working with Kubernetes
I’m always a fan of tools that can make my life easier.
One tool that I’ve recently come across is...
2019-01-09
181 reads
Setting up SQL Server replication in containers
Last week I saw a thread on twitter about how to get replication setup for SQL Server running in a...
2018-12-13
852 reads
Attaching databases via a dockerfile – UPDATE
This has been bugging me for a while but I just haven’t had a chance to get around to revisiting...
2018-12-11
195 reads
Running a SQL Server Azure Container Instance in a virtual network
Up until now Azure Container Instances only had one option to allow us to connect. That was assigning a public...
2018-10-04
355 reads
Running SQL Server 2019 CTP in a Docker container
If you’ve been anywhere near social media this week you may have seen that Microsoft has announced SQL Server 2019.
I...
2018-10-04 (first published: 2018-09-25)
4,433 reads
Taking the Linux plunge – Update
It’s been a couple of weeks now since I took the plunge and bought myself a Dell XPS 13 running...
2018-08-10
308 reads
SSL Provider error 31 when connecting to SQL in a docker container
I recently bought a Dell XPS 13 running Ubuntu 16.04 and ran into an issue when connecting SQL Operations Studio...
2018-08-06
719 reads
Evening or morning poll results!
And the results of the poll are in!
Evening just scraping it! So there’s a pretty even mix out there, interesting....
2018-08-03
238 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