Select All in a Power BI Slicer–#SQLNewBlogger
One of the things I’ve been working on this year is a Power BI report for the kids I coaco in volleyball. As a part of this, I want...
2022-11-25 (first published: 2022-11-09)
258 reads
The Voice of the DBA
Daily Coping 9 Nov 2022
Today’s coping tip is to make time for a friend and have a coffee, meal, or just spend time. It’s been a busy few months for me. Since Sept...
2022-11-09
29 reads
T-SQL Tuesday #156–Ready for Production
It’s a busy time for me, but it’s also T-SQL Tuesday blog party day. I’m rushing a bit as I forgot about this (thanks for the reminder, Deb) and...
2022-11-08
30 reads
Deciding to Submit to Conferences–#NewStarNovember
I wrote about getting started last week, with invitations from others. I think the first time I actually made my own submission was to the Indy Tech Fest in...
2022-11-08
40 reads
Daily Coping 8 Nov 2022
Today’s coping tip is to set a goal that brings a sense of purpose for the coming month. For me, I’m going away from primary work to secondary work....
2022-11-08
27 reads
Data Manipulation with Word and Excel
Recently I had to go through some training that asked me to evaluate some text. I needed to tally some data up, and decided Word and Excel were quick...
2022-11-18 (first published: 2022-11-07)
430 reads
Daily Coping 7 Nov 2022
Today’s coping tip is to identify three things that give you hope for the future. The creativity and passion of youth The drive from many people who build software...
2022-11-07
39 reads
Goal Progress for Oct 2022
I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2022. Another month of busy stuff. Prepping for the Data Community...
2022-11-04
32 reads
The Way0utwest Joker #SeattleSummitMoments
I work for Redgate, who has been a great sponsor of the Summit in the past and now is charged with stewarding the event into the future. This post...
2022-11-04
29 reads
Daily Coping 4 Nov 2022
Today’s coping tip is to plan a fun or exciting activity to look forward to. I almost shouldn’t do this much, since I’ve had a great year with plenty...
2022-11-04
25 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