Saturday, February 03, 2007

Windows 2003 Video Tutorial: Customize Login Wallpaper

Customize Login Wallpaper - view details
Since so many servers sit at the Windows Logon screen for much of their 'life' many administrators want to change these default screens to something more entertaining and/or useful (such as a clock, calendar, etc). This helps you customize the experience on Windows Server 2003 but the same process will work for Windows XP clients
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: customize login wallpaper, wall paper, change wall paper, modify, computer name, domain name, bginfo

posted by Scott Whigham @ 11:00 PM    

Microsoft SQL Server Video Tutorial: Pt. 1- Introduction to SQL Server 2005's Integration Services

Pt. 1- Introduction to SQL Server 2005's Integration Services - view details
If you've been confused, mystified, or downright ornery about SQL Server 2005's Integration Services, you're not alone. Everything has changed so drastically from the "old" DTS days that much of our previous knowledge is pass��. This video is a jumping-off point, a first look, at SSIS and some of the basic architectural changes including using the Business Intelligence Design Studio (often referred to as the BI Studio) and how the .dtsx files work within a project/solution. This video doesn't feature any package creation nor talk about the individual tasks; it's really more about how things have changed, what the new tools are, and is really designed to help you get comfortable with SSIS.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have t he TSCC codec installed to view this video

Keywords Associated with this video: SSIS intro, integration services first look, ssis basics, integration services architecture

posted by Scott Whigham @ 11:00 PM    

SQL Server 2000 Video Tutorial: How to Return Identity Value for a Just-Inserted Row

How to Return Identity Value for a Just-Inserted Row - view details
So many SQL developers use IDENTITY columns (a.k.a. sequences and/or auto-number columns) therefore this video is essential knowledge for SQL developers, DBAs, and even application developers. This tutorial focuses on working with IDENTITY columns as primary keys and how you can retrieve the just-inserted row's primary key value. Several techniques are discussed here with a final discussion on perhaps the "safest" (and recommended) technique.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: identity, @@identity, scope identity, scope_identity

posted by Scott Whigham @ 11:00 PM    

Exchange 2003 Video Tutorial: Enable the Out of Office Assistant in Microsoft Oulook

Enable the Out of Office Assistant in Microsoft Oulook - view details
This end-user video shows your users how to enable the Out of Office Assistant in MS Outlook, explains how it works, and some limitations. Going out of town? On vacation (we're jealous)? Have an important meeting to attend and will be out of the offfice for an extended period (we're definitely not jealous)? Then you may want to configure Outlook to use the "Out of Office Assistant" to automatically reply to incoming email with a message explaining the reasons for your absence and possibly when you'll be available again.

This video walks you through setting up a few Out of Office Assistants in Microsoft Outlook 2003 including creating rules for handling inbound email. You'll learn how you can configure Outlook to send one message per inbound user informing them that you are out of the office or you can set up Outlook to reply to every incoming e-mail with the Out of Office reply.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: configure outlook reply, reply out of town, auto reply, outlook 2003, beginner, beginning, for beginners, introduction, step by

posted by Scott Whigham @ 10:00 PM    

SQL Server 2000 Video Tutorial: ODBC, DSNs, and UDLs - Creating Reusable Connection Information

ODBC, DSNs, and UDLs - Creating Reusable Connection Information - view details
This video is an excellent introduction to the terms used when discussing connections to SQL Server. There are many options for connecting an application (such as Microsoft Access, ASP.NET, Java) to SQL Server and this video covers some popular options. If you've heard of ODBC and DSNs before but never really understood how they were used (or what they are) then this is a great video to watch
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: sql odbc, sql odbc driver, sql driver

posted by Scott Whigham @ 10:00 PM    

DTS Video Tutorial: Pt. 3 - Working with Variables as File Names and Assigning File Names at Runtime

Pt. 3 - Working with Variables as File Names and Assigning File Names at Runtime - view details
Don't know what the source file's name will be before you run your DTS package? You're not alone - this is very common in DTS. This video will help you write scripts to assign values to your filename.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: filename, file name, activex script, active x scripting task, DTSGlobalVariables

