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

Kindle Fire Parental Controls

I blogged a while back about not having the ability to easily disable purchasing on the Kindle. Until recently we...

SQLRally Can’t Miss Events

Things have been quiet around here lately and I have a one word explanation….SQLRally.  There’s work and family and several...