Saturday, December 09, 2006

SQL Server 2000 Video Tutorial: An Overview of the Fixed Server Roles for SQL Server 2000

An Overview of the Fixed Server Roles for SQL Server 2000 - view details
Scott Whigham walks you through an overview of the fixed server roles in SQL Server with this excellent video. Quick - what is the one server role that you should probably never use? Which server role allows its members to add other members to it? Can you add your own server roles? Can you modify the server role permissions? If you don't know the answers to all of these questions, then you should probably watch 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: server roles sql server, sql server server role, sql server role, sql role

posted by Scott Whigham @ 11:00 PM    

Transact SQL Video Tutorial: Pt. 2 - Using Output Parameters To Pass Data To the Caller

Pt. 2 - Using Output Parameters To Pass Data To the Caller - view details
This continues our discussion of OUTPUT parameters from Part 1. Please ensure that you have viewed Part 1 before watching this video.

Highlights from this video:
  • When to Use Output Parameters
  • Output Parameter or Result Set?
  • Passing Data Between Stored Procedures
  • Master-Detail Inserts with IDENTITY values
  • @@IDENTITY or SCOPE_IDENTITY?
  • OUT or OUTPUT?
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: output, out params, sql parameters, sqlparameter, parameterdirection.output

posted by Scott Whigham @ 11:00 PM    

Windows 2003 Video Tutorial: Pt. 3 - More on Managing DFS Replication

Pt. 3 - More on Managing DFS Replication - view details
This video is a continuation of the 2nd video in this series on DFS Replication. This video discusses scheduling, optimizations, and other tools you can use to manage DFS replication.
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: dfs, distributed file system, replication, replicate, replicating, shared folders

posted by Scott Whigham @ 11:00 PM    

Transact SQL Video Tutorial: Resultsets, Recordsets, and the Client Server model (SQL Server 2000)

Resultsets, Recordsets, and the Client Server model (SQL Server 2000) - view details
This is an excellent video for those of you wanting to get a solid foundation in the terms and techniques you can use to connect to and retrieve data from a SQL Server database. Although this video was originally created on a SQL Server 2000 machine, the concepts have not changed in SQL Server 2005 with the exception of the new SQL Native Client. This is an excellent video for newbies and those just getting started with database programming and the client/server world.
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 client server, result set, record set, ado, ado.net, odbc, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 10:00 PM    

Microsoft SQL Server Video Tutorial: Pt. 3 - Input Parameters and Variables

Pt. 3 - Input Parameters and Variables - view details
The bulk of your stored procedures will be dynamic, meaning that they will have parameters and those parameters will be used to make decisions (such as what rows to return). This video talks about how to create parameters and variables as well as working with default parameters ( to make a parameter optional instead of required, for example).
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: declare, local variable, argument

posted by Scott Whigham @ 10:00 PM    

SQL Server 2000 Video Tutorial: Database Diagrams - An Introduction

Database Diagrams - An Introduction - view details
All experienced SQL developers and administrators recognize that being able to "see" your database gives you great confidence in the queries you write. It helps speed up development, ensure correct queries, and remove guesswork from the development cycle (well, as much as possible). This video shows you how you can create your own visual diagrams for your SQL Server database. These diagrams can be generated and viewed in the Enterprise Manager and can even be printed over multiple pages (which you will tape together and hang on your wall) for easier visualization. If you struggle with JOINs, subqueries, or foreign keys and relationships, then you'll enjoy this video on creating ERDs (Entity Relationship Diagrams) in SQL Server
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 erd, sql database diagram, sql diagram, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 9:00 PM    

Exchange 2003 Video Tutorial: Message Queues

Message Queues - view details
If you want to know how Message Queues (message queuing) works then check out this video on queues. You'll learn how to manage the queue, pause the messages in a queue and 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: configure Exchange message queues, message queues in Exchange

posted by Scott Whigham @ 9:00 PM    

Windows 2003 Video Tutorial: Active Directory Management: Basic Group Management (Mixed Mode)

Active Directory Management: Basic Group Management (Mixed Mode) - view details
In this video you will add a new container in Active Directory and add the group Junior Staff Members as well as adding users to groups and making decisions about whether this needs to be a Local Group, a Domain Group, or a Universal Group. You'll also understand what Universal Groups are, how to enable/disable them and how to have your Active Directory interact with Windows NT 4.0 (Mixed Mode). This video could also be titled 'How to build groups in the Active Directory with Active Directory Users and Computers'
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: Windows Server 2003 Mixed Mode, Windows NT 4.0 Active Directory Migration, Create Group in Active Directory with Windows 2003, b

