SQL Server Encryption - Hashing Collisions
A hash is a computation that transforms one set of data into another (hopefully smaller) set of data. So a...
2009-06-01
5,259 reads
Understanding File System IO, Lessons Learned From SQL Server
I do more than just SQL Server. I enjoy programming. In my former life I have worked with C/C++ and...
2009-05-29
1,955 reads
Found a Bug in SQL Server 2005
It doesn’t happen often but every once in a while you may be the lucky person to find a previously...
2009-05-29
2,171 reads
Security Basics: Applying the Principle of Least Privilege Properly
Whenever I do a security presentation, I make sure to cover the Principle of Least Privilege. And when I do...
2009-05-29
3,162 reads
Fusion IO’s on Their Way!
My company has taken the plunge and we have two of the Duo 640’s coming. As soon as they get...
2009-05-29
1,534 reads
SQL Rockstar
I was scanning blogs the other day, and noticed Tom LaRock's new image on Twitter. He's SQLRockstar after a little...
2009-05-29
2,012 reads
Changing Server Default Collation
An interesting problem develops when the standard default collation for SQL Server isn't appropriate. Working with clients here in the...
2009-05-29
1,630 reads
The Conference ROI
I saw recently that Brent Ozar wrote a blog about justifying the cost of attending the 2009 PASS Summit. I...
2009-05-29
3,379 reads
Book Review: Real Leaders Don't Do Powerpoint
I bought Real Leaders Don't Do Powerpoint by Christoper Witt ($15 at Amazon) on a trip, Powerpoint catching my eye...
2009-05-28
1,751 reads
Book Review: Success Is A Choice
I just finished reading Success Is A Choice: Ten Steps to Overachieving in Business and Life. Written by Rick Pitino,...
2009-05-28
2,189 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