DevConnections Sept 14-17th 2015 – Las Vegas
DevConnections is a new conference for me and I am excited about the opportunity to present 2 different sessions. The...
2015-08-11
616 reads
T-SQL Tuesday #69–Encryption
This is a good T-SQL Tuesday topic for me. This month Ken Wilson asks everyone to write on encryption, which...
2015-08-11
913 reads
How not to do a Masters degree
There are many, many guides to successfully completing a post grad degree, so I am not going to add to...
2015-08-11
603 reads
CNJSSUG Presents: Architecting a SQL Server Availability Groups Topology - Edwin Sarmiento
Tomorrow Wednesday, August 12, 2015 at 6PM EDT, my friend and SQL MVP colleague, Edwin Sarmiento will be in town...
2015-08-11
1,188 reads
Leadership: A Name and A Principle
I’m actively working to put together the leadership course that I talked about here and here. No, not full time. I...
2015-08-11
512 reads
I’m Speaking! SQL Saturday #397 – Omaha
I recently blogged about the opportunity to speak at that the Omaha SQL Server User group. In a nutshell, being a co-founder...
2015-08-11
536 reads
Scripts and SSDT-BI 2013
Recently I tried to open a script component in SSDT-BI 2013. I was developing for SSIS 2014, so this means...
2015-08-11
1,043 reads
Compressing Encrypted Backups
A common requirement, whether it be based out of pure want or truly out of necessity, is to make a large database backup file, that is encrypted, be much...
2015-08-11
13 reads
Compressing Encrypted Backups
A common requirement, whether it be based out of pure want or truly out of necessity, is to make a...
2015-08-11
3,347 reads
Replace Blank Values to NULL in SSIS
Blank values are annoying, anywhere and everywhere. If your source system contains them, here’s how to convert blank values to NULL in...
2015-08-11
15,703 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