I’m looking forward to attending the PASS Summit 2017 next week – especially since I missed last year. If you search, you can find lots of great advice to attendees of the Summit. I agree with almost all of the advice out there and, if you’re a first-time attendee, it would serve you well to …
Continue reading My Plans for PASS Summit 2017
Author:Andy Leonard
Christian, husband, dad, grandpa, Data Philosopher, Data Engineer; Azure Data Factory, Fabric Data Factory, and SSIS guy; and farmer. I was cloud before cloud was cool. :{>
Twenty years of watching SSIS catalog drift, environment mismatches, and deployment chaos finally has a name: Data Integration Lifecycle Management. I build tools for it at DILM Suite. Start with SSIS Catalog Compare.
Moving Day
With a little help from a friend – Adam Machanic (@AdamMachanic) – I have moved my old SQLBlog.com posts here to andyleonard.blog. My old blog looks like the image above. The posts have been removed and links replace the content so older posts and links still work, but the placeholder content points folks here (I’m …
Continue reading Moving Day
Parsing SSIS Catalog Messages for Lookup Performance, v2
A couple years ago I wrote Administering SSIS: Parsing SSIS Catalog Messages for Lookups. I’ve updated the script to return all Lookup Transformation performance messages captured by the SSIS Catalog with Basic logging enabled (the SSIS Catalog’s default Logging Level). Some smart data integration people recommend setting the SSIS Catalog Logging Level to Verbose and …
Continue reading Parsing SSIS Catalog Messages for Lookup Performance, v2
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!
SQL Server Management Studio v17.3
SQL Server Management Studio v17.3 has been released! You may want to save the URL because Microsoft seems to dropping the latest and greatest versions of SSMS there each and every time here lately. :{>
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!
One Way to Install SQL Server 2017 Developer Edition
My intention in sharing this post it to help you install an instance of SQL Server 2017 Developer Edition. I accept most of the defaults in this installation, changing a few things that I only change in non-Production environments (like Mixed Mode Authentication for security). Please follow the advice of Microsoft and SQL Server professionals …
Continue reading One Way to Install SQL Server 2017 Developer Edition
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