Perth .NET Users Group First Stop of Down Under Tour
As the first stop of my five city speaking tour of Australia, I spoke at the Perth .NET Users Group...
2009-10-01
594 reads
Speaking at SQLSaturday #21 – Orlando
Well, I guess this isn’t a surprise since I put together the schedule, but I’m still excited to be speaking...
2009-10-01
313 reads
Tips for Networking at PASS
This year will be my third trip to the PASS conference. If you have met me or had any conversation...
2009-10-01
835 reads
Referral Contest for PASS Summit
Hopefully you saw it in the special mailing that went out yesterday, but the marketing team just released a new...
2009-09-30
1,374 reads
SQLSaturday #21 Update
We’re closing in on our October 17th SQLSaturday #21 in Orlando and I thought I’d share a few things about...
2009-09-30
1,408 reads
Winding Down
I'm trying to finish up the last few things here at work before taking the weekend off. I scheduled off...
2009-09-30
1,469 reads
Pre-Compiled Stored Procedures: Fact or Myth
There’s a very common belief among DBA’s: Stored procedures are pre-compiled. I had someone tell me all about it just...
2009-09-30
1,918 reads
Minor Celebration
A little cheap thrill for me. I passed 50,000 views on the blog yesterday. Thanks to everyone who has stopped...
2009-09-30
1,395 reads
The old INNER JOIN syntax vs. the new INNER JOIN syntax
I was in a presentation last week where the presenter was talking about the ANSI/ISO SQL standards. For the most part the...
2009-09-30
47,179 reads
Heading Down to the Basement
I'm taking the next two days off, heading down into the basement for a four day weekend. Nothing particular going...
2009-09-30
1,478 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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