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

Want a Free #DILM Book? See Me at the #PASSsummit 2018!

I’ll be at the PASS Summit 2018 next week. I’m delivering a full-day precon Monday, presenting Faster SSIS and participating in the BI & Data Visualization Panel Wednesday, and Enterprise Data & Analytics is exhibiting Wednesday through Friday. “You Mentioned a Free Book…” Oh. Yeah. That. I will be giving away free copies of my latest book: Data Integration …
Continue reading Want a Free #DILM Book? See Me at the #PASSsummit 2018!

DILM Tiers for the SSIS Enterprise

“How many Data Integration Lifecycle Management tiers (DILM tiers) do I need to deploy SSIS, Andy?” If I had a nickel for every time I am asked this question, I would have a lot of nickels. My answer is, “Four.” Why Four? I’m glad you asked. Before I answer, I have a question for you: …
Continue reading DILM Tiers for the SSIS Enterprise

Viewing SSIS Configurations Metadata in SSIS Catalog Browser

SSIS Catalog Browser is a pretty neat product. “How neat is it, Andy?” I’m glad you asked. It’s free. That makes it difficult to beat the cost. SSIS Catalog Browser is designed to surface all SSIS Catalog artifacts and properties in a single view. “What exactly does that mean, Andy?” You’re sharp. Let’s talk about why …
Continue reading Viewing SSIS Configurations Metadata in SSIS Catalog Browser

Anatomy of a Catalog Reference Script in SSIS Catalog Compare

A Catalog Reference script is automatically generated from several methods in SSIS Catalog Compare’s Catalog object named CatalogBase. Header Documentation The script begins with a header documentation similar to that shown here: When executed, the Project Reference script header documentation portion displays in the Messages output window of SQL Server management Studio (SSMS): The statements …
Continue reading Anatomy of a Catalog Reference Script in SSIS Catalog Compare

Anatomy of an Environment Script in SSIS Catalog Compare

An SSIS Catalog Environment script is automatically generated from several methods in SSIS Catalog Compare’s Catalog object named CatalogBase. Declarations and Header Documentation The script begins with a declaration of Transact-SQL parameters that support SSIS Catalog Environment Variables contained within an SSIS Catalog Environment. These parameters are placed at the top of the script for …
Continue reading Anatomy of an Environment Script in SSIS Catalog Compare

Anatomy of an SSIS Catalog Connection Literals Script in SSIS Catalog Compare

An SSIS Catalog Connection Literals script is automatically generated using several methods in SSIS Catalog Compare’s Catalog object named CatalogBase. Declarations and Header Documentation The script begins with a declaration of Transact-SQL parameters that will be used to provide literal overrides. These parameters are placed at the top of the script for easy access by …
Continue reading Anatomy of an SSIS Catalog Connection Literals Script in SSIS Catalog Compare