Fourth of July
Read the Declaration of Independence and then it’s time for fireworks and grilling, maybe some apple pie too!
2009-07-03
507 reads
Book Review: Rolling Thunder
Rolling Thunder ($7.99 @ Amazon) by John Varley is the third book in the series. I previously reviewed Red Thunder and...
2009-07-02
716 reads
HP Mini Netbook – Day 2
I arrived in Richmond, VA this morning earlier than expected. I was meeting a few people and things were pushed...
2009-07-02
1,466 reads
Stack Overflow, Server Fault, and SSC
Steve Jones sent me a link to a presentation Joel Spolsky did at Google about Stack Overflow (SO) and it’s...
2009-07-01
773 reads
The Best Thing I Learned At PASS
Note: I'm writing this as part of the "Best Thing I Learned At PASS" contest. Why? Because if I win...
2009-07-01
760 reads
Transaction Rollbacks with Identity Values
Have you ever noticed unexpected gaps in sequences in IDENTITY columns? Even though you’ve got transactions set up for your...
2009-07-01
10,032 reads
HP Netbook 1030NR Setup
Unpacking the netbook was pretty simple. Open it, grab the large one page poster, and then the netbook. There were...
2009-07-01
708 reads
How to Become an Exceptional DBA, 2nd Edition, Now Available Free
About a year ago, the first edition of my book, How to Become an Exceptional DBA, was published. It was...
2009-07-01
1,822 reads
HP Netbook Mini 1030NR
It was not what I expected. When I was leaving for a run this morning, I decided to apply an...
2009-07-01
1,329 reads
Powershell SQL Server Backup/Restore
I posted a script on Poshcode for doing backups and restores of SQL Server databases using SMO. The script is...
2009-07-01
2,155 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