SQL Server 2008 R2 Update for Developers Training Kit (June 2010 Update) – RTM Refresh Released!
Today Roger announced in his blog the availability of the SQL Server 2008 R2 Update for Developers Training Kit (June 2010 Update). This is the final update for this training kit and includes two additional modules covering SQL Server 2008 R2 related improvements in Excel 2010 and SharePoint 2010. Additionally, there were many updates to the original content in previous versions of the training kit to address changes in the final RTM release of SQL Server 2008 R2 (e.g. some UI changes, modifications in the API, minor bug fixing, etc).
You can download this new release at:
- http://go.microsoft.com/?linkid=9710868 (notice that is the same URL of previous releases)
New modules added to the Training Kit
As I said previously, the Excel 2010 and SharePoint 2010 modules were included in the RTM release related with SQL Server 2008 R2 improvements:
Excel 2010: Excel is the most popular data analysis tool in the world, and Excel 2010 offers a range of powerful data analysis and visualization improvements that makes it the ideal self-service analysis client. Slicers are new visual controls that provide quick, easy and interactive filtering. Sparklines are intense, simple word-sized graphics that make it easy to visualize data in-line with numbers. PivotTables support powerful new capabilities like named sets, what-if analysis (write-back), and pre-built calculations like percent of total, running totals and ranks. Charting has also been improved with an easier user interface, faster performance and expanded limits. SQL Server 2008 R2 introduces PowerPivot for Excel, a free Excel add-in that makes it possible for information workers to create their own powerful analytic models by combining and relating data from a wide variety of data sources.
SharePoint 2010: SharePoint 2010 is the most popular business collaboration platform in the world for organizations of all sizes, and SharePoint 2010 Insights lets everyone access the business information they need to make good decisions. SharePoint 2010 Insights uses well-known applications and interfaces, people are comfortable from the start, and they know how to get the data they need. Excel Services makes it easy for anyone to publish their Excel workbooks in SharePoint 2010, including workbooks that use data from SQL Server 2008 R2 Analysis Services. From there, an entire team can access and analyze the same data from their web browser and rest assured that everyone has the right information. PerformancePoint Services is a new integrated capability in SharePoint 2010 Enterprise Edition that makes it easy to build flexible, highly interactive scorecards and dashboards using data from SQL Server 2008 R2 Analysis Services. SQL Server 2008 R2 PowerPivot for SharePoint makes it easy to publish analytic models created with SQL Server PowerPivot for Excel to SharePoint 2010 and share them with other users with Excel Services. SQL Server 2008 R2 Reporting Services supports SharePoint 2010 integration, making it easy to publish and access reports using familiar SharePoint paradigms.
Requirements
- Microsoft SQL Server 2008 R2
- Microsoft Visual Studio 2010
- Microsoft Office 2010 Excel
- Microsoft SQL Server PowerPivot for Excel
- Microsoft SQL Server 2008 R2 StreamInsight
- Microsoft SQL Server 2008 R2 Report Builder 3.0
- Microsoft SharePoint Server 2010
Enjoy
Mariano


