SQL Server 2008 R2 Training Kit

-

If you want to start working with the new features in SQL Server 2008 R2, you need to download the SQL Server 2008 R2 Update for Developers Training Kit, is avaiable at http://www.microsoft.com/downloads/details.aspx?familyid=FFFAAD6A-0153-4D41-B289-A3ED1D637C0D&displaylang=en

The training kit offers the following benefits:

  • Learn how to build applications that exploit the unique features and capabilities of SQL Server 2008 and SQL Server 2008 R2.
  • Provides a comprehensive set of videos, presentations, demos and hands-on labs
  • Contains new content for developers who are new to SQL Server.
  • Contains new content for SQL Server 2008 R2.
  • Contains all of the existing content from the SQL Server 2008 Developer Training Kit.
  • Easy to download and install.

 

Contents
The training kit includes the following content:

  • Presentations (22)
    • SQL Server 2008 R2 Update for Developers Overview Part I - SQL Server 2008 Review
    • SQL Server 2008 R2 Update for Developers Overview Part II - Introducing SQL Server 2008 R2
    • SQL Server 2008: Filestream
    • SQL Server 2008: Spatial
    • SQL Server 2008: T-SQL
    • SQL Server 2008: Date and Time Types
    • SQL Server 2008: SQLCLR
    • SQL Server 2008: Reporting Services
    • SQL Server 2008 R2: Introducing Application and Multi-Server Management with SQL Server 2008 R2 and Visual Studio 2010
    • SQL Server 2008 R2: Working with Data Tier Application Projects in Visual Studio 2010
    • SQL Server 2008 R2: Managing Change in Data Tier Application Projects with Visual Studio 2010 and SQL Server 2008 R2
    • SQL Server 2008 R2: Introducing SQL Server 2008 R2 StreamInsight
    • SQL Server 2008 R2: Querying Events in SQL Server 2008 R2 StreamInsight
    • SQL Server 2008 R2: Designing SQL Server 2008 R2 StreamInsight Event Models and Adapters
    • SQL Server 2008 R2: Installing, Deploying and Maintaining the SQL Server 2008 R2 StreamInsight Runtime Engine
    • SQL Server 2008 R2: What's New in SQL Server 2008 R2 Reporting Services
    • SQL Server 2008 R2: Developing Reports with the New Features of SQL Server 2008 R2 Reporting Services
    • SQL Server 2008 R2: Visualizing Data with Maps in SQL Server 2008 R2 Reporting Services
    • SQL Server 2008 R2: Working with Shared Components in SQL Server 2008 R2 Reporting Services
    • SQL Server 2008 R2: Working with ATOM Data Feeds in SQL Server 2008 R2 Reporting Services
    • SQL Server 2008 R2: Embedded Reporting in Applications with SQL Server 2008 R2 Reporting Services and Visual Studio 2010
    • SQL Server 2008 R2: Developing with the Microsoft Chart Controls in Visual Studio 2010
  • Demos (29)
    • SQL Server 2008: AdventureWorks Racing All-Up Demo
    • SQL Server 2008: Spatial Demo
    • SQL Server 2008: Spatial Types
    • SQL Server 2008: Introduction to Filestream
    • SQL Server 2008: SQL CLR Nullable Types
    • SQL Server 2008: Programming with Filestream
    • SQL Server 2008: Reporting Services Web Application Integration
    • SQL Server 2008: T-SQL Date and Time Support
    • SQL Server 2008: T-SQL Table-Valued Parameters
    • SQL Server 2008: T-SQL Row Constructors
    • SQL Server 2008: T-SQL Grouping Sets
    • SQL Server 2008: T-SQL Merge
    • SQL Server 2008 R2: Creating a Utility Control Point
    • SQL Server 2008 R2: Enrolling a Managed Instance
    • SQL Server 2008 R2: Creating Data-Tier Applications
    • SQL Server 2008 R2: Data-Tier Application Deployment
    • SQL Server 2008 R2: Managing Change in Data Tier Application Projects in Visual Studio 2010
    • SQL Server 2008 R2: Introducing SQL Server 2008 R2 StreamInsight
    • SQL Server 2008 R2: Querying Events in SQL Server 2008 R2 StreamInsight
    • SQL Server 2008 R2: Advanced SQL Server 2008 R2 StreamInsight Event Queries
    • SQL Server 2008 R2: Working with SQL Server 2008 R2 StreamInsight CTI Events and Advance Time Settings
    • SQL Server 2008 R2: Creating a SQL Server 2008 R2 StreamInsight Input Adpater
    • SQL Server 2008 R2: Choosing a SQL Server 2008 R2 StreamInsight Development Model
    • SQL Server 2008 R2: Using the SQL Server 2008 R2 StreamInsight Event Flow Debugger
    • SQL Server 2008 R2: Using the New Report Design Features in SQL Server 2008 R2 Reporting Services
    • SQL Server 2008 R2: Visualizing Data with Maps in SQL Server 2008 R2 Reporting Services
    • SQL Server 2008 R2: Using Shared Component Libraries in SQL Server 2008 R2 Reporting Services
    • SQL Server 2008 R2: Using SQL Server 2008 R2 Reporting Services Report Feeds
    • SQL Server 2008 R2: Using the Visual Studio 2010 Report Viewer Control
  • Hands-on Labs (18)
    • SQL Server 2008: How to build your first Web Application with SQL Server and ASP.NET
    • SQL Server 2008: Using Spatial Data in TSQL
    • SQL Server 2008: Using Spatial Data in Managed Code
    • SQL Server 2008: Using SQL CLR in SQL Server 2008
    • SQL Server 2008 R2: Introduction to PowerPivot
    • SQL Server 2008 R2: Introduction to Reporting Services Improvements
    • SQL Server 2008 R2: Introduction to StreamInsight and Complex Event Processing
    • SQL Server 2008 R2: Introduction to Data-tier Applications
    • SQL Server 2008 R2: Creating and Deploying a Data-Tier Application
    • SQL Server 2008 R2: Managing Change in Data-Tier Application Projects in Visual Studio 2010
    • SQL Server 2008 R2: Querying Events in SQL Server 2008 R2 StreamInsight using LINQ
    • SQL Server 2008 R2: Working with the SQL Server 2008 R2 StreamInsight Samples
    • SQL Server 2008 R2: Working with the SQL Server 2008 R2 StreamInsight Event Flow Debugger
    • SQL Server 2008 R2: Visualizing Data with Maps in SQL Server 2008 R2 Reporting Services
    • SQL Server 2008 R2: Developing and Consuming Report Libraries in SQL Server 2008 R2 Reporting Services
    • SQL Server 2008 R2: Working with ATOM Data Feeds in SQL Server 2008 R2 Reporting Services
    • SQL Server 2008 R2: Embedded Reporting in Applications with SQL Server 2008 R2 Reporting Services and Visual Studio 2010
    • SQL Server 2008 R2: Developing with the Microsoft Chart Controls
  • Videos (35)
    • SQL Server 2008 R2 Update for Developers Overview Part I - SQL Server 2008 Review
    • SQL Server 2008 R2 Update for Developers Overview Part II - Introducing SQL Server 2008 R2
    • Introducing SQL Server 2008 R2 StreamInsight
    • Demo: Real Time Analytics with SQL Server 2008 R2 StreamInsight
    • Introducing SQL Server 2008 R2 Application and Multi-Server Management
    • Introducing SQL Server 2008 R2 Reporting Services
    • Introduction To SQL Server 2008 R2 StreamInsight and Complex Event Processing
    • Introducing PowerPivot for Excel 2010 and SharePoint 2010
    • Presentation: Introducing Application and Multi-Server Management with SQL Server 2008 R2 and Visual Studio 2010
    • Demo: Creating a Utility Control Point
    • Demo: Enrolling a Managed Instance
    • Presentation: Working with Data Tier Application Projects in Visual Studio 2010
    • Demo: Creating Data-Tier Applications
    • Demo: Data-Tier Application Deployment
    • Presentation: Managing Change in Data Tier Application Projects with Visual Studio 2010 and SQL Server 2008 R2 (Part I)
    • Presentation: Managing Change in Data Tier Application Projects with Visual Studio 2010 and SQL Server 2008 R2 (Part II)
    • Demo: Managing Change in Data Tier Application Projects in Visual Studio 2010
    • Presentation: Introducing SQL Server 2008 R2 StreamInsight (Part I)
    • Presentation: Introducing SQL Server 2008 R2 StreamInsight (Part II)
    • Demo: Introducing SQL Server 2008 R2 StreamInsight
    • Presentation: Querying Events in SQL Server 2008 R2 StreamInsight (Part I)
    • Presentation: Querying Events in SQL Server 2008 R2 StreamInsight (Part II)
    • Demo: Querying SQL Server 2008 R2 StreamInsight Using LINQ
    • Presentation: Querying Events in SQL Server 2008 R2 StreamInsight (Part III)
    • Demo: Advanced SQL Server 2008 R2 StreamInsight Event Queries
    • Presentation: Designing SQL Server 2008 R2 StreamInsight Event Models and Adapters (Part I)
    • Presentation: Designing SQL Server 2008 R2 StreamInsight Event Models and Adapters (Part II)
    • Demo: Working with SQL Server 2008 R2 StreamInsight CTI Events and Advance Time Settings
    • Presentation: Designing SQL Server 2008 R2 StreamInsight Event Models and Adapters (Part III)
    • Demo: Creating a SQL Server 2008 R2 StreamInsight Input Adapter
    • Presentation: Installing, Deploying and Maintaining the SQL Server 2008 R2 StreamInsight Runtime Engine (Part I)
    • Presentation: Installing, Deploying and Maintaining the SQL Server 2008 R2 StreamInsight Runtime Engine (Part II)
    • Demo: Choosing a SQL Server 2008 R2 StreamInsight Development Model
    • Presentation: Installing, Deploying and Maintaining the SQL Server 2008 R2 StreamInsight Runtime Engine (Part III)
    • Demo: Using the SQL Server 2008 R2 StreamInsight Event Flow Debugger
    • resentation: What's New in SQL Server 2008 R2 Reporting Services
    • Presentation: Developing Reports with the New Features of SQL Server 2008 R2 Reporting Services
    • Demo: Using the New Report Design Features in SQL Server 2008 R2 Reporting Services
    • Presentation: Visualizing Data with Maps in SQL Server 2008 R2 Reporting Services
    • Demo: Visualizing Data with Maps in SQL Server 2008 R2 Reporting Services
    • Presentation: Working with Shared Components in SQL Server 2008 R2 Reporting Services
    • Demo: Using Shared Component Libraries in SQL Server 2008 R2 Reporting Services
    • Presentation: Working with ATOM Data Feeds in SQL Server 2008 R2 Reporting Services
    • Demo: Using SQL Server 2008 R2 Reporting Services Report Feeds
    • Presentation: Embedded Reporting in Applications with SQL Server 2008 R2 Reporting Services and Visual Studio 2010
    • Demo: Using the Visual Studio 2010 Report Viewer Control
    • Presentation: Developing with the Microsoft Chart Controls in Visual Studio 2010

 

