Book Review - The Checklist Manifesto
Andy Warren recommended The Checklist Manifesto to me and after seeing his review, I decided to grab it. It’s written...
2010-11-26
1,853 reads
What Am I Thankful For
Earlier this week, I suggested that we share a message of thanks on our blogs. Since I suggested we put...
2010-11-26
979 reads
Leading the Albanian PASS Chapter
Yesterday, I have received the official email from the PASS HQ, and the confirmation that now I'm the leader of...
2010-11-25
825 reads
SSIS Denali Annotations
I have written a couple quick blogs recently sharing some of the new usability changes for SSIS in Denali.In previous...
2010-11-24
673 reads
How Do I Change SSRS Report Credentials with Powershell?
Today’s script took a long time to write. The concepts are fairly simple and the resulting script is quite trivial...
2010-11-24
7,216 reads
What I’m Thankful For
Since it is the week of Thanksgiving in the United States, Jason Strate (@strateSql) has requested that bloggers post what...
2010-11-24
589 reads
Holiday Review: Stuff I
For the last two years, I’ve participated in Sean’s InfoWorld Xmas Wish List, where we review a bunch of cool...
2010-11-24
577 reads
FreeCon
I got my FreeCon. What’s more, I did it in public and didn’t get in trouble.
FreeCon is the brain child...
2010-11-24
1,626 reads
XQuery for the Non-Expert – Resources
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
Learning XQuery...
2010-11-24
1,605 reads
Do the Packet Trace - Especially When Things Are Good
Last night we were troubleshooting really poor performance on a core system. One of the things being investigated was a...
2010-11-24
1,036 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