Running Linux Containers on Windows
Microsoft have announced the availability of SQL Server 2017 RC1 and I wanted to check it out in a container...
2017-08-02 (first published: 2017-07-18)
2,224 reads
The DBA Who Came In From The Cold
Monday Coffee: 24 Hours of Pass – Summit Preview
Starting at 12pm (UTC) this Wednesday is the online event 24 Hours of PASS – Summit Preview
For anyone out there who...
2017-07-17
291 reads
Friday Reading 2017-07-14
Fun week, and what a Lions final test last weekend. Still can’t believe it!
Here’s what I’ve been reading…
STOPAT And Date...
2017-07-14
294 reads
Creating SQL Server containers with docker compose
Up until now my posts about containers have been talking about working with one container only. In the real world...
2017-07-26 (first published: 2017-07-12)
7,857 reads
Monday Coffee: Database Deployments
I’ve always been particularly cautious when it comes to deploying code to databases, some would say overly cautious.
Because of this...
2017-07-10
728 reads
Running dbatools commands with VS Code tasks
I’ve started to look at the excellent dbatools.io to automate some of the checks that I routinely perform on my...
2017-07-07
909 reads
Friday Reading 2017-07-07
Final Lions Test tomorrow! The win last week sets up a thrilling series decider, if they win they’ll be the...
2017-07-07
801 reads
Persisting data in docker containers – Part Three
Last week in Part Two I went through how to create named volumes and map them to containers in order...
2017-07-19 (first published: 2017-07-05)
3,194 reads
Monday Coffee: Alerts & Checks
Hope you all had a good weekend, the Lions won so I’m pretty happy.
Over the weekend I was thinking about...
2017-07-03
360 reads
Friday Reading 2017-06-30
Second test for the British & Irish Lions tomorrow, they need this one to keep the series alive. I’ll be up...
2017-06-30
574 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