Database is in Transition
One of my clients called saying they were receiving the following error when trying to access a database: "Error 952...
2009-08-12
7,066 reads
SQL Quiz 5: SANs Mirroring
My turn to answer Chris Shaw’s questions “Do I feel I have a reliable SAN solution?” and “Describe Database Mirroring...
2009-08-12
644 reads
No Training Budget Still No Excuse
When I first started by career in IT and SQL Server about 10 years ago I lived in a small...
2009-08-12
464 reads
SQL Saturday Baton Rouge – Session Evaluations
I received my evaluation summary from the SQL Saturday event in Baton Rouge earlier this month. This was the first...
2009-08-12
762 reads
So many topics, so many blogs.......What says you?
So, what should I talk about next? There's so much going on in the world of SQL Server (ie: 2008,...
2009-08-12
737 reads
LIVE MEETING REMINDER - Baton Rouge SQL Server User Group
Reminder: The Baton Rouge Area SQL Server User Group will be broadcasting its user group via live meeting. If you...
2009-08-12
463 reads
Design can be too simple
I've advocated simple design for years, trying to give users less choice, help lead them down paths to get their...
2009-08-12
553 reads
Getting Security Vulnerability Information
Staying abreast of security vulnerability alerts can be a daunting task because there are so many each day. One source...
2009-08-12
1,165 reads
SQLSaturday Advisory Council
Cross posted on the SQLSaturday blog as well.
We started SQLSaturday back in May 2007 because we wanted a SQL event...
2009-08-12
567 reads
LinkedIn For Business
Ran across this recently, 33 Ways to Use LinkedIn for Business and thought I’d post it since I’ve talked about...
2009-08-12
328 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