Saturday, February 24, 2007

Exchange 2007/2003 Video Tutorial: Install Intelligent Message Filter (IMF) from Exchange 2003 Service Pack 1

Install Intelligent Message Filter (IMF) from Exchange 2003 Service Pack 1 - view details
This video walks you through the installation of IMF for Exchange and explains it use.
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: imf install, imf spam Exchange, spam blocker exchange, junk mail filter Exchange

posted by Scott Whigham @ 8:00 PM    

SQL Server 2000 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 @ 7:00 PM    

Windows 2003 Video Tutorial: How to Join a Computer to the Domain

How to Join a Computer to the Domain - view details
A quick video designed to show you how to join a computer to a domain and the benefits of doing so
To download this video, log i n, 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: join Windows domain, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 6:00 PM    

Microsoft SQL Server Video Tutorial: Part 1 - An Overview of the Options Available for Upgrading and Migrating

Part 1 - An Overview of the Options Available for Upgrading and Migrating - view details
This video walks you through the choices for migrating to SQL Server 2005 from prior versions (such as SQL Server 2000 or SQL Server 7.0). This is the first video in our series on upgrading to SQL Server 2005 from previous versions and highlights the different options for upgrading along with offering recommendations for your upgrade.
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: upgrade sql server 2000, upgrade sql 7.0, upgrade sql 7, migrate sql server 2000

posted by Scott Whigham @ 5:00 PM    

Windows 2003 Video Tutorial: Rename Windows 2003 Server and Determine Computer Name (hostname)

Rename Windows 2003 Server and Determine Computer Name (hostname) - view details
Rename Windows 2003 Server and Determine Computer Name (hostname)
To download this video, log in< /a>, 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: Rename Windows 2003 Server and Determine Computer Name (hostname)

posted by Scott Whigham @ 4:00 PM    

Exchange 2007/2003 Video Tutorial: Clustering Exchange - Pt. 4 - Installing Exchange on Node 2 (the Second Node)

Clustering Exchange - Pt. 4 - Installing Exchange on Node 2 (the Second Node) - view details
Continuing our "Installing Exchange Clusters" series is this video: how to set up the second node for Exchange.
To download this vide o, 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 node 2, clustering nodes, node clustering on Exchange

posted by Scott Whigham @ 3:00 PM    

Exchange 2007/2003 Video Tutorial: Setup Certificate Authority and Issue SSL Certificate for OWA (Outlook Web Access)

Setup Certificate Authority and Issue SSL Certificate for OWA (Outlook Web Access) - view details
There's a lot to managing certificates - this video covers the basics of getting certificates up and running so that your users can have secure connections through Outlook Web Access (OWA). Exchange guru Grant Moyle gives you several tips for installing certificates, using Exchange certificates and working with OWA
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: how to issue SSL certificate for Exchange, SSL certificate tutorial for Exchange

posted by Scott Whigham @ 2:00 PM    

Visual C# Video Tutorial: Pt. 2 - Working with WinForms

Pt. 2 - Working with WinForms - view details
WinForms, short for Windows Forms, are the basis for the UI in any Windows application and this video gets you started with Visual C# Express Edition by creating a Windows application with Windows forms.
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 forms apps, winform apps

posted by Scott Whigham @ 1:00 PM    

Windows 2003 Video Tutorial: Using Windows Server Update Services (WSUS) From a Standalone Workstation

Using Windows Server Update Services (WSUS) From a Standalone Workstation - view details
Many organizations utilize the Windows Server Update Services (WSUS). What is a WSUS Server? Well, watch this video and find out!
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: wsus installation, setup, installing, configuring

posted by Scott Whigham @ 12:00 PM    

Windows 2003 Video Tutorial: How to Remove a Computer (Windows XP) from the Domain

How to Remove a Computer (Windows XP) from the Domain - view details
At some point all administrators will need to remove a computer from the domain. This video helps you understand the effects of removing a computer from the domain and gives you many tips for safe removal
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: remove Windows XP machine from domain

posted by Scott Whigham @ 11:00 AM    

Microsoft SQL Server 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 @ 10:00 AM    

Transact SQL Video Tutorial: Design Pattern for Finding Duplicate Data - A Simple Way to Spot Non-Unique Rows (Multi Column Test)

