Posted by: techsavygal | March 16, 2009

SQL BI Samples…

Codeplex has a treasure of some great code samples and extensions on SQL Server Business Intelligence Software (SSIS, SSAS, SSRS)

Some great jewels from the above collection, which I found to be very useful for any SQL Developer are as below: 

SQL Server Service Broker Samples: (
SQL Server Scripts Samples: (
SQL Server End-to-End Samples: (
SQL Server Analysis Services Samples: (

Some of the samples on Analysis services are as below:

  • Compress M2M C# Application
  • A Solution for Collecting Analysis Services Performance Data for Performance Analysis – Updated 3/6/09 to simplify install and use
  • Scripts for Using ASCMD for Stress Testing – Updated 2/23/09
  • Script for Creating a Processing Log File
  • Powershell Scripts for Querying Analysis Services 2008 DMVs
  • AS Load Sim, including Load Testing Best Practices document
  • AS Query Generator
  • Load Test Reports
  • RSS Style Sheet
  • Activity Viewer
  • Aggregation Manager
  • AS Trace
  • Analysis Services Upgrade Verification Tool
  • SSIS Package For Collecting SSAS DMV Data
  • SSAS Monitoring Scripts For Management Data Warehouse

SQL Server Integration Services Samples:  (

You can also download SSISUnit tool to perform unit testing on the packages you may have created from the above samples.ssisUnit is a unit testing framework for SQL Server Integration Services. It is loosely based on the xUnit family of unit testing frameworks, but is tailored to better support the SSIS environment. One of the bigger differences is that you do not have to write code to create the unit tests. Instead, we have taken a declarative approach to specifying the unit tests. The test information is all stored in XML files. 

SQL Server Reporting Services Samples:


With the above RS code samples, you can also download RSBuild tool, which a deployment tool for SQL Server Reporting Service. It currently supports two types of tasks: executing SQL Server scripts and publishing SQL Server Reporting Service reports and shared data sources. From version 1.1.0 onwards SQL Server 2008 Reporting Services is supported as well as all previously supported versions of SQL Server Reporting Services.

Codeplex has another new tool added to its collection today named SQL Server FineBuildFineBuild provides 1-click install and best-practice configuration of SQL Server 2005 and SQL Server 2008.

If you have any questions or want further information on any of the above samples or tools, you can pop your questions and queries in SQL Forums from here.



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s


%d bloggers like this: