Community recognition
On the first day of January 2017, I was honoured to receive an email naming me as a Microsoft MVP...
2018-07-04
315 reads
Blog Posts
My Speaking Schedule
I have quite a few speaking engagements coming up. Rather than an intermittent blog post, I’ve decided to have a...
2018-07-04 (first published: 2018-06-25)
1,654 reads
SQL Puzzle – FizzBuzz3d
I thought for the end of the month it would be fun to do another T-SQL Puzzle. In this case...
2018-07-04 (first published: 2018-06-27)
2,174 reads
Updating VSTS to SQL Change Automation
We (Redgate) released SQL Change Automation a few weeks back. This is the first stage to implementing a combined toolset...
2018-07-04
1,004 reads
Alter Multiple Databases at Once
This is a quick and dirty method I often use when I want to make a change to multiple databases...
2018-07-03 (first published: 2018-06-26)
2,520 reads
Building Better Test Data on the Redgate Hub
I have a new piece published over at the Redgate Hub: Building Better Test Data with SQL Provision. Part of...
2018-07-03
850 reads
Code You Would Hate To Live Without (T-SQL Tuesday #104 Invitation)
The recent news about Microsoft acquiring GitHub has me thinking about how amazing it is for us to be part of today's online code community.
Before modern online programming communities,...
2018-07-03
5 reads
Code You Would Hate To Live Without (T-SQL Tuesday #104 Invitation)
The recent news about Microsoft acquiring GitHub has me thinking about how amazing it is for us to be part of today's online code community.
Before modern online programming communities,...
2018-07-03
9 reads
Code You Would Hate To Live Without (T-SQL Tuesday #104 Invitation)
The recent news about Microsoft acquiring GitHub has me thinking about how amazing it is for us to be part...
2018-07-03
269 reads
Half-year round-up
So, to do the name “blog” justice, I should post something every now and then. Alright, here you go, let...
2018-07-03
292 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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