Design Pattern for Finding Duplicate Data - A Simple Way to Spot Non-Unique Rows (Multi Column Test) - view details
We have multiple SQL tutorials for writing queries to return duplicate data in a column or multiple columns. This video focuses on spotting dupes across multiple columns. Although primary keys prevent duplicate rows, having a Primary Key on "EmployeeId" does not prevent users from entering duplicate LastName/FirstName combinations. This video shows you how to use subqueries (both correlated and simple) along with EXISTS to locate non-unique rows.
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: duplicate check

posted by Scott Whigham @ 9:00 AM    

Exchange 2007/2003 Video Tutorial: Restore Database Following Database Crash (Disaster Recovery for Exchange)

Restore Database Following Database Crash (Disaster Recovery for Exchange) - view details
This video helps you understand disaster recovery for Exchange 2003. If your database crashes due to file corruption, disk crash, or any other type of error you'll need to restore your database. This video helps you understand disaster recovery models in Exchange. A must-see 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: exchange restore database

posted by Scott Whigham @ 9:00 AM    

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

SQL Server Integration Services Video Tutorial: Pt. 1 - Installing Visual Studio 2005 Express Editions

Pt. 1 - Installing Visual Studio 2005 Express Editions - view details
This video, the first in our series on using .NET assemblies in SSIS tasks, walks you the installation of your Visual Studio environment. This particular video talks about using Visual Studio Express Editions as a free way to develop your own custom assemblies that you can use in your SSIS packages.

Highlights from this video series:
  • Setting up Visual C# Express Edition (or Visual Basic Express Edition)
  • Writing assemblies (class libraries) using C# and Visual Basic
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: install, beginner, beginning, setup, installation

posted by Scott Whigham @ 7:00 AM    

Exchange 2007/2003 Video Tutorial: Sending an E-mail Message with a VBScript Using CDO.Message

Sending an E-mail Message with a VBScript Using CDO.Message - view details
This video shows how to use a simple Visual Basic Scripting Edition (.vbs) script to send an e-mail message. Useful for Administrators and programmers.

Just a few highlights from this video:
  • Using VBScript to send email through SMTP (in this case, the SMTP server is an Exchange Server)
  • Using VBScript variables to create objects and store values for CDO Messages
  • Using WScript.Echo to verify your mail was sent successfully
  • Basic error handling within VBScript using CDO
  • Discussions of the various properties and methods exposed by CDO
  • Using the Configuration.Fields method of CDO to add schemas to your outbound email


This video was a request from one of our subscribers. Do you have any video requests? We'd love to hear from you - visit our page and submit it 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: vbs, vbscript cdonts, cdo.message

posted by Scott Whigham @ 7:00 AM    

SQL Server Integration Services Video Tutorial: Working With the Foreach Loop Container - Iterating Through Files in a Folder

Working With the Foreach Loop Container - Iterating Through Files in a Folder - view details
Often we need to load data that is in text files (also called flat files) and insert their rows into a table. This video talks about using the Foreach Loop Container and the Foreach File Enumerator along with user variables to loop through each file in a given folder.

This video helps you create an SSIS package that takes every file in a folder and loads the data into a SQL Server table.

Highlights from this video:
  • Traversing subfolders using the Foreach Loop Container
  • Avoiding the use of ActiveX Script or the Script Task in favor of using the native SSIS tasks for iteration (no more scripting!)
  • Using the Script Task to report the filename (fully qualified and/or the file name only)
  • Creating variables and assigning variables in the Foreach Loop Container
  • How to use masks to determine which files in a given directory to load
    • Only load .txt files
    • Only load files that begin with Employees_ and end in .dat (i.e., Employees_2006.dat or Employees_NewYork.data but not Customers_2006.dat)
  • Using Connection Managers with Expressions to assign connection strings based on the Foreach Loop Container's variable assignment
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: iterating, recursively, recursion, looping, loops, FileSystemObject, FSO, objFSO, MoveNext, VBScript

posted by Scott Whigham @ 7:00 AM    

Exchange 2007/2003 Video Tutorial: How to Remove And Reinstall an Exchange Server On Your Domain

