Dan English's BI Blog

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

2009 Download Catch-up List

Posted by denglishbi on May 31, 2009

Over the first part of the 2009 year I have downloaded numerous training items, whitepapers, applications, and patches and just wanted to take a little time this weekend to put out a list of items to share that I believe will be useful if you haven’t come across them yet.  Some of these maybe a little older, I might have posted about them already, or you might already know about them, but just want to put them out there just in case.  Not all of these are strictly SQL Server or Business Intelligence related, so just want to warn you.  You can share the information with someone else that might benefit from reviewing the material though.

Training Items

  • Hands-On Labs for Enterprise Library 4.1 – Use this set of Hands-on Labs as a guide to learn about the application blocks included with Enterprise Library 4.1 and practice how to leverage their capabilities in various application contexts. It includes Caching, Cryptography, Data Access, Exception Handling, Interception, Logging, Security, Validation, and Unity Hands-on Labs.
  • Azure Services Training Kit – April UpdateThe Azure Services Training Kit includes a comprehensive set of technical content including hands-on labs, presentations, and demos that are designed to help you learn how to use the Azure Services Platform.
  • Office SharePoint Server 2007 Technical Library in Compiled Help format – This downloadable CHM is a copy of content in the Microsoft Office SharePoint Server 2007 technical library. The CHM is current as of the date above. For the latest information, see the technical library on the Web.
  • SQL Server 2008 Developer Training Kit (SQL Server 2008 Developer Toolkit feedback)- SQL Server 2008 offers an impressive array of capabilities for developers that build upon key innovations introduced in SQL Server 2005. The SQL Server 2008 Developer Training Kit will help you understand how to build web applications which deeply exploit the rich data types, programming models and new development paradigms in SQL Server 2008.
  • SQL Server 2008 R2 Information and New Site – also sign up for CTP notifications on the new site.
  • IT Operations Scorecards and Dashboards – PerformancePoint Server monitoring sample available.  There is a video, whitepaper, and code sample files for download.
  • Microsoft SQL Server 2008 Books Online (May 2009) – SQL Server 2008, the latest release of Microsoft SQL Server, provides a comprehensive data platform. Books Online is the primary documentation for SQL Server 2008.
  • Demo Showcase 2008 Application Platform Optimization Demos – The Demo Showcase 2008 APO Demos are a set of 4 comprehensive click through demonstrations designed for partners to use with customers. These customer scenario demos feature many different Microsoft technologies working together to showcase the power of the App Plat Optimization capabilities. Included in the scenarios are the following products: Windows Server 2008, SQL Server 2008, Office Enterprise 2007, Visual Studio 2008, Windows Vista, Silverlight, Performance Point Server 2007 and more.


Applications (all FREE)

  • SharePoint Designer 2007 – SHAREPOINT DESIGNER 2007 IS NOW FREE! Learn more about these changes and future direction (watch the FAQ video link below). Office SharePoint Designer 2007 provides the powerful tools you need to deliver compelling and attractive SharePoint sites and quickly build workflow-enabled applications and reporting tools on the SharePoint platform, all in an IT-managed environment. Video of SharePoint Designer 2007 FAQ (16.8MB)
  • BIDS Helper – A Visual Studio .Net add-in with features that extend and enhance the functionality of the SQL Server 2005 and SQL Server 2008 BI Development Studio (BIDS).  This is a must have tool if you are doing any BI development with BIDS (SSAS, SSIS, or SSRS).
  • ZoomIt – ZoomIt is a screen zoom and annotation tool for technical presentations that include application demonstrations. ZoomIt runs unobtrusively in the tray and activates with customizable hotkeys to zoom in on an area of the screen, move around while zoomed, and draw on the zoomed image.
  • Report Builder 2.0 with SP1 (stand-alone) – Features specific to Report Builder 2.0 are focused on simplifying the process of creating and editing reports and queries and include the following: Easy to use wizards for creating table, matrix and chart data regions; Support for directly opening and editing reports stored on the report server; Support for using server resources such as shared data sources; Query designers for multiple data sources including a Microsoft SQL Server-specific query designer. (this tool does require a SQL Server 2008 license – Report Builder Licensing – you do need to so just be aware of this)
  • Data Mining Add-ins for Microsoft Office 2007 – Microsoft SQL Server 2005 or Microsoft SQL Server 2008 enables you to take advantage of SQL Server predictive analytics in Office Excel 2007 and Office Visio 2007.
  • BI Report Automation Publisher – for moving PerformancePoint Server items between environments and will work with Workspace files. The BI Report Automation Publisher is a command line tool + .net library which provides a more automated way to move data sources and reports between servers/environments.
  • Collecting Analysis Services Performance Data for Performance Analysis – ability to collect and gather information from Analysis Services using trace files, performance monitoring tools, and DMVs.  Includes all documentation, scripts, SSIS packages, trace files, XMLA scripts, SSRS reports, etc. to get started.


I think that covers the majority of it for now.  Lots of different items and plenty of stuff to keep you busy for a few weeks.  Enjoy! 

By the way, don’t forget to check out the Microsoft BI blog.  There have been lots of useful postings added recently with videos in regards to mobile BI, Excel 2007 Data Mining Add-in, Gemini demos, etc.

UPDATE (7/15/2009): While you can download Report Builder 2.0 this product does require a SQL Server 2008 license – Report Builder Licensing – you do need to.

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: