Learn your way! Get started

SQL Server 2008 R2: What's New

with expert Don Kiely


Course at a glance

Included in these subscriptions:

  • Dev & IT Pro Video
  • Dev & IT Pro Power Pack
  • Power Pack Plus

Release date Release date 12/21/2010
Level Level Advanced
Runtime Runtime 9h 1m
Closed captioning Closed captioning N/A
Transcript Transcript N/A
eBooks / courseware eBooks / courseware Included
Hands-on labs Hands-on labs Included
Sample code Sample code Included
Exams Exams Included


Enterprise Solutions
Enterprise Solutions

Need reporting, custom learning tracks, or SCORM? Learn More



Course description

SQL Server 2008 brought many changes to the SQL platform and the R2 release added many more. This course will help to bring you up to speed on these changes and how they will affect how you work with SQL Server. You will see what is new with installation and security, see its support for managing data-tier applications and a multi-server environment, and learn about PowerPivot, which Microsoft calls "managed self-service business intelligence" that gets BI data in the hands of users who need it. Next you will learn about the new StreamInsight feature that lets you query high-volume data streams for useful nuggets of information and emerging trends. Reporting Services probably received by far the most enhancements in R2 and you will learn about the new expression language and data visualization features. Report Manager and Viewer received major overhauls, and you will see how to put them to good use, as well as exploring how to put Report Builder to use creating great reports.

Meet the expert

Don Kiely Don Kiely is a featured instructor on many of our SQL Server and Visual Studio courses. He is a nationally recognized author, instructor, and consultant specializing in Microsoft technologies. Don has many years of teaching experience, is the author or co-author of several programming books, and has spoken at many industry conferences and user groups. In addition, Don is a consultant for a variety of companies that develop distributed applications for public and private organizations.


Course outline



Module 1

SQL Server 2008 R2 (33:44)
  • Introduction (04:38)
  • Focus of R2 (01:04)
  • What Hasn"t Changed in R2? (01:53)
  • New Top-End Premium Additions (02:47)
  • Features Migrated to Lower Editions (01:10)
  • Summary of Editions (05:28)
  • Enhanced Security (03:21)
  • Credential Forwarding Attacks (04:00)
  • Extended Protection In Windows (03:48)
  • Extended Protection and SQL (01:14)
  • Demo: Activate Extended Protection (04:13)
  • Summary (00:02)
Installation And MDS (29:06)
  • Introduction (00:14)
  • Installation Enhancements (00:34)
  • New Installation Options (02:46)
  • New Command Line Parameters (04:20)
  • Running SQL Server Side-by-Side (01:58)
  • Categories of Components (02:14)
  • Shared Components (02:31)
  • Using Master Data Services (02:38)
  • Master Data Management (02:36)
  • Master Data Services (01:01)
  • MDS Components (03:24)
  • Defining the Data (02:43)
  • Using Master Data (01:38)
  • Summary (00:23)

Module 2

Multi-Server Management (32:06)
  • Introduction (01:12)
  • SQL Server Utility (01:15)
  • Demo: Utility Explorer (03:34)
  • Data-Tier Applications (02:21)
  • Data-Tier Applications (DAC) (03:04)
  • DACs as Collaborative Tool (01:53)
  • Limits & Requirements of DACs (01:05)
  • Limitations on DACs (04:39)
  • Creating Data-Tier Applications (00:52)
  • Demo: Creating a DAC (04:34)
  • Import a DAC (00:48)
  • Demo: Import a DAC (06:41)
  • Summary (00:02)
Data Tier Applications (19:02)
  • Introduction (00:14)
  • Extracting a DAC (01:23)
  • Demo: Extract a DAC (06:05)
  • Working with DACs (01:40)
  • Demo: Working with DACs (04:48)
  • Delete a DAC Registered in SQL (02:26)
  • Demo: Delete a DAC (02:22)
  • Summary (00:02)
Register and Manage DACs (20:28)
  • Introduction (00:14)
  • Register Data-Tier Application (01:04)
  • Demo: Registering Data-Tier (01:53)
  • Upgrading and Updating a DAC (01:23)
  • Updating a DAC: Visual Studio (00:51)
  • Demo: DAC - Visual Studio (14:34)
  • Summary (00:26)

Module 3

Intro to PowerPivot (20:17)
  • Introduction (02:56)
  • Client and Server Tools (02:17)
  • PowerPivot Components (01:39)
  • Data Access Tools (00:53)
  • Importing Data (01:38)
  • PowerPivot Data Types (00:53)
  • PowerPivot Reports (00:56)
  • Working with PowerPivot (00:21)
  • Demo: PowerPivot (08:38)
  • Summary (00:02)
PowerPivot Features (12:20)
  • Introduction (00:14)
  • Demo: Power Pivot Features (04:34)
  • Demo: Relationships (04:59)
  • Demo: Changing Aspects (02:29)
  • Summary (00:02)
