Thursday, August 03, 2006

Free Windows 2003 Video Tutorial: Command Line Disk Defragmentation and Schedule

Command Line Disk Defragmentation and Schedule - download
Did you know that you can schedule disk defragmentation without purchasing any of the fancy tools out there? Windows Server 2003 comes with a command line tool for defragmenting your hard drive. Using the native scheduling tool built into Windows 2003 you can schedule your disk defragmentation to occur at any time. Speed up your server with regularly scheduled defragmentation! This video could also be titled 'Schedule Disk Defragmentation with the Command Line and AT command'
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 12:14 PM   0 comments links to this post

Free Microsoft SQL Server Video Tutorial: SQL Server 2005 Services and Service Accounts - What They Do and What's New

SQL Server 2005 Services and Service Accounts - What They Do and What's New - download
This video walks you through the SQL Browser service (SqlBrowser) and talks about some of the new SQL Server service accounts with a heavy focus on what's new and what's changed in SQL 2005. The service account names have changed, there are a few new services, and some new wrinkles in the still-the-same services as well.
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 12:13 PM   0 comments links to this post

Free SQL Server 2005 Video Tutorial: SQL Server 2005 Query Governor Bug

SQL Server 2005 Query Governor Bug - download
SQL Server 2005 Query Governor Bug - Oops…
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 11:45 AM   0 comments links to this post

Free Exchange 2003 Video Tutorial: Using Full plus Incremental Backups to Restore a Database

Using Full plus Incremental Backups to Restore a Database - download
Database restoration is no fun but you want to be prepared when it comes time to restore your Exchange databases. This video helps you restore your database using both the Full Database backups and the Incremental Backups - a must-see video
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 11:45 AM   0 comments links to this post

Free Windows 2003 Video Tutorial: Remove the Last Domain Controller from the Domain (via DCPromo)

Remove the Last Domain Controller from the Domain (via DCPromo) - download
DCPromo is an oft-used administrator tool that allows you to install, update, and even remove Active Directory from your network. This video shows you how you can remove the last machine (a domain controller) from the domain using DCPromo. Very tricky stuff indeed!
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 11:43 AM   0 comments links to this post

Free SQL Server 2005 Video Tutorial: Using the PIVOT Operator - An introduction to PIVOT Tables and Crosstab Queries with PIVOT

Using the PIVOT Operator - An introduction to PIVOT Tables and Crosstab Queries with PIVOT - download
SQL Server 20005 introduces the PIVOT operator to Transact-SQL for creating crosstab queries in a much simpler way. If you're used to working with cross tab queries and pivot tables and are tired of having to hard code the options in your CASE operator(s), then check out this excellent video on the PIVOT operator and how to use it.
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 11:43 AM   0 comments links to this post

Free Microsoft SQL Server Video Tutorial: How to Script Out the Indexes With the Table in SQL Server 2005 Management Studio

How to Script Out the Indexes With the Table in SQL Server 2005 Management Studio - download
Curiously enough, Microsoft decided against scripting out the indexes when you script out the table in the SQL Server 2005 Management Studio. This video shows you the default "behavior" of the Management Studio, how you can spot the "problem", and how you "fix" it. It's a strange decision by Microsoft to omit this (an accident, perhaps?) but don't get caught by this "undocumented feature"!
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 11:42 AM   0 comments links to this post

Free Exchange 2003 Video Tutorial: Change SMTP Connection Information

Change SMTP Connection Information - download
SMTP is the heart of Microsoft Exchange; it's how you send mail and receive mail. One common problem that administrators leave open is the SMTP connection information. When your Exchange server responds via SMTP it passes connection information back to the client. By default, this information contains sensitive information that you might wish to hide from clients. This video helps you establish some basic security guidelines and best practices for SMTP with Exchange. You'll use the IIS Metabase Explorer to view and change the Metabase
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 11:41 AM   0 comments links to this post

Free Exchange 2003 Video Tutorial: Pt. 1 - Pre Installation Steps for Exchange 2000

Pt. 1 - Pre Installation Steps for Exchange 2000 - download
This video walks you through the pre-requisites for installing Exchange 2000 along with some ideas for setting up the server in preparation to test your upgrade to Exchange 2003.
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 11:41 AM   0 comments links to this post

Free Microsoft SQL Server Video Tutorial: Pt 2 - Creating Your First SSIS Packages (Integration Services Packages)

Pt 2 - Creating Your First SSIS Packages (Integration Services Packages) - download
The second video in our introduction series on Integration Services focuses on creating, importing, and adding packages in the BI Studio (more formally known as the SQL Server Business Intelligence Design Studio). This is an introductory-level video designed as a "first look" into SSIS packages and the BI Studio. Many people get very confused with the basic concepts of the SSIS architecture and this video helps allay some of the intimidation. Scott Whigham walks you through finding the SSIS Package Store, how the file system works within SSIS, and more information about creating packages.
To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

posted by Scott Whigham @ 11:40 AM   0 comments links to this post