Consolidation
I’m about to go down one laptop, which is good. I have had too many for some time. Right now...
2010-12-06
402 reads
The Basics of Troubleshooting
After seeing several cases in the past couple of months where I felt the basics of troubleshooting were violated, I...
2010-12-06
2,227 reads
Digg
I’m currently doing some experiments with ,y blog and trying out digg.com. In order to do that I need to...
2010-12-05
530 reads
What happens when a query is submitted?
I know, We cant cover life span of query in short. here is my another try to list some high level information...
2010-12-05
5,457 reads
What PASS means to me.
I first heard of PASS (Professional Association for SQL Server) in connection with the PASS Summit. I had a several...
2010-12-04
366 reads
Getting Drive Info, Part 5, the SSIS WMI Data Reader Task
In the final installment of the Getting Drive Info series (Part 1, Part 2, Part 3, Part 4), SSIS will again be used to collect and save the drive...
2010-12-04
27 reads
Getting Drive Info, Part 5, the SSIS WMI Data Reader Task
In the final installment of the Getting Drive Info series (Part 1, Part 2, Part 3, Part 4), SSIS will...
2010-12-04
1,912 reads
RTFM365 Week 0
For the next year, I will read from SQL Server Books Online a little every day, and blog about it weekly. ...
2010-12-03
721 reads
Book Review: Alas, Babylon
I just re-read Alas, Babylon by Pat Frank ($10 @ Amazon). It’s a bit of a touchstone for me. It was...
2010-12-03
620 reads
Free SQL Server Training for the Week of December 6, 2010
Took a break from posting this last Friday due to the holidays. But I'm back with the weekly updates.
Monday
PASS Data Warehousing/BI...
2010-12-03
946 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