Reports In SSISDB

I was approached with an in shop issue where a group could not view the execution reports in the SSISDB....

Finding the reason for the error “Subquery returned more than 1 value”

First this type of error is because a subquery returned more than one row when it wasn’t allowed to. In...

IT Pro Airlift 2015 Portugal – Microsoft Data Platform

On 22 of January 2015, Microsoft Portugal is organising a new IT Pro Airlift 2015 – – Microsoft Data Platform event. This...

Using an alternate TypeScript compiler inside Visual Studio

TypeScript team member Daniel Rosenwasser provided instructions for replacing the TypeScript compiler and language service used by Visual Studio here:

https://github.com/Microsoft/TypeScript/issues/1110#issuecomment-62451204

He...

Execution Plans, Performance Tuning and Rum

This is me on the last cruise
In just a few more weeks I’ll be setting sail on the first of...

Website Updated

Over the Christmas holiday period the gethynellis.com website has had a bit of revamp.

In terms of what has changed,...

Things I Learned in 2014

2015 is here!
Last year I wrote about what I had learned in 2013, and I try to make it a...

Looking back on 2014

When a new year comes around it is always a great time to reflect on the previous year.

2014 was a...

T-SQL Tuesday #62 - Invitation to HealthySQL

Greetings ALL and Happy New Year 2015!  I wish everyone an excellent year ahead, and
that 2015 will bring peace and...

Table Variables, CTE and Temp Tables. Which one should I use?

There are several really good blogs that already exists that explain the differences between Table Variable, Common Table Expressions (CTE)...