Developers: Learn a New Programming Language or App Development with Deitel LiveLessons Videos!
Login  |  Register  |  Media Kit  |  Press  |  Contact Us  |   Twitter Become a Deitel Fan on Facebook  
Custom Search

SQL Server 2008 Resource Center
SQL Server 2008 Tutorials
Virtual Lab: Working with the New DATE Data Type
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
Free video tutorial: "How to Make a Table Read Only in SQL Server 2005/2008," from 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
“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
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
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
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
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.
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).

Safari Trial Subscriptuon

Update :: October 16, 2019