Dan English's BI Blog

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

Archive for December 13th, 2008

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…

Posted in Downloads | Tagged: | Leave a Comment »

MSDN Forums new look official

Posted by denglishbi on December 13, 2008

So the old forums area was locked down on 12/11 and moved over to the new Social format [MSDN Forums moving…tomorrow (12/8)].  Here is a link to some of the areas that I visit frequently and also subscribe to feeds so I can reply to posting and stay informed of postings and resolutions.  Great content available in the forums and strongly encourage people to use them for FAQs, knowledge center, and great information.

Looks like my history for past 30-days might have been wiped out for contributing to the forums (refer to my previous posting about the forums moving above).  I went in and checked my forum threads and my threads and no history That is irritating because I liked to reference the threads that I had contributed to and reference the information.  So now what?

Anyway, just want to post that this is available and in a new format.  If you are not using the Microsoft forums yet, then please start, you won’t be disappointed in viewing the information or posting questions.  This is an excellent way to contribute to the community and find resolution to your issues or solutions that you are currently working on.

Here is the list of all of the forum areas with the new link references:

  • MSDN
  • TechNet
  • Expression
  • Microsoft
  • Posted in Personal Comments | Leave a Comment »