Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

Year End Downloads and Information

Posted by denglishbi on December 13, 2008

A few more downloads have come out since my last posting Downloads and Catch-Up a few weeks ago.  Tough to keep up with everything, but with RSS feeds and aggregators like RSS Bandit which I use or Google’s Reader, SharpReader, FeedDemon, Bloglines, etc.  There are tons of different RSS readers that you can use to subscribe to blog sites, news, shopping deals, sports, comics, technology, entertainment, you name it, it can be used as a feed into one of these readers.  You could also use Outlook, at least with 2007 that option is available.

Enough of that chatter, now for the items that I want to make sure everyone is aware of and to share (these are in no particular order):

  1. SQL Server 2008 Upgrade Technical Reference Guide – This 490-page document covers the essential phases and steps to upgrade existing instances of SQL Server 2000 and 2005 to SQL Server 2008 by using best practices. These include preparation tasks, upgrade tasks, and post-upgrade tasks. It is intended to be a supplement to SQL Server 2008 Books Online.
  2. ProClarity 6.3 SP2 Readme (this was released last week – hotfix 2217: ProClarity 6.3 SP2 is now available and for more details refer to the ProClarity Teams Blog site)
  3. PerformancePoint Server SP2 – Planning Server SP2 Readme, Monitoring and Analytics SP2 Readme, Management Reporter SP2 Readme
    1. PerformancePoint Server 2007 Service Pack 2 (x86) 

      PerformancePoint Server 2007 Service Pack 2 (x64)

      Additional TechNet information – Service Pack 2 for Microsoft Office PerformancePoint Server 2007


  4. SQL Load Generator Tool – SQL Load Generator is used to run multiple concurrent queries against SQL Server. The user can choose the number of concurrent queries to run, provide different queries, choose SQL or domain accounts, and provide application name settings. SLG was developed using C# 3.5. This is available for download on CodePlex here http://www.codeplex.com/SqlLoadGenerator.
  5. Andrew Fryer’s 24 days of SQL Server 2008 – great content and quick way to get yourself familiar with SQL Server 2008 new features.  I highly recommend adding Andrew to your feeds.
  6. AdventureWorksOffline Report Samples – check out the latest Reporting Services (SSRS) sample reports utilizing the new charting, gauging, and text formatting functionality with SSRS 2008.  A great set of samples to use to be able to learn how you can apply customizations to the new features.
  7. PowerGUI – an extensible graphical administrative console and IDE for managing systems based on Windows PowerShell. See the PowerGUI homepage for more information about the product.
  8. OLAP PivotTable Extensions – an older one that I have had around for a while, but figured I should post.  This is an Excel 2007 add-in which extends the functionality of PivotTables on Analysis Services cubes. The Excel 2007 API has certain PivotTable functionality which is not exposed in the UI. OLAP PivotTable Extensions provides an interface for some of this functionality.  Allow yourself to easily view the MDX generated by using PivotTables.

And I will be doing another posting for the latest and the greatest All Up Microsoft BI VPC Release 7.1 (BI VPC R7.1) tomorrow, so stay tuned.  I was just informed of the new release this morning for the most recent VPC for download and will be sending out the link information tomorrow morning so that everyone can test drive the Microsoft BI Platform (VPC still utilizes Windows Server 2003 R2 SP2, SQL Server 2005 SP2, PAS 6.3 Hotfix 2215, and PPS 2007 SP1).

Enjoy and happy holidays  Stay tuned for more…

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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: