A New SSD For My Laptop
I’ve managed to get by for more than 3 years with the original 64G SSD in my laptop, but lately...
2012-01-24
1,234 reads
Blog Posts
A Script a Day
In February I will be starting a series of Blog Posts I'm calling a "A Script a Day". Each day...
2012-01-24
625 reads
Actual Emails: Is "NOLOCK is the epitome of evil?"
Sent: Friday, January 20, 2012 10:30 AM
To: William Assaf
Subject: dba has a questionWilliam,
Can you send me references to support my contention that NOLOCK...
2012-01-24 (first published: 2012-01-21)
3,886 reads
Afterthoughts: IT Pro Camp Orlando 2012
This past Saturday January 21, 2012 I had the opportunity to speak at my first IT Pro Camp in Orlando,...
2012-01-24
888 reads
Clicking on Links in Email
Every security awareness presentation makes the warning about opening attachments or clicking on links in emails when you don't know...
2012-01-24
1,266 reads
Determining Active Directory Group Membership
As discussed in my previous post I prefer to use Windows authentication over SQL authentication on my SQL Servers. There...
2012-01-24
1,734 reads
Generate test data using DBGen
Over the last couple of months I have on several occasions found myself in need of test data for demos,...
2012-01-24
14,409 reads
PASS Performance VC Reboot
The PASS Performance Virtual chapter is getting a reboot. We all know that responsibilities and schedules change, and that meant...
2012-01-24
748 reads
Read contents of a file to variable – SSIS
Sometimes you will find the need to import a file to a variable using SSIS. In this post, I’ll use Script...
2012-01-24
1,852 reads
RECONFIGURE can flush the procedure cache
I ran across this KB article the other day, which lists a few ways in which performance is affected by...
2012-01-24 (first published: 2012-01-19)
2,202 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