My SQL PASS Summit Adventures part 1
I started my PASS Summit a little early this year. I arrived in Seattle on Friday night, November 5th, around...
2010-11-16
593 reads
How Often Do You Backup Your Transaction Logs?
Whenever I speak about database maintenance, I always recommend that DBAs backup up their production database transaction logs at least...
2010-11-16
1,875 reads
Get Drive Space Including Mount Points
Today’s post is a quick one that came out of a conversation on Twitter. To make a long story short,...
2010-11-15
2,864 reads
Help Set Recommendations for SSAS Counters in PAL
First, if you haven’t tried PAL yet, I highly recommend downloading it from CodePlex and giving it a try. You...
2010-11-15
900 reads
PASS Report 1: Why you should have been there!
PASS Summit 2010 is now history. This is my eighth summit but the first one since leaving the DBA world...
2010-11-15
1,579 reads
Inspiration, and the Joy of the Hive Mind
PASS Summit 2010 is over, and we are suffering from the lack of chatter and SQL celebrity sightings. Bloggers are...
2010-11-15
590 reads
PASS Summit Magic: The Turn
Watch closely...
I mentioned in my last post that the Turn is the point in the act where the magician executes...
2010-11-15
1,485 reads
SSIS Denali Resolve References
One of the new features in SSIS Denali that I’m really excited about (Other than the ability to Undo ctrl-z)...
2010-11-15
1,417 reads
Presenting At East Iowa SQL Server Users Group On Nov. 16
On Tuesday, November 16, I'll be presenting Paging DR Availability, You're Wanted in the Recovery Room via LiveMeeting to the...
2010-11-15
517 reads
SQLServerPedia Awards Winner
Thanks to all those that voted for my Index Black Ops blog series for the SQLServerPedia blog awards. I am...
2010-11-15
560 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