Great Leaders in My Career
My friend Grant Fritchey recently posted in response to a quiz and at the end of that mentioned that he'd...
2009-05-04
589 reads
Writing a Technical Article - Structuring Your Article
This is part one of a series on writing a technical article. The advice might apply to non-technical articles, but...
2009-05-04
1,683 reads
A Dead Zune and Choices
Shortly after the Zune debuted, I purchased one. And I've been happy with it. It's done everything I expected out...
2009-05-04
869 reads
Working Remotely
It's too quiet in the house.
So I headed out to get some lunch and work at Paradise Bakery. They have...
2009-05-04
396 reads
Backing Up Asymmetric Keys
I've been tech editing a book about SQL Server encryption and this series of blog posts looks at some interesting...
2009-05-04
9,552 reads
Notes on SQLSaturday #15
I drove up on Friday night for the speaker dinner, getting there after a busy day trying to catch up...
2009-05-03
425 reads
Do You Have What It Takes?
I was engaged in a conversation recently where the topic under discussion was "What defines an "A" class player?" Others...
2009-05-02
384 reads
Published, Again!
I have written two new articles and they are going to be published, not on SSC but on SSWUG. I...
2009-05-02
1,289 reads
Up and Running
I’ve neglected my weather station for a few weeks. Lots of work, high winds, and snow have slowed me down.
Finally...
2009-05-01
406 reads
Lost in the Chaos
This morning I had an 8am call with the owners of my company and a consultant that was proposing some...
2009-05-01
447 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