Featured Blogger: Glenn Berry
This month I’m featuring Glenn Berry, a Denver based MVP that writes Glenn Berry's SQL Server Performance blog. He blogs...
2009-07-22
733 reads
Replication Snapshot Errors Caused By Compatibility Level Setting
I ran across an interesting replication error recently that's worth sharing. It happened while using a distributor running SQL 2008,...
2009-07-22
464 reads
Kindle Alternatives – B&N on Blackberry
I’m not a fan of Blackberry devices. Actually that’s not true, I really dislike them. They’re not intuitive, and I’ve...
2009-07-22
1,288 reads
My Virtual Lab setup Hyper-V 2008 and Virtual Server 2005 R2
One of the things I’ve maintained over the years is a lab to do everything I need. From testing new...
2009-07-22
3,558 reads
Database Mirroring - Hitting the Limits
When I first heard about database mirroring in 2004, I was excited. Here was a great new feature that would...
2009-07-22
4,401 reads
Meet, Greet, & Remember?
How many of you have said, “I have a real hard time remembering names” or “Excuse me, I know we...
2009-07-21
416 reads
PASS Update 12
Time for another update on all things PASS. I’ve been struggling to find time for PASS activities and having to...
2009-07-21
614 reads
Barnes and Noble eBooks
I saw yesterday that Barnes and Noble released their e-reader for iTouch/iPhone, Blackerrys, Mac, and PCs and at the same...
2009-07-21
800 reads
Contest to Win a Free Trip to PASS
MSSQLTips & Idera are sponsoring a contest where the grand prize in an all expenses paid trip to the PASS Summit...
2009-07-21
715 reads
Security Basics: Physical Security
In IT security, we spend so much time trying to protect servers and computers on the wire (or on wireless)...
2009-07-21
1,262 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