Rebuild all the Indexes of a SQL Database in one go

Introduction
In my last post, I had explained what could be the best value of Fill Factor for the indexes in...

Table Backups and the TableArchive Database

A discussion of how a separate database is used for storing table backups.
In a recent article, one of the things...

T-SQL Formatting Workaround (Word Macro)

Hi all! I’m on vacation this week, but I’ve cleverly scheduled this blog post so you won’t miss me too...

Presenting Two Sessions at PASS Summit 2011

I found out earlier this week that I was fortunate enough to have my half day session on “Scaling SQL...

Ice Cubes and Top SQL Rally Speakers

That title may evoke thoughts of inappropriate SQL Karaoke or perhaps not but It is so nice to know I’m...

Prevent SQL Logins from using SSMS … or any other app

In a continuation of my previous LOGON TRIGGER post.
A downside to SQL logins is that anyone with the username / password...

SSAS Maestro - Redmond Recap

Well today was the last day for a while I would be greeted by this sign:

It was a pretty exciting...

Altering Table structure - SSMS - Timeout Expired

Altering a table using SQL Server Management Studio ( SSMS ) can be done by right clicking on the table and by...

An Update on My Dell E6500

I bought my E6500 almost three years ago, giving away what was a perfectly good Latitude to trade up to...

Being Cautious With SQL Based Processes

Why being careful is such an important mindset when working with SQL and databases.
At the Boston Public Schools, certain processes...