Monthly Archives: December 2007

Moving SSAS databases

Here is an article on moving SSAS databases. The only thing to add is to be sure to set the file permissions on the folder. http://www.ssas-info.com/ssas_faq/ssas_management_faq/q_how_do_i_move_analysis_services_database_to_a_different_folder.html

Posted in SSAS | 5 Comments

Natural Keys vs Surrogate Keys

This blog entry has a good description of the pros (and some cons) of surrogate keys: http://rapidapplicationdevelopment.blogspot.com/2007/08/in-case-youre-new-to-series-ive.html

Posted in SQL Server Development | 7 Comments

SSRS filter values missing from a SSAS datasource

I recently ran into a problem where the list of values in a filter were missing for a dimension. It was due to having a fact relationship from the dimension to a very small fact table. In fact, the table … Continue reading

Posted in SSAS, SSRS | 5 Comments

SAN RAID Performance

It is difficult to find information on how different RAID levels perform. I did some performance testing with 14 SCSI disks in a SAN, and came up with the following conclusions (heavy dose of salt needed): More disks == faster … Continue reading

Posted in Hardware | 18 Comments