Saturday, November 25, 2006

Exchange 2003 Video Tutorial: Part 2 of 2 - Retire an Exchange Server

Part 2 of 2 - Retire an Exchange Server - view details
In part 2 of this two-part series, you'll finish the migration from one server to another and uninstall Exchange
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 exchange from AD, remove exchange from active directory

posted by Scott Whigham @ 11:08 PM    

Exchange 2003 Video Tutorial: Storage Groups: What Are They and How They Work

Storage Groups: What Are They and How They Work - view details
Storage Groups are inherent to Microsoft Exchange and learning the details on storage groups is a requirement for all Exchange administrators. This excellent video from Exchange guru Grant Moyle is a great tutorial on working with storage groups and the differences between the Standard and Enterprise editions with respect to working with storage groups.
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 Exchange storage groups, exchange storage group tutorial, how to work with Exchange storage groups, beginner, begi

posted by Scott Whigham @ 11:08 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 @ 11:08 PM    

Windows 2003 Video Tutorial: Windows 2003 - Lecture on Upgrading 2000 Active Directory to Windows 2003 Active Directory

Windows 2003 - Lecture on Upgrading 2000 Active Directory to Windows 2003 Active Directory - view details
This is perhaps the first video you'll want to watch before upgrading Windows 2000 AD to Windows 2003. This video talks about the architecture of the upgrade and walks you through the process. Because the upgrade process is such an involved process involving multiple servers and reboots, you'll likely want to start this series with this video to help grasp the "Big Picture"
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: upgrading active directory

posted by Scott Whigham @ 10:08 PM    

Windows 2003 Video Tutorial: Power Configuration for Windows Server

Power Configuration for Windows Server - view details
Power Configuration for Windows 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: Power Configuration for Windows Server

posted by Scott Whigham @ 10:08 PM    

Microsoft SQL Server Video Tutorial: JOINs and UNIONs - How Do I Know When to Use a JOIN or a UNION?

JOINs and UNIONs - How Do I Know When to Use a JOIN or a UNION? - view details
So many newbies to Transact-SQL have difficulties determing when to use a UNION or a JOIN to satisy their query. This video teaches you some guidelines to help you quickly and easily identify whether your query will likely need to become a JOIN or UNION. Disclaimer: these are just guidelines and they will not work in every situation but they are applicable for most SQL developers most of the time.
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: join union, sql ansi join, sql union all

posted by Scott Whigham @ 9:08 PM    

Windows 2003 Video Tutorial: How to Perform Network Diagnostics and Create Customized Reports Using Help and Support Center

How to Perform Network Diagnostics and Create Customized Reports Using Help and Support Center - view details
How to Perform Network Diagnostics and Create Customized Reports Using Help and Support Center
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 Perform Network Diagnostics and Create Customized Reports Using Help and Support Center

posted by Scott Whigham @ 9:08 PM    

SQL Server 2005 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:08 PM    

SQL Server 2000 Video Tutorial: Collations, Character Sets, Code Pages, and Sort Orders - How String Data Works in SQL Server

Collations, Character Sets, Code Pages, and Sort Orders - How String Data Works in SQL Server - view details
Do you know what a collation is in SQL Server? What's the difference between CI and CS collations? How about CP1 versus CP1252 - what's the difference (nothing)? If these questions baffle you, then you might enjoy watching Scott Whigham explain how string (character) data works in SQL Server. If you are trying to understand how SQL Server works with case-sensitive data (or case-insensitive data), then you'll get a lot out of this video. Learn the difference between SQL Collations, Windows Locale, Code Pages, and whether or not a lower-case "a" sorts before or after an upper-case "A"
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: collate, collation, sql collation

posted by Scott Whigham @ 8:08 PM    

Microsoft SQL Server Video Tutorial: Pt. 1 - Introduction to SQL Server 2005 Maintenance Plans

Pt. 1 - Introduction to SQL Server 2005 Maintenance Plans - view details
Maintenance Plans (and the Maintenance Plan Wizard) are not new in SQL Server; Microsoft introduced Maintenance Plans in SQL Server 7.0 as a great way to automatically schedule common DBA tasks such as backups. In SQL Server 2005, Microsoft has really listened to its customers and vastly improved the Maintenance Plans (and wizard). If you've used Maintenance Plans in the past, things have changed considerably but for the good.

