Friday, March 07, 2008

Free SQL Server Video Tutorial: An Overview of the Northwind Database

An Overview of the Northwind Database - download
Scott Whigham walks you through the layout of the Northwind database in this video. Northwind is used for many demos and videos throughout the site due to how easy it is to work with. This is not a long video but will serve to familiarize you with the sample database used in many of the T-SQL-based videos.

NOTE: You can download the Northwind (and Pubs) sample databases from the microsoft.com website here


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: sample database, sample db, install sample, oltp database, beginner, beginning, for beginners, introduction, step by step

Free Exchange Server Video Tutorial: Building Mail Universal Distribution Groups and Dynamic Distribution Groups

Building Mail Universal Distribution Groups and Dynamic Distribution Groups - download
How to Build Mail Universal Distribution Groups and Dynamic Distribution Groups


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 Build Mail Universal Distribution Groups and Dynamic Distribution Groups

Free Exchange Server Video Tutorial: POP3 and IMAP4 in Exchange 2003

POP3 and IMAP4 in Exchange 2003 - download
This video takes a look at the IMAP4 and the POP3 protocol configuration in Exchange System Manager (ESM) so that our Exchange server will listen for IMAP4 and POP3 requests on the internet. Grant Moyle, Exchange trainer, explains what POP3 and IMAP4 are and how they are used on the world wide web today


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: POP3 IMAP4 with Exchange, IMAP4 with Exchange, POP3 with Exchange, beginner, beginning, for beginners, introduction, step by ste

Free SQL Server Video Tutorial: Part 1 - How to Be a Proactive DBA: What Are Alerts?

Part 1 - How to Be a Proactive DBA: What Are Alerts? - download
Alerts in SQL server are a very important piece for the administrator to understand; especially the DBA?s who actively manage their server and want to be proactive with their management. Alerts allow you to define a response to an event or condition and in this introductory video tutorial your instructor Scott Whigham will divulge more on the world of alerts in SQL Server 2005.

Highlights from this video:
  • SQL Server log
  • Alert basics
  • Three firing instances of an event or condition
  • Operators in SQL
  • How an event occurs in SQL server and RAISEERROR
  • Severity levels of errors
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: alerts, DBA, management, SQL Agent, WMI, Error Handling, Performance