Part one of this series explores the changes to the administration and management tools in SQL Server 2005. The discussion focuses primarily on the new Management Studio tool, which encompasses the Enterprise Manager, Query Analyzer and OLAP Analysis Manager from SQL 2000. Because the tool runs within the Visual Studio interface, we will also look at this interface and the functions it can perform. 3/21/2005 | Duration:60 Minutes

In part two of this series, we look at the monitoring tools available with SQL Server 2005. We examine the SQL Profiler, Database Tuning Advisor, Database Maintenance Workflow and Dynamic Management Views (DMVs). 3/28/2005 | Duration:60 Minutes

SQL Server 2005 provides enhancements to enable greater concurrency and significantly reduce lock contention. In part three of this series, we show you how to use Snapshot Isolation to reduce currency contention. Gain an understanding of database snapshots and replication for scaling and read-only views, and learn how Dynamic Management Views can help you proactively monitor locking and avoid deadlocks. 4/4/2005 | Duration:60 Minutes

Parts four and five in our series highlight the security enhancements in SQL Server 2005. Part four of this series focuses on authentication and authorization while crypto support is covered in part five. We begin with authentication, examining the Security model, endpoint-based authentication and the password policy. Then we move on to explore authorization, covering User Schema separation, module execution context, granular permission control and Catalog security. 4/11/2005 | Duration:60 Minutes

Parts four and five in our series highlight the security enhancements in SQL Server 2005. Building upon the discussion of authentication and authorization in the previous session, part five of the series covers the crypto support in SQL Server 2005. We begin with an introduction to the concepts of database encryption including encryption support, keys, certificates and key management. We show how SQL 2005 can protect sensitive data using data encryption and module signatures, and introduce sign modules, what these are and how they work. 4/18/2005 | Duration:60 Minutes

Partitioned tables improve the scalability and manageability of very large SQL Server databases. In part six of this series we look at the table and index partitioning capabilities in SQL Server 2005. The discussion will outline the features and benefits of partitioning, explain how it works, and illustrate how to implement and set up this feature. 4/25/2005 | Duration:60 Minutes

The aim of creating indexes and partitioning data in a database is to yield good performance for users. Part seven in this series looks at the enhancements to the indexing within SQL Server 2005. We begin by outlining the basic changes to the indexing compared to previous versions. We then drill into index management and show how to use the Database Tuning Advisor as the main tool to analyze indexes. 5/2/2005 | Duration:60 Minutes

Part eight in the series covers troubleshooting methods and tools in Microsoft SQL Server 2005 that you can use to recover from various scenarios. Topics include database access problems, such as the database being marked as suspect during recovery; backup and restore failures; database runtime consistency failures, such as checksum; and DBCC CHECKDB errors. Learn how to take advantage of new features in SQL Server 2005 to recover your data in order to make yourself more productive in disaster recovery situations. 5/9/2005 | Duration:60 Minutes

Database mirroring is a new technology in SQL Server 2005 that provides very fast, automatic failover to a standby system. In part nine of this series we examine this new enhancement in detail, and will show you how to configure and use it. 5/16/2005 | Duration:60 Minutes

SQL Server includes a suite of replication technologies that enable a wide range of distributed database applications. SQL Server 2005 introduces a few new scenarios including Web synchronization of merge replication for mobile and distributed data applications, Oracle publishing for integration with Oracle databases, and peer-to-peer replication. In this final webcast in our ten-part series, learn how you can benefit from these scenarios with an enhanced ability to monitor the entire distributed system. 5/18/2005 | Duration:60 Minutes

A. Differences between ASP.NET 2.0 and Microsoft ASP.NET 1.1.
B. Overview for the rest of the lectures
C. Master pages
D. Themes
E. Membership
F. Profile
G. Declarative data binding

August 4, 2005 - 68 minutes

A. Fundamental architecture of Microsoft ASP.NET 2.0.
B. Page compilation
C. Assembly loading
D. Code behind
E. Shadow copying
F. Changes in the compilation model from Microsoft ASP.NET 1.1, primarily the use of partial classes in .aspx parsing.

