SQL server Encryption – Transparent Data Encryption
In the previous blogs we saw the use of certificates to encapsulate symmetric keys. How it benefits the user by...
2015-10-13
572 reads
A tSQLt Mistake – Debugging a Test
While I was working on a test the other day, it kept failing. Not a big surprise, but I couldn’t...
2015-10-12
439 reads
A tSQLt Mistake – Debugging a Test
While I was working on a test the other day, it kept failing. Not a big surprise, but I couldn’t...
2015-10-12
751 reads
Attending PASS Summit? Take a great Tuesday precon!
We’re just two weeks away from the PASS Summit in Seattle, and there is most definitely still time to get...
2015-10-12
615 reads
Argenis Without Borders: Fun For a Good Cause
This is the second year of Argenis Without Borders and the second year that I’m taking part. Last year we...
2015-10-12
525 reads
Thank You for Attending my #SQLSatOrlando Session! Slides, Resources, Recording
SQL Saturday #442 in Orlando, FL has come and gone but what a turn out! The event was excellent, we...
2015-10-12
477 reads
Simplified Session Backups
I have demonstrated how to backup a deployed session to a script previously. In this article I demonstrate how to create Simplified Session Backups.
Related Posts:
PowerShell to Backup XE Session...
2015-10-12
12 reads
Simplified Session Backups
PowerShell exposes scads of information and provides the professional with a formidable tool for the tool-belt. Over the past several...
2015-10-12
484 reads
How to create a database on a network share
If for any reason you need to place the database on a network share and by default this option is off you can follow the way described below: A...
2015-10-12
34 reads
How to create a database on a network share
If for any reason you need to place the database on a network share and by default this option is off you can follow the way described below: A...
2015-10-12
39 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