This video walks you through (1) what maintenance plans are, (2) launching the Maintenance Plan Wizard, and the basic choices of the wizard. There are so many choices in the Maintenance Plan Wizard that this video can only cover so many; the remaining videos of the series will help you walk through all of the choices in the maintenance plans. This particular video focuses on the "Check Database Integrity" choice including a walk-through of DBCC CHECKDB and what impact selecting this option may have on your server and a discussion on how often you'll want to schedule this option.

Another option covered in this video is the "Shrink Database" task along with Scott Whigham's discussion of Best Practices for shrinking databases.
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 maintenance plan, maintenance plans, maintenance plan task, maintenance plan wizard

posted by Scott Whigham @ 8:08 PM    

SQL Server 2000 Video Tutorial: Setting Database Options Using the Enterprise Manager - Setting the Database State Options

Setting Database Options Using the Enterprise Manager - Setting the Database State Options - view details
This is one of those "Oh okay, I didn't know exactly what that did" type of videos. SQL Server MCDBA Scott Whigham walks you through the settable database options that you find in the Enterprise Manager and presents the information in any easy-to-follow format that anyone can understand.
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 options, set database options, alter database

posted by Scott Whigham @ 8:08 PM    

Transact SQL Video Tutorial: Part 1 - Design Pattern for JOINs - A Simple Way to Look at Joining Tables

Part 1 - Design Pattern for JOINs - A Simple Way to Look at Joining Tables - view details
Another interesting design pattern for Transact-SQL is the JOIN pattern. The JOIN pattern is a simplistic way of looking at table joins and works with two table joins, three table joins and more. This video, part 1 of 2, features the basics concepts of the pattern and shows you 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: sql server design pattern, design patterns for sql

posted by Scott Whigham @ 7:09 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:08 PM    

SQL Server 2005 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 @ 6:08 PM    

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 @ 5:08 PM    

Exchange 2003 Video Tutorial: Configuring Outlook to Access your Exchange Server (How to Setup a Mail Profile)

Configuring Outlook to Access your Exchange Server (How to Setup a Mail Profile) - view details
This user or new administrator video shows how to setup Microsoft Outlook the first time you run it to access the Exchange Server. When you launch Outlook 2000, Outlook XP, Outlook 2003 or even 2007 for the first time, it will prompt you to walk through the "Configuring Outlook" wizard (similar names among the various versions but all essentially the same). This configures what is called a "Mail Profile" that you can later access/modify via either the Control Panel or within Outlook. To be able to use MS Outlook within an organization that uses Exchange, you must set up a Mail Profile that uses Exchange Server. This video walks you through step-by-step how to configure the Mail Profile along with thorough explanations of what each box and screen means/does.

Confused about what "Use Cached Exchange Mode" is? Should you check the box for it? Watch this video and find out!

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 Contact Us 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: configure outlook with exchange, set up outlook with Exchange, setup outlook, setup mail profile, beginner, beginning, for begin

posted by Scott Whigham @ 5:08 PM    

DTS Video Tutorial: Part 1 - Import Text File Data into SQL Server Table Using the Transform Data Task

Part 1 - Import Text File Data into SQL Server Table Using the Transform Data Task - view details
Part 1 - Import Text File Data into SQL Server Table Using the Transform Data Task
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: Part 1 - Import Text File Data into SQL Server Table Using the Transform Data Task

posted by Scott Whigham @ 4:08 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 @ 4:08 PM    

SQL Server 2005 Video Tutorial: Part 1 - An Overview of the Setup Process Including Installing the Pre-Requisites

Part 1 - An Overview of the Setup Process Including Installing the Pre-Requisites - view details
The setup process for SQL Server 2005 is very involved, may take you over an hour (depending on features you choose and speed of media) and often features cryptic messages and stringent requirements. This video is designed to help you understand the initial setup including installing the Pre-Requisites (such as the .NET 2.0 Framework). You'll also receive a few suggestions and recommendations for ensuring a smooth setup experience.
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 prerequisite, sql pre-requisite, minimum requirements, sql hardware, .net 2.0, setup, set up, beginner, beginning, for begin

posted by Scott Whigham @ 4:08 PM    

Windows 2003 Video Tutorial: Local Security Policy Management

Local Security Policy Management - view details
Local Security Policy can manage things such as auditing, password retention/aging parameters, file and folder access and much, much more. Windows training guru Grant Moyle walks you through the basic Local Policy security settings and explains password management, log on locally, 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: local security policy Windows 2003

posted by Scott Whigham @ 3:08 PM    

