Daily Coping 31 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...

Generate SQL Server Role Member Reports using dbatools and ImportExcel PowerShell modules

This was initial posted on SQL Server Central articles. As one of dbatools' first members, I've been using it for years and it's really my goto tool. This task...

AWS Community Builders #AWSCommunity

I’m excited and happy to announce that I’m part of the AWS Community Builders.  Check out more on Twitter with the #AWScommunity tag. To learn more about the program...

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