Monday Coffee 2017-01-23
I like to think of myself as a fairly hardworking, motivated person. However I recently met someone who regularly gets...
2017-01-23
318 reads
The DBA Who Came In From The Cold
Friday Reading 2017-01-20
Been an interesting week! My site has had the most views ever (so chuffed) and during all that I’ve been...
2017-01-20
524 reads
The two types of IT worker
Last week I published this post about something a colleague noticed when playing around with a SQL Server instance running...
2017-01-20 (first published: 2017-01-17)
2,873 reads
Monday Coffee 2017-01-16
I’ve been a scribbler for as long as I can remember, in fact I’m not sure that I write everything...
2017-01-16
352 reads
Friday Reading 2017-01-13
Ahh, is it really Friday the 13th?!! So before Jason gets me, I’ll be reading…
A whole day of PowerShell & SQL
Join...
2017-01-13
350 reads
Killing databases in SQL Server on Linux
Bit of fun this week with something that a colleague of mine noticed when playing around with SQL Server on...
2017-01-11
1,017 reads
Monday Coffee 2017-01-09
I’m almost back into the swing of things now after the Xmas break, that holiday feeling has just about left...
2017-01-09
395 reads
Friday Reading 2017-01-06
Happy New Year to all of you out there! I know, I know it’s a week late but hey I’ve...
2017-01-06
342 reads
Saturday Reading 2016-12-17
It was my office Xmas party last night so whilst recovering on my settee, I’ll be reading:-
The Most Important Role...
2016-12-17
355 reads
Presenting with SQL Server Management Studio
Short one this week as it’s the usual madness on the lead up to Xmas!
One of the cool things that...
2016-12-14
728 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