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

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

24-Hours of PASS - Be on-time!

Right on the heels of the recent SQL Server 2012 virtual online launch event (as in virtually not there :-), a...

Another Interesting Sort

In October of 2011, I shared an example of a peculiar set of sort requirements.  Today, I am going to...

Another Interesting Sort

Some code requirements can be met through various means including the use of a different collation - which means a lot of testing.
Related Posts:

Creative Database Naming January 2, 2020...

Columnstore Indexs

Columnstore Indexes for Fast DW

The SQL Server 11.0 release (2012) introduces a new data warehouse query acceleration feature based on...

Looking to Windows 9

I haven’t played with Windows 8 yet, and only a little with Windows Phone 7, but I am a little...

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