posted by Scott Whigham @ 10:00 PM    

Transact SQL Video Tutorial: Pt. 1 - Introduction to Stored Procedure Concepts and Common Usage

Pt. 1 - Introduction to Stored Procedure Concepts and Common Usage - view details
Stored procedures are the way of the modern programmer and this first video in this series helps you understand the need for and the use of stored procedures in modern applications. You'll learn the basic syntax elements, where to use stored procs, who uses them, and see some rather intricate examples of usage.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: stored procedure tutorial, stored proc help, stored proc script

posted by Scott Whigham @ 9:00 PM    

Microsoft SQL Server Video Tutorial: Variables - Understanding the Difference Between Using SET and SELECT to Assign Values

Variables - Understanding the Difference Between Using SET and SELECT to Assign Values - view details
This video is designed to help you understand when you should use SET @Variable = value and SELECT @Variable = value. For new people coming into T-SQL programming, it's often quite confusing when to use SET vs. SELECT for variable assignment.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: assign variable from database

posted by Scott Whigham @ 9:00 PM    

Windows 2003 Video Tutorial: Display Information about Non-present (Hidden) Devices

Display Information about Non-present (Hidden) Devices - view details
When you install a new system Windows will attempt to install drivers and load the device. This video shows you where this information is held within the system and how you can use this for troubleshooting device drivers and installation issues
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: configure hidden devices

posted by Scott Whigham @ 9:00 PM    

Exchange 2003 Video Tutorial: How to Reclaim Space on Your Exchange Server By Purging Multiple Mailboxes

How to Reclaim Space on Your Exchange Server By Purging Multiple Mailboxes - view details
By default Exchange holds onto deleted account mailboxes for thirty days. This takes up unnecessary space on your Exchange Server. Exchange trainer Grant Moyle shows you some best practices and how--Exchange-works for reclaiming wasted space
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: purge multiple exchange mailboxes, purge exchange mailboxes

posted by Scott Whigham @ 8:00 PM    

SQL Server 2005 Video Tutorial: TOP Operator: What's New and Why Life Is much Easier Today

TOP Operator: What's New and Why Life Is much Easier Today - view details
The TOP operator has been greatly enhanced over SQL Server 2000's implementation of TOP by adding support for parameterization and the ability to use TOP in all DML statements (instead of just the SELECT). Scott Whigham, author of LearnSqlServer.com and LearnTransactSql.com, walks you through using the new features of TOP and how it differs from previous versions.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: new feature, top parameter, insert, update, delete, select

posted by Scott Whigham @ 7:00 PM    

Exchange 2003 Video Tutorial: Upgrade From Exchange Service Pack 1 to Service Pack 2 (with IMF Uninstall)

Upgrade From Exchange Service Pack 1 to Service Pack 2 (with IMF Uninstall) - view details
Have you ever seen the error "The component Microsoft Exchange Messaging and Collaboration Services cannot be assigned the action Update because���"? Chances are that you are trying to upgrade Exchange Server 2003 SP1 to Service Pack 2 and you cannot upgrade to SP2. To upgrade from Exchange SP1 to SP2, you must uninstall the Intelligent Message Filter (the IMF) because, as the error message says, "An earlier version of the Exchange Intelligent Message Filter has been detected on this system and this earlier version must be uninstalled before applying Service Pack 2." It may be long but at least it's a helpful error message! In this video, Grant Moyle shows you how to un install IMF before applying SP2 and actually shows you two different techniques.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.
< br />

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: imf error sp1, sp1 upgrade, sp2 cannot install

posted by Scott Whigham @ 7:00 PM    

Windows 2003 Video Tutorial: Customize the Start Menu and Desktop

Customize the Start Menu and Desktop - view details
Windows Server 2003 and Windows XP changed the Start Menu and the Desktop's default configurations. If you're new to Windows Server 2003 and want to understand where everything is check out this video. This video also helps you understand Windows XP's Start Menu and customizations
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: Customize Start Menu, Put My Computer on Desktop, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 6:00 PM    