posted by Scott Whigham @ 8:00 PM    

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 @ 8:00 PM    

Windows 2003 Video Tutorial: The Dreaded Blue Screen of Death: Every Administrators Nightmare!

The Dreaded Blue Screen of Death: Every Administrators Nightmare! - view details
While recording a video on how to add USB/Firewire drives into your Windows 2003 server, expert trainer Grant Moyle encountered a blue screen of death (BSOD). Unable to later reproduce the error, Grant decided to release this video showing you how you can experience these at the worst possible times (getting a BSOD while recording a 'How-To' video is not a good time!) and Grant talks about what the error text can mean and how to recover. Good job, Grant - way to recover gracefully! BE AWARE that Grant does not experience the BSOD until around 6:38. Feel free to fast forward if you like!
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: bsod windows 2003 how to recover

posted by Scott Whigham @ 7:00 PM    

Windows 2003 Video Tutorial: Creating an Integrated Software Directory with Install CD plus SP4 plus Rollup

Creating an Integrated Software Directory with Install CD plus SP4 plus Rollup - view details
Creating an Integrated Software Directory with Install CD plus SP4 plus Rollup
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: Creating an Integrated Software Directory with Install CD plus SP4 plus Rollup

posted by Scott Whigham @ 7:00 PM    

Exchange 2003 Video Tutorial: How to Install Windows Server 2003 R2 Standard Edition

How to Install Windows Server 2003 R2 Standard Edition - view details
In this video, consultant Grant A. Moyle shows you how to install Microsoft Windows 2003 R2, Standard Edition. You'll see the features of the Windows Server R2 setup and learn all the details about a typical Windows Server installation
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: setup windows 2003 r2, install windows server 2003 r2

posted by Scott Whigham @ 7:00 PM    

Windows 2003 Video Tutorial: Build Your First Domain Controller

Build Your First Domain Controller - view details
This video is perfect for helping you understand (a) the requirements for Active Directory setup, and (2) the setup and usage of your first domain controller. If you haven't used DCPromo before this is the perfect intro video for using DCPromo to promote a machine to become a domain controller. You'll take an existing fresh install of Windows Server 2003 and promote it to a domain controller. You'll assign static IP addresses, add domain accounts and more. This video could also be titled 'Add the First Domain Controller to Your Active Directory'
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: Windows 2003 Add New Domain Controller, Create Active Directory using DCPromo, beginner, beginning, for beginners, introduction,

posted by Scott Whigham @ 6:00 PM    

Windows 2003 Video Tutorial: Audit File and Folder Usage and Access

Audit File and Folder Usage and Access - view details
This is a great video to help you learn how to secure and audit certain directories on your Windows network. This video will show you how to secure a folder and/or files so that even the Administrators will not have access yet you'll still be able to determine who has accessed the file/folder. You'll use the Advanced Security Settings for Sensitive Info screen under the Security tab to add auditing in the Event Log. This can be quite tricky for first-timers since the default policies does not record audit information. Grant will walk you through setting up file/folder auditing and show you how to change the policies correctly. This video could also be titled 'How to Audit Folder Access using Windows Server 2003'
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: Windows 2003 file and folder auditing, Audit file usage in Windows 2003

posted by Scott Whigham @ 6:00 PM    

Microsoft SQL Server Video Tutorial: Pt. 5 - RETURN Codes and How to Use Them

Pt. 5 - RETURN Codes and How to Use Them - view details
The last video in our "Introduction to Stored Procedures" series, this video helps you understand the @RETURN_VALUE parameter when calling/executing stored procedures. The RETURN statement in SQL Server is very important - it allows you to stop execution inside a stored procedure or trigger. Did you know that it also has the ability to return a value to the caller? It sure can but there are certain rules and Best Practices. Check out this video for 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: RETURN, RETURN_VALUE, @@ERROR

posted by Scott Whigham @ 5:00 PM    

Exchange 2003 Video Tutorial: Clustering Exchange - Pt. 3 - Installing SP2 on the Cluster

Clustering Exchange - Pt. 3 - Installing SP2 on the Cluster - view details
Now that Exchange is installed on Node 1, you'll want to install the necessary Service Packs.
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: sp2, service pack 2, cluster, clustered service pack, how to install sp2

posted by Scott Whigham @ 5:00 PM    

