In the upcoming April issue of SQL Server Magazine, look for Tool Time with Kevin Kline's coverage of the SQL Server Analysis Services Samples. The article will give an overview of some must-have samples that you should add to your toolkit. Here are some notes about system requirements and tips for working with the Analysis Services Samples.
· To use the samples, you need to have .NET Framework 2.0; if you don’t have Visual Studio 2005, you can download the .NET Framework SDK 2.0 at http://msdn.microsoft.com/netframew...downloads.
· When you download the samples, you get the SqlServerSamples.msi file; to finish the installation, you need to run the .msi file.
· If you use a non-default location for the samples (other than drive:\Program Files\Microsoft SQL Server\90\Samples), you’ll have to modify the sample code for the samples to work properly.
· Many samples require the AdventureWorks sample database, the AdventureWorksDW sample cube, or both. These sample databases ship with the SQL Server 2005 Setup, or you can download them separately from the SQL Server Developer Center at http://msdn2.microsoft.com/en-us/sq...6343.aspx.
· Some samples won’t work with SQL Server Express or Workgroup editions because those editions don’t include Analysis Services or SSIS. You’ll need the Enterprise, Standard, or Developer edition.
· The utilities in the samples are provided as source code, not executables. You need to compile the utilities by using either Visual Studio or the .NET Framework SDK before you get a usable binary file.
How to Get It:
Download the SQL Server 2005 Samples and Sample Databases at http://www.microsoft.com/downloads/...ayLang=en.