Wednesday, July 12, 2006

Free 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 - download
Part 2 - How to Assign Values to Global Variables Using the Execute SQL Task
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 LearnItFirst.com @ 1:10 PM   links to this post

Monday, July 10, 2006

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

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

Free Exchange 2003 Video Tutorial: Pt 3 - Customize Outlook to Display the SCL Scores in IMF

Pt 3 - Customize Outlook to Display the SCL Scores in IMF - download
In parts 1 & 2 you learned to configure the IMF to work with your Exchange Server and AD. In part 3, Grant Moyle teaches you how to customize Microsoft Outlook so that you can actually see the SCL score from IMF.
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 LearnItFirst.com @ 6:43 PM   links to this post

Free SQL Server 2000 Video Tutorial: Creating Databases with the SQL Server Enterprise Manager

Creating Databases with the SQL Server Enterprise Manager - download
The Enterprise Manager is probably the easiest tool for creating new databases and, in this video, Scott Whigham shows you all the details of creating databases with EM. This video talks about the options you are presented in the Enterprise Manager including the Logical Filename, physical filename, file growth options, and how collations can influence the database. This video is primarily aimed at those new to creating databases in SQL 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 LearnItFirst.com @ 6:42 PM   links to this post

Free Exchange 2003 Video Tutorial: Global Settings: Mobile Services

Global Settings: Mobile Services - download
Inside Exchange System Manager you'll find a listing for Global Settings - Mobile Services which allows you to configure how Exchange works with today's mobile devices (Exchange ActiveSync and Outlook Mobile Access [OMA]). If you have to support mobile devices with your Exchange server this is the video for you
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 LearnItFirst.com @ 6:41 PM   links to this post

Free Exchange 2003 Video Tutorial: Public Folder Database Properties

Public Folder Database Properties - download
Learn about public folders and the MAPI public folders in Exchange and Outlook Web Access (OWA). This video walks you through the properties and configuration options for managing a single public folder so that it is available in Outlook 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 LearnItFirst.com @ 6:41 PM   links to this post

Free SQL Server 2000 Video Tutorial: Database Diagrams - An Introduction

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

Free Exchange 2003 Video Tutorial: Installing Exchange 2003: Perform a Quick Install

Installing Exchange 2003: Perform a Quick Install - download
If you want just a quick install without too much fuss then this is the perfect video. This is perfect for first-time installs or to get some good pointers on installations. After watching this video you'll be well prepared to install Exchange Server 2003 on your own system. If you want more detail after watching this video, look for installation videos with higher skill-levels; those will go into more details on each option/property you see in the setup screens as well as providing you with recommended configurations, best practices, and more
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 LearnItFirst.com @ 6:36 PM   links to this post

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

Installing SQL Server 2000 - Basic Overview - download
This video is a quick walk-through of the SQL Server install. It is aimed for those viewers wanting to see a quick install and then, after they have a good overview of how it works, want to delve deeper (by watching the other installation videos). Perfect for newbies and people migrating to SQL Server from other systems
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 LearnItFirst.com @ 6:35 PM   links to this post

Friday, July 07, 2006

Free Microsoft SQL Server Video Tutorial: Backup and Recovery - An Introduction to the Three Main Types of Backups in SQL Server 2000

Backup and Recovery - An Introduction to the Three Main Types of Backups in SQL Server 2000 - download
Ahhhhh, backup and recovery - the "Bread and Butter" of every SQL Server DBA's life, right? This video is an excellent introduction to the different types of SQL Server backups - the full backup, the differential backup and the transaction log backup. EVERY administrator and developer should have a strong understanding of the types of backups in SQL Server 2000. Do you need to watch this video? Answer this question, "Which of the following backup types clear out the online transaction log (truncate the log) - full, differential, and/or transaction log backup?" Did you get the right answer? Oh - you don't know if you got the right answer? Then you're guessing and you should watch this 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 LearnItFirst.com @ 4:31 PM   links to this post