Text, Data and Analysis (16:37)
  • Introduction (00:14)
  • Demo: Delimited Text Files (03:40)
  • Demo: Import Linked Tables (04:56)
  • Demo: Create PowerPivot Report (07:17)
  • Summary (00:28)

Module 4

Stream Insite Intro (43:27)
  • Introduction (02:07)
  • Complex Event Processing (CEP) (01:26)
  • CEP Uses (02:15)
  • Queries vs. Event Processing (02:09)
  • Microsoft StreamInsight (01:14)
  • Availability (00:52)
  • StreamInsight Architecture (01:51)
  • Streams (00:50)
  • Events and Data Structures (02:26)
  • Input and Output Adapters (01:32)
  • StreamInsight Base Classes (00:26)
  • Queries (02:20)
  • Installing StreamInsight (01:32)
  • Demo: Installing StreamInsight (02:04)
  • Developing with StreamInsight (00:46)
  • Demo: StreamInsight (19:27)
  • Summary (00:02)
Querying (20:01)
  • Introduction (00:14)
  • Querying a Data Stream (01:06)
  • Demo: Highway Monitor (11:23)
  • Windowing and Aggregation (02:26)
  • Demo: Highway Monitor (03:09)
  • Other Query Options (01:06)
  • Summary (00:34)

Module 5

SSRS Sources and Expressions (28:52)
  • Introduction (01:19)
  • New Data Sources (01:24)
  • Cache Refresh Plans (02:01)
  • Expression Language (00:53)
  • Lookup Functions-Join Datasets (01:29)
  • Lookup Functions Syntax (01:02)
  • Lookup Function (00:18)
  • Demo: Lookup Function (03:41)
  • MultiLookup Function (00:42)
  • Aggregates of Aggregates (01:07)
  • Demo: Aggregates (03:43)
  • RenderFormat (03:18)
  • Demo: RenderFormat (07:45)
  • Summary (00:02)
SSRS Variables and Layout (23:15)
  • Introduction (00:14)
  • Writable Report Variables (00:55)
  • Demo: Writable Report Variable (04:20)
  • Layout Enhancements (01:35)
  • Demo: Layout Enhancements (01:16)
  • Pagination and Page Numbering (02:28)
  • Demo: Pagination and Numbering (12:22)
  • Summary (00:02)
Data Alignment and Atom Feed (17:10)
  • Introduction (00:14)
  • Synchronized Data Alignment (00:32)
  • Demo: Data Alignment (04:22)
  • Report as Atom Data Feed (01:34)
  • Demo: Atom Data Feed (09:57)
  • Summary (00:28)

Module 6

Shared Datasets (24:39)
  • Introduction (01:29)
  • Shared Datasets (01:45)
  • Benefits of Shared Datasets (02:41)
  • Creating Shared Datasets (00:37)
  • Demo: Shared Datasets (16:51)
  • Which Kind of Dataset to Use (01:12)
  • Summary (00:02)
Data Visualization (21:30)
  • Introduction (00:14)
  • Make Report Data Come Alive (01:44)
  • Data Bars (01:44)
  • Demo: Data Bars (03:12)
  • Sparklines (01:13)
  • Demo: Sparklines (06:51)
  • Indicators (02:16)
  • Demo: Indicators (04:11)
  • Summary (00:02)
Mapped Based Data (18:45)
  • Introduction (00:14)
  • Map-Based Data (01:00)
  • Map Data (01:38)
  • Types of Spatial Data (01:11)
  • Layers (00:41)
  • Demo: Map Based Data (13:20)
  • Summary (00:37)

Module 7

Managing Reporting Services (29:38)
  • Introduction (01:15)
  • Reporting Services Tools (01:26)
  • Configuration Manager (01:34)
  • Demo: Configuration Manager (08:39)
  • Reporting Services (00:49)
  • Demo: Management Studio (15:51)
  • Summary (00:02)
Report Manager (44:53)
  • Introduction (00:14)
  • Report Manager (02:22)
  • Starting Report Manager (01:42)
  • Demo: Report Manager (28:14)
  • Report Viewer (00:27)
  • Browser Support (01:43)
  • Demo: Report Viewer (09:17)
  • Summary (00:49)

Module 8

Report Builder and Models (44:31)
  • Introduction (02:17)
  • Report Builder vs. Designer (02:33)
  • Demo: Report Builder (17:08)
  • Installing and Starting (03:28)
  • Standalone vs. ClickOnce (02:52)
  • Creating & Using Report Models (02:40)
  • Create the Model (01:56)
  • Demo: Data Model (11:32)
  • Summary (00:02)
Creating Reports (41:20)
  • Introduction (00:14)
  • Creating Reports (00:33)
  • Demo: Creating Reports (12:52)
  • Preview Performance (03:37)
  • Cache Refresh (01:12)
  • Using Report Parts (02:58)
  • Demo: Report Parts (08:20)
  • Using Reports with SharePoint (02:46)
  • Integrated Mode (02:54)
  • Native Mode (02:43)
  • Viewing Reports in Native Mode (00:32)
  • Demo: SharePoint (02:19)
  • Summary (00:14)