Cristian's Blog : SQL Server 2008 R2 resources

Sunday, April 11, 2010 9:53 AM xmldeveloper

SQL Server 2008 R2 resources

With SQL Server 2008 R2 RTM knocking at the door a list with R2 resources may come in handy.
So here you are:

SQL Server 2008 R2 Update for Developers Training Kit (April 2010 Update)
[quote]
The SQL Server 2008 R2 Update for Developers Training Kit is ideal for developers who want to understand how to take advantage of the key improvements introduced in SQL Server 2008 and SQL Server 2008 R2 in their applications, as well as for developers who are new to SQL Server.
[/quote]
It contains presentations (22), demos (29), hands-on labs (18), videos (35) as well as an utility to help configuring your computer for running the demos.
E-Learning Clinics (thanks to Greg Low)

Clinic 10331: Introduction to Microsoft SQL Server 2008 R2 Master Data Services
[quote] This clinic covers the following topics:Master Data Services concepts, hierarchies, how to plan and implement Master Data Services Projects. [/quote]
Clinic 10335: Introduction to Microsoft SQL Server 2008 R2 StreamInsight
[quote] This clinic covers the following topics:
- StreamInsight core concepts
- Querying Stream-based Events
- Designing and Working with Event Models
- Hosting Queries and configuring Adapters
[/quote]
Clinic 10336: Introduction to SQL Server 2008 R2 Application and Multi-Server Management
[quote]
This clinic covers the following topics:
- Introducing Application and Multi-server Management
- Working with data-tier applicationsManaging change in data-tier applications.
- Managing data-tier applications
[/quote]
Clinic 10332: Introduction to Microsoft SQL Azure
Obviously this clinic is not related to SQL Server 2008 R2 but it's worth mentioning it :) [quote]
This clinic covers the following topics:
- Understanding the SQL Azure Platform
- Designing Applications for SQL Azure
- Migrating Applications to SQL Azure
- Achieving Scale with SQL Azure
[/quote]
Clinics on Self-Service BI and Reporting, Parallel Data Warehouse, SQL Virtualization to published soon.

Rafal Lukawiecki - BI with Microsoft SQL Server 2008 R2 and Microsoft Office System 2010 (event slides - source: Zoli's blog)

Session 1: The Big Picture of Business Intelligence: Goals, Concepts, and the Platform
This session will introduce the overall picture of Business Intelligence and will relate the Microsoft BI Platform to it.
Session 2: The Knowledge Worker’s Perspective: Self-Service of BI
This session will concentrate on how Office System 2010, in particular SharePoint 2010 and its PerformancePoint Services enable anyone to create and use BI in an organization. We will also introduce the very new Microsoft Power Pivot stressing how existing Excel skills enable self-service analysis and also mention other self-service aspects of BI, such as self-service reporting. This session will also discuss the IT Professional challenge of managing the life cycle of a potentially fast, organically growing BI system built by its users.
Session 3: The IT Perspective: Data Warehousing, Management, and Analytical Structures
This session aims to take a look at BI capabilities of the SQL Server 2008 R2. We will introduce Master Data Management and new approaches to massive Data Warehousing.
Session 4: The Analyst’s Perspective: Ad-hoc Analysis with Microsoft Power Pivot and Office 2010 Excel
We will introduce a new language for analysis known as DAX which can help more advanced users create powerful analytical applications all inside Excel and PowerPivot. Finally, we will review the existing Data Mining technologies of SQL Server 2008 R2.
Summary: Microsoft BI for Your Enterprise

Enjoy!

No Comments

Anonymous comments are disabled