[Coping] The Five Minute Journal
Reading Steve Jones’ posts about daily coping and seeing how it has affected me in a positive way, I’ve decided to share some of the things I’ve done to...
2020-08-14 (first published: 2020-07-30)
317 reads
Daily Coping 30 Jul 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-07-30
22 reads
Things That Shouldn’t Be Normal in Database Development (28 minute video/podcast episode)
Many people use entrenched processes for database development that have been in place so long that it’s hard to imagine doing it any other way. In this episode, I...
2020-08-11 (first published: 2020-07-30)
748 reads
How to Iterate Through A List of Objects with Terraform's for_each function
What I want to do
# create file local.users.yml
user:
- name: foobar1
email: foobar1@foobar.com
- name: foobar2
email: foobar2@foobar.com
- name: foobar3
email: foobar3@foobar.com
locals {
users_file = "local.users.yml"
users_file_content =...
2020-08-10 (first published: 2020-07-29)
6,268 reads
Adding a FK to a Table–#SQLNewblogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One thing that helps ensure your data is...
2020-08-07 (first published: 2020-07-29)
304 reads
I am speaking at the PASS Virtual Summit 2020
After being selected to present my full day pre-conference session at the Summit, I am very pleased to announce that I will also be presenting my Database Administration Through...
2020-07-29
35 reads
Daily Coping 29 Jul 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-07-29
28 reads
Notifying a Teams Channel of a SQL Agent Job result
Following on from yesterdays post about creating an overview of SQL Agent Job Results and sending it to a Teams channel, I was given another challenge Can you write...
2020-07-29
807 reads
Should I Transform My Data In My SQL Query?
Watch this week's video on YouTube
Imagine you need to join two tables of data and filter the results. Perhaps you also need to convert some of the values for...
2020-07-29
14 reads
Should I Transform My Data In My SQL Query?
Watch this week's video on YouTube
Imagine you need to join two tables of data and filter the results. Perhaps you also need to convert some of the values for...
2020-07-29
18 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
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