019 – 24 HOP Questions Answered - Syndication – WaterOx Consulting
24 HOP Questions Answered In WOxPod!, episode # 019 – “24 HOP Questions Answered” I answer those questions that I wasn’t able...
2015-10-02
647 reads
SET Operations and Metadata
SET operations in extended events are the extra configurations that can be made to various components. As an example, a target can be configured with certain properties via the...
2015-10-02
8 reads
SET Operations and Metadata
Having covered the core concepts of deployed session metadata (events, actions, targets, predicates), there is one more topic to cover....
2015-10-02
671 reads
Free learning materials
If you are new to a technology, you might want to have a place to get you started. It would be great if can be free and can guide...
2015-10-02
25 reads
Oregon SQL Saturday 2015 Keynote
This year we are honored to have a particularly special guest kicking off our SQL Saturday event on October 24th. ...
2015-10-02
249 reads
Oregon SQL Saturday 2015 Keynote
This year we are honored to have a particularly special guest kicking off our SQL Saturday event on October 24th. ...
2015-10-02
471 reads
Step by Step SSIS–Aggregate Transformation TIP #118
Dear Friends,
In the series of step by step SSIS tutorial this is another post. In this post we will see...
2015-10-02
2,042 reads
SQL Server – Configuring custom Load Balancing in SQL Server 2012 and 2014 using Read-Only Routing
Starting with SQL Server 2012, AlwaysOn Availability Groups provided group level high availability for any number of databases for multiple...
2015-10-01
1,438 reads
SQL Server – Dynamically Generate Scripts for Configuring Read-Only Routing URLs and Lists
Read-only routing refers to the ability of SQL Server to route incoming read-intent connection requests, which are directed to an...
2015-10-01
492 reads
SQL Server – Script to generate Read-Only Routing URLs
If you are familiar with the new feature Read-Only Routing introduced in SQL Server 2012 with AlwaysOn then you should...
2015-10-01
517 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