SQL Quiz #5 – SANs the Star the Show Must Go On(Mirroring)?
Okay, Jorge Segarra (@SQLChicken) tagged me in Chris Shaw’s (@SQLShaw) latest SQL Quiz, SAN’s and Mirroring. I’m a little behind...
2009-08-21
340 reads
SQL Down Under Code Camp to be Held in October
If you live in Australia, or are just looking for an excuse for a vacation in Australia, sign up for...
2009-08-21
681 reads
Cumulative Update 5 For SQL Server 2005 SP3
Microsoft has released the latest Cumulative Update for SQL Server 2005 SP3, which is Build 4230. They also released a...
2009-08-21
486 reads
Keeping SQL Server Client Tools Up-to-Date
In a recent forum thread, someone asked to see who created/altered a particular object. Starting in SQL Server 2005, this information is...
2009-08-21
1,419 reads
What happens when you use WITH RECOMPILE
I saw this question and my immediate thought was “Well, duh, the execution plan is recreated by a recompile.” But,...
2009-08-21
1,333 reads
SQL Lunch
Baton Rouge SQL Server group leader and recent SQL Saturday host Patrick LeBlanc is putting together a new learning series. ...
2009-08-21
712 reads
Denver SSUG – AUG 2009
I attended the Denver SQL Server User Group meeting, wanting to get a chance to catch up with some friends...
2009-08-21
1,111 reads
SQL Profiler – Wild Card Filter on TextData
WARNING: This may be very obvious to most of you. However, several people that I have encountered did not realize...
2009-08-21
37,283 reads
The Kindle Update - A Month on the iPhone/iTouch
Ever since my Kindle broke, I've been reading on my iTouch for the most part. I've been using both the...
2009-08-21
780 reads
A True Sense of Community
We have a thread in our forums that many of the participants refer to as "The THREAD." It's a long...
2009-08-21
724 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