SQL Server 2000 Video Tutorial: Database Diagrams - An Introduction

Database Diagrams - An Introduction - view details
All experienced SQL developers and administrators recognize that being able to "see" your database gives you great confidence in the queries you write. It helps speed up development, ensure correct queries, and remove guesswork from the development cycle (well, as much as possible). This video shows you how you can create your own visual diagrams for your SQL Server database. These diagrams can be generated and viewed in the Enterprise Manager and can even be printed over multiple pages (which you will tape together and hang on your wall) for easier visualization. If you struggle with JOINs, subqueries, or foreign keys and relationships, then you'll enjoy this video on creating ERDs (Entity Relationship Diagrams) in SQL Server
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 erd, sql database diagram, sql diagram, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 4:00 PM    

Exchange 2003 Video Tutorial: Pt. 2 - Preparing the Active Directory for Exchange 2000 - ForestPrep and DomainPrep

Pt. 2 - Preparing the Active Directory for Exchange 2000 - ForestPrep and DomainPrep - view details
In order to have a successful integration/installtion of Exchange 2000 with Active Directory, you have a little work to do first: Forest Prep and Domain Prep.
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: prepare active directory for exchange

posted by Scott Whigham @ 4:00 PM    

Microsoft SQL Server Video Tutorial: Part 2 - Network Libraries and Authentication Modes - Choosing What's Right for Your Organization

Part 2 - Network Libraries and Authentication Modes - Choosing What's Right for Your Organization - view details
Part 2 in our series on SQL Server Netlibs
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 server netlibs, sql server network libraries, sql server appletalk, multiprotocol, protocol encryption

posted by Scott Whigham @ 3:00 PM    

SQL Server 2000 Video Tutorial: Install SQL Server - Discussion of Whether Sharing SQL Server with IIS and Other Applications is Recommended

Install SQL Server - Discussion of Whether Sharing SQL Server with IIS and Other Applications is Recommended - view details
Veteran SQL trainer Scott Whigham talks to you about how to put your SQL Server on the web without unnecessarily exposing it directly to potential hackers, all wrapped in a discussion about whether you should install SQL Server on the web server or another server in your organization. This video also talks about how dynamic data pages, such as ASP, ASP.NET, and JSP, work with respect to SQL Server
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 iis, sql server iis, where to install sql server, separate machine

posted by Scott Whigham @ 3:00 PM    

Microsoft SQL Server Video Tutorial: Why You Use SCOPE_IDENTITY() Instead of @@IDENTITY

Why You Use SCOPE_IDENTITY() Instead of @@IDENTITY - view details
If your queries and stored procedures use @@IDENTITY (perhaps you have legacy code updated from SQL Server 7.0 or earlier), you'll likely get good value from watching this video on replacing @@IDENTITY calls with the T-SQL function SCOPE_IDENTITY(). This video shows very plainly the negative possiblities of using @@IDENTITY today (triggers are a real problem) and, after you watch this tutorial, you'll never want to use @@IDENTITY again!
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: scope Identity, dbcc check_ident

posted by Scott Whigham @ 2:00 PM    

Microsoft SQL Server Video Tutorial: Creating SQL Server Authentication Logins in the Enterprise Manager

Creating SQL Server Authentication Logins in the Enterprise Manager - view details
SQL Server expert and trainer Scott Whigham shows you how to create SQL Server Authentication logins in this video. You will get an excellent idea of how SQL Server Authentication works, Best Practices for using SQL Server logins, a discussion of the builtin logins (the "sa" account, for example), and much more on working with sysadmins and SQL logins.
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 server login, sql server sa account, sql sysadmin

posted by Scott Whigham @ 2:00 PM    

SQL Server 2000 Video Tutorial: Pages, Extents, and Blocksizes - What They Are and How They Work

Pages, Extents, and Blocksizes - What They Are and How They Work - view details
If knowing the architecture of SQL Server is interesting to you, then you'll enjoy this video from Scott Whigham on how things like pages and indexes work in SQL Server. This is more of a theoretical discussion that discusses the sysinternals of SQL Server at a high level. The goal is to give you an understanding of how SQL Server stores data and indexes and how your index and table design decisions can influence SQL Server in multiple ways
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 server architecture, sql design, sql internal design, index pages, extents

posted by Scott Whigham @ 1:00 PM    

Microsoft SQL Server Video Tutorial: Part 2 - An Overview of the AdventureWorks Database - Database Diagrams and DDL Triggers