Regards,

Ing. Eduardo Castro, SQL Server MVP

Note: Cross posted from Eduardo Castro.

Permalink

Comments

Post a Comment

Popular posts from this blog

Cómo identificar consultas más pesadas en SQL Server

-
Muchas veces nos encontramos en situaciones en las cuales tenemos un servidor SQL Server, y los usuarios reportan que el sistema está lento, por lo tanto, es crucial que podamos identificar cuál es la causa.  El primer paso puede ser identificar cuáles son las consultas TSQL que están consumiendo más recursos en el servidor, para poder identificarlas podemos recurir al siguiente script, el cual nos devuelve las consultas ordenadas por tiempo de ejecución, a partir de esta consulta podemos identicar el TSQL que consume más recursos e iniciar nuestras tareas de mejoras de desempeño. -- Consultas que afectan el desempeño SELECT TOP 10 SUBSTRING ( qt . TEXT , ( qs . statement_start_offset / 2 ) + 1 , ( ( CASE qs . statement_end_offset WHEN - 1 THEN DATALENGTH ( qt . TEXT ) ELSE qs . statement_end_offset END - qs . statement_start_offset ) / 2 ) + 1 ) AS consulta_TSQL , db . name AS [nombre_base_datos] , qs . total_...
Read more

Permitiendo la administración de los jobs a usuarios que no son System Administrators en SQL Server Agent 2005 o superior