Exchange 2003 Video Tutorial: POP3 Testing

POP3 Testing - view details
If you have clients that can only use POP3 to connect to your Exchange server then this video can help you understand the basics of POP3 configuration in Exchange and how it works with Exchange. You'll use the Exchange System Manager to manage POP3 and the Telnet utility to test a few POP3 emails
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: test pop3 Exchange, pop3 with Exchange

posted by Scott Whigham @ 6:00 PM    

Transact SQL Video Tutorial: Pt. 2 - CREATE PROCEDURE Syntax and Execution

Pt. 2 - CREATE PROCEDURE Syntax and Execution - view details
This video walks you through the essential syntax elements of the CREATE PROC (or CREATE PROCEDURE if you prefer) statement and also helps you understand how to execute stored procs. At the end of this video, you'll also learn how to modify (ALTER) and remove (DROP) stored procedures.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: create proc, create procedure, alter proc, alter procedure, drop proc, drop procedure

posted by Scott Whigham @ 6:00 PM    

Microsoft SQL Server Video Tutorial: How to Upgrade The Documentation of SQL Server 2000 (Books Online)

How to Upgrade The Documentation of SQL Server 2000 (Books Online) - view details
At the same time that Service Pack 3 for SQL Server 2000 was released, Microsoft "refreshed" the Books Online documentation. How can you tell whether or not you're working with the latest copy? Where do you get it? Is it installed with Service Pack 3 (and what about SP4)? This video shows you the details of Microsoft's Update to Books Online and answers all these questions
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: update sql server books online, update bol, sql server update

posted by Scott Whigham @ 5:00 PM    

Windows 2003 Video Tutorial: Setting Printer Defaults for Your Network Printers

Setting Printer Defaults for Your Network Printers - view details
You'll pick up several tips and helpful ideas for configuring printers for your network. The printer's default are a great place to save time and money by ensuring that users get exactly what they need.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: network printer configuration Windows 2003

posted by Scott Whigham @ 5:00 PM    

Exchange 2003 Video Tutorial: Intro - High-Level Overview and Walk-Through

Intro - High-Level Overview and Walk-Through - view details
This video is an overview of the process of upgrading from Exchange Server 2000 to Exchange Server 2003. This is an excellent video to watch if you are planning an Exchange Server 2000 upgrade. Watching this video, especially in conjunction with the other
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: exchange 2000 upgrade overview, exchange 2000 upgrade tutorial

posted by Scott Whigham @ 5:00 PM    

Microsoft SQL Server Video Tutorial: Pt. 2 - Index-Related Tasks in SQL Server 2005 (the Rebuild Index, Reorganize Index, and Update Statistics options)

Pt. 2 - Index-Related Tasks in SQL Server 2005 (the Rebuild Index, Reorganize Index, and Update Statistics options) - view details
Continuing our discussion on SQL Server 2005 Maintenance Plan tasks in the wizard, this video gives a nice overview of the index-related tasks, the 'Rebuild Index', 'Reorganize Index' and the 'Update Statistics' tasks.

Scott Whigham, author of LearnSqlServer.com, walks you through a simple-to-understand discussion of how index fragmentation works, how data-distribution statistics are calculated and why tasks such as the Rebuild Index tasks are vitally important to the health of your SQL Server. Included in this video is a discussion of online defragmentation vs. offline defragmentation and a quick overview of the new ALTER INDEX ... WITH REBUILD or WITH REORGANIZE (instead of the DBCC DBREINDEX and DBCC INDEXDEFRAG).

Also included in this video is a discussion of how often you should run these tasks along with the impact that each task will have on your server and users. You'll also understand why fragmentation occurs and how these tasks can help your database run faster.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: index defragmentation, index defrag, how to defragment indexes, defragment sql server, alter index, dbcc

posted by Scott Whigham @ 4:00 PM    

SQL Server 2000 Video Tutorial: Pt. 2 - Using the DTS Designer to Migrate Tables from Access to SQL Server 2000

