I am honored to present Designing an SSIS Framework at the Chicago Suburban SQL Server User Group Tuesday 3 Oct 2017! Learn more and register here. I hope to see you there! :{>
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.
Available for Pre-Order – The Biml Book!
I am excited to announce The Biml Book is now available for pre-order from Amazon and Apress! I was honored to write with the inventor of Biml, Scott Currie, and an awesome team of BimlHeroes: Jacob Alley, Martin Andersson, Peter Avenant, Bill Fellows, Simon Peck, Reeves Smith, Raymond Sondak, Benjamin Weissman, and Cathrine Wilhelmsen. Chapters …
Continue reading Available for Pre-Order – The Biml Book!
BLObs in SSIS – Part 2 – The BLOb-Load Turbo Button.
As we saw in the first post in this series – BLObs in SSIS – Part 1 – How Does SSIS Load BLObs? – SSIS copies BLObs from their source to the location stored in the TEMP and TMP operation system environment variables. That location defaults to %USERPROFILE%\AppData\Local\Temp. That’s a problem because that default location …
Continue reading BLObs in SSIS – Part 2 – The BLOb-Load Turbo Button.
Presenting Use Biml to Automate SSIS Design Patterns at PASS Summit 2017
I am honored to present Use Biml to Automate SSIS Design Patterns at the PASS Summit 2017! Abstract: Perhaps you’ve heard the buzz about Business Intelligence Markup Language (Biml) and wondered, “Why is everyone so excited about Biml?” Occasionally, a new technology emerges that changes everything. For SSIS developers, Biml is one such technology. Business Intelligence …
Continue reading Presenting Use Biml to Automate SSIS Design Patterns at PASS Summit 2017
SSIS Version 15.0 Script Error
There I was… Delivering ExpertSSIS training with Brent Ozar Unlimited (we’re going to present another ExpertSSIS class – stay tuned for more information). I scheduled the execution of an SSIS package that contains a Script Task via SQL Agent, executed the job, and boom: “Excellent teaching moment,” I thought as I opened SSIS Catalog Overview and …
Continue reading SSIS Version 15.0 Script Error
A Note About Delivering Content For Brent Ozar
I recently had the honor and privilege of delivering ExpertSSIS training in cooperation with Brent Ozar Unlimited. Brent believes people want to learn technology from folks who: Are willing to share their knowledge on their personal or professional blog; Work in the field with the technology – perhaps even own a company that provides consulting …
Continue reading A Note About Delivering Content For Brent Ozar
BLObs in SSIS – Part 1 – How Does SSIS Load BLObs?
How Does SSIS Load BLObs? When SSIS loads Binary Large Objects (BLObs), the Data Flow Task first copies the data from the BLOb storage location to some location and stores the BLOb in a file. When it’s time to write the BLOb value, the Data Flow Task reads the BLOb from the file location and …
Continue reading BLObs in SSIS – Part 1 – How Does SSIS Load BLObs?
Why I Do Not Mix High Availability with Reporting Solutions
One way to offload reporting requirements from the Production OLTP (OnLine Transaction Processing) database while providing a near-real-time copy of Production data is to execute reporting and analytics queries against a High Availability solution replica – such as SQL Server Availability Groups. Learn more about Availability Groups On at: Overview of Always On Availability Groups (SQL Server). “Why …
Continue reading Why I Do Not Mix High Availability with Reporting Solutions
Presenting Faster SSIS at SQL Saturday 683 – Charlotte 14 Oct
I’m honored and excited to deliver a brand new presentation at SQL Saturday 683 – Charlotte on 14 Oct: Faster SSIS! Abstract: Ever wonder why SSIS runs so slow? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data and shows you how to tune SQL Server 2016 Integration Services …
Continue reading Presenting Faster SSIS at SQL Saturday 683 – Charlotte 14 Oct
Presenting Designing an SSIS Framework at SQL Saturday 681 – Spartanburg 23 Sep
I am honored to present Designing an SSIS Framework at SQL Saturday 681 – Spartanburg 23 Sep! Abstract: Enterprise data integration changed with the introduction of the SSIS Catalog. Implementing enterprise data integration often requires functionality beyond the rich features provided by the SSIS Catalog. Building on his previous work in the field of Data …
Continue reading Presenting Designing an SSIS Framework at SQL Saturday 681 – Spartanburg 23 Sep