Want a Sean-made Precon? You got it!

Sean’s giving a precon at SQL Satrurday 163 this October! Oh yeah, and so are Tim Mitchell and David Stein....

Querying Information from the Plan Cache, Simplified

One of the great things about the Dynamic Management Objects (DMOs) that expose the information in plan cache is that,...

Guest Post: SQL Server Installation Error by David Postlethwaite

A strange SQL installation error with even a stranger solution
This week I was installing  SQL Server 2008 R2 Developer onto...

Changing physical locations of all DBs

I got a request this week from an application engineer. The request was to move ALL physical database files from...

New in SQL 2012 (1)

Learning new is a interesting thing. Today I read several posts regarding the SQL Server 2012 new feature:

1. Indirect Checkpoint
Prior to...

Lost in Translation – Deprecated System Tables – sysaltfiles

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

Lost in Translation – Deprecated System Tables – Introduction

When SQL Server 2005 launched, it included a slew of dynamic management objects (DMOs) that were meant to replace the...

Determine space used for each table in a SQL Server database

I have written following Microsoft SQL Server T-SQL scirpt to quickly determine space used for each table in a SQL...

Database Interview questions

I decided to expand the collection of SQL Server Interview questions and this time focus on database objects related questions.

SQL Server Performance Tuning Overview

In this blog article I will give an overview of performance tuning based on common situation that occur on small...