Active August #1
I like to blog about technical topics and community, not personal stuff. However, this is a community post. A number...
2009-08-01
628 reads
Revive your User Group, part IV
Over the past three posts in this series entitled “Revive your User Group”, I’ve shared some of best practices that...
2009-08-01
523 reads
Things You Need To Know If You Use DFS Replication
In addition to being a SQL DBA I'm also a network administrator, or at least I pretend to be. This...
2009-07-31
2,964 reads
PASS & SQL Bloggers
PASS is trying to find better ways to reach out to SQL Bloggers. They’re going to experiment with taking advantage...
2009-07-31
1,331 reads
No really. When did this statement start?
I thought I had an interesting answer to the question. Unfortunately Adam Machanic, who has been working in this specific...
2009-07-31
1,332 reads
Article re-featured on SQLServerCentral
The second article I had published on SQLServerCentral, ANSI PADDING, Trailing Whitespace, and Variable Length Character Columns, was re-featured in...
2009-07-31
1,416 reads
Heading to N'Awlins
I'm leaving today for SQLSaturday #17, actually in Baton Rouge. I'll be at the speaker party tonight and hope to...
2009-07-31
1,558 reads
Book Review: The Connect Effect: Building Strong Personal, Professional, and Virtual Networks
I read The Connect Effect: Building Strong Personal, Professional, and Virtual Networks by Michael Dulworth ($16 @ Amazon) months ago, forgot...
2009-07-30
1,919 reads
24 Hours of PASS - Building a Better Blog
I got asked to do an hour during the 24 hours of PASS that is happening on Sept 2. It's...
2009-07-30
1,386 reads
Embedding Bing Maps in a Web Page
I was doing some maintenance on the SQLSaturday web site recently and one request kinda low on the list was...
2009-07-29
3,610 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