Difference between Checkpoint and LazyWritter

Was thinking about to write this blog for quite some time. CheckPoint Lazy Writer 1. Flush dirty pages to Disk...

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