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

Unzip Files with SSIS

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

Locking Resources in Azure

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

Query Store Database Dashboard v1.3 released!

Next to releasing a new version of sp_WhatsupQueryStore, I just released the 1.3 version of the Query Store Database Dashboard!

Release...

Connecting to a Specific Port–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

Live #SQLintheCity–Behind the Scenes

Here’s a shot from our engineer, behind the scenes of my live talk today.
Tom Austin and @way0utwest live at #sqlinthecity...

An interview with me

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

Master Data Services Error – Missing Temp Directory

I recently had to install SQL Server 2016 again on my Windows 10 machine. This also meant that I had...

sp_WhatsupQueryStore v1.2 available

sp_WhatsupQueryStore v1.2 has just been released!

In this new version additional parameters are added to control what information is returned and...

Zip Files in SSIS

Of the very many things SQL Server Integration Services does well, one of its shortcomings is that it does not...