Part 2 - An Overview of the AdventureWorks Database - Database Diagrams and DDL Triggers - view details
Continuing our series on the AdventureWorks database, Scott Whigham walks you through how to create database diagrams using AdventureWorks as well as using the DDL triggers for database-level events. A very interesting video with some exciting new SQL Server 2005 features.
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: database events, database event trigger

posted by Scott Whigham @ 1:00 PM    

Exchange 2003 Video Tutorial: POP3 and IMAP4 in Exchange 2003

POP3 and IMAP4 in Exchange 2003 - view details
This video takes a look at the IMAP4 and the POP3 protocol configuration in Exchange System Manager (ESM) so that our Exchange server will listen for IMAP4 and POP3 requests on the internet. Grant Moyle, Exchange trainer, explains what POP3 and IMAP4 are and how they are used on the world wide web today
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: POP3 IMAP4 with Exchange, IMAP4 with Exchange, POP3 with Exchange, beginner, beginning, for beginners, introduction, step by ste

posted by Scott Whigham @ 1:00 PM    

Exchange 2003 Video Tutorial: Recover a Mailbox From an RSG After It Has Been Removed From the Active Directory

Recover a Mailbox From an RSG After It Has Been Removed From the Active Directory - view details
The Recovery Storage Group (RSG) can be very valuable. If you've recently done a recovery there can be one tiny little problem that it can have. This video helps you understand what the problem is and how to resolve it
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: Recover Exchange mailbox using RSG, Remove Exchange from AD, Remove Exchange from Active Directory

posted by Scott Whigham @ 12:00 PM    

Windows 2003 Video Tutorial: Windows Services: Explanations and Best Practices

Windows Services: Explanations and Best Practices - view details
If you've ever looked in the Services applet and wondered 'What does that service do?' then this video is for you! Grant Moyle, veteran Windows trainer and consultant, explains the details of some of the most common services you'll see in Windows. All Windows admins should view this video - it is essential knowledge for any sysadmin
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: windows 2003 services

posted by Scott Whigham @ 12:00 PM    

DTS Video Tutorial: Who Uses DTS? What Are the Goals of DTS? An Overview of DTS as an ETL Tool

Who Uses DTS? What Are the Goals of DTS? An Overview of DTS as an ETL Tool - view details
This video is for those of you who are new to DTS and possibly even SQL Server. It is meant to describe the many uses of DTS including its role in data warehousing (as an E.T.L. tool).
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: etl, extract, datamart, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 11:00 AM    

Microsoft SQL Server Video Tutorial: Pt. 2 - Determining Which Events, Data Columns and Filters to Use in Your Trace

Pt. 2 - Determining Which Events, Data Columns and Filters to Use in Your Trace - view details
You can significantly impact your trace's "drag" on your SQL Server by wisely choosing your events, data columns, and filters when you start your trace. This video walks you through the Event Classes (and makes suggestions as to which to use for what purpose), what common Data Columns are used (and what are Data Columns anyway?), and how filters can be used (what Event Classes use what Filters?).

Highlights from this video:
  • Suggestions for using filters to create more manageable traces
  • Tracing for performance tuning
  • Tracing errors
  • Viewing trace data and interpreting Profiler's results
  • What's the difference between "Profiler" and a "trace"?
  • SQL Batches and the SP:BatchCompleted Event Class
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: sql trace, RPC:Complete, CursorOpen, Deadlock, Exception, Data File Auto Grow, SP:CacheMiss, SP:CacheInsert

posted by Scott Whigham @ 11:00 AM    

SQL Server 2000 Video Tutorial: Pt. 3 - What Do You Do With Your Trace Data? How to Write Queries Against Your Trace

Pt. 3 - What Do You Do With Your Trace Data? How to Write Queries Against Your Trace - view details
Do you want to know how many times a query has run in your trace? What about finding aggregates like what the minimum duration, maximum duration, and average durations/page reads/CPU? This is a great video that teaches you how to manipulate the trace data into a table for querying. Even then, you still have some work to do...

Highlights from this video:
  • How to save a trace to a table
  • Querying trace tables
  • Writing reporting-style queries against traces
  • Working with ntext data types and GROUP BY/WHERE clauses
  • Modifying your trace table to make it usable in aggregates
  • Saving the queries traced to a SQL file
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: profile, profiler table, write queries against profiler data

posted by Scott Whigham @ 10:00 AM    

