I was honored to deliver Azure DevOps and the SSIS Development Lifecycle at 12:00 PM EDT 18 Aug 2020. This is a condensed version of a larger presentation that goes by the same name. This version lasted about 20 minutes and is packed with information about basic build automation using Azure Pipelines with SSIS. I …
Continue reading Azure DevOps and the SSIS Development Lifecycle on LinkedIn Live
Category:SSIS
Free! Azure DevOps and the SSIS Development Lifecycle Presentation
I’m excited to deliver Azure DevOps and the SSIS Development Lifecycle at 12:00 PM EDT Tuesday, 18 Aug 2020! This time, though, I am trying something new – LinkedIn Live! That means there’s no registration and no sign-up. Just show up at LinkedIn and attend. I’m not sure if you need to be following me on …
Continue reading Free! Azure DevOps and the SSIS Development Lifecycle Presentation
Free Webinar – Updates to the SSIS Framework
Join me 30 Jul 2020 at 12:00 PM EDT for Updates to the SSIS Framework! The recording for this presentation is available here. “I cover a really good example in the webinar. “ My favorite new feature is Application Package Property Overrides. I can hear you thinking, “What are Application Package Property Overrides, Andy?” I’m …
Continue reading Free Webinar – Updates to the SSIS Framework
Learn SSIS Data Flows and Azure Data Factory in August 2020!
I recently added two online training deliveries for August 2020: 10-11 Aug 2020: SSIS Data Flows 12 Aug 2020: Master the Fundamentals of Azure Data Factory SSIS Data Flows is a two-day, online, live course designed to jumpstart SSIS developers who want to learn SSIS and those who desire to fill gaps in their self-taught …
Continue reading Learn SSIS Data Flows and Azure Data Factory in August 2020!
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!
The Recording of Configuring and Managing ADF Azure-SSIS Integration Runtimes is Available
Enjoy this recording of Configuring and Managing ADF Azure-SSIS Integration Runtimes! <ShamelessPlug> Need Help Getting Started with ADF? Enterprise Data & Analytics specializes in helping enterprises modernize their data engineering by lifting and shifting SSIS from on-premises to the cloud. Our experienced engineers grok enterprises of all sizes. We’ve done the hard work for large and challenging data engineering enterprises. …
Continue reading The Recording of Configuring and Managing ADF Azure-SSIS Integration Runtimes is Available
Integration Services Extension for VS 2019 v3.8 Released
The Integration Services v3.8 extension for VS 2019 has been released! From the SQL Server Integration Services Projects page: <ShamelessPlug> Need Help Getting Started with SSIS? Enterprise Data & Analytics specializes in helping enterprises kickstart or complete Enterprise Data Warehouse projects – whether on-premises or in the cloud. Our experienced engineers grok enterprises of all …
Continue reading Integration Services Extension for VS 2019 v3.8 Released
Four Questions to Ask When Hiring an Enterprise Data Consultant
It’s time to hire a consultant for your enterprise data project. That is awesome news, but a quick search for the perfect consultancy reveals a number of options (and hourly rates). What’s a CEO, CIO, CFO, VP, or Director to do? How do you choose a consultant with the right experience for your enterprise data …
Continue reading Four Questions to Ask When Hiring an Enterprise Data Consultant
Integration Services Extension for VS 2019 v3.7 Update
The SQL Server Integration Services Projects extension for Visual Studio 2019 was updated 20 Apr 2020. There are also recent updates to Microsoft® OLE DB Driver 18 for SQL Server® and the GitHub Extension for Visual Studio. Happy coding! :{>
The SSIS Catalog and SCCPAC Files
The SSIS Catalog is a pretty cool SSIS framework, whether installed on-premises or in the cloud (Azure-SSIS). Practicing lifecycle management with the SSIS Catalog can be… challenging. Try scripting an existing SSIS Catalog Environment after creation, for example: The result? Sad trombone… SCCPAC Files to the Rescue! SSIS Catalog Compare Enterprise Edition includes SCCPAC file …
Continue reading The SSIS Catalog and SCCPAC Files