Cristian's Blog : SQL Server 2008 R2 resources (reloaded)

Thursday, April 22, 2010 10:13 AM xmldeveloper

SQL Server 2008 R2 resources (reloaded)

The SQL Server 2008 R2 RTM is here and with it a lot of new resources.

Test Drive

Webcasts, Videos and events

SQL Server 2008 R2 Virtual Tour
TechNet Webcast: How Microsoft IT Developed Best Practices in Offering PowerPivot as a Service (Level 300)
TechNet Webcast: SQL Server 2008 R2: Server Consolidation (Level 300)
TechNet Webcast: SQL Server 2008 R2: Simplify Management of Your SQL Server Data Platform (Level 300)
SQL Server 2008 R2 Technical Preview: New features and capabilities in SQL Server 2008 R2 Tom Casey, General Manager, SQL Server Business Intelligence (GITCA Fireside Chat)
SQL Server 2008 R2: Self Service Analytics Donald Farmer (GITCA Fireside Chat)
Microsoft Kicking Off SQL Server 2008 R2 Launch Tour at PASS European Conference 2010
24 Hours of PASS: Celebrating SQL Server 2008 R2
For MCT and Educators - MCT & Educator Virtual Summit 2010
SQL Server 2008 R2 Tweetup Video Montage

Blog posts

Books

Documentation

SQL Server 2008 R2 Books Online - downloadable format here
SQL Server 2008 R2 Books Online - What's new
SQL Server 2008 R2 Resource Kit

Whitepapers

E-Learning Clinics (thanks to Greg Low)
- Clinic 10334: Introduction to Managed Self-Service BI with SQL Server 2008 R2 (New)
  [quote]This clinic covers the following topics:
  - Self-service Analysis
  - Self-service Report Authoring
  - Enhancing Report Visualization
  - Managed Self-service BI
  [/quote]
- 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 Parallel Data Warehouse, SQL Virtualization to published soon.
Local Resources

Slides from the SQL Server 2008 R2 launch (in Romanian from Zoli's blog)

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

Filed under: SQL Server 2008 R2, PowerPivot, Master Data Services, StreamInsight, DAX

Comments

No Comments

Anonymous comments are disabled

Cristian's Blog

Search

Tags

Navigation

Archives

Blogs I read

Contact

News

SQL Server 2008 R2 resources (reloaded)

Comments