Both, Azure Data Factory and Azure Databricks offer transformations at scale when it comes to ELT processing. On top of that, ADF allows you to orchestrate the whole solution...
2021-02-04
7 reads
Azure Data Factory is a fantastic tool which allows you to orchestrate ETL/ELT processes at scale. This post is NOT about what Azure Data Factory is, neither how to...
2021-01-15
4 reads
Introduction Alex is a Data Platform MVP who loves DevOps. He’s has been helping data professionals apply DevOps principles to relational database development and deployment since 2010. He’s most...
2020-12-18
22 reads
Introduction Alex is a Data Platform MVP who loves DevOps. He’s has been helping data professionals apply DevOps principles to relational database development and deployment since 2010. He’s most...
2020-11-04 (first published: 2020-10-30)
130 reads
Introduction Alex is a Data Platform MVP who loves DevOps. He’s has been helping data professionals apply DevOps principles to relational database development and deployment since 2010. He’s most...
2020-10-30
5 reads
Press ADF Release Notes 07/31/2020 I believe this is the first Release Notes from ADF Team. Working with Git repositories in Azure Pipelines Multi-repository access and more. DevOps for...
2020-08-02
14 reads
Press Azure resource providers operations List of all of the available ADF-specific RBAC permissions. Simplifying declarative deployments in Azure The power of What-If within ARM Template deployments. Collecting custom...
2020-07-12
39 reads
Struggling with #ADF deployment? adf_publish branch doesn’t suit your purposes? Don’t have skills with PowerShell? I have good news for you. There is a new tool in the market. It’s a task for...
2020-07-07
14 reads
Introduction Jennifer Stirrup is a data strategist and technologist, Microsoft Data Platform Most Valuable Professional (MVP), Microsoft Regional Director, Microsoft Certified Trainer, founder of Data Relish Ltd, diversity and...
2020-07-02
72 reads
Press ExpandString in Powershell This function can do much more than you think. Pester – using -should -throw Useful example when you want to filter output by ExceptionType or ErrorId....
2020-06-28
7 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
Comments posted to this topic are about the item Stairway to Snowflake Level 5...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers