Wednesday, November 22, 2006

Free SQL Server 2005 Video Tutorial: Part 5 - How to Configure SQL Server 2005 to Listen on Multiple TCP IP Ports

Part 5 - How to Configure SQL Server 2005 to Listen on Multiple TCP IP Ports - download
Another in our series on SQL Server 2005's Network Libraries, this video shows you a rather obscure and not-often-used technique of configuring your SQL Server to listen on multiple TCP/IP ports. TCP/IP is the most common way to connect to SQL Servers (including 7.0 and 2000) so the more you know, the better you are!
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: sql server multiple ips, multiple tcp/ip ports

posted by Scott Whigham @ 7:31 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

Keywords Associated with this video: sql registry, sql keys, registry entries, modify registry, change registry

posted by Scott Whigham @ 7:31 AM   0 comments links to this post

Free SQL Server 2005 Video Tutorial: Why You Use SCOPE_IDENTITY() Instead of @@IDENTITY

Why You Use SCOPE_IDENTITY() Instead of @@IDENTITY - download
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, 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: scope Identity, dbcc check_ident

posted by Scott Whigham @ 7:31 AM   0 comments links to this post

Free SQL Server 2005 Video Tutorial: Pt. 1 - An Introduction to the Concepts and Terms of SQL Server Replication

Pt. 1 - An Introduction to the Concepts and Terms of SQL Server Replication - download
As replication becomes easier to implement and the world becomes more "wired", replication becomes increasingly the de facto standard for synchronizing data between different databases. This video, part 1 in our "Introduction to SQL Server Replication" series, gives you the big picture of why we use replication as well as describing several key terms and definitions. This video is more of a lecture-style video instead of a demo video but do not miss it! It will help you grasp the full scope of how SQL Server can use replication to do everything from synchronizing small "slices" of data from a source to a destination (more accurately termed the publisher and subscriber) and how you can even do disaster recovery with SQL Server replication.

Highlights from this video:
  • Answers the question, "What is Replication?"
  • Definitions, terms, terminology, architecture and topology of replication
  • Understanding Distributors, Publishers, and Subscribers
  • Publications, Articles, Tables, Stored Procedures and Views
  • Common Uses of/for replication
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: replication architecture, merge, transactional, snapshot, dr, beginning, beginner, intro, introduction

posted by Scott Whigham @ 7:31 AM   0 comments links to this post

Free SQL Server 2005 Video Tutorial: Part 1 - An Overview of the Default SQL Server Installation

Part 1 - An Overview of the Default SQL Server Installation - download
SQL trainer Scott Whigham walks you through the default installation of SQL Server 2005 in this video, part 1 in a series on installing SQL Server 2005. In this video you'll learn about the instances, folders, services, and options chosen during the default install.
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: sql 2005 overview, sql server change, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 7:31 AM   0 comments links to this post

Tuesday, November 21, 2006

Video Tutorials from LearnItFirst.com

Video Tutorials from LearnItFirst.com

We just launched this new blog to keep track of all the 1,000+ videos we have!

posted by Scott Whigham @ 3:54 PM   0 comments

Saturday, November 18, 2006

Free Windows 2003 Video Tutorial: Using NEWSID to Change SID and Rename a Machine

Using NEWSID to Change SID and Rename a Machine - download
Anytime you create a 'Ghost' image, a Virtual Machine, a Virtual PC or even clone a disk you might need to change the SID (security identifier). A freeware utility, NEWSID from www.sysinternals.com, can help you ensure that you always have a randomly generated SID for your Windows 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 @ 6:36 PM   0 comments links to this post

Free Windows 2003 Video Tutorial: Configure Your Server Wizard - Setup an Active Directory

Configure Your Server Wizard - Setup an Active Directory - download
Most administrators will run the Configure Your Server wizard at least once when they are learning to configure Windows Server 2003. The Configure Your Server wizard, in this video, is used to build the Active Directory (where information like domain users and permissions are stored). There are many changes to the Active Directory in Windows 2003 and this video highlights several of the new features, the changes, and helps you understand the basics of AD in Windows. This video could also be titled 'Promote Your Windows Server 2003 to a Domain Controller'
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 @ 6:36 PM   0 comments links to this post

Free Windows 2003 Video Tutorial: Defragment the Active Directory Database

