A Long Trip Ahead
This is my last day at home for a long time. At least long by my standards. I head to...
2015-10-07
403 reads
A Long Trip Ahead
This is my last day at home for a long time. At least long by my standards. I head to...
2015-10-07
568 reads
SQL Server Contracting – The first 14 months (or so)
Crikey, where did that time go! I have been so busy adjusting to my new work life style I have...
2015-10-16 (first published: 2015-10-07)
1,814 reads
TDE and Availability Groups
Caution must be exercised when mixing Transparent Data Encryption (TDE) and Availability Groups to ensure databases don't end up in...
2015-10-07
691 reads
Speaking at SQL Saturday #445 - Raleigh, NC - October 10
I will be speaking this weekend at SQL Saturday #445 - Raleigh, NC. If you are in the area, please come...
2015-10-07
494 reads
HOW WE CAN GET WHO IS CONNECTED TO DATABASE?
Some time we need to know that who is using database as of now or who all are connected to...
2015-10-07
595 reads
You DO have outstanding, free backup and maintenance, right?
It’s entirely possible that you’ve heard us talk about our supercharged, free backup and index maintenance solutions on Twitter, or on...
2015-10-07
666 reads
Get Hyper-V Host To Talk To Guest VM’s With This Simple Trick - Syndication – WaterOx Consulting
The Assumption I assume you already have a Hyper-V basic configuration on your system, be it a laptop, server or...
2015-10-16 (first published: 2015-10-07)
1,209 reads
Kicking the Tires on SSIS 2016
Last week I hosted a webinar in which I reviewed some of the coming changes for SQL Server Integration Services...
2015-10-19 (first published: 2015-10-07)
3,024 reads
Finding the error from a failed job.
This is a fairly simple one once you’ve seen it, but then so are lots of things :). Let’s say you...
2015-10-15 (first published: 2015-10-07)
2,329 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