New SSIS Extension v3.15 for Visual Studio 2019

On 16 Aug 2021, the Microsoft SSIS Team released version 3.15 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.   I am late getting this update published. Visual Studio 2019 v16.11.4 is now available… …
Continue reading New SSIS Extension v3.15 for Visual Studio 2019

Video Coding and Loading Leonard Greenhouse Data

I had some time over the weekend to work on a process to capture weather measurements from an IoT instrument pack Stevie Ray recently constructed. You can learn more about what he did over at his blog – StephenRayLeonard.com – in a post titled The Modern Back Yard Greenhouse Begins With IoT. Although I did …
Continue reading Video Coding and Loading Leonard Greenhouse Data

Building Custom Tasks for SSIS Second Edition Errata, Chapters 13-14

As I wrote in 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 month, as I prepared to return to full-time consulting, I started feeling “better.” Prior to that …
Continue reading Building Custom Tasks for SSIS Second Edition Errata, Chapters 13-14

Join Me for LIVE Online SSIS and ADF Training 29 Nov – 1 Dec

It’s been a while since I delivered training live and online. Let’s fix that! Join me for Master the Fundamentals of ADF and Expert SSIS 29 Nov – 1 Dec.

Addressing Software Development Estimation

I recently blogged about punching developers in the brain when a software deliverable deadline is slipping. The title of the post is The Question Unasked. In this post, I would like to address software development estimation. In the past, I have stated “Either all software developers are pathological liars or software development is inherently inestimable.” …
Continue reading Addressing Software Development Estimation

The Question Unasked

In the past, I’ve blogged about my experiences with project managers. If you’ve read my thoughts, there will likely be little new content here (with the exception of the Obi-wan clip at the very end…). Most of my thinking is included in a post titled IT Coaching – Software Done Well, Part 1, written almost …
Continue reading The Question Unasked

Install and Configure SQL Server 2019 Developer Edition

This post is for people interested in setting up an instance of SQL Server 2019 Developer Edition for personal use. I caution those interested in configuring an instance of SQL Server 2019 for production purposes: You should not use Developer Edition because it’s not for production workloads, by design (and according to the EULA). In …
Continue reading Install and Configure SQL Server 2019 Developer Edition

Download SQL Server 2019 Developer Edition

This post is for people interested in setting up an instance of SQL Server 2019 Developer Edition for personal use. If you are interested in configuring an instance of SQL Server 2019 for production purposes, you should not use Developer Edition – it’s not for production workloads, by design (and according to the EULA). SQL …
Continue reading Download SQL Server 2019 Developer Edition

One Way to Install SQL Server 2019 Developer Edition

In this series, I walk through one way to install and configure SQL Server 2019 Developer Edition. This series is not intended as guidance for production environments. This series is simply one way I install and configure SQL Server 2019 for my test and exploration environment. Download SQL Server 2019 Developer Edition Install and Configure …
Continue reading One Way to Install SQL Server 2019 Developer Edition