Wednesday, June 28, 2006

Free Windows 2003 Video Tutorial: Customize Internet Explorer and the Desktop Using Local Policy

Customize Internet Explorer and the Desktop Using Local Policy - download
You can change the computer's Local Policy (using gpedit.msc) to influence Internet Explorer and make many desktop and user-experience customizations. In this video you'll learn how to change the browser's user interface including how to change the browser title and include custom logos inside Internet 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 @ 12:53 PM   0 comments links to this post

Free Windows 2003 Video Tutorial: Join Windows XP to the Domain

Join Windows XP to the Domain - download
A quick video designed to show you how to join a computer to a domain and the benefits of doing so
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:53 PM   0 comments links to this post

Free Windows 2003 Video Tutorial: Mapping Processes to Port Usage

Mapping Processes to Port Usage - download
A very helpful video for even the most skilled sysadmins. This video helps you map a process (such as ftp.exe, for example) to the port it is using. You'll see how you can use the native tools within Windows 2003 to view the port numbers that a process is using (No, you don't need additional software installed).
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:53 PM   0 comments links to this post

Free SQL Server 2005 Video Tutorial: Part 2 - SQL Server Network Library Discussion - TCP IP Connections and TCP IP Ports

Part 2 - SQL Server Network Library Discussion - TCP IP Connections and TCP IP Ports - download
This video focuses on SQL Server connections and protocols, primarily how to connect to SQL Server 2005 using TCP/IP as well as a discussion on TCP/IP ports.
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:53 PM   0 comments links to this post

Monday, June 26, 2006

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

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

Free Windows 2003 Video Tutorial: Display Information about Non-present (Hidden) Devices

Display Information about Non-present (Hidden) Devices - download
When you install a new system Windows will attempt to install drivers and load the device. This video shows you where this information is held within the system and how you can use this for troubleshooting device drivers and installation issues
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 @ 1:53 PM   0 comments links to this post

Free Windows 2003 Video Tutorial: Microsoft Firewall: Configuration and Setup for Windows 2003

Microsoft Firewall: Configuration and Setup for Windows 2003 - download
If you need to protect LAN and WAN connections incoming and outgoing to/from your Windows 2003 machine then Windows Firewall might be an option. While this is in no way a replacement for your hardware-based firewalls Microsoft's Windows Firewall may be an excellent choice to protect inter-network activity. This video shows you how to configure Windows Firewall for a File and Print server. This video could also be titled 'How to Use Microsoft Windows Firewall on Your Network'
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 @ 7:20 AM   0 comments links to this post

Free SQL Server 2005 Video Tutorial: ODBC, OLE-DB, UDLs and the SQL Native Client - Connecting to SQL Server and Making Reusable Connections

ODBC, OLE-DB, UDLs and the SQL Native Client - Connecting to SQL Server and Making Reusable Connections - download
The SQL Native Client, new with SQL Server 2005, is the preferred way to connect to a SQL Server 2005 instance today. This video is an excellent introduction to the terms used when discussing connections to SQL Server. There are many options for connecting an application (such as Microsoft Access, ASP.NET, Java) to SQL Server and this video covers some popular options. If you've heard of ODBC and DSNs before but never really understood how they were used (or what they are) then this is a great video to watch
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 @ 7:16 AM   0 comments links to this post

Wednesday, June 14, 2006

Free DTS Video Tutorial: Part 3 - Using Global Variables Inside the Transform Data Task

Part 3 - Using Global Variables Inside the Transform Data Task - download
Part 3 - Using Global Variables Inside the Transform Data 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 Scott Whigham @ 9:34 AM   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 @ 9:34 AM   0 comments links to this post

Free DTS Video Tutorial: Understanding Options for Saving DTS Packages

Understanding Options for Saving DTS Packages - download
Understanding Options for Saving DTS 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 @ 9:34 AM   0 comments links to this post

Free DTS Video Tutorial: Part 2 - A Basic Walkthrough of the Built-In Tasks

Part 2 - A Basic Walkthrough of the Built-In Tasks - download
Part 2 - A Basic Walkthrough of the Built-In Tasks
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:33 AM   0 comments links to this post

Saturday, June 10, 2006

Free SQL Server 2000 Video Tutorial: Cross Database Ownership Chaining - What It Is and When to Use It - Part 2

Cross Database Ownership Chaining - What It Is and When to Use It - Part 2 - download
This video is part 2 in our series on Cross Database Ownership Chaining
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:02 PM   0 comments links to this post

