Article Of the Week
I really enjoy reading technical articles. They often enlighten me on new technologies or provide me with a new way...
2009-08-24
956 reads
I went silly
Well, a little silly at least. I wrote yesterday about winning a gift certificate to ThinkGeek, and wondering what to...
2009-08-24
949 reads
24 Hours of PASS
Image a full day of SQL Server and BI training. Even better yet, a full day of FREE training. Well PASS (Professional...
2009-08-24
545 reads
PASS Update #13
It’s been a busy few weeks since update #12. We announced guidelines for submitting content to sqlpass.org, an effort that...
2009-08-23
744 reads
Active August –> Week 3 Recap
Well, I had a pretty good week this week. I made an effort and met all my goals:
Eat smaller portions...
2009-08-23
360 reads
Beware the REPLACE function when doing heavy string parsing
I found something interesting the other day. I was attempting to optimize a very heavy string parsing routine using T-SQL...
2009-08-23
8,701 reads
A New Identity
Well, perhaps not a whole new identity, just a consolidation of multiple facets of my online persona. For several years...
2009-08-23
545 reads
SOX in the City - Preparations for Audit
As I was going through some of my documentation at past clients, I found my summary of the general SOX...
2009-08-23
2,472 reads
The Netbook: 40 Days In
I wrote last month about purchasing a new Toshiba netbook to supplement my mobile computing arsenal. Forty days later, I’m...
2009-08-22
618 reads
Welcome Home !!
I realize I have been relatively quiet for a while, but summer is actually a fairly busy time for us...
2009-08-22
1,233 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