Defragment the Active Directory Database - download
This video walks you through using NTDSUTIL.exe, a tool to perform database management on the Active Directory, to defrag the AD database. If you want to really optimize your Windows environment, then you should know how to use NTDSUTIL.exe to defragment your Active Directory database. Defragmenting the Active Directory database can help reclaim space in Ntds.dit that is not reclaimed when you delete/remove objects during normal Garbage Collection.
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 @ 6:35 PM   0 comments links to this post

Free Windows 2003 Video Tutorial: Upgrade Windows 2000 - Adding a Windows 2003 Domain Controller

Upgrade Windows 2000 - Adding a Windows 2003 Domain Controller - download
Another video in our series on Upgrading a Windows 2000 Server to Windows 2003 Server, this video shows you how to add a Windows Server 2003 DC to your domain for the upgrade. This video talks about using Active Directory services and Windows 2003 with Windows 2000 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 @ 6:35 PM   0 comments links to this post

Free Windows 2003 Video Tutorial: Install and Format a New Hard Disk

Install and Format a New Hard Disk - download
You'll learn how to initialize a new hard disk (set of RAID hard disks as well) on 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 @ 6:35 PM   0 comments links to this post

Thursday, November 16, 2006

Blogger post failed

Blogger could not process your message at this time.

Error code: 6.144F86

Original message:
From: bigtoga.liffreevideos@blogger.com
Date: Thu, 16 Nov 2006 16:04:10 -0600
Subject: Free Transact SQL Video Tutorial: Rapid Database Development Using Database Diagrams (SQL Server 2000)
<b style="font-size: 18px; color: black;">Rapid Database Development Using Database Diagrams (SQL Server 2000)</b> - <a href="http://www.LearnTransactSQL.com/FreeVideos/">download</a><br /><blockquote style="border: 1px dotted black; padding: 10px;">This video tutorial shows you how to use the Enterprise Manager's Database Diagrams to create tables and manage constraints. Instead of having to manually create tables in the Enterprise Manager with the New Table dialog, you can use the Database Diagrams to do proof of concept and rapid database development (similar to rapid application development). <p> Highlights from this video: <ul> <li>Customizing the Database Diagrams to include/exclude columns/metadata</li> <li>Adding Existing Tables to Layout</li> <li>Using the Save Change Script Option</li> <li>Explanations of what the asterisks mean in the Database Diagrams</li> <li>Create Foreign Keys Using the Drag-and-Drop features of the Database Diagrams</li> </ul></p></blockquote><ul> <li>Category: <a href="http://www.learnitfirst.com/VideoTutorials/eLearningWebsite3.aspx">SQL Server Videobooks</a></li><li>Skill Level: 100 (Beginner)</li><li>Length: 8:57 (5.36MB)</li><li><a href="http://www.LearnTransactSQL.com/VideoTutorials/TechnicalTrainingVideo431.aspx">Source Videobook Entry</a> (Subscriber-only version)</li></ul><hr />To download this video, visit the <a href="http://www.LearnTransactSQL.com/FreeVideos/">Free Videos</a> page, click "download" and enter the correct security code.<br /><br /><p>Note: You must have the <a href="http://www.LearnTransactSQL.com/TSCC.zip">TSCC codec</a> installed to view this video</p>

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

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

Collations, Character Sets, Code Pages, and Sort Orders - How String Data Works in SQL Server 2000 - download
Many developers do not get the opportunity to work with international and multi-national data therefore they have a cursory understanding of collations in SQL Server. If you'd like to understand Unicode data and what the difference is between the nchar/char datatypes and the nvarchar/varchar datatypes, then this video is for you. You'll learn about code pages, character sets, collations, and how SQL Server works with case-sensitive data.
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 @ 4:12 PM   0 comments links to this post

Free Transact SQL Video Tutorial: SET Commands for Working with NULL values

SET Commands for Working with NULL values - download
Do you know the difference between ANSI NULLS and ANSI NULL DEFAULT (or is there a difference)? If you aren't sure what an "ANSI" is, then you definitely will want to watch this video! If you have trouble with NULLs or just want a good explanation of what NULLs are and how three-valued logic works in relational databases, you'll also want to watch this video.