Pt. 2 - Using the DTS Designer to Migrate Tables from Access to SQL Server 2000 - view details
In the first video in this series we used the DTS Import/Export Wizard to move Access tables to SQL Server 2000. In this video, we go one step further and create a DTS package in the DTS Designer (inside of the Enterprise Manager).

Highlights from this video:
  • Using connections in DTS
  • Using the Transform Data Task
  • Changing the tranformations and auto-generated schema
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: data transformation services designer, transform data task, oledb provider

posted by Scott Whigham @ 4:00 PM    

Exchange 2003 Video Tutorial: Database Management for Multiple Exchange Databases: Managing Storage Limits

Database Management for Multiple Exchange Databases: Managing Storage Limits - view details
This video shows you how to manage multiple Exchange databases and control users' sending/receiving limits. It can become very difficult to manage multiple Exchange servers if you maintain different limits on each database/server. This video walks you through setting policies for multiple Exchange servers so that all Exchange servers can be the same
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: configure mailbox limit policy

posted by Scott Whigham @ 3:00 PM    

Transact SQL Video Tutorial: Pt. 4 - OUTPUT Parameters and How to Use Them

Pt. 4 - OUTPUT Parameters and How to Use Them - view details
One of the more confusing aspects of the stored procedure is the syntax and usage of OUTPUT parameters. This video tutorial will help you understand what OUTPUT params are, where they are used (in a Singleton pattern, for example), and how to access/assign the values to local variables. Don't miss this video!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: stored proc output params, OUT parameters, advanced stored procedures

posted by Scott Whigham @ 3:00 PM    

Visual C# Video Tutorial: Templates - Project Templates and Item Templates

Templates - Project Templates and Item Templates - view details
Templates exist to help you speed up your development time and also to help standardize control/item usage throughout your projects and solutions. This video shows you the core concepts of using templates, the architecture of the template, and how to build your own templates for easy reuse.

Highlights from this video:
  • Reusing forms and commonly used items
  • Exporting templates to other machines and even for email/FTP
  • Using templates for standardization
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: projects, solutions, items

posted by Scott Whigham @ 3:00 PM    

SQL Server 2000 Video Tutorial: Using Linked Servers In Your SQL Server SELECT Statement (SQL Server 2000)

Using Linked Servers In Your SQL Server SELECT Statement (SQL Server 2000) - view details
Linked servers can really help you get "out of a jam" with SQL. If you'd like to be able towrite SQL queries against Microsoft Access and JOIN the data to a SQL Server table, for example, then you'll love the flexibility that linked servers offer you. This video is just an overview of how linked servers work and how you can use them in your queries to simplify your life.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: excel, access, oracle, sql server 7, remote server, oledb, jet, ole-db

posted by Scott Whigham @ 2:00 PM    

Microsoft SQL Server Video Tutorial: Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys

Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys - view details
This video focuses on common SQL developer/DBA terms regarding indexes and constraints and helps you get comfortable with the SQL lexicon. The work "key" is used over and over in SQL - Primary Key, Foreign Key, Alternate key, and more - yet many developers rarely go beyond the primary key and foreign key. This makes it difficult to develop robust systems. For more on the types of keys available and their usage, watch this video from SQL consultant Scott Whigham.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: alternate key, associative key, pk, fk, check constraint, unique constraint

posted by Scott Whigham @ 2:00 PM    

Windows 2003 Video Tutorial: File Screening Management for Microsoft Windows Server 2003 R2

File Screening Management for Microsoft Windows Server 2003 R2 - view details
File screening is the process of preventing users from storing certain file types in a folder/volume. The File Server Resource Manager includes the ability to prevent users from storing video and audio files on public shares - a very handy feature. This v
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: file screening, fsrm screening, fsrm windows 2003 r2

posted by Scott Whigham @ 2:00 PM    

Windows 2003 Video Tutorial: Installing IIS (Internet Information Services) - the Web server for Windows

Installing IIS (Internet Information Services) - the Web server for Windows - view details
An essential video for all Windows sysadmins
To download this video, log in, the n visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: Windows 2003 IIS 6.0, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 1:00 PM    

