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

Moving xml child elements to its parent using XQuery

I haven’t been able to do much XQuery development recently which is a shame as I love developing with the...

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

Purging MSDB Backup and Restore History Tables

Today while checking our database growth reports, I noticed that size of msdb database on most of our SQL Server...

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

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

SQL Audit 101 – Creating a basic audit

SQL Audit was introduced in SQL 2008, and for the first time auditing was treated as a “first-class” object in...

SQL Internals Reading Data Records Part 6: Variable Length Data

Welcome back Dear Reader to Part 6 on our series of how to read a Data Record.    In Part 1...

Writing About SQL Server

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

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