Tuesday, March 27, 2007

Free SQL Server Integration Services Video Tutorial: Pt. 1 - In Place Upgrade of SQL Server 2000 DTS to SQL Server 2005 SSIS

Pt. 1 - In Place Upgrade of SQL Server 2000 DTS to SQL Server 2005 SSIS - download
This series of videos (eight in all) walks you through migrating an entire SQL Server 2000 instance to SQL Server 2005's SSIS. You'll cover everything from the install/setup of SQL 2005 to moving individual 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

Keywords Associated with this video: upgrading, upgrade, migrating, data transformation services, migrate, inplace, in-place

posted by Scott Whigham @ 5:26 PM   0 comments links to this post

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

Pt. 1 - Installing Visual Studio 2005 Express Editions - download
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, 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

Keywords Associated with this video: install, beginner, beginning, setup, installation

posted by Scott Whigham @ 5:26 PM   0 comments links to this post

Free SQL Server Integration Services Video Tutorial: Tips on Documenting and Annotating Your SSIS Packages

Tips on Documenting and Annotating Your SSIS Packages - download
This video covers the basics of documenting, printing, and annotating (i.e., marking up) your SSIS packages. You'll see more than the basics however, you'll also see a few best practices and common uses.

Highlights from this video:
  • Using the Text Annotations Effectively
  • Arranging and Formatting Your Annotations
  • Printing and Documenting Your Packages and Tasks
  • Formatting Your Text for Clear Documentation
  • Grouping and anchoring text
and much more

*** This is an updated 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

Keywords Associated with this video: documentation, printing, printer, printed, dictionary, generate, annotate, annotating, documenting

posted by Scott Whigham @ 5:26 PM   0 comments links to this post

Free SQL Server Integration Services Video Tutorial: Formatting Options in SSIS - How to Make Your Packages More Manageable

Formatting Options in SSIS - How to Make Your Packages More Manageable - download
Just like well-written source code, "good looking" SSIS packages are easier to manage (edit/maintain) than sloppily laid out packages. Do you want to save yourself time? Then lay out your SSIS packages carefully so that you (or others) will understand what the package flow is when you revist this package three months from now.

Highlights from this video:
  • Using the new formatting options in the Business Intelligence Development Studio (BIDS)
  • Aligning sides and centers
  • Using the Visio-style controls to manipulate task-boxes and text
  • Formatting text annotations
  • Suggestions for auto-sizing
  • Manipulating hard-to-work-with text annotations easily
  • Horizontal and Vertical spacing options
and much 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

Keywords Associated with this video: autosizing, autosize, auto-size, auto-layout, autolayout, lay out, autoformat, auto-format, pretty, prettify

posted by Scott Whigham @ 5:26 PM   0 comments links to this post

Monday, March 26, 2007

Free Windows 2003 Video Tutorial: How to Customize the Windows Slideshow Gadget to Display Your Pictures

How to Customize the Windows Slideshow Gadget to Display Your Pictures - download
How to Customize the Windows Slideshow Gadget to Display Your Pictures
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

Keywords Associated with this video: How to Customize the Windows Slideshow Gadget to Display Your Pictures

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

Free Windows 2003 Video Tutorial: Performing a Clean Install of Windows Vista Home Edition

Performing a Clean Install of Windows Vista Home Edition - download
This video, a shared video from LearnWindows.com (our videobook on Windows Vista), is an demo of a Windows Vista 'Home Edition' installation.

LearnWindows.com
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

Keywords Associated with this video: setup, install, beginner, intro, installation

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

Tuesday, March 20, 2007

Free Transact SQL Video Tutorial: 1 - An Introduction to Datatype Conversion

1 - An Introduction to Datatype Conversion - download
Datatype conversion is what we, as developers, have to deal with on a daily basis. No matter what the language, data type conversion is a daily event. This video helsp introduce the concept from a SQL Server-specific standpoint.

Highlights from this video:
  • Overview of the various datatypes available in SQL Server
    • Numbers
    • Strings
    • Dates
  • Differences between various datatypes
  • Using 'SELECT 123' statements and how SQL Server implements such queries
  • How SQL Server performs datatype conversions in expressions
and much 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

Keywords Associated with this video: data type conversion, cast, convert, cast and convert, numeric, decimal, varchar(max), nvarchar(max), float, real, int32, int64

posted by Scott Whigham @ 4:31 PM   0 comments links to this post

Free Transact SQL Video Tutorial: Pt. 1 - An Overview of the INSERT Statement in Transact SQL

Pt. 1 - An Overview of the INSERT Statement in Transact SQL - download
Pt. 1 - An Overview of the INSERT Statement in Transact SQL
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

Keywords Associated with this video: Pt. 1 - An Overview of the INSERT Statement in Transact SQL

posted by Scott Whigham @ 4:31 PM   0 comments links to this post

Wednesday, March 14, 2007

Free Sharepoint Video Tutorial: A Quick Tour of the Sharepoint Central Operations Site

A Quick Tour of the Sharepoint Central Operations Site - download
A Quick Tour of the Sharepoint Central Operations Site
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

Keywords Associated with this video: A Quick Tour of the Sharepoint Central Operations Site

posted by Scott Whigham @ 9:02 PM   0 comments links to this post

Free Sharepoint Video Tutorial: Accessing the Sharepoint Site as an Anonymous User (Visitor)

Accessing the Sharepoint Site as an Anonymous User (Visitor) - download
Accessing the Sharepoint Site as an Anonymous User (Visitor)
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

Keywords Associated with this video: Accessing the Sharepoint Site as an Anonymous User (Visitor)

posted by Scott Whigham @ 9:02 PM   0 comments links to this post

Tuesday, March 06, 2007

Free Exchange 2007/2003 Video Tutorial: Enabling and Examining SMTP Logs

Enabling and Examining SMTP Logs - download
Using the Exchange System Manager you will learn how to manage the SMTP logs and configure SMTP logging with Exchange. Exchange logs can be quite cryptic and this video helps you understand what's in the log and how to interpret 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

Keywords Associated with this video: SMTP logs Exchange

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

Free Exchange 2007/2003 Video Tutorial: What Are Recipients and Recipient Update Services?

What Are Recipients and Recipient Update Services? - download
There are two Recipient Update Services - do you know what each one does? This video explains both services - the Recipient Update Service (Enterprise Configuration) and the one for your organization. A must-see video for beginners!
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

Keywords Associated with this video: exchange recipient update services, beginner, beginning, for beginners, introduction, step by step

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

Sunday, March 04, 2007

Free Microsoft SQL Server Video Tutorial: Part 1 - An Overview of the AdventureWorks Database

Part 1 - An Overview of the AdventureWorks Database - download
AdventureWorks - the "new standard" for sample databases out of Redmond. Scott Whigham, author of LearnSqlServer.com and LearnTransactSql.com, is certainly a fan of this new database for certain things but also feels reservations about the complexity of AdventureWorks when it comes to using it as your primary training database. Nevertheless, this video (part 1), walks you through the layout of AdventureWorks, how the schemas are used, and shows some of the "primary" relationships between the important tables and views. This video provides a good starting point for working with AdventureWorks and understanding how the tables are related.
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

Keywords Associated with this video: adventureworks install, sample database, sql server sample database, sql server adventure works, oltp, beginner, beginning, for

posted by Scott Whigham @ 1:25 PM   0 comments links to this post

Free Microsoft SQL Server 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

Keywords Associated with this video: create sql database, create sql server database enterprise manager

posted by Scott Whigham @ 1:25 PM   0 comments links to this post