Microsoft SQL Server Video Tutorial: Part 1 - How to Configure SQL Server 2005 for Remote Connections Using TCP IP and Named Pipes

Part 1 - How to Configure SQL Server 2005 for Remote Connections Using TCP IP and Named Pipes - view details
When you install SQL Server 2005, remote connections are disabled. This can cause confusion for newbies trying to install and work with SQL Server for the first time. This video shows you the secure-by-default design and how to configure your SQL Server for remote connections and TCP IP.
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 port, sql connection, connect sql server

posted by Scott Whigham @ 3:08 PM    

SQL Server 2000 Video Tutorial: Some Dangerous Stored Procedures - xp_cmdshell, sp_OACreate, and sp_enum_dtspackages

Some Dangerous Stored Procedures - xp_cmdshell, sp_OACreate, and sp_enum_dtspackages - view details
Right now, on your SQL Server, are stored procedures that certain people could execute that would blue screen (BSOD) your SQL Server's host machine. Seriously. Well, that's part of the story at least. Yes, it's true - xp_cmdshell and sp_OACreate could blue screen your machine but you'd have to be a sysadmin (by default) to execute them. In this video, you'll learn about several dangerous stored procedures and how to neutralize their impact on your system. If security is of utmost importance to you and your team, then this video on SQL Server security and stored procedures is well worth watching
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 security, sql hack

posted by Scott Whigham @ 3:08 PM    

SQL Server 2005 Video Tutorial: An Overview of the Northwind Database

An Overview of the Northwind Database - view details
Scott Whigham walks you through the layout of the Northwind database in this video. Northwind is used for many demos and videos throughout the site due to how "easy" it is to work with. This is not a long video but will serve to familiarize you with the sample database used in many of the T-SQL-based videos.

NOTE: You can download the Northwind (and Pubs) sample databases here
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: sample database, sample db, install sample, oltp database, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 2:08 PM    

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

Design Pattern for Finding Duplicate Data - A Simple Way to Spot Non-Unique Rows (Single Column Test) - view details
Let's say that you have a Primary Key on "SubscriberId" but you want to locate rows that live in the same Country - how would you do it? This query talks about spotting duplicates in a single column (like "Country" in this case). Primary Keys prevent duplicate data in the table but they don't necessarily prevent duplicates across non-key columns. This video is all about spotting single-column duplicates and it uses subqueries and the EXISTS operator to help you locate the dupes.
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: sub-query, sub-queries, subquery, correlated, simple, exists

posted by Scott Whigham @ 2:08 PM    

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 @ 2:08 PM    

Exchange 2003 Video Tutorial: Installing Exchange 2003: Pre-installation Requirements - Add Exchange Machine to the Domain

Installing Exchange 2003: Pre-installation Requirements - Add Exchange Machine to the Domain - view details
This video covers adding your member server to the domain so that it can become an Exchange 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: exchange sevrer add to domain, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 1:08 PM    

Windows 2003 Video Tutorial: Installing NT 4.0 SP6

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

posted by Scott Whigham @ 1:08 PM    

Exchange 2003 Video Tutorial: Restrict Access to OWA OMA POP3 and IMAP

Restrict Access to OWA OMA POP3 and IMAP - view details
From the title this video sounds like alphabet soup! Essentially this video discusses the different clients and protocols used to connect to Microsoft Exchange and how to configure Exchange to prevent access to these for one or more users
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: restrict Exchange OWA access, restrict Exchange Outlook Web Access, prevent OWA access, prevent OMA access, deny POP3 Exchange,

posted by Scott Whigham @ 12:08 PM    

SQL Server 2005 Video Tutorial: Pt. 2 - Setting Up Publications for Transactional Replication

Pt. 2 - Setting Up Publications for Transactional Replication - view details
This video, part 2 in our series, walks you through creating publications using the "New Publication Wizard" in SQL Server Management Studio (SSMS). You'll learn about publishing tables and doing vertical as well as horizontal filters.

Highlights from this video:
  • What requirements are there for publishing tables?
  • How to publish an entire table and how to publish only certain columns
  • How to publish all columns but only rows that meet a WHERE clause
  • Should you change the destination object owner?
  • Syntax for writing filters
  • Determining snapshot creation and snapshot agent location/properties
  • How frequently should the snapshot agent run?
  • Configuring Agent Security for the snapshot agent and the log reader agent
  • Should you run the agent accounts as the SQL Server Agent service account?
  • Scripting your publication for easier maintenance/reinitialization
  • After running the wizard, how to modify and view the publication's properties
  • How to generate new snapshots
  • What does the snapshot look like? How is it implemented?
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: replication architecture, transactional, beginning, beginner, intro, introduction, snapshot folder, snapshot, filters, horizont

