SQL Server 2008 Tutorials

Virtual Lab: Working with the New DATE Data Type

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032357625&EventCategory=3&culture=en-US&CountryCode=US

Virtual Lab: “Working with the New DATE Data Type in SQL Server 2009,” discusses the new DATE/TIME data types and implement new data types in table definitions and in T-SQL batches.

How to Make a Table Read Only in SQL Server

http://www.learnsqlserver.com/videotutorials/sql-server-tutorials/270/series-3-videos-how-to-make-table-read-only-in-sql.aspx

Free video tutorial: "How to Make a Table Read Only in SQL Server 2005/2008," from LearnSqlServer.com. This is a three-part tutorial that discusses how to mark an SQL table as read-only, the architecture of SQL Server 2005/2008, file groups, data files, placement and indexes.

Virtual Earth and SQL Server 2008 Spatial

http://www.viawindowslive.com/Articles/VirtualEarth/SQL2008Spatialafirstimpression.aspx

“Virtual Earth and SQL Server 2008 Spatial: A First Impression,” by John O’Brien. Discusses what Virtual Earth is, the geometry and geography data types, creating a spatial field, importing data, integration with Virtual Earth, the Default.aspx, the Default.aspx.js, the MapArgs.js, the Map,js, the MapService.cs, the PostCodeLogic.cs, the dbo.getPostCodesByBound, and the spatial index.

Using Declarative Management Framework Policies

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032357626&EventCategory=3&culture=en-US&CountryCode=US

Virtual Lab: “Administering Servers by Using Declarative Management Framework (DMF) Policies,” discusses managing one or more instances of SQL Server 2008, implementing a DMF policy on a server level and filtering.

Virtual Lab: The SQL Server 2008 Reporting Service

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032358592&EventCategory=3&culture=en-US&CountryCode=US

Virtual Lab: “Authoring Reports Using SQL Server 2008 Reporting Services,” discusses how to launch the Report Designer Preview, create a data source, create a data set, design a new report using the Report Designer, preview a report, enhance a report layout using Tablix functionality and enriching a report with charts.

Virtual Lab: Implementing Change Data Capture

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032357624&EventCategory=3&culture=en-US&CountryCode=US

Virtual Lab: “Implementing Change Data Capture (CDC) in SQL Server 2008,” discusses what the Change Data Capture functions are and the necessary steps to enable data capture in a database.

Building Occasionally Connected Apps

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032358846&EventCategory=3&culture=en-US&CountryCode=US

Virtual Lab: “Learn How to Build Occasionally Connected Applications with SQL Server 2008,” discusses how to build offline smart client applications that synchronize with a local Microsoft SQL server.

What’s New in SQL Server 2008 for DB Admins.

http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032357623&EventCategory=3&culture=en-US&CountryCode=US

Virtual Lab: “What’s New in SQL Server 2008 for Database Administrators,” discusses the new date data type, implementing a DMF (Declarative Management Framework) policy, data mirroring, table valued parameters, and using the CDC (Change Data Capture).