Learning a New Development Platform
This past week at work we have been having some in-depth training. The interesting thing is it hasn't been SQL...
2009-06-18
1,338 reads
The secret skill revealed in the dusty booklet
Going through one’s father’s belongings after his death is
always a poignant, bitter-sweet experience. I was going through his most
precious books...
2009-06-18
1,996 reads
Enabling Checkpoints in your SSIS Packages
Checkpoints are a great tool in SSIS that many developers go years without even experimenting with. I hope to enlighten...
2009-06-18
13,034 reads
The Cost of E-books
What’s the cost of e-books? It’s an interesting question that I have always wondered. I found this account of the...
2009-06-18
727 reads
PASS Connector Editorial for June 17, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-06-18
662 reads
Tips on Getting HIred – Part 3
Part 1 discussed ways to find opportunities, Part 2 was about how to get more interviews, and today we’ll cover...
2009-06-17
1,006 reads
ALSSUG...soon!
Yes, ALbanian SQL Server User Group will start soon with first meeting and registering the new users. So we will...
2009-06-17
510 reads
Starting up a Pass Chapter
I am on my way in setting up a Pass chapter on our tiny Caribbean island. I had no clue...
2009-06-17
611 reads
Speaking at North Texas SQL Server User Group meeting
For those in or around the Dallas area tomorrow (Thursday) evening, I'll be speaking at the North Texas SQL Server...
2009-06-17
792 reads
Creating Red Gate SQL Compare Snapshots with Powershell
Co-worker and fellow DBA,, John O'Shea developed a Powershell script to create Red Gate SQL Compare snapshot files. Check out...
2009-06-17
1,066 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