SQL Server, Azure SQL Database, Azure SQL Data Warehouse, Azure Data Factory V2, Linked Services Azure Data Factory v2 Parameter Passing: Linked Services Sometimes I get so involved in my repeatable processes and project management that I forget to look up. Such is the case of [...] Delora Bradish June 5, 2019
Azure, Data Analytics, Azure Data Factory, Azure Data Lake Technical Tips for a Successful Azure Data and Analytic Implementation This is my second attempt to articulate lessons learned from a recent global Azure implementation for data and analytics. My [...] Delora Bradish May 24, 2019
Azure, Business Intelligence Tips for a Successful Azure for BI Implementation I have been on a long term Azure for BI implementation and took some time today for a "what went right", "what went wrong" [...] Delora Bradish April 19, 2019
Azure, Power BI, Business Intelligence, Azure Databricks, Azure Data Architecture Data Architecture for Azure BI Programs A Bit of Intro If I recall correctly, I completed the first version of this data architecture diagram in 2012 when we used [...] Delora Bradish January 31, 2019
Azure, SSIS, HDInsight, Azure Data Factory, Business Intelligence, Azure Databricks, Azure Data Lake, Azure Data Architecture Transitioning from Traditional to Azure Data Architectures Confession: I put a lot of subtexts in this blog post in an attempt to catch how people may be describing their move from [...] Delora Bradish January 4, 2019
Azure Every Day, Azure SQL Database, Azure Data Week, Elastic Query Azure SQL Database Elastic Query Just a note that our Azure Every Day posts this week will be stepping away from our normal posts as our regular bloggers are [...] Delora Bradish October 11, 2018
Azure Data Factory V2, ADFv2, Parameter Passing Azure Data Factory v2 Parameter Passing Summary of the Matter: Parameter passing in ADFv2 had a slight change in the summer of 2018. Microsoft modified how [...] Delora Bradish October 5, 2018
SSIS, Slowly Changing Dimensions Easily Handle Transform and Load of SCD2 (Type 2 Slowly Changing Dimensions) This blog post is about type two slowly changing dimensions (SCD2). This is when an attribute change in row 1 results in [...] Delora Bradish October 20, 2017