Goals for 2023
This is the goal setting post for 2023. The previous ones were: 2022 2021 2020 2019 2018 As with previous years, I’ll break these into three categories: career, personal,...
2023-01-06
27 reads
The Voice of the DBA
Outlining Goals in 2023
Last year I set a bunch of goals, and I thought I did pretty good working on them. Not amazing, but pretty good. This year, I want to attack...
2023-01-06
24 reads
Daily Coping 6 Jan 2023
Today’s coping tip is to do something outdoors today. Enjoy nature. I’m writing this a few days ahead, so I’m using an activity I did over the weekend. The...
2023-01-06
26 reads
Daily Coping 5 Jan 2023
Today’s coping tip is to set aside a regular time for the next month for an activity you love . This is a big month for me, with coaching...
2023-01-05
35 reads
Installing Flyway Community on Windows
One of the things I’ve been trying to do is dig in more deeply to the Flyway command line (CLI) as part of my work with Redgate. While Flyway...
2023-01-13 (first published: 2023-01-04)
217 reads
Daily Coping 4 Jan 2023
Today’s coping tip is to share something helpful with a friend that you learned recently. I share a lot with my wife and kids. They are a big part...
2023-01-04
19 reads
Daily Coping 3 Jan 2023
Today’s coping tip is to use one of your strengths in a new or creative way. I have a lot of strengths. They’ve helped me to be successful. This...
2023-01-03
30 reads
Daily Coping 2 Jan 2023
Today’s coping tip is to start the new year off with something new – listen, watch, read something completely different. I started listening to more country music last year....
2023-01-02
28 reads
Goal Progress for Dec 2022
I set goals at the beginning of the year, and I’m tracking my progress in these updates during 2022. December is usually quiet, though this year I spent the...
2022-12-30
23 reads
Daily Coping 30 Dec 2022
Today’s coping tip is to give thanks. List the kind things others have done for you. I know that my life is great, but it’s because of a lot...
2022-12-30
33 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