Wrap Methods With Same Frame Functionality

Sometimes one have to write several methods in one class having the same “frame” functionality, e.g. a try/catch block with logging inside the catch. Instead of copying this try/catch block all the times, one can create a wrapper for these methods. The goal is to have the try/catch block only …

Extract Files From .msi

Usually it is possible to use your favorite compression utility to treat a Microsoft Installer Package (MSI) like it is a normal archive. Though, sometimes this does not work. In this case one can use the Windows Installer Tool (msiexec.exe) to extract the files from the MSI package. The tool …

Limit Code Analysis Warnings

Visual Studio Code Analysis hat ein Limit von 200 für die Anzahl der Code-Analysis-Warnungen. Dies ist gut, um trotz der vielen Warnungen ein Projekt kompilieren zu können, kann aber auch ein Problem verursachen, wenn Tools eingebunden werden, welche selbst massive Anzahlen von Warnungen generieren und auf die Warnung von VS, …

SSIS Logging SP Name Has Changed

In SSIS SQL 2005, the stored procedure to write SSIS logging informwation was sp_dts_addlogentry. In case this sp does not exist in the logging database, it was created automatically. When I ported a BI solution from SQL 2005 to SQL 2008, I was wondering why the logging was not working …