How to Remove And Reinstall an Exchange Server On Your Domain - view details
This Exchange Server 2003 training video shows you how to do one of the most difficult tasks an Exchange administrator can ever have to do: uninstall Exchange completely from the machine. WARNING: You will be modifying important registry entries if you follow along on your own PC. After you completely remove Exchange Server from the machine you will then walk through re-installing Exchange. This is a very advanced video due to the number of steps involved: uninstalling Exchange requires you to uninstall/reinstall IIS, modify the registry, and re-apply any service packs/hotfixes to your newly installed Exchange Server. You will also see use of the Exchange Server 2003 Installation Wizard to uninstall/re- install in addition to removing Exchange Server from the Active Directory. If you want to be a true Exchange guru you must know how to correctly uninstall/re-install in the event you have database corruption or worse.
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: uninstall exchange, uninstall exchange 2003, uninstall exchange server 2003

posted by Scott Whigham @ 6:00 AM    

Microsoft SQL Server Video Tutorial: Pt. 5 - Templates and Working Within the Profiler UI

Pt. 5 - Templates and Working Within the Profiler UI - view details
This is a quick video that teaches you how to work with templates in Profiler so that you can quickly start tracing and get helpful data.

Highlights from this video:
  • Default templates
  • How to Backup templates
  • Importing and Exporting templates
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 TS CC codec installed to view this video

Keywords Associated with this video: trace template, start automatically, profile startup

posted by Scott Whigham @ 6:00 AM    

Visual C# Video Tutorial: Pt. 1 - Creating Our First Application Using Visual C# Express Edition

Pt. 1 - Creating Our First Application Using Visual C# Express Edition - view details
This video walks you through creating your first Windows application with a discussion of the various project types as well as properties and events.

Highlights from this video:
  • Properties and Eventhandlers
  • Understanding the various project types and project templates
  • Creating Projects and Solutions
and much more.

NOTE: If you are a beginner or are new to C# and you are using the Express Edition, you'll definitely want to watch this video very early on in your C# development.
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: beginner, beginning, intro, introduction, msde, starter

posted by Scott Whigham @ 6:00 AM    

DTS Video Tutorial: Part 2 - How to Assign Values to Global Variables Using the Execute SQL Task

Part 2 - How to Assign Values to Global Variables Using the Execute SQL Task - view details
Part 2 - How to Assign Values to Global Variables Using the Execute SQL Task
To download this video, log in, then visi t 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: Part 2 - How to Assign Values to Global Variables Using the Execute SQL Task

posted by Scott Whigham @ 5:00 AM    

Windows 2003 Video Tutorial: Prevent Changes to a Customized Microsoft Management Console (MMC)

Prevent Changes to a Customized Microsoft Management Console (MMC) - view details
Prevent Changes to a Customized Microsoft Management Console (MMC)
To download this video, log in< /a>, 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: Prevent Changes to a Customized Microsoft Management Console (MMC)

posted by Scott Whigham @ 5:00 AM    

SQL Server 2000 Video Tutorial: Pt. 4 - Viewing the Results and Doing Repairs

Pt. 4 - Viewing the Results and Doing Repairs - view details
Although the Access Upsizing Wizard isn't perfect, it is a tremendous timesaver. You will need to do a few repairs after it has finished such as rwriting views/functions/stored procedures and verifying and modifying datatypes.

Highlights from this video:
  • Common pitfalls of the Upsizing Wizard
  • Suggestions for datatypes
  • How to rewrite Access queries to become SQL Server objects
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: unicode, nvarchar, real

posted by Scott Whigham @ 5:00 AM    

SQL Server 2000 Video Tutorial: Stored Procedure Introduction: Definition, Usage, and Creating Stored Procedures Using the Create Stored Procedure Wizard

Stored Procedure Introduction: Definition, Usage, and Creating Stored Procedures Using the Create Stored Procedure Wizard - view details
Stored procedures are, quite simply, the most popular way that modern database developers allow applications to interface with the database. This video is an excellent introduction to what a stored procedure is, how to use ("execute") stored procedures, and the syntax and tools used in creating/managing stored procedures.

