Non use of persisted data – Part deux

In my last blog I showed how persisted data may not be used if you have used the base data...

Poor man’s SQL monitor

Here is quick tip that can help you track SQL Job and Alert notifications in Microsoft Outlook. Many of you...

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