I delivered Master the Fundamentals of Azure Data Factory earlier this week and, as always, it was a blast! My disclaimer slide proved accurate, once again. Anyone who works in Azure groks the maxim: Change happens. Managing Bucks Cost management in Azure is important. No one wants to wake up to a larger-than-expected bill at …
Continue reading Azure Resource Groups Save Money
Category:Azure
SQL Server Data Automation through Frameworks Book Available for Pre-Order
Although the cover image needs an update, my and Kent Bradshaw’s next book – titled “SQL Server Data Automation through Frameworks: Building Metadata-driven Frameworks with T-SQL, SSIS, and Azure Data Factory” is available for pre-order!
In 2020, Two Full Training Days, Two Continents
It dawned on me that I am honored to deliver two full-day conference training presentations in early 2020 on two continents! At the Difinity 2020 conference in Auckland New Zealand, Sandy Winarko and I are co-presenting Intelligent Data Integration with SSIS and Azure Data Factory 20 Feb 2020. Sandy is Principal Program Manager – Azure …
Continue reading In 2020, Two Full Training Days, Two Continents
Honored to Present From Zero to ADF at SQLBits 2020 in London!
Honored to Present From Zero to ADF at SQLBits 2020 in London 1 Apr 2020! When I look at this list of SQLBits Training Day presenters, I think, “Wow! That’s a lot of really smart people… plus me!” Registration is open now. Register today! :{>
PASS Summit 2019, Coming Down
During the PASS Summit 2019, Frank and I worked hard to deliver several DataDriven *DataPoint*’s.Here’s a list: *DataPoint* Andy is on the Way to Seattle for PASS 2019 *DataPoint* Andy Arrives at PASS 2019 *DataPoint* PASS 2019 Welcome Reception *DataPoint* Hanging Out with #SQLGeeks at PASS 2019 *DataPoint* Andy Speaks with SentryOne CEO Bob Potter …
Continue reading PASS Summit 2019, Coming Down
PASS Summit 2019 Presentations
SSIS DevOps and Azure Containers I am preparing for an exciting week in Seattle! This year I have the honor of co-presenting SSIS DevOps and Azure Containers with Elizabeth Baron and Sreeja Pullagura, two (really) smart architects who work together at Teach For America – an awesome non-profit in New York. Catch us Wednesday, 6 …
Continue reading PASS Summit 2019 Presentations
PowerShell and Azure: AzureRM vs. Az
Earlier this year Microsoft announced the new Azure PowerShell Az Module. I recently encountered the following reminder when doing research: The part that caught my attention is: You can still use the AzureRM module, which will continue to receive bug fixes until at least December 2020. from https://docs.microsoft.com/en-us/azure/storage/blobs/storage-quickstart-blobs-powershell#prerequisites Consider this a 13-month heads-up… :{>
Embed an SSIS Package in an Azure Data Factory Pipeline
The Azure-SSIS Team has done it again; they’ve added more cool SSIS execution functionality to Azure Data Factory! Execute SSIS Package Activity Update First, add an Execute SSIS Package Activity in an Azure Data Factory pipeline. On Settings, select an Azure-SSIS Integration Runtime. Set Package Location to “Embedded package”: The Execute SSIS Package activity’s properties …
Continue reading Embed an SSIS Package in an Azure Data Factory Pipeline
Learn Azure Part 0 – Create an Azure Account
If you are interested in learning Azure, cool! I am here to help.™ Let’s begin by thinking about this journey accurately: Azure is not easy. Azure is not simple. Learning Azure will take time. You will experience frustration. Sounds awesome, right?! The preceding list is the bad news. There is good news, though: If learning …
Continue reading Learn Azure Part 0 – Create an Azure Account
Presenting Moving Data with ADF at TriPASS 20 Aug
I am honored to deliver Moving Data with ADF to the Triangle SQL Server Users Group (TriPASS) 20 Aug 2019 starting at 6:00 PM EDT! This event will be streamed live via Twitch. Abstract Azure Data Factory – ADF – is a cloud data engineering solution. ADF version 2 sports a snappy web GUI (graphical …
Continue reading Presenting Moving Data with ADF at TriPASS 20 Aug