SSIS – Using Kill with SP_Who to Break locks

The dreaded table lock can occur and cause your SSIS packages to fail. A popular request I receive asks “How...

SSIS – Using Kill with SP_Who to Break locks

The dreaded table lock can occur and cause your SSIS packages to fail. A popular request I receive asks “How...

Verdasys Digital Guardian and SQL Server

I’m writing this post as a reminder for myself and possibly to help out the poor souls that may suffer...

What Tables Are In My Filegroups

One issue I've found a bit troublesome is trying to find out what's in a specific Filegroup. Let's say you're...

Analyzing your Microsoft Exchange Account Data with Power Query

One of the interesting additions to the Power Query Preview December update is the ability to import data from Microsoft...

Hortonworks Makes HDP 2.0 for Windows Server Generally Available

Today, Hortonworks announced the general availability of the Hortonworks Data Platform (HDP) 2.0 for Windows.  This is the next release...

Master Data Services for the Beginner Part 06

Introduction

The consumers of our data wish to be able to make stock and financial decisions from our data. Turning raw...

SQL Server Analysis Services – SSAS Fundamentals

SQL Server Analysis Services (SSAS) Fundamentals
SSAS comes with your purchase of Microsoft’s SQL Server.  It is a separate component and...

Transactions: Creating a single restore point across multiple databases.

This is a disaster and recovery trick I’ve found to be useful for developers with batch processes that hit multiple...

Dating Tips Part 1

This is the first in a series of dating tips, so if you need you’ve come to the right place.

...