Highlights from this video:

  • Explanation of NULLs
  • Using SET commands and database options to control how SQL Server works with NULLs
  • Concatentation and arithmetic with NULL values
  • Changing the default behavior with CONCAT_NULL_YIELDS_NULL
  • ISNULL and COALESCE
  • Using "= NULL" and IS NULL
  • Determining SET options with DBCC USEROPTIONS
  • Defaults of SET options, database options and connection options
  • Variable assigment and whether unassigned variables are null, empty or 0

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 @ 4:12 PM   0 comments links to this post

Free Transact SQL Video Tutorial: Design Pattern for Looping Through Rows and Executing A Stored Procedure - Using a Temporary Table

Design Pattern for Looping Through Rows and Executing A Stored Procedure - Using a Temporary Table - download
Another great video in our Design Pattern series, this video tutorial focuses on how to iterate through a resultset and execute a stored procedure for each of the row values. Example: let's say you wanted to execute SP_HELPDB for every database on your server. You could write the code by hand by entering EXEC SP_HELPDB master; EXEC SP_HELPDB msdb; etc. The problem? This is not a dynamic approach so any new databases added after your script would not be included. The technique in the video uses temp tables for iteration.
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 @ 4:12 PM   0 comments links to this post

Blogger post failed

Blogger could not process your message at this time.

Error code: 6.FE99BD

Original message:
From: bigtoga.liffreevideos@blogger.com
Date: Thu, 16 Nov 2006 16:03:56 -0600
Subject: Free Transact SQL Video Tutorial: Creating Your Own System Functions (SQL Server 2000)
<b style="font-size: 18px; color: black;">Creating Your Own System Functions (SQL Server 2000)</b> - <a href="http://www.LearnTransactSQL.com/FreeVideos/">download</a><br /><blockquote style="border: 1px dotted black; padding: 10px;">Did you know that you are allowed to create your own system functions in SQL Server 2000? It's true, it's true. System functions are, like system stored procedures, callable from any database and are excellent DBA tools for reporting. There are some quirky rules associated with writing your own system functions and, if you don't know the &quot;stricks&quot; it's likely that you'll get stuck trying to figure them out. Check out this video for an interesting approach to writing your own functions in master.</blockquote><ul> <li>Category: <a href="http://www.learnitfirst.com/VideoTutorials/eLearningWebsite3.aspx">SQL Server Videobooks</a></li><li>Skill Level: 500 (Advanced)</li><li>Length: 9:04 (5.02MB)</li><li><a href="http://www.LearnTransactSQL.com/VideoTutorials/TechnicalTrainingVideo404.aspx">Source Videobook Entry</a> (Subscriber-only version)</li></ul><hr />To download this video, visit the <a href="http://www.LearnTransactSQL.com/FreeVideos/">Free Videos</a> page, click "download" and enter the correct security code.<br /><br /><p>Note: You must have the <a href="http://www.LearnTransactSQL.com/TSCC.zip">TSCC codec</a> installed to view this video</p>

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

Free DTS Video Tutorial: Who Can View DTS Packages in SQL Server 2000 and What You Can Do About It

Who Can View DTS Packages in SQL Server 2000 and What You Can Do About It - download
Who Can View DTS Packages in SQL Server 2000 and What You Can Do About 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 @ 4:11 PM   0 comments links to this post

Free DTS Video Tutorial: Part 1 - What DTS Global Variables Are and the Architecture of Global Variables

Part 1 - What DTS Global Variables Are and the Architecture of Global Variables - download
Part 1 - What DTS Global Variables Are and the Architecture of Global Variables
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 @ 4:11 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 @ 4:11 PM   0 comments links to this post

Free Transact SQL Video Tutorial: SET Commands for Working with NULL values

SET Commands for Working with NULL values - download
Do you know the difference between ANSI NULLS and ANSI NULL DEFAULT (or is there a difference)? If you aren't sure what an "ANSI" is, then you definitely will want to watch this video! If you have trouble with NULLs or just want a good explanation of what NULLs are and how three-valued logic works in relational databases, you'll also want to watch this video.

Highlights from this video:

  • Explanation of NULLs
  • Using SET commands and database options to control how SQL Server works with NULLs
  • Concatentation and arithmetic with NULL values
  • Changing the default behavior with CONCAT_NULL_YIELDS_NULL
  • ISNULL and COALESCE
  • Using "= NULL" and IS NULL
  • Determining SET options with DBCC USEROPTIONS
  • Defaults of SET options, database options and connection options
  • Variable assigment and whether unassigned variables are null, empty or 0

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 @ 4:08 PM   0 comments links to this post

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

