SSIS will not warn if metadata is out-of-date for a Lookup

I ran into this problem today that didn't take a long time to resolve, but took me a little by surprise. Most of my SSIS packages use the Lookup transformation component to look up keys used in source systems and match them to the data warehouse. When SSIS packages fail at the Lookup component, the most common cause is that the source system's key does not exist in the data warehouse and must be added first. This time was different, however.

Installing Office 2016 (VL, MSI) together with Visio and/or Project 2016 (click-to-run, C2R): Deadlocked

While the particular scenario I am describing here is likely common only at educational institutions, for those affected, it is a major showstopper. This blog post details the common licensing and deployment practices for higher education labs and the particular conundrum it causes with Office 2016 and Visio/Project 2016. I am proposing two workarounds that could help and one I've included just for completeness. I am calling on Microsoft to address the issue with a real fix.

Using ImageMagick to simultaneously split and convert a TIFF into multiple PDFs

Just sometimes, my wife needs some IT help. The latest occurrence is when she had scanned a number of documents to a TIFF file but really needed every page to be a single PDF file. We're talking a few dozen files with a few hundred pages each - a manual approach was not going to … Continue reading Using ImageMagick to simultaneously split and convert a TIFF into multiple PDFs

Creating an Azure SQL DB Firewall Rule from SSMS 2016 and Error 401

When connecting to an Azure SQL DB endpoint (somename.database.windows.net), your IP must be listed in that endpoint's (server's) firewall: If you're connecting to your Azure SQL DB from SQL Server Management Studio 2016 and your IP address is not in the list, SSMS will offer to add it: You'll need to sign in with a … Continue reading Creating an Azure SQL DB Firewall Rule from SSMS 2016 and Error 401

Performing a Silent Install of SQL Server Management Studio (2016)

With the release of SQL Server 2016, SQL Server Management Studio (SSMS) is now a stand-alone tool. It requires no licensing and can be downloaded without as much as registering. Because it is a separate download, it requires a separate installation. The computer labs I manage have SQL Server installed, including Management Studio. Prior to … Continue reading Performing a Silent Install of SQL Server Management Studio (2016)

My first NuGet package: Repository and UnitOfWork patterns for EF 6.1.3

Since I've been developing software again, I've had to sharpen my skills on the latest enterprise architecture patterns and how they are used in .NET. The Repository and UnitOfWork patterns aren't new, but implementing them correctly to achieve the most benefit without going overboard is nevertheless a learning curve. I found a presentation posted on … Continue reading My first NuGet package: Repository and UnitOfWork patterns for EF 6.1.3