Service Broker Sample: Multi-Threading

Introduction
Service Broker is a cool new feature since SQL Server 2005. Yes, SQL 2012 just came out so it’s hardly...

SQLSaturday #158 NYC Event Update! - Spread the word...

It's about three months to  to SQLSaturday #158  in NYC, and we're hard at work nailing down all the little...

SSAS: Duplicate Attribute Key Error

One type of error that arises occasionally during SSAS cube processing is the ‘duplicate attribute key’ error.  The error message...

SSIS 2012 Copy or Duplicate Environments

In SSIS 2012 there is a great new feature called environments. They can be thought of as a collection of parameters...

The Fantastic 12 of SQL Server 2012

The SQL Server Team Blog is in the midst of posting twelve, short weekly videos that let someone from the...

Updated SQL Rockstar Blogger Rankings

This morning, Thomas LaRock (blog|@SQLRockstar) released an updated version of his Blogger Rankings. I was very happy and humbled to...

Denali — Day 6: indirect Checkpoint

Denali – Day 6: indirect Checkpoint

I have already blog some information about checkpoint here

As I have already blog about Checkpoint and...

Implementing a replication agent progess bar

Using Replication Management Objects, SQL Server subscriptions can be synchronized programmatically without using SQL Server Agent or SQL Server Management...

Denali — Day 5: Column-store indexes (aka Project Apollo)

Denali – Day 5: Column-store indexes (aka Project Apollo)

 
There is another great achievement for Denali, especially for Data warehouse, where data...

It was time for an upgrade

I am not one of these anti PC sorta guys, but I do love my MacBook Pro.  I have owned...