Code Snippet for an SSIS DataFlow Performance Wiretap

I was recently tweaking a few Data Flows, and settled on a very small, but very useful script to help...

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

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

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

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

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

Itzik Ben-Gan is in town

Not that you would know it from the page below,  but Itzik Ben-Gan is back in London to do a...

SSMS Add-in for Analysis Services

A nice new little add-in available for SSMS on Codeplex.  It helps with repetitive tasks involved with SSAS such as processing and deployment. ...

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