SQL Server 2012 RC0 is here!

SQL Server 2012 RC0 (Release Candidate 0), formerly known as SQL Server Denali, is now available for download.  SQL Server 2012...

SQL University: Virtualization Basics

This week we’re going to talk about a topic that has been gaining steam in the last few years and...

Table Space revised Again

Since I am in the Collation Sensitive mood, I am finally getting around to updating this script.  This is the Table Space script that I have had out there...

Table Space revised Again

Since I am in the Collation Sensitive mood, I am finally getting around to updating this script.  This is the...

DBA in Space: Behind the Scenes Part 3

This is a continuation of my DBA in Space journal.
 

Friday, September 16, 2011
OMG. (This is the first time in my...

Degenerate Dimensions

Degenerate dimensions, also called fact dimensions, are standard dimensions that are constructed from attribute columns in fact tables instead of...

Identify Risk Early

One of the mistakes I see a lot is teams failing to identify risks early and failing to leave time...

SQL Saturday 86 BI Edition Tampa 2011: Afterthoughts

Wow! Just Wow! That’s all I can say to describe how great SQL Saturday 86 was on November 5th in Tampa,...

SQL Server A to Z – Views

Happy Wednesday folks! Hope everyone’s having a great week. This episode of SQL Server A to Z is brought to...

SQL Triggers - An Introduction

Introduction
Triggers can be defined as the database objects which perform some action for automatic execution whenever users try to do execute...