Using Dynamic SQL to create a Pivot Table

I recently came across a situation whereby I needed to create a SQL Pivot Table based on every day between now and 6 weeks time. Those of you who have used a pivot table within SQL will know that you need to provide the names for each group of data that you wish to pivot, that then… Read More »

Using WinSCP and SSIS to Download files from SFTP

Recently a client of the company I work for required us to download files using their SFTP server and process these files and for that we decided that we would use SSIS to complete the task. SSIS provides functionality to connect to a FTP server but not a SFTP server. Luckily SSIS allows you to… Read More »


I recently came across an issue where I needed to load a particular Windows Form dependant on the result of a SQL query. After some amount of time googling and asking a question on StackOverflow, I finally found the answer in the System.Reflection namespace. This post will explain the methods I used to load the… Read More »

Hello World…

Hi, Welcome to my new blog. I decided to setup this blog to document my learnings throughout my career as a .NET developer. Over the last couple of years I have been thrown in the deep end with my job and was tasked with teaching myself ASP.NET, C#, WinForms, SQL and much more. I want… Read More »