Windows 2003 Video Tutorial: Using and Enabling the Themes Service in Windows 2003

Using and Enabling the Themes Service in Windows 2003 - view details
This video is particularly helpful for those of you who run Windows Server 2003 on your desktop/laptop. This is part of a set of videos on configuring your machine to run best for desktop/laptop use. This features the Themes Service, a feature that first appeared in Windows XP, and discusses how to enable the Themes Service for Windows Server 2003. If you've ever wondered exactly how Themes work in Windows this is the video for you!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: Themes Service Windows 2003, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 1:00 PM    

Exchange 2003 Video Tutorial: Intro - High-Level Overview and Walk-Through

Intro - High-Level Overview and Walk-Through - view details
This video is an overview of the process of upgrading from Exchange Server 2000 to Exchange Server 2003. This is an excellent video to watch if you are planning an Exchange Server 2000 upgrade. Watching this video, especially in conjunction with the other
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: exchange 2000 upgrade overview, exchange 2000 upgrade tutorial

posted by Scott Whigham @ 1:00 PM    

SQL Server 2005 Video Tutorial: COLLATE and How Queries and Table Data Work with Case-Sensitive and Accent-Sensitive Data

COLLATE and How Queries and Table Data Work with Case-Sensitive and Accent-Sensitive Data - view details
If you have to work with multi-national and international data, then you'll often find yourself working with Unicode Datatypes (such as nchar and nvarchar) and even needing to use particular collations. In fact, some of you may need to work with (gasp) a case-sensitive server, database, table or column. If you are wanting to know more information about how case sensitive data, regional data, global data and basically get a handle on how string data works in SQL Server, this is a good video for helping you understand how SQL Server works.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: unicod e, nchar, nvarchar, collate, collation, globalization

posted by Scott Whigham @ 12:00 PM    

DTS Video Tutorial: What is the Import/Export Wizard and Using the Import/Export Wizard in Common Data Movement Scenarios

What is the Import/Export Wizard and Using the Import/Export Wizard in Common Data Movement Scenarios - view details
Every DTS admin or developer needs to know this wizard backwards and forwards since it is the entry point for many people into DTS. The more you understand it's quirks and how it can help you, the better DTS designer you'll be!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: What is the Import/Export Wizard and Using the Import/Export Wizard in Common Data Movement Scenarios, beginner, beginning, for

posted by Scott Whigham @ 12:00 PM    

Free Transact SQL Video Tutorial: Views: Introduction, When and Where to Use, and Using the Create View Wizard

Views: Introduction, When and Where to Use, and Using the Create View Wizard - download
Views are one of the most popular techniques to access data in the database. This video is the perfect introduction to the view which is really nothing more than a stored query. When should you use views? How do you create views? What happens to the data when you remove the view from the database? All of these questions and more are answered in this great video from our author, Scott Whigham.

Highlights from this video:

  • Best Practices for Using Views
  • Designing Manageable and Reusable SQL
  • Using Views to Control Security and Data Access
  • Using the Enterprise Manager to Create/Manage Views
  • CREATE VIEW syntax
  • ANSI-89 vs. ANSI-92 JOIN syntax (SQL-1 vs. SQL-2)
  • Designing Views with the Query Designer
  • CROSS JOINs and How to Run Out of Disk Space Quickly
  • Why You Should Always, Always, Always Test Your Queries Before Posting to Production
  • Internal Acrhitecture of Query Analyzer

Note: This should be considered a "Must-See" video for all newbies!
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: , beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 12:00 PM    

Windows 2003 Video Tutorial: Using Remote Assistance

Using Remote Assistance - view details
Remote Assistance, supported in Windows XP and Windows Server 2003, allows a remote administrator to assist a user who is having trouble on a system. Grant Moyle walks you through configuring Remote Assistance and walk through a great demo of how it works
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: Remote Assistance requests

posted by Scott Whigham @ 11:00 AM    

