Do you read my blog? Would you like to save money on Azure Data Factory and SSIS training (from me!) for a full year? For a limited time, you can save $4,000 (67%) on my Live ADF and SSIS Class Season Pass! Visit Enterprise Data & Analytics Training to view upcoming public course deliveries and …
Continue reading My Black Friday 2020 Sale is On!
Author:Andy Leonard
Christian, husband, dad, grandpa, Data Philosopher, Data Engineer; Azure Data Factory, Fabric Data Factory, and SSIS guy; and farmer. I was cloud before cloud was cool. :{>
Twenty years of watching SSIS catalog drift, environment mismatches, and deployment chaos finally has a name: Data Integration Lifecycle Management. I build tools for it at DILM Suite. Start with SSIS Catalog Compare.
One Reason to Avoid SSISDB Backup and Restore
First, please do not misunderstand. You should back up SSISDB just like you back up all other databases – especially in Production. You should also conduct Disaster Recovery exercises in which you restore SSISDB from the latest backup, or avail yourself of Always On availability groups and / or Windows Server Failover Clustering. To demonstrate …
Continue reading One Reason to Avoid SSISDB Backup and Restore
Buy the Live Season Pass 01-14 Nov and Save
It’s that time of year again: Enterprise Data & Analytics kicks off the Black Friday Training Sale 13 Nov 2020 with a substantial discount – for two weeks only, 01-14 Nov 2020 – on our Live Season Pass. Sign up for the Live Season Pass and attend my SSIS and ADF training course deliveries for …
Continue reading Buy the Live Season Pass 01-14 Nov and Save
Kicking Off Data Driven Podcast Season 4 with Rick Hall!
Frank and me are honored to announce Data Driven, Season 4, led by an awesome interview with (THE) Rick Hall! Enjoy! :{>
View Azure Blob Storage Containers in SSMS
SQL Server Management Studio – SSMS – supports viewing the contents of Azure Blob Storage containers. Connect to a Azure Blob Storage Container To connect, open the latest version of SSMS, open Object Explorer, and click the Connect dropdown in the Object Explorer menu: Select “Azure Storage…” to start the connection process. The Connect to …
Continue reading View Azure Blob Storage Containers in SSMS
Regarding Amazon Reviews
In a scene in History of the World, Part 1, Mel Brooks portrays a caveman painting and describes the scene as the “first artist.” He follows this scene with a non-flattering comment about the first art critic. Since the movie, made in 1981, is not longer appropriate (truth be told, it probably was inappropriate in …
Continue reading Regarding Amazon Reviews
SQL Server Data Automation Through Frameworks is Available!
Kent Bradshaw and I are excited and honored to announce the release of our latest book, SQL Server Data Automation Through Frameworks: Building Metadata-Driven Frameworks with T-SQL, SSIS, and Azure Data Factory! Enjoy! :{> Need Help? Enterprise Data & Analytics delivers private training, can join your team to help implement your enterprise data warehouse solution, …
Continue reading SQL Server Data Automation Through Frameworks is Available!
Andy’s Black Friday Training Sale is Coming…
Next week, Enterprise Data & Analytics kicks off the Black Friday Training Sale! This year’s sale begins 1 Nov 2020 with a substantial discount on our Live Season Pass (attend my SSIS and ADF training course deliveries for a full year) for two weeks only! The Enterprise Data & Analytics Black Friday ends 13 Dec 2020. …
Continue reading Andy’s Black Friday Training Sale is Coming…
Azure-SSIS Catalog Database Connection Failed
I was provisioning a new Azure Data Factory (ADF) Azure-SSIS Integration Runtime (IR) to conduct some testing and, when I clicked the “Test connection” link, I got a Connection failed error as shown in the red box: I clicked the “More” link to display details in the blue box To provision new Integration Runtime, Azure …
Continue reading Azure-SSIS Catalog Database Connection Failed
Azure Data Factory and SSIS Training 2020-Q4
Join me 16-19 Nov 2020 for four days of SQL Server Integration Services (SSIS) training! Days 1 and 2 focus on development using real-world data (I love AdventureWorks for demos, but real-world data is never that clean). Students complete 10 labs on days 1 and 2 and get to play the game What Will SSIS …
Continue reading Azure Data Factory and SSIS Training 2020-Q4