-
Antes de que llegara el Microsoft SQL Server 2005 al mercado, si usted deseaba que alguien tuviera acceso a ver, modificar, crear y ejecutar los SQL Server Agent Jobs, necesitaba darle permisos de Systems Administrator al login deseado de SQL Server, con el inconveniente que de también le iba a permitir hacer lo que deseara en esa instancia. A partir del SQL Server 2005, se incluyeron los siguientes 3 roles: SQLAgentUserRole: Los usuarios pueden crear jobs y manejar solo los jobs que ellos han creado. SQLAgentReaderRole: Van a tener los privilegios del rol SQLAgentUserRole junto con la habilidad de enumerar y ver el historial de todos los jobs. SQLAgentOperatorRole: Van a tener los mismos privilegios del rol SQLAgentReaderRole junto con la habilidad de ejecutar jobs locales de los cuales ellos no son dueños. El procedimiento para asignarle permisos a un login en alguno de esos roles es el siguiente: 1. Agregue el usuario deseado a la base de datos "msdb...
Read more

FileTable en SQL Server 2012

-
Image
SQL Server 2012 incluye una nueva característica llamada FileTable, lo que permite el FileTable es poder tener dentro de la base de datos un tipo especial de tabla en la cual se puedan almacenar archivos y directorios, de la misma forma en que se hace en un sistema de archivos NTFS. De esta forma los archivos almacenados en un FileTable puede ser accedidos por otras aplicaciones de la misma forma en que se acceden archivos en el sitema de archivos NTFS. La ventaja de que presenta FileTable es que el contenido es presentado a las aplicaciones como un directorio compartido. Cuando se realiza una operación de creación de archivos, borrado o modificación, el comando es interceptado por SQL Server que hace posible que se reflejen los cambios dentro del FileTable.   A muchos parecerá familiar al concepto de FILESTREAM, sin embargo se puede configurar FileTables de forma separada del FILESTREAM, incluso si lo desea puede seguir utilizando FILESTREAM. Para habilitar el FileTable pr...
Read more