Since publishing my last blog post about Azure Data Factory including my Azure tenant’s tenantId and principalId in its commits to git and how to…
Author: Deirdre O'Leary
Aim: To remove sensitive strings, such as hard-coded credentials or IDs, from the history of a git repo. This blog post has come about as…
My answer to this month’s T-SQL Tuesday topic is rather dependent on my workplace. So long as the database code is covered by version control…
Last year I wrote about the formats of connection strings that can be stored in Azure Key Vault & then used by Data Factory, &…
This month’s T-SQL Tuesday caught my eye & started me thinking about my favourite question from the candidate’s perspective. (Note: I really don’t like the…
In the past week, I’ve moved my blog from wordpress.com to a new (though somewhat familiar) domain here at therightjoin.com. The blog move has been…
Aim: To utilise Azure Data Factory’s “Auto create table” feature to temporarily store data as part of an ETL pipeline. There are some situations where…
As I explore Data Factory, I’ve started to compile a list of lessons learned. Some things that may trip up a new user of the…
Using Azure Data Factory & Azure Key Vault, I connect to a few core databases (usually Azure SQL Database & traditional SQL Server instances) &…
Aim: To restore a Long-Term Retention (LTR) backup of an Azure SQL Database after the associated SQL Server has been deleted. Microsoft’s documentation states that…