Bob Duffy's Blobby Blog

Data compression in SQL 2008 is best for data warehouses, where they tend to be very IO constrained and can take a wee hit on CPU and latency. So how much space will you save with data compression? Well I just took a sample table from our SCOM data warehouse...

For those of you like me running Hyper-V, there is a VPC with the some of the 2010 “IW” stack loaded: - Domain Controller - MOSS 2010 - office 2010 - SQL 2008 - fast Search - Project server - Communicator I’m going to see how easy it is to put PowerPivot...

One side effect of following the best practices and running SQL Server under a Domain User account is that “Kerberos” authentication may not work due to the fact that the SPN cannot be registered. To step back a bit – what’s an SPN? This is a mapping...