30 Days of Adventure in Australia and New Zealand
Starting Saturday, September 26, 2009, I will begin a 30 day, 9 city, and 11 session speaking tour of Australia...
2009-09-04
654 reads
Proper T-SQL Stored Procedure Formatting
Here is a very good blog post from Aaron Bertrand (another SQL MVP) on how to write and format stored...
2009-09-04
953 reads
Amazon Finally Making Good on 1984
They should have done this on day 1 of the issue: offer users a legitimate copy and move their annotations....
2009-09-04
581 reads
Speaking to Association of Information Technology Professionals (AITP)
On Monday August 1st I had the pleasure of speaking to a group of college students that all belong to...
2009-09-04
403 reads
Speaking At SQL Saturday #21
Well looks like I will be packing my bags for Sunny Orlando. I Just found out that my abstract was...
2009-09-04
419 reads
A Great Business Model
Tia and I were moving dirt around the ranch this weekend. It was a chore that needed to be done,...
2009-09-04
351 reads
Job Market Update and some Job Search Advice…..
Job Market Update and some Job Search Advice…..
Not too long ago, I posted a blog on the possible thawing of...
2009-09-04
1,420 reads
Debuting: Beginning SQL Server 2008 Administration
The new book is up on Amazon. I only worked on three chapters of Rob Walter’s new book and that...
2009-09-04
637 reads
Survival: How a Culture of Preparedness Can You and Your Family From Disasters
Picked up Survival: How a Culture of Preparedness from the local library on a whim without looking at anything except...
2009-09-03
594 reads
Thoughts on the 24 hours of PASS
From all indications, the first 24 hours of PASS was a resounding success. Hundreds of attendees for each session, minimal...
2009-09-03
369 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