SSIS: Script Component Asynchronous Transformation

The SSIS script component can be configured to use synchronous or asynchronous outputs.  If the script component is configured for...

Microsoft Releases SQL Server 2008 SP2 Cumulative Update 9

Right on schedule, Microsoft has released SQL Server 2008 SP2 Cumulative Update 9. This is Build 10.00.4330.00, and it has...

PASS for Today (and Tomorrow)

I just wanted to plug two events that are free SQL Server training. First, Thomas LaRock (@sqlrockstar) and Jason Strate...

Seldom Used Indexes

On occasion you may ask yourself if there are any under used indexes in your database.  If not you, then possibly a manager or client.  Usually this comes up...

Seldom Used Indexes

On occasion you may ask yourself if there are any under used indexes in your database.  If not you, then...

Get Free Learning

A couple of different events going on today and tomorrow:
Today (03/20) at 3pm CDT - "Choose Your Own Adventure: Performance Tuning"...

Free E-Book on SQL Server 2012, Great Job by Ross Mistry and Stacia Misner (yes, they have done it again :)

Free E-Book: Introduction to SQL Server 2012

Ross Mistry and Stacia Misner have again done a wonderful job on this free...

FILESTREAM and Snapshot Isolation Mode in SQL 2008

FILESTREAM and Snapshot Isolation mode are incompatible in SQL 2008.

In SQL 2008 R2 however...

http://msdn.microsoft.com/en-us/library/ms173763.aspx
In SQL Server 2008 R2, snapshot...

Powershell - Working with Cluster Resources - Byte Arrays

Over the next few weeks, I plan to share some of the discoveries I've had when working with Windows 2008R2...

SQL in the City: Free SQL Server Event in London

Red Gate Software has announced “SQL in the City: London,” to be held on Friday, July 13, 2012, at the...