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 Update – The 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.
Whitepapers
- Office SharePoint Server 2007: Five Ways SharePoint Can Save You Money – When you adopt SharePoint Products and Technologies in your organization, you can: • Reduce IT costs and complexity • Reduce development costs • Simplify management and training • Improve employee productivity • Enhance the effectiveness of customer service and sales teams
- Twelve Ways to Reduce Costs with Microsoft SQL Server 2008 – This white paper describes ways in which organizations can use Microsoft SQL Server 2008 to save time and money.
- Total Economic Impact of SQL Server 2008 Upgrade
- Microsoft SQL Server Migration Pays Big Dividends for SAP/ERP Customers
- Office PerformancePoint Server 2007 end-to-end walkthrough – This paper describes how to install, configure, and use PerformancePoint Planning Server and Monitoring Server so that they can interact with and support the PerformancePoint client applications.
- Publishing PerformancePoint Server in Extranet Scenarios
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.
Patches
- PerformancePoint Server 2007 Hotfixes (since SP2) Available and Build List
- SQL Server 2008 SP1 – SQL Server 2008 SP1 Available and Install Experience – build 2531
- Office 2007 SP2
- Service Pack 2 for Office SharePoint Server 2007 and Windows SharePoint Services 3.0
- Important Notice: A bug in Service Pack 2 could affect the server farm licensing information, for more information, please refer to the new post here: http://blogs.msdn.com/sharepoint/archive/2009/05/21/attention-important-information-on-service-pack-2.aspx
- Windows Vista and Server 2008 SP2 – Windows Server 2008 and Vista SP2 is now available
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.