Friday, July 3, 2009

Windows Server 2008 Video Tutorial: Addition of the Print Server Role and Using the Print Management Console to Managed Printers Across Mul tiple Servers

Addition of the Print Server Role and Using the Print Management Console to Managed Printers Across Multiple Servers - view details
In this video we will continue with our topic of printers in Windows Server 2008 by discussing the printer server role.

Highlights from this video:
  • Installing the Print Server role and about the LPD Service and Internet Printing
  • Exploring the Print Management snap-in
  • Adding and removing print servers
and much more
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: windows server, windows 2008, print server, print management, insta ll print server role, add print server

This video comes from the Windows 2008 online training course, Windows Server 2008 Administration. And be sure to check out even more Windows Server 2008 training videos.

posted by Scott Whigham @ 9:53 PM  

SharePoint (MOSS/WSS) Video Tutorial: How to Create a New Websit e and Site Collection in SharePoint Services 3.0

How to Create a New Website and Site Collection in SharePoint Services 3.0 - view details
A single SharePoint server can host multiple web applications which are used to host our SharePoint sites and site collections. This video will show you how to use a SharePoint server to create a new site collection or site. You'll also learn how to check the status of the server, and how to use the application management to create or extend a web application.

Highlights:
  • How to use existing IIS website
  • How to create existing IIS website
  • How to customize your new web application
  • How to add a web description to your site collection
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: create site collection, create site, application management, extend web application, IIS website, customize web app,

This video comes from the SharePoint 2007 online training course, Building Portals with SharePoint 2007. And be sure to check out even more SharePoint (MOSS/WSS) training videos.

posted by Scott Whigham @ 8:53 PM  

MSSQL Programming and Query Writing Video Tutorial: Auto-Numberin g Rows with IDENTITY Columns - How Identity Columns Work

Auto-Numbering Rows with IDENTITY Columns - How Identity Columns Work - view details
This video is mainly an architecture/sysinternals type of video designed to show you how things work "behind the scenes" with IDENTITY columns. You'll learn how SQL Server chooses the values, how you can influence those values as well as tips and tricks for using IDENTITY columns and Best Practices. IDENTITY columns (and all surrogate keys) are often easy to use but not completely understand by new users. If you use IDENTITY columns in your databases then you'll appreicate this thorough treatment of how IDENTITY columns work in SQL Server.
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: IDENTITY, auto number, sequence, surrogate key, alternate key

This video comes from the SQL Server Programming and Queries online training course, SQL Server Programming (SQL Server 2005/2000): Transact SQL. And be sure to check out even more MSSQL Programming and Query Writing training videos.

posted by Scott Whigham @ 7:53 PM  

C# Programming Video Tutorial: Pt. 4 - Understanding How AutoEven tWireup Works

Pt. 4 - Understanding How AutoEventWireup Works - view details
This video will cover the basics of the AutoEventWireup and how it works in different languages as well as the variations in the defaults and how to change specific handling behaviors.

Highlights:

  • AutoEventWireup value when using codefile
  • How to define your delegate in VB

??

To download this video, lo g in then then visit the video's detail page and click "download".

Keywords for this video: AutoEventWireup, eventwireup, page events

This video comes from the C# online training course, C# Programming with Visual Studio 2005. And be sure to check out even more C# Programming training videos.

posted by Scott Whigham @ 6:53 PM  

C# Programming Video Tutorial: Pt. 2 - Understanding the Properti es, the Toolbox, and Design Time Programming

Pt. 2 - Understanding the Properties, the Toolbox, and Design Time Programming - view details
This video will take your web application further by introducing you to the Toolbox, Properties, and Design Time Programming. Your instructor Scott will walk you through the various aspects of these and what they can do for your web application.

Highlights:

  • How to use Properties to edit variables
  • Where is my Toolbox?
  • What tags do??I need running inside of a form?
  • Functions of an asp label

??

To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: props

This video comes from the C# online training course, C# Programming with Visual Studio 2005. And be sure to check out even more C# Programming training videos.

posted by Scott Whigham @ 5:53 PM  

MSSQL Programming and Query Writing Video Tutorial: Subqueries, N ested Queries, and Derived Tables - An Introduction to Advanced SQL Constr ucts

Subqueries, Nested Queries, and Derived Tables - An Introduction to Advanced SQL Constructs - view details
Subqueries and derived tables can be some of the hardest constructs for people new to SQL to really grasp. This video is a "First Look" at sub-selects (another word for sub-queries) and the basic concepts of using subqueries in your SELECT statements. Perhaps the most valuable thing that even seasoned query-writers will get from watching this video is the "how"; a major focus of this video is how SQL Server processes subqueries internally. Scott Whigham, author of this site, takes you through how SQL Server will process the subquery in a step-by-step approach.

Note: This video was shot on SQL Server 2005 but the concepts are the same for SQL Server 2000.

Highlights from this video:

  • Execution plans: are they different or the same between different subqueries?
  • Using a subquery instead of a JOIN and vice-versa
  • Correlated subqueries and Simple Subqueries
  • Derived Tables; i.e., embedding a SELECT statement in the FROM clause
  • Step by step approach to writing subqueries
  • SQL Server architecture: Query Processing Sequence

To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: synchronized query, sub select, nested query, virtual table, materialize

This video comes from the SQL Server Programming and Queries online training course, SQL Server Programming (SQL Server 2005/2000): Transact SQL. And be sure to check out even more MSSQL Programming and Query Writing training videos.

posted by Scott Whigham @ 4:53 PM  

C# Programming Video Tutorial: Installing Visual Studio 2005 on W indows Vista

Installing Visual Studio 2005 on Windows Vista - view details
So you're looking to install Visual Studio 2005 on Windows Vista? Well then this video is just for you! Your instructor, Scott, will cover the particulars of installing VS2005 on Vista and include an overview of some of the nightmares that Vista will present you when doing the install.

Highlights:

  • Customizing the User Access Control setting (UAC)??in Vista
  • Suggestions for the best install

??

To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: vs2005

This video comes from the C# online training course, C# Programming with Visual Studio 2005. And be sure to check out even more C# Programming training videos.

posted by Scott Whigham @ 3:53 PM