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
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. :{>
Azure DevOps, Git, and SSIS
After a couple false starts, I was able to live-stream one way to use Azure DevOps with Git to source-control the contents of an SSIS Catalog folder – including SSIS Catalog Folder, Projects, Packages, Environments, Environment Variables, Configured Literals, References, and Reference Mappings. In the video, I create an Azure DevOps project configured to use …
Continue reading Azure DevOps, Git, and SSIS
SSIS and the Future – December 2020 Edition
My friend, Sandy Winarko, recently published a fantastic summary of the efforts of the Microsoft SSIS Team to mitigate friction for enterprises seeking to lift and shift SSIS workloads to Azure. In my humble opinion, their work is outstanding. Looking In From the Outside As we say in Farmville Virginia, “Data integration and I go …
Continue reading SSIS and the Future – December 2020 Edition
SSIS 2019 Extension v3.11 Now Available
The Microsoft SSIS Team sent SSIS developers an early Christmas present this year: a new SQL Server Integration Services Projects extension for Visual Studio 2019! Release Notes: Version 3.11 (Current Version): Release Date: December 23th, 2020 Build Version: 15.0.2000.149 Tested against Visual Studio 2019 16.8 Whats’ new: Make creating SSISDB optional in IR Creation Wizard. …
Continue reading SSIS 2019 Extension v3.11 Now Available
Why Do I Like to Stream?
For as long as I can remember, I’ve always enjoyed learning – whether it’s learning something new and different, or learning something new and different about a topic in which I already possessed some knowledge. I confess: It’s a rush for me. To my knowledge, I’ve created no knowledge. With few exceptions, I learned everything …
Continue reading Why Do I Like to Stream?
AndyTube
I’ve been live-streaming more lately. There are a number of reasons why; perhaps most trenchant is: I like to stream. On YouTube… On today’s live-stream, a viewer asked if I have a YouTube channel. I have a YouTube channel! Apparently I’ve done an awesome job publicizing that fact! Enjoy! :{>
Enterprise Data Warehouse Maintenance Costs More Than Development
This post is part of a series titled Enterprise Data Warehouses: Uncomfortable Truths. There are cases where developing Enterprise Data Warehouses costs less than maintaining Enterprise Data Warehouses. Which cases? When enterprises do not maintain their Data Warehouse, EDW maintenance costs nothing (or nearly nothing). One side-effect of not maintaining an EDW is the Enterprise Data …
Continue reading Enterprise Data Warehouse Maintenance Costs More Than Development
Enterprise Data Warehouse: Uncomfortable Truths
Most enterprises recognize the need to capture, store, collect, and surface enterprise data analytics. Why, then, do most enterprise data warehouse projects disappoint or outright fail? The author proposes to share three reasons gleaned from decades of delivering and writing about data warehouse solutions: Enterprise Data Warehouse Maintenance Costs More Than Development Enterprise Data Warehouse …
Continue reading Enterprise Data Warehouse: Uncomfortable Truths
Stage Updates and Inserts for SSIS Data Flow Performance
A few days ago, I streamed SSIS Data Flow Performance, which you can view below (from LinkedIn) or by clicking the link to the YouTube recording: I share similar SSIS Design Patterns in my Expert SSIS course. I next deliver Expert SSIS 14-15 Dec 2020. Also, Expert SSIS is on sale for 50% off as part of my Cyber Monday Sale at the …
Continue reading Stage Updates and Inserts for SSIS Data Flow Performance
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