Daily Coping 23 Mar 2023
Today’s coping tip is to focus your attention on the good things you take for granted. My life is great. I used to say perfect, but a few struggles...
2023-03-23
16 reads
The Voice of the DBA
Converting Types in C#
I am not a great software developer. I’m OK, and I do know how to use Google and Stack Overflow well. Maybe my best skill is wording searches well?...
2023-04-07 (first published: 2023-03-22)
291 reads
Daily Coping 22 Mar 2023
Today’s coping tip is to appreciate your hands and all the things they do for you. I make a living with my hands. I type constantly, which is a...
2023-03-22
14 reads
Daily Coping 21 Mar 2023
Today’s coping tip is to listen to a piece of music without doing anything else. This is surprisingly hard. I turn something on, but then I look around, think...
2023-03-21
25 reads
Daily Coping 20 Mar 2023
Today’s coping tip is to get outside and notice how the weather feels. This was a good tip to see before my trip last week to the UK. I...
2023-03-20
21 reads
Enjoying SQL Bits
It’s been a good week at SQL Bits. This is my favorite conference, and the organizers go out of their way to make it a fun and sustainable event....
2023-03-20
26 reads
Blogging for the Tech Professional PowerPoint
Thanks to everyone that came to my talk at SQL Bits. Powerpoint here for download. If you have questions, reach out.
2023-03-19 (first published: 2023-03-18)
29 reads
Daily Coping 17 Mar 2023
Today’s coping tip is to eat mindfully. Appreciate the taste, texture, and smell of your food. I am not a big foodie. I’ve been to some cool dinners with...
2023-03-17
19 reads
Daily Coping 16 Mar 2023
Today’s coping tip is to take three calm breaths at regular intervals during the day. I had to travel recently, crossing time zones and moving between planes, trains, and...
2023-03-16
20 reads
Daily Coping 15 Mar 2023
Today’s coping tip is to slow down if you find yourself rushing too often. The modern world encourages rushing around. We try to do so many things, get to...
2023-03-15
27 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