Easily Shred Event Data
Parsing XML is the epitome of salt in a wound for a DBA. Parsing the XML from Extended Events need not be so painful. Read further to discover how...
2016-08-01
32 reads
Easily Shred Event Data
It has been nearly a year since I started an extensive series about Extended Events. Previous to that start, I...
2016-08-04 (first published: 2016-08-01)
2,463 reads
Top 3 books for Becoming TOGAF Certified
I often get asked what books are useful for preparing for the TOGAF certification exam. The resources are generally from...
2016-08-01
984 reads
Index-Cheat-Sheet. The complete Index-compatibility Matrix for SQL Server
(DE) Mit dem Aufkommen der Columnstore Technologie und auch der In-Memory Technologie in SQL Server 2014 sind insgesamt 4 neue Indextypen zu den althergebrachten page-basierten hinzugekommen.
Wo es früher nur...
2016-08-01
16 reads
Index-Cheat-Sheet. The complete Index-compatibility Matrix for SQL Server
(DE)
Mit dem Aufkommen der Columnstore Technologie und auch der In-Memory Technologie in SQL Server 2014 sind insgesamt 4 neue...
2016-08-01
681 reads
Power BI: If you have a Cloud of Words, let them Fly!
[2016-July-31] Last week was my 2nd time participating at the local Toronto Open Data meetup (https://www.meetup.com/opentoronto/). The audience of this meetup...
2016-08-02 (first published: 2016-07-31)
2,644 reads
Speaking at IT/Dev Connections!
I’m proud to announce that I will be speaking at IT/Dev Connections on October 11th 2016 in Las Vegas! I can’t begin to tell you how excited I am...
2016-07-31
19 reads
Speaking at IT/Dev Connections!
I’m proud to announce that I will be speaking at IT/Dev Connections on October 11th 2016 in Las Vegas! I...
2016-07-31
648 reads
The ROI of SQLSaturday for PASS & Decreased Event Funding
Returning to the post about Making SQSaturday Sustainable (see also a follow post about addressing concerns) it mentioned two topics...
2016-08-05 (first published: 2016-07-30)
1,489 reads
The End of the BAC–Why?
In a post titled The Future of the BA Community PASS announced that there would be no Business Analytics conference...
2016-07-30
828 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