The Enterprise Manager allows you to quickly create generic stored procedures using the Create Stored Procedure Wizard. Is it a good wizard; i.e., should you use it? Maybe - this video gives you the pros and cons of using the Enterprise Manager to manage stored procedures.

Highlights from this video:

  • What is a stored procedure?
  • Example stored procedures
  • Using the Create Stored Procedure Wizard
  • Suggestions for using stored procs
  • Naming Conventions
  • Creating and Editing Stored Procedures with TSQL

Note: This should be considered a "Must-See" video for all newbies!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a s ubscription is required.

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

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

posted by Scott Whigham @ 4:00 AM    

Windows 2003 Video Tutorial: Lecture on How File Deletion Works on Windows 2003 Including How to Tune the Windows 2003 Recycle Bin

Lecture on How File Deletion Works on Windows 2003 Including How to Tune the Windows 2003 Recycle Bin - view details
Lecture on How File Deletion Works on Windows 2003 Including How to Tune the Windows 2003 Recycle Bin
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: Lecture on How File Deletion Works on Windows 2003 Including How to Tune the Windows 2003 Recycle Bin, beginner, beginning, for

posted by Scott Whigham @ 4:00 AM    

SQL Server 2000 Video Tutorial: How to Increase a Database's Size Using the SQL Server Enterprise Manager

How to Increase a Database's Size Using the SQL Server Enterprise Manager - view details
If you don't know the ALTER DATABASE commands for increasing your SQL Server file sizes (or don't want to use it), then this video is a great head-start to learning file manipulation and management for SQL Server 2000. Veteran SQL Server trainer Scott Whigham shows you a few of his tips and tricks for working with the Enterprise Manager as well.
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: grow database sql server, grow sql file, increase sql database

posted by Scott Whigham @ 4:00 AM    

Microsoft SQL Server Video Tutorial: Pt. 1 - Using SQL Profiler - Concepts and Screens

Pt. 1 - Using SQL Profiler - Concepts and Screens - view details
SQL Server Profiler is one of the greatest SQL Server admin tools ever - you absolutely need to know it! This video walks you through the basics of "What is SQL Server Profiler?" and "How do I run Profiler?"

Highlights from this video:
  • What traces are and how to use them
  • Security requirements for running Profiler
  • Using (local) or . or any alias in Profiler - good or bad?
  • Concepts of server-side tracing vs. client-side traces
  • Suggestions for naming traces
  • Explanation of rollover files and Best Practices for using Profiler
  • Should You Trace to File or Trace to Table? What's the "Best Practice"?
  • Using templates
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, sql profiler, sql server 2000 profiler, profiling, sql sniffer, sniffing sql, tracing sql

posted by Scott Whigham @ 3:00 AM    

Microsoft SQL Server Video Tutorial: Overview of SET Commands in Transact-SQL - What They Are, Syntax, and How to Use Them

Overview of SET Commands in Transact-SQL - What They Are, Syntax, and How to Use Them - view details
SET commands in T-SQL control the environment in which SQL Server or the client processes that client queries. This view shows you some of the more common SET commands, how they work, scoping (are they scoped to the statement, the batch, the connection?), and how you can use SET commands to increase throughput and help increase your SQL knowledge.
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: SET NOCOUNT ON, OFF, QUOTED_IDENTIFIERS, ANSI_NULLS

posted by Scott Whigham @ 3:00 AM    

Windows 2003 Video Tutorial: Using Disk Quotas to Document Disk Usage

Using Disk Quotas to Document Disk Usage - view details
Disk quotas allow the Windows administrator to ensure that certain users can only take up so much file storage. This video shows you how to audit folder space usage and set up disk quotas
To d ownload 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 disk quotas

posted by Scott Whigham @ 3:00 AM    

Exchange 2007/2003 Video Tutorial: Exchange 5.5 - Outlook Profiles and Moving Mailboxes

Exchange 5.5 - Outlook Profiles and Moving Mailboxes - view details
Continuing our scenario for installing Exchange 5.5, this video teaches you all about working with Microsoft Outlook profiles and how to move mailboxes between Exchange servers.

posted by Scott Whigham @ 2:00 AM    

SQL Server 2005 Video Tutorial: Part 1 - Common Table Expressions (CTEs) - What They Are and When to Use Them

