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

Why Isn’t Everyone Accountable? A Work Conundrum

A pattern I’ve seen over and over again at many different jobs is that some people are not held accountable...

Database Interview questions

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

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

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

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

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

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

Is SELECT Identity() … INTO Minimally Logged in Simple Recovery?

Is SELECT Identity() … INTO Minimally Logged in Simple Recovery?
Extreme Logging

I was having a discussion with Idera (@idera_software) dev lead Vicky...

Rebuild indexes based on fragmentation – sp_RebuildIndex

In my previous post here, I’ve discussed how we can detect fragmentation in SQL Server databases indexes using dynamic management...