August 11, 2005 - 64 minutes

A. Two significant user interface features of Microsoft ASP.NET 2.0: master pages and themes
B. Master pages give you a flexible way of defining templates for your site
C. Master pages make it easy for you to change the look and feel of entire sets of pages from a single source.
D. Themes provide a way to consolidate user interface features like style sheets, images and control styles in a single location, and simplify the process of "skinning", or changing the appearance of all elements of a site.

August 18, 2005 - 63 Minutes

A. New controls in Microsoft ASP.NET 2.0
B. Navigation controls (SiteMapPath, Menu, TreeView)
C. Wizard control
D. MultiView control

August 25, 2005 - 56 minutes

A. New declarative data binding model
B. How to bind data to controls using the new data source controls
C. SqlDataSource object
D. Comparison of  the way the new declarative model works with an analogous programmatic approach.
E. Other new data-related features in Microsoft ASP.NET 2.0.

Sept 1, 2005 - 60 Minutes

A. New ways to handle state management in Microsoft ASP.NET 2.0
B. Comparison of URL mangling to the practice of using cookies for storing session keys
C. New cross-page posting feature
D. How to use the Microsoft ASP.NET 2.0 Profile service as a generic data-backed per-client store.

September 08, 2005 - 59 Minutes

A. New membership features of Microsoft ASP.NET 2.0
B. How to implement cookie-based authentication for sites using the new security controls and the site administration tool
C. How this authentication works

September 15, 2005 - 46 minutes

A. Portal pages
B. Web Parts
C. Basic steps for setting up a customizable site using new Web Part controls, including WebPartManager, WebPartZone, CatalogZone, and EditorZone.

October 6, 2005 - 57 minutes

A. How ASP.NET 2.0 performs its parsing and compilation,
B. Deployment options ranging from complete source deployment to binary-only deployment.

October 13, 2005 - 57 minutes

A. New features in Microsoft ASP.NET 2.0 specific to the validation controls.
B. Validation groups.

October 20, 2005 - 50 minutes

A. Hierarchical data binding
B. ObjectDataSource object
C. Multi-layered architectures with declarative binding
D. Two-way binding

October 27, 2005 - 58 minutes

A. Internationalization of Web applications.
B. In addition to the App_Code directory, Microsoft ASP.NET 2.0 defines two new directories designed to store resources for compilation; App_LocalResources and App_GlobalResources
C. Declarative and programmatic techniques

November 3, 2005 - 53 minutes

A. How Microsoft ASP.NET 2.0 simplifies the way tracing works, and makes it much easier to redirect trace output to alternate sources.
B. New diagnostic features, including performance counters and the new Web events

November 10, 2005 - 51 minutes

A. New client callback feature built into Microsoft ASP.NET 2.0, along with other features that make it easier to integrate client-side script into your rendered pages.
B. Add sophisticated client-side JavaScript that retrieves data from the server without performing a POST-back request.
C. Both the TreeView and GridView controls have built-in support for dynamic data population with client callbacks.
D. Dow to build your own callbacks.

November 17, 2005 - 61 minutes

A. ASP.NET 2.0 has a complete implementation of SQL cache invalidation.
B. Build your own cache dependencies with ease.
C. This webcast covers SQL cache invalidation in both Microsoft SQL Server 2000 and Microsoft SQL Server 2005, and explores new cache management features and the new substitution control.

December 8, 2005 - 53 minutes

A. the basic language constructs
B. Different types of applications you can build using Visual Basic .NET
C. Overview of webcast series

2/5/2007

A. Visual Basic 2005 Express Edition, a free download from Microsoft that enables you to develop Visual Basic .NET applications.
B. Integrated development environment (IDE) features, like Code Editor, Compiler, IntelliSense, and the Debugger.
C. The project system that can help you build a collection to keep all the files related to your program together.

2/13/2007

