Backups – They Are Needed, Who Knew?
Backups are essential for a successful business model. That statement may or may spark some topics for debate, but at...
2015-04-06 (first published: 2015-03-30)
7,143 reads
The SQL Professor
Impact Series – Part 2
It’s that time again to add another impact player to the roster; this time for the month of February.
This month...
2015-02-27
953 reads
Impact Series – Part 2
It’s that time again to add another impact player to the roster; this time for the month of February.
This month...
2015-02-27
750 reads
Q and A With SQL MVP Chris Shaw
This has been a long time in the making, back in 2011 I attended a session at PASS Summit by...
2015-02-17
963 reads
TSQL Tuesday #63 – Security
This months T-SQL Tuesday is hosted by none other than Kenneth Fisher (B|T). His topic for this month revolves around...
2015-02-12
571 reads
Friends Of Red Gate 2015
I’m excited that I’ve been asked to be back involved for another year in the Friends of Red Gate program. This...
2015-01-27
524 reads
Impact Player Series – Part 1
I wanted to start this series in regards to impact players that go above and beyond in the SQL Community....
2015-01-26
584 reads
A Healthy SQL Server
T-SQL Tuesday has come and gone and I missed the boat due to some ongoing work constraints. With that said...
2015-01-19
565 reads
Impact Players – SQL Style
Awhile back I did a post on my Fab Five – was one of my favorite ones I’ve done to date...
2015-01-12
443 reads
Reports In SSISDB
I was approached with an in shop issue where a group could not view the execution reports in the SSISDB....
2015-01-09 (first published: 2015-01-07)
10,799 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