Free SQL Server 2000 Video Tutorial: How to Update Your SQL Server Documentation Manually

How to Update Your SQL Server Documentation Manually - download
At the same time that Service Pack 3 for SQL Server 2000 was released, Microsoft "refreshed" the Books Online documentation. How can you tell whether or not you're working with the latest copy? Where do you get it? Is it installed with Service Pack 3 (and what about SP4)? This video shows you the details of Microsoft's Update to Books Online and answers all these questions
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:02 PM   0 comments links to this post

Free SQL Server 2000 Video Tutorial: Help - My Transaction Log Is Full and Has Taken Up the Entire Disk! Emergency!

Help - My Transaction Log Is Full and Has Taken Up the Entire Disk! Emergency! - download
Real-World Scenario - your boss (or client) calls you at 4:54PM on Friday afternoon and says, "All of my people are getting an error working with Application X. Can you check what's going on?" You take a look and, sure enough, your transaction log has taken up the entire disk! Your data file is regular size but your transaction log is HUGE. What do you do? If you answered, "Take a transaction log backup" then you need to watch this video (because the log is full, it will not allow you to take a "traditional" transaction log backup). This video, recorded by resident SQL guru Scott Whigham, presents you with the What-If's, the Why's, and How To's of solving this very problem.
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:02 PM   0 comments links to this post

Free SQL Server 2000 Video Tutorial: Shrinking Database Files and Removing Space from Your SQL Server Database (Using Enterprise Manager)

Shrinking Database Files and Removing Space from Your SQL Server Database (Using Enterprise Manager) - download
One of the most common SQL Server topics is how to shrink a database file. It seems strange - we seem to be in a time where people are wanting larger databases yet everyone wants to know how to shrink. This video, recorded by SQL guru Scott Whigham, puts an interesting spin on the standard "How to Shrink" instructions. You'll not only learn how to shrink but Scott gives several best practices and tips and tricks for shrinking including a few "Don't do this"-type of tips!
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:01 PM   0 comments links to this post

Free SQL Server 2000 Video Tutorial: Enterprise Manager - Registering a server

Enterprise Manager - Registering a server - download
If you are just getting started with SQL Server and want to know how to use the Enterprise Manager, this video is for you. Before you start working with a SQL Server in the Enterprise Manager, you must "register" that server (which writes information into the Registry). This video, by SQL Server guru Scott Whigham, contains lots of tips and tricks, some well-hidden techniques and features, and a lot of good, solid information to get you started
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:01 PM   0 comments links to this post

Friday, June 09, 2006

Free Exchange 2003 Video Tutorial: Tuning the Intelligent Message Filter (IMF) to Filter Spam Effectively

Tuning the Intelligent Message Filter (IMF) to Filter Spam Effectively - download
This Exchange video tutorial shows you many of the advanced features of the Intelligent Message Filter (IMF) including performance tuning and optimizations that help your organzation fight spam more effectively. Exchange guru Grant Moyle shows you how to tune your Exchange Server's Intelligent Message Filter to filter junk mail based on customized settings including looking at message headers to identify potential offensive email. If you've ever wanted to really get into the headers that the IMF processes/uses, this is an excellent tutorial on how IMF works, how it evaluates the messages, what the scores mean, and how to interpret the Spam Confidence Level (the X-SCL information).
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 @ 7:28 AM   0 comments links to this post

Free Exchange 2003 Video Tutorial: Moving Databases and Transaction Logs

Moving Databases and Transaction Logs - download
In this video you'll learn to move your database and log files around your server as well as a few best practices for managing files on your Exchange server. 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 @ 7:28 AM   0 comments links to this post

Free Exchange 2003 Video Tutorial: Global Settings: Internet Message Formats

Global Settings: Internet Message Formats - download
Inside Exchange System Manager you'll find a listing for Global Settings - Internet Message Formats. This video talks about MIME and how to map handlers for file extensions in your emails as well as how to set the defaults for your organizations' email format (do you want to use rich text or html-based?)
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 @ 7:28 AM   0 comments links to this post

Free Exchange 2003 Video Tutorial: Use SelfSSL to Issue a Self-Signed Certificate to Secure OWA (Outlook Web Access)

Use SelfSSL to Issue a Self-Signed Certificate to Secure OWA (Outlook Web Access) - download
SelfSSL helps us issue a self-signed certificate and we can use SelfSSL to create certificates to test our Exchange server or to setup internal certificates. An excellent advanced video in working with Outlook Web Access and working with Security Best Practices
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 @ 7:28 AM   0 comments links to this post

