New Whitepaper: Deciding Between Merge and Peer-to-Peer Replication
Replication is still a major component of SQL Server today even with Availability Groups as an alternative to certain scenarios....
2015-10-01
701 reads
SQL Saturday Southampton Pre-con
It’s been a while since my last pre-con, in fact it’s been a while since my last SQL Saturday with...
2015-10-01
546 reads
October speaking schedule: Two Saturdays and a Summit
October is going to be a very busy month for me! Three conferences and a pre-con are on the agenda.
This...
2015-10-01
377 reads
I’m Speaking! SQL Saturday #444 – Kansas City
This weekend I’ll be traveling to Kansas City, Missouri for their annual SQL Saturday. Normally, I would just drive to this...
2015-10-01
467 reads
What’s new for BI in SQL 2016 – Session materials
SQL Server Days 2015 is over and it was a blast. Met a lot of people from the #sqlfamily, too...
2015-10-01
583 reads
SQL 2016 Row-Level Security Demo: Users with various clearance levels
SQL 2016 is right around the corner and one of the new security enhancements promised is Row-Level security for tables....
2015-10-01
1,308 reads
Session Target Metadata
In the case of the final core component, Targets, the exploration into the metadata can be a little awkward. At least at first. Read on to see how to...
2015-10-01
14 reads
Session Target Metadata
With the ability to find the metadata for deployed session, events and actions firmly under the belt, the natural progression...
2015-10-01
742 reads
Notes From the September 16, 2015 Jacksonville SQL User Group Meeting
Forgot to post the next day and now missing details! Notes:
Rained the entire drive up (and back)Not a bad drive...
2015-09-30
949 reads
How to convert to Base64 and backwards via T-SQL
I want to share my way to convert a string to Base64 and back. Let me note that presented method is not the fastest, but it has one important...
2015-09-30
26 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