NOLOCK – truth
With the NOLOCK hint (or setting the isolation level of the session to READ UNCOMMITTED) you tell SQL Server that...
2010-11-30
1,511 reads
Multiple Mirrors
Up through SQL Server 2008 R2 database mirroring has been limited to a single mirror for each database. While that...
2010-11-30
5,492 reads
SSIS Package Annotation in Denali
If you are anything like me, you document your SSIS packages for those who may have to maintain them after...
2010-11-30
3,775 reads
Certificate Based Application Roles
What if I told you that you could sign an assembly that your Windows application uses with a certificate, load...
2010-11-30
1,603 reads
Executing PowerShell in SQL Server Redux
A while ago I blogged about using xp_cmdshell to execute a PowerShell script in SQL Server and return a result...
2010-11-30
1,637 reads
Drumroll Please…
Defensive Db Programming Chapter 10 After dragging this review on for months now, it is finally time to bring this bad boy home and wrap it up. I have...
2010-11-29
12 reads
Drumroll Please…
Defensive Db Programming Chapter 10
After dragging this review on for months now, it is finally time to bring this bad...
2010-11-29
1,386 reads
PASS Update #48
It’s the end of November and this will probably be my last update on PASS for the year as things...
2010-11-29
1,566 reads
TechEd 2011
TechEd will be in Atlanta next year, May 16-19, 2011 at the Georgia World Conference Center. I went this year...
2010-11-29
1,537 reads
Android Adventures–Part 2
I’ve been living with my Droid X phone for a couple weeks now. It’s definitely a big change from my...
2010-11-29
1,489 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