SSRS 2016: Great and Getting Better

Although I’ve been a regular user of SQL Server Reporting Services since it was released in the mid-2000s, I’ve done...

Saturday Reading 2016-12-17

It was my office Xmas party last night so whilst recovering on my settee, I’ll be reading:-
The Most Important Role...

SSIS Execution Status Lookup

The SSIS catalog comes packaged with a rich set of built-in reports that give those monitoring Integration Services a window...

Why I am called BlobEater

It’s coming towards the holiday season for me and I thought that I would wind-down a little with a non-technical...

Locking Resources in Azure

I look at locking resources within Azure as a safety mechanism where it can protect users from accidental deletion, it...

Power BI on-Premises Production Targeted for Mid 2017

NEWS FLASH: Power BI reports can be deployed to SQL Server Reporting Services web portal.  The production-ready release is targeted...

Reflecting on Ten Years of SQLSaturday

It’s hard to believe it’s been more than 10 years since we started the planning for the first event in...

Unzip Files with SSIS

In my last post I shared how to build a package in SSIS to perform simple file archive (zip) operations....

What’s the little popup window in #SQLPrompt?

Awhile back I was working in SSMS and saw this window.

It threw me off since I was trying to write...

An interview with me

The other day I received an email asking for some help with a school project. Would I please answer some...