Finding and keeping your #SQLPassion
I consider myself lucky. I fell into a job that I truly enjoy, something that I do for fun even...
2015-10-26
492 reads
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
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
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