Wednesday, December 24, 2008

New Visual Studio Team System Virtual Machines!

Just in time for Christmas! Brian Randell, better known as the guy who hosts cool PDC parties and builds a lot of Virtual Machines for Microsoft has announced the availability of 4 new Visual Studio Team System 2008 Virtual Machines!

Basically there are 4 new VSTS Images:

The full text of his blog announcement, including information on what all is contained can be found here: 

Thanks Brian!


Note: When I originally posted this blog entry I incorrectly stated the images were VSTS 2010 when in reality they are just the new and improved Visual Studio 2008 Team System. Sorry about that for those who got too excited!

Tuesday, December 2, 2008

SQL Server Analysis Services 2008 Performance Tuning Whitepaper

This paper was recently released by Microsoft. It covers all of the things you need to look for when tuning SSAS 2008 (and is very relevant to 2005 as well). From the download description:

Because Microsoft SQL Server Analysis Services query and processing performance tuning is a fairly broad subject, this white paper organizes performance tuning techniques into the following three segments.
Enhancing Query Performance - Query performance directly impacts the quality of the end user experience. As such, it is the primary benchmark used to evaluate the success of an online analytical processing (OLAP) implementation. Analysis Services provides a variety of mechanisms to accelerate query performance, including aggregations, caching, and indexed data retrieval. In addition, you can improve query performance by optimizing the design of your dimension attributes, cubes, and Multidimensional Expressions (MDX) queries.
Enhancing Processing Performance - Processing is the operation that refreshes data in an Analysis Services database. The faster the processing performance, the sooner users can access refreshed data. Analysis Services provides a variety of mechanisms that you can use to influence processing performance, including efficient dimension design, effective aggregations, partitions, and an economical processing strategy (for example, incremental vs. full refresh vs. proactive caching).
Tuning Server Resources – There are several engine settings that can be tuned that affect both querying and processing performance.


Download the paper here: