Using the SSIS Multiple Flat Files Connection Manager

When building an ETL pipeline to import data from a text file, it’s very common to have the incoming data spread across multiple files. For example, if you are...

ASF 017: Alex Whittles interview

Introduction Alex Whittles is the owner and principle consultant at Purple Frog, a SQL Server Business Intelligence consultancy in the...

Azure Backup Storage Options

As a database administrator, I am very conscious of how data is being backed up.  Up until SQL Server 2012,...

Fun time Friday - A week is a long time in....

A week is a long time in...

SQL Server Land
A week is a long time in SQL Server land. This week...

Fun time Friday - A week is a long time in....

A week is a long time in...

SQL Server LandA week is a long time in SQL Server land. This week I have been busy working on a version migration...

SQL Server Guide To NULL Handling

Every language handles null equality differently and understanding this is crucial as a misunderstanding here can lead to some quite...

Synonyms in SQL Server – Good and Bad

When SQL Server 2005 was released, a nifty little feature was included called synonyms.  Despite being around since SQL Server...

Synonyms in SQL Server – Good and Bad

How you use a synonym can be a huge asset or it can be a significant dampener to performance.  There are benefits and uses for these nifty little things....

The Year in Review Webinar–Dec 18

Join me for our Year in Review Webinar next week, Dec 18, at 4pm GMT. I’ll be joining Kendra and...

Things I Learned at Summit v20 - Trace Flag 4199

Part of a series of posts on cool stuff I learned at PASS Summit v20 (2018) - in this first post...