Extended Events Intro
Extended Events is supposed to be taking over for most of Profiler and server-side tracing functionality, but there were people...
2015-10-26
1,612 reads
Short Circuit Events
The predicate order is critical. Having the wrong order can result in not trapping the desired events. I cover the critical nature of predicates in the aforementioned article. At...
2015-10-26
11 reads
Short Circuit Events
I introduced the importance about predicate order previously. I recommend either reading that article for the first time or reading...
2015-10-26
610 reads
SQL Server Database Source Control using VSO Git
For a while now, I have ensured that the source code of new projects that I have undertaken (in both...
2015-10-26
246 reads
Things You Need To Know about Nolock
Nolock is not the Satan, but no an angel too
Surfing the web you will find articles saying that Nolock is...
2015-10-26
491 reads
SQL Server – Columnstore Index creation error: A columnstore index cannot have INCLUDED columns
Hi friends, in my previous blog we learnt that sparse column cannot be part of columnstore index. In this blog...
2015-10-26
617 reads
Be Cautious About Invoke-SqlCmd Bug
With PowerShell becoming more popular in daily DBA work, I’d like to mention one huge ugly bug I recently encountered...
2015-10-25
370 reads
Be Cautious About Invoke-SqlCmd Bug
With PowerShell becoming more popular in daily DBA work, I’d like to mention one huge ugly bug I recently encountered...
2015-10-25
2,039 reads
So Long Seattle and Thanks for all the Fish!
I’ve had some good times in the Seattle area. I’ve lived in the Seattle are since 1987 and graduated high...
2015-10-25
583 reads
Hekaton Part 9: Things Hash Indexes can't do
Last few posts have explored hash indexes in depth. This one will deal with the limitations on Hash Indexes. What...
2015-10-25
411 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