SQL Server 2005 Video Tutorial: Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys

Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys - view details
This video focuses on common SQL developer/DBA terms regarding indexes and constraints and helps you get comfortable with the SQL lexicon. The work "key" is used over and over in SQL - Primary Key, Foreign Key, Alternate key, and more - yet many developers rarely go beyond the primary key and foreign key. This makes it difficult to develop robust systems. For more on the types of keys available and their usage, watch this video from SQL consultant Scott Whigham.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: alternate key, associative key, pk, fk, check constraint, unique constraint

posted by Scott Whigham @ 11:00 AM    

Microsoft SQL Server Video Tutorial: EXCEPT and INTERSECT - An Introduction to Syntax and Concepts

EXCEPT and INTERSECT - An Introduction to Syntax and Concepts - view details
New in Transact-SQL for SQL Server 2005 are the EXCEPT and INTERSECT operators. These are not new SQL concepts; rather, these are just being added to SQL Server after being supported in other systems. Chances are that you've written your fair share of EXCEPT and INTERSECT-type queries but using a different syntax. NOTE: this video talks extensively about INNER and OUTER JOINs therefore a solid understanding of both is assumed.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: outer join, inner join, new feature 2005, ansi, iso, standard

posted by Scott Whigham @ 9:00 AM    

Free Microsoft SQL Server Video Tutorial: ODBC, DSNs, and UDLs - Creating Reusable Connection Information

ODBC, DSNs, and UDLs - Creating Reusable Connection Information - download
This video is an excellent introduction to the terms used when discussing connections to SQL Server. There are many options for connecting an application (such as Microsoft Access, ASP.NET, Java) to SQL Server and this video covers some popular options. If you've heard of ODBC and DSNs before but never really understood how they were used (or what they are) then this is a great video to watch
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: sql odbc, sql odbc driver, sql driver

posted by Scott Whigham @ 9:00 AM    

Transact SQL Video Tutorial: DATETIME and SMALLDATETIME - Working with Dates and Times SQL Server

DATETIME and SMALLDATETIME - Working with Dates and Times SQL Server - view details
One of the most confusing datatypes to work with in SQL Server, for new people, seems to be the DATETIME/SMALLDATETIME datatypes. Questions abound and, even worse, incorrectly written queries abound using these data types. This video will teach you the fundamentals of working with date and time data in SQL Server so that you can avoid these common query writing pitfalls.

Highlights from this video:
  • Differences between DATETIME and SMALLDATETIME
  • Implicit date rounding and Rounding dates
  • Using DATETIME data in the BETWEEN clause
  • Writing WHERE clauses and <, >, <= and >= with dates
  • Default values for time and dates
  • Should dates use single quotes, double quotes or no quotes (or does it matter)?
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: datetime, smalldatetime, date time, milliseconds, seconds, rounding, year, month, day, truncate, truncating, truncation

posted by Scott Whigham @ 9:00 AM    

Transact SQL Video Tutorial: Part 3 - GOTO Statements and When and How to Use Them

Part 3 - GOTO Statements and When and How to Use Them - view details
"IF @@Error <> 0 GOTO Errorhandler" Look familiar? Well, it might if you have been working with error handlers and writing GOTO labels and statements. In this third installment in our series on working with Control-of-Flow language, SQL instructor Scott Whigham shows what GOTO is, how to use it and talks about best practices for using GOTO in your queries.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: goto label, control of flow, controlling execution in SQL

posted by Scott Whigham @ 7:00 AM    

Transact SQL Video Tutorial: Part 2 - Using IF Statements to Control Execution in Scripts and Stored Procedures

Part 2 - Using IF Statements to Control Execution in Scripts and Stored Procedures - view details
This video explores more uses of IF statements to control the flow of your SQL code inside stored procedures. You'll learn about using IF EXISTS and more in this video on basic SQL programming.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: if exists

posted by Scott Whigham @ 7:00 AM    

Microsoft SQL Server Video Tutorial: Part 3 - Running the January 2006 Microsoft SQL Server Upgrade Advisor Against a SQL Server 7.0 Instance

Part 3 - Running the January 2006 Microsoft SQL