A. How Visual Basic .NET relies on a hierarchical set of prewritten functions that enable developers to gain access to standard functionality provided by the host operating system.
B. How these functions are contained in files called class libraries

2/19/2007

A. What Visual Basic.NET is and how programs written in Visual Basic are structured.
B. Basics of the language and how Visual Basic assembles the lines of code

2/20/2007

A. Object types
B. Variables
C. Constants
D. Statements

3/5/2007

A. Classes
B. Objects

3/19/2007

A. Different kinds of operators and how to use them.

3/26/2007

A. Iterators
B. Loops
C. Branching

4/2/2007

A. Debugging
B. How the integrated development environment (IDE) enables you to see what is going on inside your application while it is running
C. Tracing

4/9/2007

A. Arrays
B. Collections

4/16/2007

A. Exception-handling
B. Try/catch blocks

4/23/2007

A. Delegates and events, and how they  can send alerts to other applications when interesting changes occur within your application.
B. How multiple listeners can respond to a single event.

4/30/2007

A. Inheritance allows one to create objects that are "like" other objects.
B. Inheritance and polymorphism can reduce the amount of code you write and make it easier to understand.

5/7/2007

A. Overview of Microsoft ASP.NET and how it relates to Visual Basic
B. How you can build Web pages and controls that enable you to reuse your code.

5/14/2007

A. User Controls
B. Custom Controls
C. Code reuse

5/21/2007

A. Building basic Windows Applications
B. The basic window class is the Form.
C. System.Windows.Form object

5/22/2007

A. Advanced features of Windows Forms development, such as GDI+ that allow us to tailor the user interface to exactly what our application needs.

5/28/2007

A. Learn about strings and find out how to create and manipulate them using basic operators, in addition to the StringBuilder class.

6/4/2007

A. We discuss how to include data access features in your applications. We specifically address how to integrate Microsoft SQL Server 2005 database functionality directly into your Web and Windows-based applications. See how Microsoft Visual Basic enables you to programmatically get direct access to SQL Server data. We also look at the various features in Visual Basic that empower you to develop against SQL Server 2005 and other data sources.

6/6/2007

A. We discuss the various deployment options for your applications. Writing an application can be a very tedious task, but deploying it can be an even greater challenge. Join this webcast to see how the different deployment techniques work, and to gain the information you need to successfully deploy your own applications.

6/18/2007

A. Join this final session to see how you can build a multi-tier business application with Visual Basic. Do not miss this chance to learn how building business applications with a multi-tier architecture can enable you to build an application for maintainability, reusability, and extensibility.

6/25/2007

A. The basic language constructs
B. What types of applications can be built
C. Overview of this webcast series

11/13/2006

A. Visual C# Express is a free download from Microsoft that allows you to develop C# applications
B. Learn about the powerful IDE features like Code Editor, Compiler, Intellisense and the Debugger.
C. The project system that allows us to build a collection to keep all the files related to our program together.

11/20/2006

A. Class Libraries

11/27/2006

A. What is C# and how are programs written in C# structured
B. How the "main" function is defined
C. Basics of the language
D. How C# assembles the lines of code  into something meaningful at runtime.

12/4/2006

A. Specific C# language features
B. Types
C. Variables
D. Constants
E. Statements

12/11/2006

A. Iterators
B. Loops
C. Branching

12/18/2006

A. Classes
B. Objects
C. Instantiation

1/8/2007

A. The different kinds of operators and how to use them.

1/15/2007

A. Debugging
B. How the IDE allows you to see what is going on inside your application while it is running.

1/22/2007

A. Arrays
B. Collections

1/29/2007

A. Creating and Manipulating Strings
B. StringBuilder class.

2/5/2007

A. Exception Handling
B. Try-Catch blocks and how to correctly handle the different types of exceptions

2/12/2007

A. Delegates and Events allow us to build applications that can let others know that some type of interesting thing has happened within our application.
B. Multiple listeners responding to a single event

2/19/2007

A. Inheritance allows one to create objects that are "like" other objects.
B. Advantages of Inheritance and Polymorphism: reduces the amount of code and makes it much easier to understand.

