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

RYO Maintenance Plan – Integrity Checks

Happy Monday! Everyone fully recovered from St. Patrick’s Day? Hopefully the weather where you are was as perfect as it...

Slides & Samples from my SQLSaturday #115 presentation about ColumnStore Indexes

As I have announced in my ColumnStore presentation last Saturday in Lisbon, you can
find here the slides
& samples for download....

SQL Server 2012: xVelocity

After SQL Server 2012 was released this past week, I saw a few mentions from Microsoft about a new feature...