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!
Category:SSIS
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
Want to Learn More About Azure Data Factory?
From me? I am honored to announce Fundamentals of Azure Data Factory – a course from Enterprise Data & Analytics! The next delivery is 04 Mar 2019, 9:00 AM – 4:30 PM ET. Azure Data Factory, or ADF, is an Azure PaaS (Platform-as-a-Service) that provides hybrid data integration at global scale. Use ADF to build …
Continue reading Want to Learn More About Azure Data Factory?
How May I Serve You?
2018 is drawing to a close. Some readers recently shared requests for more blog posts on certain topics. I thought I’d put the question to my audience (both of you, hi Mom!) to gather your thoughts. Feel free to leave a comment or reach out via email. Here are some topics I plan to blog …
Continue reading How May I Serve You?
SSIS, Docker, and Windows Containers, Part 0 – Getting Started
To begin tinkering with SSIS in containers, you first need to install Docker. There are some prerequisites. I will not exhaust the prerequisites here. I strongly suggest you familiarize yourself with the requirements for Docker prior to attempting to install the software. Since I use a PC (a Lenovo P51S) running Windows 10 Pro, I chose …
Continue reading SSIS, Docker, and Windows Containers, Part 0 – Getting Started
Packaging SSIS Catalog Deployments
I love the SSIS Catalog. It’s an elegant piece of data integration engineering and I cannot say enough positive things about it. Packaging SSIS Catalog deployments can be tricky, though. The SSIS Catalog is a framework. Frameworks manage execution, configuration, and logging; and the SSIS Catalog handles each task with grace. Like I said, I …
Continue reading Packaging SSIS Catalog Deployments
Biml, Book Reviews, and Metadata-Driven Frameworks
I occasionally (rarely) read reviews at Amazon of books I’ve written. If I learn of a complaint regarding the book I often try to help. If a reader experiences difficulty with demos, I often offer to help, and sometimes I meet with readers to work through some difficulty related to the book (as I offered …
Continue reading Biml, Book Reviews, and Metadata-Driven Frameworks
Catalog Browser v0.7.8.0
I’ve been making smaller, more incremental changes to SSIS Catalog Browser – a free utility from the Data Integration Lifecycle Management suite (DILM Suite). You can use SSIS Catalog Browser to view SSIS Catalog contents on a unified surface. Catalog Browser works with SSIS Catalogs on-premises and Azure Data Factory SSIS Integration Runtime, or Azure SSIS. It’s …
Continue reading Catalog Browser v0.7.8.0