Group Think (or Groupthink)

I’ve thought about writing on this topic a couple times and was reminded of it again when I read a...

Speaker Selection for SQLSaturday Orlando-Group #5

Three more added to the stellar slate of speakers for SQLSaturday Orlando, we look forward to seeing you soon!

Ira Whiteside

Devin...

Parallel Data Warehouse (PDW) Lesson 1: – Basic Architecture Overview

I’ll begin my coverage of Microsoft’s Parallel Data Warehouse (PDW) architecture / appliance with a brief overview of the Massively Parallel...

Writing About SQL Server

I.              Introduction I recently submitted my entry for a writing competition as part of my continuing education.  While I was...

Speaking at SQL Saturday 122 - Louisville

It has been a great couple of months for both me and for Perpetual Technologies (my employer). PTI has been...

Lost in Translation – Deprecated System Tables – sysdatabases

This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...

SQL Server 2012 Diagnostic Information Queries (July 2012)

Here is the latest version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to...

Baton Rouge SQLSaturday #150 & Tech Day–DBA 1 track

August 4th of this year will be the forth annual Baton Rouge SQL Saturday and Tech Day. Patrick LeBlanc got...

Securing Database Contents with Transparent Data Encryption (TDE)

Introduction
Microsoft SQL Server has many security features available within the database, but until release of SQL Server 2008 there has...

A Pattern for PIVOT

Use of the PIVOT operator in T-SQL has always been tantalizing yet confounding to me.  It offers the promise of...