Oreilly - Microsoft SQL Server 2008 R2: In-Depth Training for Developers
by | Released March 2011 | ISBN: 01201000048TG
The goal of the SQL Server 2008 R2 Update for Developers Training Course is to provide information about the improvements introduced in SQL Server 2008 and the new features added in SQL Server 2008 R2. Its primary audience is solution architects and developers who are familiar with SQL Server, and also developers who are new to SQL Server and want to learn the basics. The content focuses on development aspects and illustrates how to design more effective database applications that take advantage of improved capabilities in SQL Server. This version of the training course is designed to work best with the SQL Server 2008 R2. Show and hide more
- Lesson 1: SQL Server 2008 R2 - Overview
- SQL Server 2008 R2 Update for Developers Overview Part II - Introducing SQL Server 2008 R2 00:22:54
- Introducing SQL Server 2008 R2 Application and Multi-Server Management 00:25:49
- Introducing SQL Server 2008 R2 StreamInsight 00:23:26
- Introducing SQL Server 2008 R2 Reporting Services 00:20:45
- Introducing SharePoint 2010 PerformancePointServices 00:13:00
- Lesson 2: SQL Server 2008 R2 - Application and Multi-Server Management
- Introducing Application and Multi-Server Management with SQL Server 2008 R2 and Visual Studio 2010 00:11:12
- Creating a Utility Control Point 00:08:30
- Lesson 3: SQL Server 2008 R2 - StreamInsight
- Real Time Analytics with SQL Server 2008 R2 StreamInsight 00:17:26
- Demo: Introducing SQL Server 2008 R2 StreamInsight 00:04:48
- Querying Events in SQL Server 2008 R2 StreamInsight(Part I) 00:09:22
- Demo: Querying SQL Server 2008 R2 StreamInsightUsing LINQ 00:13:20
- Querying Events in SQL Server 2008 R2 StreamInsight(Part II) 00:07:29
- Advanced SQL Server 2008 R2 StreamInsightEvent Queries 00:07:48
- Designing SQL Server 2008 R2 StreamInsightEvent Models and Adapters (Part I) 00:07:14
- Designing SQL Server 2008 R2 StreamInsightEvent Models and Adapters (Part II) 00:04:37
- Designing SQL Server 2008 R2 StreamInsightEvent Models and Adapters (Part III) 00:05:38
- Working with SQL Server 2008 R2 StreamInsightCTI Events and Advance Time Settings 00:05:27
- Demo: Creating a SQL Server 2008 R2 StreamInsightInput Adapter 00:03:45
- Installing, Deploying and Maintaining SQL Server 2008 R2 StreamInsight(Part I) 00:04:57
- Installing, Deploying and Maintaining SQL Server 2008 R2 StreamInsight(Part II) 00:02:12
- Installing, Deploying and Maintaining SQL Server 2008 R2 StreamInsight(Part III) 00:05:07
- Demo: Choosing a SQL Server 2008 R2 StreamInsightDevelopment Model 00:03:58
- Demo: Using the SQL Server 2008 R2 StreamInsightEvent Flow Debugger 00:04:48
- Lesson 4: SQL Server 2008 R2 - Reporting Services
- What's New in SQL Server 2008 R2 Reporting Services 00:16:30
- Developing Reports with the New Features of SQL Server 2008 R2 Reporting Services 00:16:24
- Demo: Using the New Report Design Features in SQL Server 2008 R2 Reporting Services 00:16:30
- Visualizing Data with Maps in SQL Server 2008 R2 Reporting Services 00:15:33
- Demo: Visualizing Data with Maps in SQL Server 2008 R2 Reporting Services 00:14:25
- Working with Shared Components in SQL Server 2008 R2 Reporting Services 00:12:30
- Demo: Using Shared Component Libraries in SQL Server 2008 R2 Reporting Services 00:13:56
- Working with ATOM Data Feeds in SQL Server 2008 R2 Reporting Services 00:12:04
- Demo: Using SQL Server 2008 R2 Reporting Services Report Feeds 00:09:14
- Embedded Reporting in Applications 00:11:17
- Developing with the Microsoft Chart Controls in Visual Studio 2010 00:09:37
- Lesson 5: Excel 2010 and SQL Server
- What's New in the Excel 2010 Client 00:13:24
- Demo: What's New in the Excel 2010 Client 00:14:13
- Loading and Preparing Data for Analysis in SQL Server PowerPivot for Excel 2010 00:17:41
- Demo: Loading and Preparing Data for Analysis in SQL Server PowerPivot for Excel 2010 00:17:25
- Creating Reports with SQL Server PowerPivot for Excel 2010 00:09:15
- Demo: Creating Reports with SQL Server PowerPivot for Excel 2010 00:16:11
- Defining DAX Calculations with PowerPivot for Excel 2010 00:15:25
- Demo: Defining DAX Calculations with SQL Server PowerPivot for Excel 2010 00:15:23
- Lesson 6: SharePoint 2010 Insights and SQL Server
- Introducing SharePoint 2010 Insights 00:12:51
- Demo: Introducing SharePoint 2010 Insights 00:24:16
- What's New in SharePoint 2010 Excel Services 00:14:16
- Demo: What's New in SharePoint 2010 Excel Services 00:16:07
- What's New in SharePoint 2010 PerformancePointServices 00:11:21
- Demo: What's New in SharePoint 2010 PerformancePointServices 00:06:52
- Developing KPI's and Scorecards with SharePoint 2010 PerformancePointServices 00:30:24
- Demo: Developing KPI's and Scorecards with SharePoint 2010 PerformancePointServices 00:14:31
- Developing Reports and Dashboards with SharePoint 2010 PerformancePointServices 00:25:34
- Demo: Developing Reports and Dashboards with SharePoint 2010 PerformancePointServices 00:17:47
- Managing Excel 2010 PowerPivot Solutions in SharePoint 2010 00:15:37
- Demo: Managing Excel 2010 PowerPivot Solutions in SharePoint 2010 00:21:55
Show and hide more 01201000048TG.microsoft.sql.server.OR.part1.rar
01201000048TG.microsoft.sql.server.OR.part2.rar
01201000048TG.microsoft.sql.server.OR.part3.rar
TO MAC USERS: If RAR password doesn't work, use this archive program:
RAR Expander 0.8.5 Beta 4 and extract password protected files without error.
TO WIN USERS: If RAR password doesn't work, use this archive program:
Latest Winrar and extract password protected files without error.