I’ve authored and co-authored a bunch of books! Truth be told, I enjoy writing. I think my love of writing stems from a love of learning. I’m just trying to share the joy! It’s a huge honor to write. I’m humbled and thrilled (all at the same time – a feeling I describe as “all …
Continue reading My Books
Tag:SSIS
Introduction to the SSIS Lifecycle – 7 Jun 2018
Join me Thursday, 07 Jun at noon EDT for a free webinar: Introduction to the SSIS Lifecycle! How should an enterprise promote SSIS projects from Development to Production? How many “levels” are required? What are the best practices? Do SSIS lifecycle management tools exist? Join Andy Leonard – SSIS author, trainer, and consultant – to …
Continue reading Introduction to the SSIS Lifecycle – 7 Jun 2018
Introduction to Configuring SSIS in the SSIS Catalog – 24 May 2018
Join me Thursday, 24 May for a free webinar: Introduction to Configuring SSIS in the SSIS Catalog! The SSIS Catalog is a flexible data integration framework. What’s wrong with that last sentence? “Flexible” is dual-edged – it means there’s some complexity. Fear not! Andy Leonard – SSIS author, trainer, and consultant – is here to …
Continue reading Introduction to Configuring SSIS in the SSIS Catalog – 24 May 2018
OLE DB is *NOT* Deprecated
I cannot count how many times I’ve been asked about the deprecation of Microsoft OLE DB for SQL Server. My best guess? Hundreds of times over the years. My reply to questions has been: “I do not believe Microsoft will deprecate the OLE DB Driver for SQL Server.” In data integration circles, the announcement in …
Continue reading OLE DB is *NOT* Deprecated
SSIS Performance Pattern – Loading a Bajillion Records
Do you need to use SSIS to load some data from a large source? This post covers some thoughts on a couple/three patterns you may apply to help. I can hear you thinking, “Which pattern should I use, Andy?” That’s an excellent question! The answer is, “It depends.” You should test each pattern and see …
Continue reading SSIS Performance Pattern – Loading a Bajillion Records
Immersion Event on Learning SSIS – May 2018!
I am honored to partner with the awesome team at SQLSkills to deliver IESSIS1: Immersion Event on Learning SQL Server Integration Services in person in Chicago 7-11 May 2018! Click here to register! Here’s what I’ll be covering: Module 1: Introduction In the introduction we share information about the instructor, course flow, and content, and gather …
Continue reading Immersion Event on Learning SSIS – May 2018!
Data Integration Life Cycle Management with SSIS: A Short Introduction by Example is Available for Pre-Order!
I’m excited to announce that book #3 for 2017 is available for pre-order at Amazon! Data Integration Life Cycle Management with SSIS: A Short Introduction by Example is a(nother) short-ish book (~112 pages) that offers insight into managing SQL Server Integration Services (SSIS) in an enterprise. I wrote the book to demonstrate managing SSIS as it …
Continue reading Data Integration Life Cycle Management with SSIS: A Short Introduction by Example is Available for Pre-Order!
SSIS Change Detection Patterns: None
A Post About Nothing Actually not. But as a fan of Seinfeld, it’s cool to work in that quote. Seriously, though, No Change Detection is a valid change detection use case. In SSIS it looks like this: Whack ‘n’ Load I (lovingly) refer to this SSIS Design Pattern as the Whack ‘n’ Load Pattern. Is …
Continue reading SSIS Change Detection Patterns: None
Expert SSIS Training 4-5 Dec 2017!
Yep, we’re doing it again. In cooperation with Brent Ozar Unlimited, the next delivery of Expert SSIS Training is 4-5 Dec 2017. I had a great time delivering this course with Brent in September and I’m excited to have the opportunity to share this material with you again! If you register soon (written 27 Sep …
Continue reading Expert SSIS Training 4-5 Dec 2017!
Presenting at the Seattle SQL Pro Workshop 2017
I am honored to be among the presenters at the Seattle SQL Pro Workshop 2017! Also presenting are Jason Brimhall, Louis Davidson, Jimmy May, Gail Shaw and Wayne Sheffield. I’m looking forward to learning a bunch from these smart folks! My session is titled Designing an SSIS Framework: In this “demo-tastic” presentation, SSIS trainer, author, and …
Continue reading Presenting at the Seattle SQL Pro Workshop 2017