Part 1 - Common Table Expressions (CTEs) - What They Are and When to Use Them - view details
Common Table Expressions (CTEs) are an interesting addition to SQL Server 2005's Transact-SQL language. Scott Whigham, author of LearnSqlServer.com and LearnTransactSql.com, walks you through the basics of what CTEs are, the syntax and concepts of using CTE and gives you a few examples in this video. This video is part 1 in our series on CTEs and is designed to be an introduction to the syntax and the concepts of using CTEs.
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 recursion, sql hierarchy, hierarchical query

posted by Scott Whigham @ 2:00 AM    

Visual C# Video Tutorial: Pt. 7 - A Quick Tour of the Standard Controls

Pt. 7 - A Quick Tour of the Standard Controls - view details
Pt. 7 - A Quick Tour of the Standard Controls
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: panel, placeholder, radio button, dropdownlist, controls

posted by Scott Whigham @ 2:00 AM    

SQL Server 2000 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 @ 1:00 AM    

SQL Server 2000 Video Tutorial: Result sets, Recordsets, and the Client Server model

Result sets, Recordsets, and the Client Server model - view details
This video is really helpful for you newbies - those of you who want to get up to speed on all the terms, jargon, parlance, and lexicon of SQL Server. Is a field the same as a column? An alias the same as a header? Is Result Set the same as resultset? The answer to all three questions is "Probably yes, depending on who's asking!" This video helps you dissect several (not all) of the confusing terms and tries to help you speak the language fluidly and easily. Is a recordset the same as a resultset? If you don't know, 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 Server resultset, client/server, beginn er, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 1:00 AM    

Windows 2003 Video Tutorial: Configure DNS Server for Static IP Addresses

Configure DNS Server for Static IP Addresses - view details
Most systems will use DHCP but there are times you need to assign static IP addresses. In this video you'll learn how to assign these static IP address in your DNS server(s)
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: DNS static IP address configuration

posted by Scott Whigham @ 1:00 AM    

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

Exchange 2007/2003 Video Tutorial: How the Exchange Database Works: Database Growth

How the Exchange Database Works: Database Growth - view details
This video shows you what happens to your Exchange databases when your database grows. You'll learn what the STM and the LOG files do along with the EDB files. A great video for Exchange administrators of all levels
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 database explanation, exchange database intro

posted by Scott Whigham @ 12:00 AM    

SQL Server 2000 Video Tutorial: Pt. 2 - Migration and Upgrade Options for Moving From Access to SQL Server

Pt. 2 - Migration and Upgrade Options for Moving From Access to SQL Server - view details
This video covers the basic tools that you use to migrate from Access to SQL Server including discussions of differences in migrating the various versions of Access and SQL Server.

Highlights from this video:
  • Discussions on moving from Access 2007, 2003, 2000, XP, and even 97
  • Techniques for migrating one table at a time
  • Techniques for migrating all tables
  • Using DTS (Data Transformation Services) to upgrade to SQL Server 2000
  • Using SSIS (SQL Server Integration Services) for upgrades to SQL Server 2005
  • Text files as an upgrading option
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 i nstalled to view this video

Keywords Associated with this video: migration, migrating, upgrades, upgrading

posted by Scott Whigham @ 12:00 AM    

Friday, February 23, 2007

SQL Server 2005 Video Tutorial: Pt. 1 - Transactions and Failover

Pt. 1 - Transactions and Failover - view details
Now that you have installed your cluster, you'll want to test the failover - right? You do want to make sure it works in the event of a disaster, don't you?

Scared?

Just a bit?

Well, there's no need - clusters are no longer incredibly difficult to manage and certainly SQL Server's integration within the cluster makes this a much less painful process than in years past.

Highlights from this video:
  • What happens to running queries/transactions when a failover event (i.e., a failure) occurs?
  • How to manually failover and failback
  • Identifying your service pack level
  • Using the Cluster Administrator (comclust.exe) to manage your groups and resou rces
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: fail over, failback, fail back, active, passive, node, virtual server

posted by Scott Whigham @ 11:00 PM    

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

Active Directory Management: Basic Group Management (Mixed Mode) - view de