SQL Server 2008 R2 - Overview

SQL Server 2008 R2 introduces several breakthrough capabilities that make it the ideal data platform for Software-plus-Services. This section provides content that will give you a high-level overview of these improvements.

Visual Studio 2010 introduces a new database project type known as a Data-tier application (DACPAC) that greatly simplifies the development, deployment and maintenance of database applications. DBA's can deploy DACPAC's to SQL Server 2008 R2 in a single step without having to waste time analyzing cryptic Transact-SQL scripts. SQL Server 2008 R2 will even handle automatic upgrades to a new version of a DACPAC.

Microsoft SQL Server 2008 R2 StreamInsight is a platform for developing Complex Event Processing (CEP) applications with the .NET Framework. Complex Event Processing applications provide a range of data processing capabilities that are appropriate for workloads that need to process very high volumes of event stream data with very low latency.

Microsoft SQL Server 2008 R2 Reporting Services introduces several exciting new features for report development, like the Map Wizard to create map reports in the Report Designer of SQL Server Business Intelligence Development Studio, the usage of lookup functions in report expressions, and the ability to create ATOM data feeds from reports.

PowerPivot is a new in-memory analytics engine that makes it easy for information workers to create their own powerful analytic models in Excel 2010 from multiple data sources without having to know how to build a cube. Information workers can then share their PowerPivot models with other users by publishing them to PowerPivot for SharePoint 2010.

PerformancePoint Services is an integrated capability of SharePoint 2010 that makes it easy to build rich, interactive scorecards and dashboards from data in SQL Server 2008 R2 Analysis Services.

Lessons

Video: Introducing PowerPivot for Excel 2010 and SharePoint 2010
The barbarians are at the gate! Information Workers want great analytical tools to work with their data and they want them now! While you can build sophisticated reporting and analytics solutions with SQL Server Analysis Services and SQL Server Reporting Services, you might not be able to build…
Hands On Lab: Data-tier Applications in SQL Server 2008 R2 and Visual Studio 2010
This hands-on Lab shows how to perform the basic steps in creating, developing, deploying, managing and upgrading a Data-tier Application (DAC) using the new features in Microsoft SQL Server 2008 R2 and Microsoft Visual Studio 2010. It also shows some of the new IDE tools and enhancements included…
Hands On Lab: Using the New Features of Reporting Services 2008 R2
This hands-on lab introduces the new features included in Microsoft SQL Server 2008 R2 Reporting Services like the Map Wizard to display geospatial data, the lookup functions in report expressions so that data from multiple datasets can be shown in a single data region and the capability to export…
Hands On Lab: PowerPivot in SQL Server 2008 R2
This hands-on lab introduces to the Microsoft SQL Server PowerPivot for Excel 2010 add-in and shows how to load data into it and how to create PowerPivot pivot tables. It also introduces DAX expressions for multidimensional calculations against PowerPivot data and explains how to publish…
Presentation: SQL Server 2008 R2 Update for Developers Part II - Introducing SQL Server 2008 R2
This second presentation in a two-part series provides an overview of the key improvements in SQL Server 2008 R2 from a developer perspective in the context of Microsoft's overall strategy for Software-plus-Services (S+S).
Presentation: SQL Server 2008 R2 Update for Developers Overview Part II - Introducing SQL Server 2008 R2
This second presentation in a two-part series provides an overview of the key improvements in SQL Server 2008 R2 from a developer perspective in the context of Microsoft's overall strategy for Software-plus-Services (S+S). Presenter: Roger Doherty, Sr. Technical Evangelist. DPE.
Video: Introducing SQL Server 2008 R2 Application and Multi-Server Management
Becoming the most popular database platform in the world has its downside. SQL Server instances and applications are popping up all over the place and usually no one has a clue if they are being properly utilized. What's a poor DBA to do? Enter Application and Multi-Server Management, a tightly…
Video: Introducing SQL Server 2008 R2 StreamInsight
Have you ever had to work with data that is coming at you so fast in such high volume that you can't keep up? That's the domain of StreamInsight, a powerful new development platform for building a new category of SQL Server applications known as Complex Event Processing. Presenters: Roger Doherty,…
Demo: Real Time Analytics with SQL Server 2008 R2 StreamInsight
This video provides a real-world example of SQL Server 2008 R2 StreamInsight in action. Microsoft Media Analytics is a Software-plus-Services application used to monitor Silverlight usage for major media events at a massive consumer scale. StreamInsight helps provide real-time monitoring and…
Video: Introducing SQL Server 2008 R2 Reporting Services
Did you ever want to build a report that plots data on a map? Have you ever wanted to view your data and charts together on the same row? Have you ever wanted to build a report from shared parts instead of starting from scratch? SQL Server 2008 R2 Reporting Services enables all of these things and…
Presentation: Introducing Application and Multi-Server Management with SQL Server 2008 R2 and Visual Studio 2010
Describes the challenges associated with managing multiple servers and the investments Microsoft have made to date in this area. Introduces the concept of the SQL Server Utility. Presenter: Dr. Greg Low, MD and Mentor, SolidQ Australia.
Demo: Creating a Utility Control Point
Shows how to create a SQL Server Utility Control Point in SQL Server Management Studio and then shows how to use the Utility Explorer to monitor organizational SQL Server health. Presenter: Dr. Greg Low, MD and Mentor, SolidQ Australia.
Demo: Enrolling a Managed Instance
Shows how to enroll a managed instance of SQL Server with the SQL Server Utility by using SQL Server Management Studio. Later shows how the process could be achieved using Powershell. Presenter: Dr. Greg Low, MD and Mentor, SolidQ Australia.
Presentation: Working with Data Tier Application Projects in Visual Studio 2010
Introduces the concept of a data-tier application and contrasts it with a database project. Presenter: Dr. Greg Low, MD and Mentor, SolidQ Australia.
Demo: Creating Data-Tier Applications
Shows how to create a data-tier application and shows the enhanced T-SQL development experience provided by Visual Studio 2010. Presenter: Dr. Greg Low, MD and Mentor, SolidQ Australia.
Demo: Data-Tier Application Deployment
Shows how to deploy a data-tier application via both Visual Studio 2010 and SQL Server Management Studio. Presenter: Dr. Greg Low, MD and Mentor, SolidQ Australia.
Presentation: Managing Change in Data Tier Application Projects in Visual Studio 2010 (Part I)
Provides an overview of managing application change when using data-tier applications. Presenter: Dr. Greg Low, MD and Mentor, SolidQ Australia.
Presentation: Managing Change in Data Tier Application Projects in Visual Studio 2010 (Part II)
Describes the overall life-cycle of a data-tier application, how to work with .dacpac files and potential futures for data-tier applications. Presenter: Dr. Greg Low, MD and Mentor, SolidQ Australia.
Demo: Managing Change in Data Tier Application Projects in Visual Studio 2010
Shows how to deploy changes to a managed application. Presenter: Dr. Greg Low, MD and Mentor, SolidQ Australia.
Video: Introducing SharePoint 2010 PerformancePoint Services
SharePoint is becoming ubiquitous. Sure, you can enable great collaboration capabilities with this powerful platform, but did you know you can also use it to stay on top of how your organization is performing? PerformancePoint Services is a new integrated capability in SharePoint 2010 Enterprise…

SQL Server 2008 R2 - Overview

Lessons

The Team