Building Custom Tasks for SSIS Second Edition Errata, Chapters 1-9

Things change. Things change in software. Things change regularly in software. If you take nothing else away from this post, please take those nuggets of wisdom. Last week, my latest book – titled Building Custom Tasks for SQL Server Integration Services: The Power of .NET for ETL for SQL Server 2019 and Beyond, (Second Edition) was …
Continue reading Building Custom Tasks for SSIS Second Edition Errata, Chapters 1-9

Wrapping Up 2020

It’s that time of year again; that time when bloggers and others share their thoughts about the year that was and the year to come. “2020 was ____.” I complete this sentence three ways, listed below. Feel free to add your thoughts in the comments. “Different” …is the first word that leaps to mind. The …
Continue reading Wrapping Up 2020

Foreword – Building Custom Tasks for SSIS 2nd Edition

I’m excited to announce Building Custom Tasks for SQL Server Integration Services: The Power of .NET for ETL for SQL Server 2019 and Beyond 2nd Edition is available for pre-order at Amazon! I spent more time on this book and the demo task – the Execute Catalog Package Task – than any other book I’ve authored or …
Continue reading Foreword – Building Custom Tasks for SSIS 2nd Edition

SQL Server Data Automation Through Frameworks is Available!

Kent Bradshaw and I are excited and honored to announce the release of our latest book, SQL Server Data Automation Through Frameworks: Building Metadata-Driven Frameworks with T-SQL, SSIS, and Azure Data Factory! Enjoy! :{> Need Help? Enterprise Data & Analytics delivers private training, can join your team to help implement your enterprise data warehouse solution, …
Continue reading SQL Server Data Automation Through Frameworks is Available!

On Over-Engineering…

Some who follow me on Twitch (you may follow me at https://twitch.tv/andyleonard) – have seen me live-code the demo project for the second edition of Building Custom Tasks for SQL Server Integration Services (link to the first edition). The demo project is a custom task named Execute Catalog Package Task: While writing about parsing the …
Continue reading On Over-Engineering…

SQL Server Data Automation through Frameworks Book Available for Pre-Order

Although the cover image needs an update, my and Kent Bradshaw’s next book – titled “SQL Server Data Automation through Frameworks: Building Metadata-driven Frameworks with T-SQL, SSIS, and Azure Data Factory” is available for pre-order!

In the Beginning…

As I stated in the post titled Writing a Technical Book, “I am often asked for more information about writing a technical book.” In a follow-up post titled, One Way to Write a Technical Book, I state, [here] “I share details of my approach to writing a technical book.” People reading these posts have asked …
Continue reading In the Beginning…

Biml, Book Reviews, and Metadata-Driven Frameworks

I occasionally (rarely) read reviews at Amazon of books I’ve written. If I learn of a complaint regarding the book I often try to help. If a reader experiences difficulty with demos, I often offer to help, and sometimes I meet with readers to work through some difficulty related to the book (as I offered …
Continue reading Biml, Book Reviews, and Metadata-Driven Frameworks