T-SQL Tuesday 138: Managing Technology Changes

I’m honored to host T-SQL Tuesday for May 2021. One point I make (repeatedly) in my latest book – titled Building Custom Tasks for SQL Server Integration Services – is “software changes.” In fact, software changed on me between the completion of editing and the release of the book! I wrote about the changes in a …
Continue reading T-SQL Tuesday 138: Managing Technology Changes

New SSIS Extension v3.13.1 for Visual Studio 2019

On 12 Apr 2021, the Microsoft SSIS Team released version 3.13.1 of the Integration Services extension for Visual Studio 2019: SQL Server Integration Services Projects extension for Visual Studio 2019, but there is an issue that has triggered a warning. On 24 Apr 2021, the Integration Services extension was updated. The page displays this information …
Continue reading New SSIS Extension v3.13.1 for Visual Studio 2019

SSIS Framework Manager Property Overrides Video

I’m adding a GUI to DILM Suite called SSIS Framework Manager. If you read that name and guessed the GUI manages the SSIS Framework metadata, you are correct! I’ve been streaming as I’ve coded along on the project. I reached a pretty good functionality place earlier this week. Since then, I’ve been testing. I thought …
Continue reading SSIS Framework Manager Property Overrides Video

One Way to Create a Parquet File from SQL Server Data

Yesterday I was coding away, deep into using C# to decompress and parse Excel XML so I could read data from a specific worksheet in a workbook on a server without Excel objects installed, when I saw the following on Twitter: For those of you who do not already know… I Don’t Switch Contexts Well I …
Continue reading One Way to Create a Parquet File from SQL Server Data

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

New DataDriven Episode with Peter Voss

 In this episode of Data Driven, Frank and Andy speak with Peter Voss about Artificial General Intelligence, Personalizing Personal Assistants, and Motorcycles Sponsor Sponsor: Audible.com – Get a free audio book and support DataDriven – visit thedatadrivenbook.com! Guest Bio Peter Voss is the world’s foremost authority in Artificial General Intelligence. His company Aigo (https://www.aigo.ai/) has created the …
Continue reading New DataDriven Episode with Peter Voss