Using Windows stored credentials to connect to SQL in containers
I work with SQL Server in containers pretty much exclusively when testing code and one of my real bug bears...
2018-01-17
1,128 reads
The DBA Who Came In From The Cold
Time to find a new place to live
Over the last couple of weeks I’ve been looking at various different locations around Dublin as my tenancy in the...
2018-01-15
277 reads
Friday Reading 2018-01-11
Phew, what a week! Have been looking for a new flat to live so it’s been a bit mad. Have...
2018-01-12
320 reads
Comparing two SQL instances
Last week I was working on a couple of SQL instances that contained databases which were part of an Always...
2018-01-10
495 reads
Roll on 2018!
Hey everyone, hope you all had a great Christmas and New Year!
I took December off from blogging as had started...
2018-01-08
364 reads
Checking SQL Configuration with Pester & Dbatools
I know, I know, there’s loads of different ways to test the configuration of SQL Server but I’ve started playing...
2017-12-13 (first published: 2017-11-29)
1,856 reads
Friday Reading 2017-11-17
Fun week, lots of stuff to organise and prepare for! Whilst I’ve had some downtime I’ve been reading…
Write your first...
2017-11-17
304 reads
Running SQL Server in Kubernetes on Azure Container Services (AKS) II
I’ve previously blogged about running SQL Server in ACS but Microsoft has now released a new version still called Azure...
2017-11-15
1,002 reads
Blogging for four years!
I find it absolutely amazing that I’ve been writing this blog for four years. My first ever post My 5...
2017-11-13
238 reads
Friday Reading 2017-10-27
Morning all! PASS Summit is coming next week but unfortunately I can’t make it this year. I hope everyone who...
2017-10-27
420 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