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

CHECKDB and Page Restoring from SSMS

Did you know that you can run DBCC CHECKDB (WITH PHYSICAL_ONLY) and issue page restores from SSMS (SQL Server Management...

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