Collations, Character Sets, Code Pages, and Sort Orders - How String Data Works in SQL Server 2000 - download
Many developers do not get the opportunity to work with international and multi-national data therefore they have a cursory understanding of collations in SQL Server. If you'd like to understand Unicode data and what the difference is between the nchar/char datatypes and the nvarchar/varchar datatypes, then this video is for you. You'll learn about code pages, character sets, collations, and how SQL Server works with case-sensitive data.
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 @ 4:08 PM   0 comments links to this post

Free DTS Video Tutorial: Part 1 - What DTS Global Variables Are and the Architecture of Global Variables

Part 1 - What DTS Global Variables Are and the Architecture of Global Variables - download
Part 1 - What DTS Global Variables Are and the Architecture of Global Variables
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 @ 4:08 PM   0 comments links to this post

Free Transact SQL Video Tutorial: Rapid Database Development Using Database Diagrams (SQL Server 2000)

Rapid Database Development Using Database Diagrams (SQL Server 2000) - download
This video tutorial shows you how to use the Enterprise Manager's Database Diagrams to create tables and manage constraints. Instead of having to manually create tables in the Enterprise Manager with the New Table dialog, you can use the Database Diagrams to do proof of concept and rapid database development (similar to rapid application development).

Highlights from this video:

  • Customizing the Database Diagrams to include/exclude columns/metadata
  • Adding Existing Tables to Layout
  • Using the Save Change Script Option
  • Explanations of what the asterisks mean in the Database Diagrams
  • Create Foreign Keys Using the Drag-and-Drop features of the Database Diagrams

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 @ 4:08 PM   0 comments links to this post

Friday, November 10, 2006

Free SQL Server 2000 Video Tutorial: Part 1 - Network Libraries and Authentication Modes - Choosing What's Right for Your Organization

Part 1 - Network Libraries and Authentication Modes - Choosing What's Right for Your Organization - download
Network Libraries in SQL Server are very important to SQL security. What you choose to enable or disable can have a profound impact on potential vulnerabilities. This video, Part 1, walks through the idea of Network Libraries and helps you choose the one(s) 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 @ 5:40 AM   0 comments links to this post

Free SQL Server 2000 Video Tutorial: Pt. 1 - An Introduction to Using Views in SQL Server

Pt. 1 - An Introduction to Using Views in SQL Server - download
Who uses views? We all do! Every developer, DBA, business analyst, systems analyst, manager, CEO, etc uses views to access the data in the database. Views make life so much easier - they are, for many people, the first choice to simplify query-writing and/or create reusable queries.

This video, recorded by resident expert Scott Whigham, is a great introduction to using views and helps with:
  • When should I use a view?
  • Should I use a view or a stored procedure?
  • What is the basic syntax for creating views in SQL Server?
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

posted by Scott Whigham @ 5:40 AM   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 @ 5:40 AM   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 @ 5:40 AM   0 comments links to this post

Free Exchange 2003 Video Tutorial: Clustering Exchange - Pt. 1 - Installing the Cluster and PreRequisites

Clustering Exchange - Pt. 1 - Installing the Cluster and PreRequisites - download
Exchange clustering is one of the most common uses of clustering in the Microsoft Windows environment. This video, the first video in our series on clustering Exchange, teaches you what the pre-requisites are for installing an Exchange cluster and walks you through prepping the nodes and using the MSCS and Cluster Administrator.
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 @ 5:40 AM   0 comments links to this post

Free Exchange 2003 Video Tutorial: 5.5 Migration - Optional Video - Removing the 5.5 Administrator and File cleanup

5.5 Migration - Optional Video - Removing the 5.5 Administrator and File cleanup - download
5.5 Migration - Optional Video - Removing the 5.5 Administrator and File cleanup
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 @ 5:40 AM   0 comments links to this post

Free Exchange 2003 Video Tutorial: Installing a 2nd Exchange 5.5 Site

Installing a 2nd Exchange 5.5 Site - download
To take our testing scenario one step even further, we'll add another Exchange 5.5 Site to our network in 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 Scott Whigham @ 5:40 AM   0 comments links to this post