SSIS #118–Is it an OLEDB or an SMO Server Connection?

OLEDB is the native client for SQL Server. Every SSIS developer is familiar with how to use it. Almost every...

Analytics Platform System (APS) AU3 released

The Analytics Platform System (APS), which is a renaming of the Parallel Data Warehouse (PDW), has just released an appliance update (AU3),...

2014 Tribal Awards Are Open

Yesterday morning I opened my email and was very pleased to find that I have been nominated for the 2014 Tribal...

Building Your First Windows Azure Machine

Recently, I had the pleasure of writing another article that was included the Notes From the Field series that is hosted...

Outlier Detection with SQL Server, part 3.2: GESD

By Steve Bolton
…………In the last edition of this amateur series of self-tutorials on finding outlying values in SQL Server columns,...

Playing with the log – VLF order while growing the log

The log file is one of those parts of SQL Server I find fascinating. For instance it is composed of...

SQLSaturday Portugal 2015 – Above & Beyond

At the same day, 4 years ago me & my team were already in the process of organising the very first...

Azure Columnstore, part 2 – Snapshot Isolation & Batch Mode DOP

Welcome to the 2nd blog post in the Azure Columnstore series, as previously mentioned in the Azure Columnstore, part 1...

‘Twas 4:45 Friday

‘Twas 4:45 Friday, and all through the office

not a creature was stirring, not even the bosses.

The code was checked in,...

Load Balanced IIS Machines

I noticed a contest this week while working on the Database Weekly newsletter. It’s the Cloud Hero contest, with the...