MSDN Screencasts | By Tags | SQL Server

SQL Server 2008 - Change Tracking

Fri, 14 Dec 2007 22:37:02 GMT

SQL Server 2008 has two facilities for monitoring changes to a table to facilitate (e.g.) loading of a data warehousing or building an online/offline application with syncronisation capabilities.

In this video we take a look at "Change Tracking" which provides notification of net changes made to data during a period of time and is a good basis for building of an application requiring one or two way synch.

SQL Server 2008 - Table Valued Parameters

Fri, 14 Dec 2007 22:34:27 GMT

SQL Server 2008 (and ADO.NET in .NET Framework V3.5) have a capability whereby you can pass a whole table of data into a stored procedure in one go. Rather than passing XML or a string, multi-valued parameters can be represented quite naturally.

In this video, we take a quick look.

LINQ to Entities - Deferred Loading of Entities

Sat, 13 Oct 2007 20:07:14 GMT

ADO.NET V3.0 will come with the ADO.NET Entity Framework and a flexible object relational mapping layer that plugs in to LINQ - LINQ to Entities. In this video we'll take a look at how the framework deals with the deferred loading of related entities from the database.

LINQ to Entities - Defining and Executing Queries

Sat, 13 Oct 2007 20:03:28 GMT

ADO.NET V3.0 will come with the ADO.NET Entity Framework and a flexible object relational mapping layer that plugs in to LINQ - LINQ to Entities. In this video we'll take a look at the difference between defining a query and executing a query.

LINQ to Entities - Metadata Generation Tools

Sat, 13 Oct 2007 19:59:06 GMT

ADO.NET V3.0 will come with the ADO.NET Entity Framework and a flexible object relational mapping layer that plugs in to LINQ - LINQ to Entities. In this video we'll take a look at how we can use metadata generation tools in order to produce the necessary models for the Entity Framework.

LINQ to Entities - Intro (Metadata, Querying, Updating)

Sat, 13 Oct 2007 19:51:56 GMT

ADO.NET V3.0 will come with the ADO.NET Entity Framework and a flexible object relational mapping layer that plugs in to LINQ - LINQ to Entities. In this video we take a quick look at how to obtain build a model in order to query and update data. Later videos will examine these topics in greater depth.

Windows Workflow Foundation: Building Persistence Services

Mon, 26 Jun 2006 07:00:00 GMT

Windows Workflow Foundation comes with its own persistence service that uses SQL Server. However, it is also possible to build your own, and in this session we explore the basics of achieving that.

ASP.NET Database Connection

Thu, 23 Feb 2006 08:00:00 GMT

This Screencast shows you how to configure your ASP.NET 2.0 Web application to connect to SQL Server 2005 by using Windows authentication. In addition, this Screencast presents an authorisation pattern for restricting your application's identity within the database.

SQL Server 2005 Express- Express Editions

Mon, 19 Sep 2005 07:00:00 GMT

Working with triggers on Data Definition Language

Tue, 31 May 2005 07:00:00 GMT

A new feature in SQL Server 2005 allows us to install triggers on Data Definition Language (e.g. when a table is created). This session takes a look.

Working with the new XML data type

Thu, 03 Mar 2005 08:00:00 GMT

In SQL Server 2005 we have a new XML data type with rich capabilities for storing your XML data. This session explores how that works.

Writing stored procedures in .NET managed code

Tue, 11 Jan 2005 08:00:00 GMT

In this session we'll look at how we can use managed languages such as C# and VB to write stored procedures for SQL Server.