Friday, March 17, 2006

Free SQL Server 2000 Video Tutorial: How to Change the SQL Server TCP IP Port Number Using the Server Network Utility

How to Change the SQL Server TCP IP Port Number Using the Server Network Utility - download
What TCP/IP port has IANA assigned for Microsoft to use for a SQL Server instance &$45; do you know? So does everyone else! One of the first things that a DBA does (if he/she wants to setup a secure SQL Server) if to change the default SQL Server port number from 1433 to something else. This video shows you the how, the how it works, and also gives recommendations for network libraries and more. This should be considered required viewing for all SQL Server DBAs
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:21 PM   0 comments links to this post

Free SQL Server 2000 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 @ 1:21 PM   0 comments links to this post

Free SQL Server 2000 Video Tutorial: How SQL Server Logs Errors - The SQL Server Error Log and Configuration

How SQL Server Logs Errors - The SQL Server Error Log and Configuration - download
The SQL Server Error Log Viewer in SQL Server 2000 leaves quite a bit to be desired. This video shows you a few alternatives to viewing your SQL Server configuration and errors as well as tips on configuring the SQL Server error logs so that the important logs will be there when you need them. You'll also learn about the architecture of how SQL Server logs errors so that you can manage your SQL Server most effectively.
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:21 PM   0 comments links to this post

Free SQL Server 2000 Video Tutorial: Multiple Instances - Lecture on When They're Appropriate and Special Considerations

Multiple Instances - Lecture on When They're Appropriate and Special Considerations - download
You probably already know that SQL Server 2000 allows you to install multiple named instances but do you know the details? When should you use named instances? How could you use them? Scott Whigham, SQL trainer, gives you his takes on working with multiple instances in this video and includes some excellent examples of when to use named instances to save yourself development and testing time
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:21 PM   0 comments links to this post

Free SQL Server 2000 Video Tutorial: ODBC, DSNs, and UDLs - Creating Reusable Connection Information

ODBC, DSNs, and UDLs - Creating Reusable Connection Information - download
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 @ 1:21 PM   0 comments links to this post

Wednesday, March 01, 2006

Free Exchange 2003 Video Tutorial: Change SMTP Connection Information

Change SMTP Connection Information - download
SMTP is the heart of Microsoft Exchange; it's how you send mail and receive mail. One common problem that administrators leave open is the SMTP connection information. When your Exchange server responds via SMTP it passes connection information back to the client. By default, this information contains sensitive information that you might wish to hide from clients. This video helps you establish some basic security guidelines and best practices for SMTP with Exchange. You'll use the IIS Metabase Explorer to view and change the Metabase
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:56 AM   0 comments links to this post

Free Exchange 2003 Video Tutorial: Public Folder Management and Creation for Your Organization

Public Folder Management and Creation for Your Organization - download
Learn how to create multiple public folders and manage public folders for your organization. This video shows you how to use Outlook Web Access (OWA) and the Exchange System Manager (ESM) to view and manage public folders
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:55 AM   0 comments links to this post

Free Exchange 2003 Video Tutorial: Retire an Exchange Server: Part 2 of 2

Retire an Exchange Server: Part 2 of 2 - download
In part 2 of this two-part series, you'll finish the migration from one server to another and uninstall Exchange
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:55 AM   0 comments links to this post

Free Exchange 2003 Video Tutorial: Sender Filtering

Sender Filtering - download
Sender Filtering is the ability to block messages that claim to be from a particular user. This video shows you how to use the Exchange System Manager (ESM) to implement sender filtering
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:55 AM   0 comments links to this post

Free Exchange 2003 Video Tutorial: The database files in this store are corrupt - How to Use a Dialtone Database

The database files in this store are corrupt - How to Use a Dialtone Database - download
Worst case scenario: your database is down and you cannot restore (maybe your backups are corrupt or missing as well). In this advanced video, Exchange guru Grant Moyle shows you how you can quickly and easily get a workable database up and running immediately using what's called a Dialtone database. This is a very advanced technique used in special scenarios - hopefully you'll never have to use 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 @ 7:55 AM   0 comments links to this post