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

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

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

Can You Dig It? – Determining Index Plan Usage

She Can Dig It!
A while back I was asked, if you can use the plan cache to determine which plans...

Living a Dream

It was a little over a year ago that I stood on stage at the Rocky Mountain Tech Trifecta and...

Slowing Changing Dimension (SCD) demystified – Part 2

In Part 1 of this series, we looked at SCD Type I. We would now look at the SCD Type...

Denali – Day 4: Editions & Licensing

Denali – Day 4: Editions & Licensing

Editions:

Here is a brief edition summary of Editions available for all sql server from 2005 to...