T-SQL Tuesday #47: SWAG SWAG SWAG
This month we probably have the easiest topic I have ever seen for a TSQL Tuesday blog party. That isn’t...
2013-10-08
939 reads
Transaction Log Management
I have had the distinct pleasure of being asked to review a book by RedGate. The book is by a friend and respected community member Gail Shaw (blog |...
2013-10-07
23 reads
Transaction Log Management
I have had the distinct pleasure of being asked to review a book by RedGate. The book is by a...
2013-10-07
1,660 reads
Can You Dig It? – Find All Plans for a Database
She Can Dig It!
With today’s SQL Server instances, there easily be anywhere from a dozen to a hundred databases on...
2013-10-07
542 reads
Last Weeks Top “Reading” Links #52
Monday morning and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...
2013-10-07
986 reads
Cumulative Update – 13 for SQL Server 2008 SP3 Is Now Available !
The 13th cumulative update release for SQL Server 2008 Service Pack 3 is now available. Cumulative Update 13 contains all...
2013-10-07
728 reads
My Busy Weekend
This weekend is the fall camporee for my middle son’s Boy Scout troop. He’s one of the senior scouts in...
2013-10-07
791 reads
SSIS Tips and Tricks Q&A
Thank you to everyone who attended my webinar on SSIS Tips and Tricks on October 3, 2013. The link to...
2013-10-14 (first published: 2013-10-07)
3,676 reads
Renewed As MVP for 2013
Last Tuesday I received the email confirming that I will be an MVP for another year. Nice news to get....
2013-10-07
353 reads
SSIS Records on the Same Row – kind of like pivot
If you have two or more records on the same row, and need to write each record on its own...
2013-10-11 (first published: 2013-10-07)
2,112 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