[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)
311 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
14 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)
741 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,261 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)
293 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
29 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
22 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
803 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
11 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
12 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
Return all intermediate members of a recursive CTE?
I wrote a recursive CTE to determine employee levels... but what if I wanted...
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers