Monday, September 11, 2006

Free Windows 2003 Video Tutorial: How to Implement a Software-Based RAID 5 Array

How to Implement a Software-Based RAID 5 Array - download
RAID 5 is the fastest performing redundancy option for most small and medium-sized installations. In this video Windows guru Grant Moyle shows you how to implement a RAID 5 array (software-based) using Windows 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 @ 9:29 AM   0 comments links to this post

Free Windows 2003 Video Tutorial: How to Raise Domain and Forest Functional Levels

How to Raise Domain and Forest Functional Levels - download
Depending on the status of your Active Directory and the type of domain controllers you use, it might be time for you to update the functional level of your domain controllers. In this video you'll view the details on how to change from Mixed Mode (which supports both Windows 2000 and Windows 2003 Active Directory) to Windows 2003 Native Mode (which supports only Windows 2003 and higher).
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 @ 9:29 AM   0 comments links to this post

Free 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 - download
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, 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 @ 9:29 AM   0 comments links to this post

Free SQL Server 2005 Video Tutorial: How SQL Server 2005 Uses the Registry and Changes to the Registry

How SQL Server 2005 Uses the Registry and Changes to the Registry - download
This video is an overview of the architecture of SQL Server 2005 and how it uses the registry to record certain information. There is a heavy focus on what has changed from earlier versions of SQL Server including the new keys and startup parameters. This video uses "regedit" to display the registry keys and walks you through each of the Hives that SQL Server 2005 uses. An excellent video for you "sys-internals" buffs!
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 @ 9:29 AM   0 comments links to this post

Free SQL Server 2005 Video Tutorial: Templates in SQL Server Management Studio - What They Are and How to Use Them

Templates in SQL Server Management Studio - What They Are and How to Use Them - download
Templates were added to SQL Server 2000's Query Anaylzer and were a very handy tool (though mostly unused). SQL Server 2005's Management Studio expands on SQL Server 2000's templates by allowing you to easily add your own templates, write templates in multiple languages (such as T-SQL, XMLA or MDX), and the easy-to-use Template Explorer.
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 @ 9:29 AM   0 comments links to this post

Free SQL Server 2000 Video Tutorial: Customizing SQL Server with International Error Messages and How SQL Server 2000 Uses the Default Language

Customizing SQL Server with International Error Messages and How SQL Server 2000 Uses the Default Language - download
If you work with international or multi-national applications, SQL Server's custom error messages can really help make your error handling and user experience much better by using localized error messages. This video shows you how to create multiple "multiple versions" of the same error message with the only difference being that each message is in a different language. Have you used SQL Server's error messages before? If not, you'll want to watch this video to get an idea of how they work!
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 @ 9:29 AM   0 comments links to this post

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

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

Highlights from this video:

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

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

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

posted by Scott Whigham @ 9:29 AM   0 comments links to this post

Free Microsoft SQL Server 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 - download
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, 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 @ 9:28 AM   0 comments links to this post

Thursday, September 07, 2006

Free Microsoft SQL Server Video Tutorial: Install SQL Server - Discussion of Collation Types and Recommendations

Install SQL Server - Discussion of Collation Types and Recommendations - download
When you install SQL Server, you make perhaps one of the most important decisions you can make: which default collation you will use. Should you choose Windows Locale or a SQL Collation (and what's the difference)? Are SQL Server Authentication passwords case-sensitive (and why are you asking me that here)? Collations are incredibly important to SQL Server and the collation that you choose during setup can save you hours of frustration later on. Watch this video and get an excellent overview of what collations are and how you should go about choosing the right collation for your installation
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 @ 3:38 PM   0 comments links to this post

Free Exchange 2003 Video Tutorial: How to Manage and Create User Templates and Address Templates for Outlook

How to Manage and Create User Templates and Address Templates for Outlook - download
Did you know that there are user templates, address templates and more within Exchange? You can control what is displayed within Outlook by customizing these templates
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 @ 3:38 PM   0 comments links to this post

Free Video Training Network Video Tutorial:

- download
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 @ 3:21 PM   0 comments links to this post

Free Microsoft SQL Server 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 - download
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, 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 @ 3:21 PM   0 comments links to this post

Free Microsoft SQL Server Video Tutorial: An Overview of the Database Files - Data Files (MDF), the Transaction Log (LDF) and Additional Data Files (NDF)

An Overview of the Database Files - Data Files (MDF), the Transaction Log (LDF) and Additional Data Files (NDF) - download
All SQL Server developers and administrators should have an excellent understanding of the file architecture for SQL databases. This video helps you learn about the different file types, their usage in SQL Server, and when and where to use the .NDF files (additional data files)
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 @ 3:17 PM   0 comments links to this post

Free Exchange 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 - download
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, 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 @ 3:17 PM   0 comments links to this post

Free Exchange 2003 Video Tutorial: 5.5 Migration - Preparing a Server for running Exchange 2003

5.5 Migration - Preparing a Server for running Exchange 2003 - download
This video shows you best practices for preparing your server to run 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 @ 3:17 PM   0 comments links to this post

Free Exchange 2003 Video Tutorial: Migrating Public Folders and System Public Folders

Migrating Public Folders and System Public Folders - download
This video shows you how to migrate public folders from Exchange 2000 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 @ 3:17 PM   0 comments links to this post

Free DTS Video Tutorial: DTS Architecture - Using Profiler to Learn DTS

DTS Architecture - Using Profiler to Learn DTS - download
Yet another tutorial in our series on the inner workings of DTS, this video shows you how you can learn the system stored procedures and tables that are used by the Enterprise Manager if you'll use Profiler to trace the SQL passed by the Enterprise Manager. Using Profiler is an excellent way to learn the language of SQL and it's also a helpful tool to learn DTS from the inside out.
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 @ 3:16 PM   0 comments links to this post

Free 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 - download
This video covers adding your member server to the domain so that it can become an Exchange Server
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 @ 3:16 PM   0 comments links to this post

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

What is the Import/Export Wizard and Using the Import/Export Wizard in Common Data Movement Scenarios - download
What is the Import/Export Wizard and Using the Import/Export Wizard in Common Data Movement Scenarios
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 @ 3:15 PM   0 comments links to this post