Reusing a Recordset in an SSIS Object Variable

A few years back, I wrote a blog post about using an SSIS object variable as a data flow source. In that post, I described how you could load...

Announcing: AWS Community Builders

I’m excited to be able to announce that the AWS Community Builders, a new program for those who help out with AWS technologies, has been launched. You can read...

[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...

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...

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...

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 =...

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...

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...

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...

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...