posted by Scott Whigham @ 12:08 PM    

Microsoft SQL Server Video Tutorial: Auto-Numbering Rows with IDENTITY Columns - How Identity Columns Work

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

posted by Scott Whigham @ 12:08 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 @ 11:08 AM    

Windows 2003 Video Tutorial: Customize Internet Explorer and the Desktop Using Group Policy

Customize Internet Explorer and the Desktop Using Group Policy - view details
Ever wondered how to add/change the icons displayed in the top right corner of Internet Explorer? You can change them and many companies will so that they will have a standardized installation of Internet Explorer and/or Windows. Master consultant Grant Moyle teaches you how to tweak Windows using Group Policy to affect the browser title, change logos, and more. This video could also be titled 'Add Your Own Custom Logo to Internet Explorer'
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 IE logo Windows 2003, change Internet Explorer logo Windows 2003

posted by Scott Whigham @ 10:08 AM    

Exchange 2003 Video Tutorial: Monitoring Exchange Server and Setting Up Notifications (Exchange Monitoring)

Monitoring Exchange Server and Setting Up Notifications (Exchange Monitoring) - view details
So, the Exchange Server is up and running, users and managers are happy, everyone can sit back and enjoy - right? Wrong - it's now time to setup your Exchange Server to watch for problems, and - more importantly - notify you when the problems occur. Grant Moyle will walk you through how to configure Exchange Monitoring, and then how to setup Notifications when your servers are in Warning or Critical states.

Highlights from this video:
  • What makes our server go into a Warning or Critical state?
  • Using System Manager to Monitor Exchange
  • Configuring SMTP Queue Thresholds
  • Configuring Virtual Memory Thresholds
  • CPU Thresholds, Disk Space Thresholds
  • Creating and Configuring Event Notifications
  • Monitoring Multiple Servers
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: monitor exchange 2003, exchange 2003 system management, exchange sysadmin, notification services

posted by Scott Whigham @ 10:08 AM    

Transact SQL 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 @ 9:08 AM    

Windows 2003 Video Tutorial: Deploy Software Using Group Policy

Deploy Software Using Group Policy - view details
Windows guru Grant Moyle teaches you how to deploy software on your network using Group Policy. This video shows you how to deploy Adobe's Acrobat software using Group Policy. All you need to do is configure the policy and then place the required objects in the proper containers. Once the user logs on the new software will be deployed! If you're hoping to add automation to your network 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: automatically deploy software with Group Policy

posted by Scott Whigham @ 9:08 AM    

Exchange 2003 Video Tutorial: Creating an Incremental Backup and Discussion

Creating an Incremental Backup and Discussion - view details
Do you know the difference between an Incremental backup and a Differential backup? Many people get confused at the terminology and usage of these two different types of backups. This video explains what the Incremental backup is, how to use it, and gives you a few best practices and tips and techniques for working with Incremental backups
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: incremental backup Exchange

posted by Scott Whigham @ 8:08 AM    

SQL Server 2000 Video Tutorial: Enterprise Manager - Registering a server

Enterprise Manager - Registering a server - view details
If you are just getting started with SQL Server and want to know how to use the Enterprise Manager, this video is for you. Before you start working with a SQL Server in the Enterprise Manager, you must "register" that server (which writes information into the Registry). This video, by SQL Server guru Scott Whigham, contains lots of tips and tricks, some well-hidden techniques and features, and a lot of good, solid information to get you started
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: register sql server, sql server enterprise manager, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 8:08 AM    

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, 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 IIS 6.0, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 8:08 AM    

SQL Server 2000 Video Tutorial: Discussions on Decisions Such as What to Install, Optional Components, and Infrequently Used Terms

Discussions on Decisions Such as What to Install, Optional Components, and Infrequently Used Terms - view details
SQL Server trainer and consultant Scott Whigham talks about what each of the options mean during the install regarding what tools to install (and which are his favorites) and some of the terms you might hear or use when discussing an install of 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: sql install, install sql server

posted by Scott Whigham @ 7:08 AM    

SQL Server 2000 Video Tutorial: Installing SQL Server 2000 - Basic Overview

</