Quite Time
It’s vacation week for me. Everything’s scheduled for SQLServerCentral, and my family is taking our annual ski break for Thanksgiving....
2010-11-22
703 reads
SSIS Denali Data Flow Grouping
There have been several usability features that have been added to SSIS in the latest CTP.One of these features is...
2010-11-22
840 reads
Guest Vs. Host Clustering Virtual Machines: Speaking Tuesday 23rd November at Montreal Tech Days
I will be replacing speaker Steven Robidas on Tuesday, 23 November at Microsoft TechDays.ca Montreal. The discussion will be on...
2010-11-21
652 reads
Un-SQL Friday: Personal Branding – Don’t Bother
My friend Jen McCown of MidnightDBA fame issued a challenge last week called “Un-SQL Friday”. The inaugural topic is on...
2010-11-21
707 reads
What are you thankful for?
About this time last year, Digineer had an internal event where we could share messages of thanks. These messages were...
2010-11-21
589 reads
SQLSaturday#59 - It's A Wrap! - Summary of Our Saturday...
SQLSaturday#59 went off without a hitch! It was one awesome fun-filled day with our great speakers, sponsors, volunteers, and hundreds...
2010-11-21
1,157 reads
New book from Pragmatic Works in the "works"...
Hey folks, Just a quick preview that we’re hard at work again on a new book with Wiley publishing focused...
2010-11-21
502 reads
New Video Blogs
Hey there folks! I am sorry it has been about a week without an entry.I have been on planes all...
2010-11-21
331 reads
Where will I be?
After the great time everyone had at the PASS Summit this past week I am getting asked more and more...
2010-11-21
371 reads
XQuery for the Non-Expert – Query
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
In the...
2010-11-21
1,268 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