Presenting A Day of Azure Data Factory at the PASS Data Community Summit 2022!

I am honored to deliver a full day pre-conference session at the PASS Data Community Summit 2022! My precon is titled “A Day of Azure Data Factory.” Register today! Abstract In this session we provision an Azure Data Factory (ADF) and demonstrate many uses for ADF in the modern data enterprise, including: – Version control …
Continue reading Presenting A Day of Azure Data Factory at the PASS Data Community Summit 2022!

After Azure Subscription Disabled, Restart ADF Triggers

A couple / three days after delivering the April 2022 edition of Master the Fundamentals of Azure Data Factory (the next delivery is 20 May 2022 – check out Enterprise Data & Analytics Training to register and save money!), I got an email from Azure informing me my account had been disabled because I reached …
Continue reading After Azure Subscription Disabled, Restart ADF Triggers

Documenting an SSIS Lift and Shift Project

I was honored to work on a cool SSIS lift and shift project in 2021. I will not mention project details or the client. I will share that I’ve worked with the team before and that they are awesome and talented and easy to work for (and with). The company is large. Like international-large. I, …
Continue reading Documenting an SSIS Lift and Shift Project

AndyStream for 8 Nov 2021

Frank and I are on Day 6 of 1,000 days, a new thing we started 02 Nov 2021 to remind us time is not fungible and we should build – and stick to – atomic habits and systems of execution. This morning I popped on for a few minutes to share information about the PASS …
Continue reading AndyStream for 8 Nov 2021

One Way to Create a Parquet File from SQL Server Data

Yesterday I was coding away, deep into using C# to decompress and parse Excel XML so I could read data from a specific worksheet in a workbook on a server without Excel objects installed, when I saw the following on Twitter: For those of you who do not already know… I Don’t Switch Contexts Well I …
Continue reading One Way to Create a Parquet File from SQL Server Data

An ADF Azure-SSIS Framework

I spent a little time walking through the third section of the book SQL Server Data Automation Through Frameworks: Building Metadata-Driven Frameworks with T-SQL, SSIS, and Azure Data Factory co-authored by (the) Kent Bradshaw and me. At the start of Part 1, I included thoughts about our first review. Part 1 did not go as planned. …
Continue reading An ADF Azure-SSIS Framework

Getting Started With ADF (Azure Data Factory)

Here’s a sample of a live stream I recorded today about Getting Started with ADF (Azure Data Factory)! You can view the full video here. Be sure to click Follow to be alerted when I stream live! :{> Need Help With ETL or Your Enterprise Data Warehouse? At Enterprise Data & Analytics, we believe you should ask …
Continue reading Getting Started With ADF (Azure Data Factory)