Loopback available for Windows Containers
The April 2018 update for Windows brought a few cool things but the best one (imho) is that now we...
2018-05-16 (first published: 2018-05-07)
1,740 reads
The DBA Who Came In From The Cold
Friday Reading 2018-05-04
Phew, busy week. In the middle of updating presentations and making sure demos work!
Here’s a few of the articles...
2018-05-04
349 reads
Changing the location of docker named volumes
A few weeks ago I was presenting at SQL Saturday Raleigh and was asked a question that I didn’t know...
2018-05-09 (first published: 2018-05-02)
1,816 reads
Shiny Tech Syndrome
This is the name I give to anyone who, whilst learning a new technology, suddenly thinks it’s the best thing...
2018-04-30
375 reads
T-SQL Tuesday #101: My Essential SQL Server Tools
This month’s T-SQL Tuesday topic comes from Jens Vestergaard (b|t) who is asking us about our essential SQL Server Tools.
I’ve...
2018-04-10
311 reads
Friday Reading 2018-04-06
Feels like an age since I posted some links. So busy these days!
I’m really excited today as tomorrow I head...
2018-04-06
270 reads
Changing the port for SQL Server in Azure Container Services
I got asked this question last week and it’s a very good one. After all, running Sql Server in Azure...
2018-04-05 (first published: 2018-04-04)
1,758 reads
Imposter syndrome
Last week I posted the following “joke” on twitter: –
I’ve called it a “joke” but I wasn’t really joking. This...
2018-04-02
307 reads
How I became a Data Platform MVP
As I spent last week attending my first MVP Summit in Seattle I thought I’d write this post about how...
2018-03-14
403 reads
A gotcha when switching partitions
When working with partitioning the SWITCH operation has to be my favourite. The ability to move a large amount of...
2018-02-28
3,155 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