Azure Storage Replication Types

Storage Accounts are pretty much integrated into so many different designs in Azure, whether you are using Azure Synapse, 3rd party product like Snowflake, or Event Streaming designs –...

Daily Coping 15 Jun 2022

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

Populating PostgreSQL JSONB column using Azure Data Factory Data Flow

(2022-May-31) 
Personal notes of one of the recent ADF JSON pipeline development to remember how to use it next time.
Requirements:

Sourcing data comes from a SQL Server database
The destination is a...

T-SQL Tuesday #151 Coding Standards

This month the T-SQL Tuesday blog party is hosted by my good friend, Mala. This is her fourth time hosting and she has a good topic this time. While...

Using a Regular Expression to Detect a Number–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Here are some hints to get started. I...

Coding Standards (T-SQL Tuesday #151)

Foreword
This month’s invitation is from Mala Mahadevan, and it’s about coding standards. Fortunately, I may forget several basic ones because my team probably eradicated them long ago.
I’ll go with...

Daily Coping 14 Jun 2022

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

Too many coding standards : T-SQL Tuesday #151

One of my favorite people, Malathi Mahadevan (blog|twitter), is our host this month and she’d like to talk about coding ... Continue reading

T-SQL Tuesday 151: T-SQL Coding Standards

It’s that time of the month again, the blog party, woohoo! This time Mala Mahadevan (b | t) has invited us to blog about our T-SQL coding standards. I...

Who is Updating That Table? – SQL Audit

I had a problem at work recently where a record was getting updated, and no one knew where or what was updating the record.  Our team discussed the best...