SQL Server 2000 Video Tutorial: Defaults and Rules in SQL Server 2000 - What They Are, How to Use Them and Best Practices

Defaults and Rules in SQL Server 2000 - What They Are, How to Use Them and Best Practices - view details
What is the difference between a SQL Server Default and a Default constraint (or are they the same thing)? Should you use a Check constraint or a Rule (and are they the same thing)? SQL Server Defaults and Rules have been around forever in SQL Server but, if you don't know what they are, then you should watch 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: sql default, sql rule

posted by Scott Whigham @ 10:00 AM    

SQL Server 2005 Video Tutorial: Pt. 5 - RETURN Codes and How to Use Them

Pt. 5 - RETURN Codes and How to Use Them - view details
The last video in our "Introduction to Stored Procedures" series, this video helps you understand the @RETURN_VALUE parameter when calling/executing stored procedures. The RETURN statement in SQL Server is very important - it allows you to stop execution inside a stored procedure or trigger. Did you know that it also has the ability to return a value to the caller? It sure can but there are certain rules and Best Practices. Check out this video for 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: RETURN, RETURN_VALUE, @@ERROR

posted by Scott Whigham @ 9:00 AM    

Windows 2003 Video Tutorial: Installing NT 4.0 PDC

Installing NT 4.0 PDC - view details
Installing NT 4.0 PDC
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: Installing NT 4.0 PDC

posted by Scott Whigham @ 9:00 AM    

Microsoft SQL Server Video Tutorial: Part 1 - An Overview of the Default SQL Server Installation

Part 1 - An Overview of the Default SQL Server Installation - view details
SQL trainer Scott Whigham walks you through the default installation of SQL Server 2005 in this video, part 1 in a series on installing SQL Server 2005. In this video you'll learn about the instances, folders, services, and options chosen during the default install.
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 2005 overview, sql server change, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 8:00 AM    

Exchange 2003 Video Tutorial: Outlook 2003 Tips: Junk Email, How to Disable Word as Editor, Recover Delete Items and Public Folder Favorites

Outlook 2003 Tips: Junk Email, How to Disable Word as Editor, Recover Delete Items and Public Folder Favorites - view details
We all use Outlook so we all want the tips and tricks, right? Grant Moyle, Exchange guru extraordinaire, shows you some of his favorite Exchange-related tweaks and optimizations for Microsoft Outlook in 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: ms outlook, outlook express, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 8:00 AM    

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 @ 8:00 AM    

DTS Video Tutorial: Understanding How DTS Package Logs and Error Logs Work in SQL Server 2000

Understanding How DTS Package Logs and Error Logs Work in SQL Server 2000 - view details
Understanding How DTS Package Logs and Error Logs Work in SQL Server 2000
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: Understanding How DTS Package Logs and Error Logs Work in SQL Server 2000

posted by Scott Whigham @ 7:00 AM    

Windows 2003 Video Tutorial: Pt. 4 - Setting Up the Cluster for the First Time

Pt. 4 - Setting Up the Cluster for the First Time - view details
Now that you've put in the hard work to setup the pre-requisites and requirements for the cluster, it's finally time to setup the cluster.

Highlights from this video:
  • Setting up cluster service accounts
  • Security for your cluster
  • Installing Microsoft Cluster Service (MSCS)
  • Running the New Server Cluster Wizard
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: cluster, clustering, clustered, setup, setting up, install, installing clusters, ip address, san, public ip address, private ip

posted by Scott Whigham @ 7:00 AM    

Transact SQL Video Tutorial: Creating and Altering Views in the Enterprise Manager (SQL Server 2000)

Creating and Altering Views in the Enterprise Manager (SQL Server 2000) - view details
If you are new to working with SQL Server (and views), then this is an excellent introduction to creating and altering views using SQL Server 2000's Enterprise Manager. This video is focused on SQL Server 2000 but, for those of you using SQL Server 2005, the screens are almost identical in the SQL Server Management Studio.
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 view, alter view, drop view

posted by Scott Whigham @ 7:00 AM    

Exchange 2003 Video Tutorial: Trying to Bring Back a Deleted Message with a Database Restore

Trying to Bring Back a Deleted Message with a Database Restore - view details
In Exchange 2003 anything that happens inside Exchange (such as a new message being delivered) is located in the transaction log. This video shows you how to use a data restore to recover a user's message. This video could also be titled 'Disaster Recovery: Restoring a Message With the Transaction Log'
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: retrieve mailbox with database restore

posted by Scott Whigham @