Overview of Published Articles – 2014Q4

Here is an overview of the articles I published in the last quarter of 2014.
INTENSE SCHOOL
MCSE Prep: Overview of T-SQL Windowing...

Building Rollback Scripts with SQL Compare

There’s a neat switch in SQL Compare that lets you build rollback scripts. It looks like this:

I’ve used this before...

The big disconnect with Connect

A couple of years ago I blogged about a bug on the Data Collector that I couldn’t resolve but with an...

SSIS 2012 Design Patterns by Andy Leonard, Matt Masson, Tim Mitchell, Jessica Moss and Michelle Ufford

During my vacations at the end of 2014 I have finally finished a book on “SQL Server 2012 Integration Services...

Using Power BI to access on-premise data

The following blog describes how to use certain cloud-based Power BI for Office 365 products (Power View and Q&A) on...

Exam Prep 70-463: Control Flow Tasks and Containers

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...

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...