Category:Uncategorized

On Friday, 04 Aug 2017, I have the privilege and honor of delivering a full-day precon titled Intelligent Data Integration: SSIS Design Patterns and Biml as part of SQL Saturday Louisville. If you’re interested in learning more or attending, you can learn more here. “Isn’t This The Same Presentation You Delivered Before, Andy?” Yes and …
Continue reading Intelligent Data Integration, SSIS Design Patterns, and Biml

DevOps is getting a lot of attention in SQL Server and Developer communities these days. Two friends have blogged about the outage and accompanying data loss experienced by GitLab: Brent Ozar (blog | @BrentO) wrote SQL Server DBA’s Guide to the Gitlab Outage Mike Walsh (blog | @mike_walsh) wrote DevOps: Don’t Forget The Ops I’m …
Continue reading On DevOps…

The recording for the webinar Save Time and Improve SSIS Quality with Biml is now available (registration required). Enjoy! :{> Learn More: SSIS Catalog Compare v2.0 Launch Event 7 Mar 2017! The Basics of Biml – Populating the Biml Relational Hierarchy Related Training: IESSIS1: Immersion Event on Learning SQL Server Integration Services – April 2017, …
Continue reading The Recording for Save Time and Improve SSIS Quality with Biml is Available

I’m not good at naming things. “Biml Express Metadata Framework” is descriptive but the acronym – BEMF – is difficult to pronounce (for me, at least). Kent Bradshaw wants to name it George. We’ll keep working on a name… What is the BimlExpress Metadata Framework? The Biml Express Metadata Framework uses Business Intelligence Markup Language …
Continue reading BimlExpress Metadata Framework

The recording for the Enterprise Data & Analytics webinar titled Advanced SSIS Execution is now available (registration required). Enjoy! :{> Learn More: SSIS Catalog Compare v2.0 Launch Event 7 Mar 2017! SSIS Catalog Management SSIS Lifecycle Management Related Training: IESSIS1: Immersion Event on Learning SQL Server Integration Services – April 2017, Chicago  IESSIS2: Immersion Event …
Continue reading The Recording for Advanced SSIS Execution is Available

The Data Integration Lifecycle Management Suite (DILM Suite) helps SSIS Developers and Database Administrators manage SQL Server Integration Services (SSIS) deployments in the enterprise lifecycle. Join Kent Bradshaw and me at 1:00 PM EST 7 Mar 2017 for the SSIS Catalog Compare v2.0 Launch Event! In this free webinar we will demonstrate the value of …
Continue reading SSIS Catalog Compare v2.0 Launch Event 7 Mar 2017!

I was honored to be interviewed by Carlos Chacon (@CarlosLChacon | SQL Data Partners) and Steve Stedman (@SqlEmt | Blog) for the SQL Data Partners podcast. We had a great discussion about the SSIS Catalog. We talked about how the SSIS Catalog works, Data Integration Lifecycle Management (DILM), SSIS Catalog Browser, SSIS Catalog Compare, and …
Continue reading SQL Data Partners Podcast Episode 79: SSIS Catalog

For months, I’ve received pings about a screenshot I posted on social media a year or so ago. Plus I needed to wind down. You real runners will know what I mean: You know how you feel after you’ve covered some distance (for you)? You need to walk around for a bit, you can’t just …
Continue reading Introducing astreams

The recording for the Enterprise Data & Analytics webinar titled “SSIS Catalog Management” is now available (registration is required). In the SSIS Academy: Using the SSIS Catalog series, Kent and I walked through the SSIS Catalog functionality built into SQL Server Management Studio (SSMS). This webinar picks up where SSIS Academy: Using the SSIS Catalog, …
Continue reading The Recording for SSIS Catalog Management is Available

I am pleased to announce the release of SSIS Catalog Compare and CatCompare version 2. You can purchase a bundle that includes both products (and saves you some money) or can purchase each product separately: SSIS Catalog Compare and CatCompare. If you’re interested in learning more about the functionality provided by the products you can …
Continue reading Announcing SSIS Catalog Compare and CatCompare Version 2