Free Exchange 2003 Video Tutorial: Using Exmerge to Extract Live Mail Data

Using Exmerge to Extract Live Mail Data - download
This video shows you how to use the Exchange Mailbox Merge Wizard (ExMerge) to extract live mail from your Exchange Server. A tool for every Exchange administrator - 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 @ 7:27 AM   0 comments links to this post

Wednesday, June 07, 2006

Free Exchange 2003 Video Tutorial: Use SelfSSL to Issue a Self-Signed Certificate to Secure OWA (Outlook Web Access)

Use SelfSSL to Issue a Self-Signed Certificate to Secure OWA (Outlook Web Access) - download
SelfSSL helps us issue a self-signed certificate and we can use SelfSSL to create certificates to test our Exchange server or to setup internal certificates. An excellent advanced video in working with Outlook Web Access and working with Security Best Practices
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:01 AM   0 comments links to this post

Free Exchange 2003 Video Tutorial: Global Settings: Internet Message Formats

Global Settings: Internet Message Formats - download
Inside Exchange System Manager you'll find a listing for Global Settings - Internet Message Formats. This video talks about MIME and how to map handlers for file extensions in your emails as well as how to set the defaults for your organizations' email format (do you want to use rich text or html-based?)
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:01 AM   0 comments links to this post

Free Exchange 2003 Video Tutorial: Using Exmerge to Extract Live Mail Data

Using Exmerge to Extract Live Mail Data - download
This video shows you how to use the Exchange Mailbox Merge Wizard (ExMerge) to extract live mail from your Exchange Server. A tool for every Exchange administrator - 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 @ 6:01 AM   0 comments links to this post

Sunday, June 04, 2006

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

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

Free Microsoft SQL Server Video Tutorial: Enterprise Manager - Put Table On Filegroup

Enterprise Manager - Put Table On Filegroup - download
Performance tuning SQL Server often involves tuning how SQL Server stores the data and index data. This video shows you how SQL Server uses "filegroups" to control data placement. This is often a very important performance tweak and optimization for SQL Server databases. Consider this: let's say you know that 50% of your queries run against the "Customers" table, another 25% hit the "Products" table and a whopping 75% run against the "Orders" table (remember JOINs and subqueries mean it doesn't have to add up to 100%). If you could separate the Order table onto a different file (on a different drive) from the Customers and Products table, SQL Server would be able to access all three tables in parallel (depending on hardware) which means faster access to read and write data. Filegroups are the key to understanding both data and index data placement 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 Scott Whigham @ 9:35 AM   0 comments links to this post

Free Microsoft SQL Server Video Tutorial: SQL Server 2005 Transaction Log Is Full - log_reuse_wait_desc and sys.databases Error

SQL Server 2005 Transaction Log Is Full - log_reuse_wait_desc and sys.databases Error - download
What do you do when your transaction log is full - how do you fix it? This video walks about just that as well as highlights some gotchas along the way. This video talks architecture as well as providing practical examples or truncating the log and backing up the log as options.
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:32 AM   0 comments links to this post

Free Microsoft SQL Server Video Tutorial: Result sets, Recordsets, and the Client Server model

Result sets, Recordsets, and the Client Server model - download
This video is really helpful for you newbies - those of you who want to get up to speed on all the terms, jargon, parlance, and lexicon of SQL Server. Is a field the same as a column? An alias the same as a header? Is Result Set the same as resultset? The answer to all three questions is "Probably yes, depending on who's asking!" This video helps you dissect several (not all) of the confusing terms and tries to help you speak the language fluidly and easily. Is a recordset the same as a resultset? If you don't know, 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 Scott Whigham @ 9:32 AM   0 comments links to this post

Free Microsoft SQL Server Video Tutorial: Creating Database Diagrams in SQL Server Management Studio

Creating Database Diagrams in SQL Server Management Studio - download
Scott Whigham, author of LearnSqlServer2005.com and LearnSqlServer2000.com, loves to show people how to create diagrams because he feels that they are essential tools for all developers and DBAs of any skill level. Database diagrams (often called Entity Relationship Diagrams or ERDs) are a visual tool that allows you to see your table layouts, relationships, datatypes and much more. This video is for those people wanting to learn how to visualize SQL problems thus helping you be able to write JOINs, subqueries, and make decisions quickly and easily 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 Scott Whigham @ 9:32 AM   0 comments links to this post

Thursday, June 01, 2006

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