After attending the Pass Summit 2016 a couple of weeks ago, I attended a number
Fairly often I come across a project where there is a requirement to extract data
As a BI Consultant, I regularly sit down with a new/prospective client and dissect both
One challenge I have faced recently is to automatically delete files which are over X
This is a quick post to highlight how making some small changes to the SSIS
Well it’s been quite a week and this has certainly been a summit with many
In the current SQL Server 2016 CTP2, there are not many exciting improvements made to
A standard practice in the data warehousing world is the process of delivering conformed dimensions,
In this blog we look at how to optimise SSIS lookups with HASHBYTES. I was
After doing my recent blog post on the Excel Fuzzy Lookup Add-In Vs SSIS, it