Category:Uncategorized

I’m honored to deliver Intelligent Data Integration with SSIS – a full-day pre-conference session – at SQL Saturday 813 in Boston 29 Mar 2019! 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 Integration Lifecycle Management), produced using …
Continue reading SQL Saturday 813 – Boston #SSIS Precon 29 Mar 2019!

I am honored and thrilled to welcome Eugene Meidinger (@SQLGene | blog | LinkedIn | Pluralsight) to the Enterprise Data & Analytics team! Eugene is self-described as a Business Intelligence Consultant but I think he’s being modest (in my humble opinion… see what I did there?). Eugene has authored three Pluralsight courses on the topics Power BI, DAX, Power Pivot, and SSAS. His …
Continue reading Enterprise Data & Analytics Welcomes Eugene Meidinger!

I am sometimes asked, “Andy, how do I start a technical blog?” I demonstrate one way here – a way that has served me well with search engines. 1. Describe how the error occurred.2. Copy the error message, post it as text.  3. Describe the solution. I am helping a large enterprise client migrate their data integration …
Continue reading SSIS Project Connection Manager Naming Error

Last August, I had a blast at the Data Platform Summit 2018 in Bengaluru, India. One highlight of the trip was meeting and conversing with the Azure Data Factory SSIS Integration Runtime Product/Program Manager, Sandy Winarko. Sandy and I swapped coder stories and talked about data integration design patterns and I learned a few new …
Continue reading Start Azure-SSIS, Execute Package, Stop Azure-SSIS

I am excited to announce general availability of SSIS Catalog Compare version 4! I made three short-ish (~2 minutes each) videos demonstrating some of the capabilities of the product. I really like the SCCPAC files and SCCPAC Deployment Wizard, which are only available in the Enterprise Edition. Use SCCPAC Deployment Wizard to Lift and Shift …
Continue reading SSIS Catalog Compare Version 4 – Three Videos

The SSIS Catalog has built-in security to manage permissions. SSISDB – the database behind the SSIS Catalog – is “just a database” in many respects. When it comes to security, the SSIS Catalog surfaces an internal mechanism that provides granular permissions management. In this post I intend to demonstrate how to use SSIS Catalog security to …
Continue reading Grant SSIS Catalog Read-Only Permissions

I just posted a preview of the next version of SSIS Catalog Compare at the brand new DILM Suite blog. You can head on over and check out the video is you have five minutes to spare. I’ll let you in on a secret: the star of the show is the new SCCPAC Deployment Wizard: …
Continue reading Testing SSIS Catalog Compare v4.5

The holidays are a joyous and happy time of year.  Almost everyone struggles in some way with the holidays, though. There are numerous posts about how to have difficult conversations with family who disagree with you on some matter or other – usually politics or religion. For some folks, though, it’s worse. Some struggle with …
Continue reading Thinking of You…

I speak with up-and-coming software developers often. A couple junior / intermediate software developers work with me at Enterprise Data & Analytics. As I’ve navigated four decades (plus) of software development I have witnessed – and experienced – places on my career-trajectory-map marked, “Here be dragons.”  “I Can Learn All the Things” “My name is …
Continue reading Q: “What are Pitfalls for Software Developers to Avoid?”