2/26/2007

A. ASP.NET and how it relates to C#
B. How we can build web pages and controls that allow us to reuse our code

3/5/2007

A. Building basic ASP.NET controls in C#.
B. Code reuse can significantly reduce our development time
C. User Controls - not compiled into separate assembly
D. Custom Controls- compiled into separate assembly

3/12/2007

A. Building basic Windows Applications
B. The basic window class we use in C# is the Form.
C. System.Windows.Form object

3/19/2007

A. Advanced features of Windows Forms development, such as GDI+ that allow us to tailor the user interface to exactly what our applicaiton needs.

3/26/2007

A. How to take advantage of Windows Vista's new presentation system, Windows Presentation Foundation (aka WPF) with C#.
B. WPF allows our applications to include stunning graphics (2-D, 3-D, animations, and more) and enhanced user experience functionallity that was unatainable in the past.
C. XAML

4/9/2007

A. How to include data access features in your applications
B. How to integrate SQL Server 2005 database functionality directly into your web and Windows based applications
C. C# allows us to programatically get direct access to SQL Server data
D. SQL Server 2005 and other data sources.

4/16/2007

A. XNA Game Studio Express.
B. XNA is a gaming framework available for Windows as well as for the XBox 360.
C. How XNA Game Studio and Microsoft Visual C# Express allow one to develop stunning 3D games with ease.

4/23/2007

A. Deployment options

4/30/2007

A. SQL Server  terminology for creating and managing databases;
B. SQL Server database;
C. Compare SQL Server to Excel;
D. Relation between SQL Server Database and Desktop application or website;
E. Relationship between SQL Server Express and Visual Studio Express; ADO.NET

Duration: 28 minutes, 15 seconds

Duration: 24 minutes, 56 seconds

Date: 29 March 2006

Duration: 21 minutes, 37 seconds

Date: 22 February 2006

Duration: 34 minutes, 10 seconds

Date: 29 March 2006

A. ADO.NET objects
B. Execution of SQL statement from ADO.NET
C. Insert, update, and delete SQL statements.

Duration: 40 minutes, 20 seconds

Date: 29 March 2006

This lesson requires Management Studio Express and MSXML

A. Sub-select
B. Stored procedures and their counterparts in C# and VB methods.

Duration: 23 minutes, 13 seconds

Date: 29 March 2006

A. Differentiate between SQL Server database files and SQL Server processes.
B. Various scenarios for connecting to SQL Server Express databases
C. Enabling and disabling user instances
D. login permissions
E. other security precautions

Duration: 40 minutes, 59 seconds

Date: 20 March 2006

A. Workflow of creating a database driven Web application
B. Visual tools to quickly create an administration application.

Duration: 1 hour, 5 minutes

Date: 20 March 2006

A. SQL Server Management Studio Express
B. Connect to database instances
C. Navigate the query window
D. Scripting database objects
E. Attaching, detaching and backing up databases

Duration: 40 minutes, 26 seconds

Date: 23 October 2006

A. Set up Reporting Services and the Business Intelligence Development Studio
B. Build reports using the wizards and designers
C. Deploy reports to Report Server.

Duration: 32 minutes, 51 seconds

Date: 21 October 2006

A. Building reports from scratch
B. Modifying the reports that were created using the wizards and designers
C. Embedding reports into ASP.NET Web Form applications

Duration: 44 minutes, 50 seconds

Date: 22 October 2006

A. Stored Procedures
B. Basic syntax to create and update stored procedures
C. Using input and output parameters, return values, declaring variables and adding other T-SQL programming elements into you stored procedures
D. Executing stored procedures from the query window
E. Visual Basic and C# syntax required to utilize stored procedures in applications

Duration: 42 minutes, 34 seconds

Date: 14 November 2006

A. Setting up Full-Text search within SQL Server Express.
B. Creating full-text indexes
C. Configuring the index population settings
D. CONTAINS predicate

Duration: 38 minutes, 25 seconds

Date: 14 November 2006