Enjoy this recording of a free webinar titled Overcome Challenges of Lifting and Shifting SSIS to Azure! In this webinar, I demonstrated challenges of scripting SSIS Catalog Environments, Environment Variables, References, Reference Mappings, and Literals for deployment to another SSIS Catalog. These challenges are particularly troublesome when practicing Lifecycle Management or DevOps with SQL Server …
Continue reading Overcome Challenges of Lifting and Shifting SSIS to Azure
Category:DevOps
SSIS Is Not Dead (Or Dying)
A few weeks ago I began hearing a rumor that SSIS had a couple years of life remaining. “In two years or so,” according to the rumor, “SSIS will die and be replaced with Azure Data Factory.” Is Microsoft capable of such a move; deprecating a technology? Yep. Remember SQL Server Notification Services? I can …
Continue reading SSIS Is Not Dead (Or Dying)
Regarding SSIS Frameworks, Part 1 – Execution
Why Use a Framework? The first answer is, “Maybe you don’t need or want to use a framework.” If your enterprise data integration consists of a small number of SSIS packages, a framework could be an extra layer of hassle metadata management for you that, frankly, you can live without. We will unpack this in …
Continue reading Regarding SSIS Frameworks, Part 1 – Execution
Mean Time to Identify Failure
While managing a team of 40 ETL developers, I wanted to track lots of metrics. Some of the things I wanted to track were technical, like SSIS package execution times. Some metrics were people-centric. Andy’s First Rule of Statistics states: You can use statistics for anything about people, except people. Andy – circa 2005 It was …
Continue reading Mean Time to Identify Failure
Delivering Intelligent Data Integration through SSIS in Dallas 31 May 2019!
I am honored to announce I will be delivering Intelligent Data Integration through SSIS – a day-long SQL Saturday 841 – Dallas pre-conference session 31 May 2019! Description: What is Intelligent Data Integration? SSIS (SQL Server Integration Services) packages developed using tried and true design patterns, built to participate in a DevOps enterprise practicing DILM (Data …
Continue reading Delivering Intelligent Data Integration through SSIS in Dallas 31 May 2019!
Lift and Shift is Not a Strategy…
Lift and shift is a bridge. If your enterprise is considering migrating enterprise data and data integration workloads from on-premises to the cloud, lifting and shifting is not the end of the story. Lifting and shifting is, rather, the mechanism – the conversion project – that positions your enterprise to leverage the economies of scale …
Continue reading Lift and Shift is Not a Strategy…
Enterprise Data & Analytics Welcomes Shannon Lowder!
I am honored and thrilled to welcome Shannon Lowder (@shannonlowder | blog | LinkedIn) to the Enterprise Data & Analytics team! Shannon is a data engineer, data scientist, BimlHero (though not listed on the page at the time of this writing), and shepherd of the Biml Interrogator open source project. If you use Biml to generate SSIS …
Continue reading Enterprise Data & Analytics Welcomes Shannon Lowder!
Join me For Expert SSIS Training!
I’m honored to announce Expert SSIS – a course from Enterprise Data & Analytics! The next delivery is 01-02 Apr 2019, 9:00 AM – 4:30 PM ET. Data integration is the foundation of data science, business intelligence, and enterprise data warehousing. This instructor-led training class is specifically designed for SQL Server Integration Services (SSIS) professionals …
Continue reading Join me For Expert SSIS Training!
The 2:00 AM Test
I’m working with a collection of clients these days providing data integration, cloud, and DevOps advice. I love architecture work! My clients love the results. Everyone wins. Kent Bradshaw and I are tag-teaming with a couple clients who are converting data integration from other platforms to SSIS. In a recent meeting Kent mentioned “the 2:00 …
Continue reading The 2:00 AM Test
Two (or More) Kinds of Developers
I’ve made statements about “two kinds of developers” for years. These statements are false inasmuch as all generalizations are false. The statements are not designed to be truisms. They are designed to make people think. Last week – while presenting a full-day pre-conference session at the PASS Summit 2018 and again when delivering a session …
Continue reading Two (or More) Kinds of Developers