Vote on Connect Items for SQL Server 2008/2008 R2 and 2012 Service Packs

As we get closer to the end of mainstream support for both SQL Server 2008 and SQL Server 2008 R2...

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.

...

Master Data Services for the Beginner Part 05

 
Introduction
In yesterday’s discussion we looked at creating a current flag, creating views and looking at some of our data.  Today...

Some Great Big Data Sources

What kinds of data are exciting to you? Census and government data? Zombie Data? Marvel Comics? Time and time again...