How good is Data Compression in SQL 2008

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 and applied compression. Results are…

1

IW 2010 Demo Hyper-V Image Released

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 on the VPC…

0

SQL Server and Kerberos

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 maintained in Active Directory between a service account…

0