Announcing the SQLpassion Performance Tuning Training Plan

You are a developer and/or DBA and want to learn in a very compact way the essential things about performance...

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

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

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

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

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

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

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.

...