Next Week, in or out of Charlotte (#sqlpass #Summit13 #SQLHighTea #TooManyHashtags)
Welcome to Tuesday. We hope you enjoy your stay! Edit: We have been informed that today is actually Wednesday. We...
2013-10-09
538 reads
Do Be a Gatekeeper
I read this fascinating blog post called “Don’t Be a Gatekeeper” by Julie Zhuo. Please read that first.
It really resonated...
2013-10-18 (first published: 2013-10-09)
2,738 reads
How to Limit IO Requests with SQL Server 2014 Resource Governor
Resource Governor was introduced in SQL Server 2008 in order to allow us have better control over our system resource...
2013-10-09
2,253 reads
Unexpected result with the File System Task
Recently I ran across a forum thread where someone encountered an unexpected result when creating a directory using the File...
2013-10-09
364 reads
Unexpected result with the File System Task
Recently I ran across a forum thread where someone encountered an unexpected result when creating a directory using the File...
2013-10-09
646 reads
Checking Backup/Restore progress
Every now and then we all need to perform backup or restore, for large databases when we need to perform...
2013-10-09
623 reads
Merge outputs of perfmon and profiler to get a great view
There is a way by which we can merge the .trc and .blg files to get a great view as...
2013-10-17 (first published: 2013-10-09)
6,379 reads
T-SQL Tuesday #47: My Best SQL Server SWAG
This blog post is part of T-SQL Tuesday, a monthly SQL blog party with a rotating host and common topic....
2013-10-08
1,224 reads
Oh, The Free Stuff!
Ah, Shwag I’ve been doing the whole conference thing for a while. Not as long as some but quite a while. Along the way I’ve collected quite a...
2013-10-08
12 reads
Oh, The Free Stuff!
Ah, Shwag
I’ve been doing the whole conference thing for a while. Not as long as some but quite a while....
2013-10-08
893 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