Ok hands up who is still running SQL Server 2000 systems in production. I know you are out there.
Last week I had to determine why a set of DTS packages were running extremely slow. Perfmon indicated that the Disk IO latency was ranging from 50 ms to 1 to 2 seconds, that’s right seconds.
If you are grappling with the decision on the correct SSAS model to use for your next BI project, then have a look at Melissa Coates article; Decision Matrix: How to Choose Which Type of Model Meets Your Needs (Here).
Microsoft has announced a preview of a new Premium Windows Azure SQL Database offering. The Premium Windows Azure SQL Database product enables you to reserve capacity for your SQL Database which guarantees a fixed amount of dedicated resources (CPU, Memory and IO).