The new SQL Server Management Studio
Ok, so this is old news I know, but I’ve had a busy couple of months and am only getting...
2016-07-20
1,387 reads
The DBA Who Came In From The Cold
Setting up powershell remote sessions
Hey guys, differing from usual this is a quick post on setting up powershell remote sessions. I know you can...
2016-05-02 (first published: 2016-04-22)
1,918 reads
SQL 2016 – Dynamic Data Masking
One of the new features that’s coming with SQL Server 2016 is Dynamic Data Masking. DDM is designed to allow...
2016-04-22 (first published: 2016-04-13)
2,155 reads
Tools of the trade
I’ve been meaning to write this post for a while now, nice and simple, just want to list the tools...
2016-04-06
531 reads
Update to TRUNCATE TABLE in SQL 2016 (partition support)
Continuing my obsession with partitioning I thought I’d write this quick post about a cool change in SQL Server 2016.
This...
2016-04-12 (first published: 2016-03-29)
2,805 reads
Partitioning and filegroup restores
I’ve been playing around with partitioning quite a lot recently and wanted to write a quick post about how it...
2016-04-05 (first published: 2016-03-24)
1,764 reads
First foray into presenting
It’s been a while since I’ve posted as the run up to Xmas last year and this January have been...
2016-01-29
793 reads
Pass 2015 – Overall Thoughts
I know I only posted one other blog about Pass but I’ve been way too busy over the last couple...
2015-11-01
333 reads
Pass 2015 – First Impressions
It’s Pass 2015 this week and I’m attending (seriously I’m unbelievably chuffed)! As they’ll be a shedload of blogs about...
2015-10-27
514 reads
Pass 2015 – First Impressions
It’s Pass 2015 this week and I’m attending (seriously I’m unbelievably chuffed)! As they’ll be a shedload of blogs about...
2015-10-27
297 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