Microsoft TechNet frequently releases White Papers on SQL Server Technology. I have read the following two white papers recently. The summary of its content is here.

Analysis Services Query Performance Top 10 Best Practices

1. Optimize cube and measure group design
2. Define effective aggregations
3. Use partitions
4. Write efficient MDX
5. Use the query engine cache efficiently
6. Ensure flexible aggregations are available to answer queries.
7. Tune memory usage
8. Tune processor usage
9. Scale up where possible
10. Scale out when you can no longer scale up

Partial Database Availability

Writer: Danny Tambs
Download Word Document

As databases become larger and larger, the infrastructure assets and technology that provide availability become more and more important. The database filegroups feature introduced in previous versions of SQL Server enables the use of multiple database files in order to host very large databases (VLDB) and minimize backup time. In SQL Server 2005 specific files can be set to offline or online.

Reference : Pinal Dave (https://blog.sqlauthority.com)