Saturday, April 14, 2007

Exchange 2007/2003 Video Tutorial: Overview of the Default Domain Security Policy in Windows 2003

Overview of the Default Domain Security Policy in Windows 2003 - view details
Overview of the Default Domain Security Policy in Windows 2003
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: Overview of the Default Domain Security Policy in Windows 2003

posted by Scott Whigham @ 6:00 AM    

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 - view details
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, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: Unicode, nvarchar, nchar, ntext, cp1252, cp1, latin1_general, cp850

posted by Scott Whigham @ 4:00 AM    

Friday, April 13, 2007

SQL Server 2005 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 - view details
What TCP/IP port has IANA assigned for Microsoft to use for a SQL Server instance - 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, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: change sql tcp ip port number

posted by Scott Whigham @ 6:00 AM    

SQL Server 2000 Video Tutorial: Creating and Altering Views in the Enterprise Manager (SQL Server 2000)

Creating and Altering Views in the Enterprise Manager (SQL Server 2000) - view details
If you are new to working with SQL Server (and views), then this is an excellent introduction to creating and altering views using SQL Server 2000's Enterprise Manager. This video is focused on SQL Server 2000 but, for those of you using SQL Server 2005, the screens are almost identical in the SQL Server Management Studio.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: create view, alter view, drop view

posted by Scott Whigham @ 4:00 AM    

Thursday, April 12, 2007

SQL Server 2005 Video Tutorial: EXCEPT and INTERSECT - An Introduction to Syntax and Concepts

EXCEPT and INTERSECT - An Introduction to Syntax and Concepts - view details
New in Transact-SQL for SQL Server 2005 are the EXCEPT and INTERSECT operators. These are not new SQL concepts; rather, these are just being added to SQL Server after being supported in other systems. Chances are that you've written your fair share of EXCEPT and INTERSECT-type queries but using a different syntax. NOTE: this video talks extensively about INNER and OUTER JOINs therefore a solid understanding of both is assumed.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: outer join, inner join, new feature 2005, ansi, iso, standard

posted by Scott Whigham @ 6:00 AM    

Exchange 2007/2003 Video Tutorial: Pt. 1 - Building a Standalone SMTP Server for Exchange Message Relay in the DMZ

Pt. 1 - Building a Standalone SMTP Server for Exchange Message Relay in the DMZ - view details
Many Organizations utilize a DMZ (Demilitarized Zone) between their corporate Networks and the Internet. In this video, the instructor will demonstrate how to setup Windows 2003 Web Edition to act as an intermediate messaging point between your Exchange Servers and the Internet for incoming and outgoing SMTP communication. A must-see video for administrators deploying multiple exchange servers or those addressing security with a DMZ. NOTE: This video is split into two parts due to the size of the file and length of the video.

Highlights from this video:
  • Installing IIS' SMTP Service
  • Configuring SMTP
  • Outbound Security and Advanced Options
  • Configuring SMTP Virtual Server Properties
  • Non Delivery Report options
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: demilitirized zone, dmv, exchange smtp

posted by Scott Whigham @ 4:00 AM    

Wednesday, April 11, 2007

Transact SQL Video Tutorial: Stored Procedure Introduction: Definition, Usage, and Creating Stored Procedures Using the Create Stored Procedure Wizard

Stored Procedure Introduction: Definition, Usage, and Creating Stored Procedures Using the Create Stored Procedure Wizard - view details
Stored procedures are, quite simply, the most popular way that modern database developers allow applications to interface with the database. This video is an excellent introduction to what a stored procedure is, how to use ("execute") stored procedures, and the syntax and tools used in creating/managing stored procedures.

The Enterprise Manager allows you to quickly create generic stored procedures using the Create Stored Procedure Wizard. Is it a good wizard; i.e., should you use it? Maybe - this video gives you the pros and cons of using the Enterprise Manager to manage stored procedures.

Highlights from this video:

  • What is a stored procedure?
  • Example stored procedures
  • Using the Create Stored Procedure Wizard
  • Suggestions for using stored procs
  • Naming Conventions
  • Creating and Editing Stored Procedures with TSQL

Note: This should be considered a "Must-See" video for all newbies!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: sp_help, sproc, procs, , beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 11:55 AM    

Windows 2003 Video Tutorial: DHCP Server: Assign Reserved IP Addresses

DHCP Server: Assign Reserved IP Addresses - view details
This video shows you how you can use both DHCP and static IP addresses easily with Windows Server 2003. You'll also get great explanations of DHCP address leases and expirations, the address pool and reservations. You'll assign reservations to particular machines and get an understanding of the benefits/trade-offs of using static vs dynamic IPs
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: DHCP reserved IP addresses

posted by Scott Whigham @ 11:00 AM    

SQL Server 2005 Video Tutorial: Pt. 1 - Installing Service Pack 2 on Your SQL Server Cluster

Pt. 1 - Installing Service Pack 2 on Your SQL Server Cluster - view details
SP2 is the latest service pack from Microsoft and this video helps you view a service pack installation on a cluster. You'll walk through the entire installation as well as the verification of the installation.

Highlights from this video:
  • Installing SQL Server 2005 Service Pack 2 CTP (a.k.a. the Beta version)
  • Best Practices for installing service packs
  • Managing the cluster and verifying the Active/Passive nodes
  • Tips and techniques for a smooth upgrade
  • Viewing the new setup bootstrapping program in SP2
  • Suggestions for disaster recovery/rollback
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: sp2, sp1, clustered service packs, SPS, installing, installation, setup.bat

posted by Scott Whigham @ 10:15 AM    

Windows 2003 Video Tutorial: Building a New User With Mailbox

Building a New User With Mailbox - view details
In this video you'll add new users to your Active Directory and setup a mailbox (and test it) for each. Required viewing for all new Exchange admins!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: create new Exchange user, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 10:08 AM    

Exchange 2007/2003 Video Tutorial: Pt. 3 - Customize Outlook to Display the SCL Scores in IMF

Pt. 3 - Customize Outlook to Display the SCL Scores in IMF - view details
In parts 1 & 2 you learned to configure the IMF to work with your Exchange Server and AD. In part 3, Grant Moyle teaches you how to customize Microsoft Outlook so that you can actually see the SCL score from IMF.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: ms outlook, outlook express

posted by Scott Whigham @ 10:00 AM    

Transact SQL Video Tutorial: Pt. 3 - Best Practices for Using Return Values

Pt. 3 - Best Practices for Using Return Values - view details
The final video in this series on using return values talks about using RETURN to send @@ERROR values back to the caller and whether or not this is a common/good practice.

Highlights from this video:
  • Using RETURN with @@ERROR
  • Making Decisions with SqlParameter and ParameterDirection.ReturnValue
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: SqlParameter, ParameterDirection.ReturnValue, returning error, return @@ERROR, @RETURN_VALUE

posted by Scott Whigham @ 10:00 AM    

Transact SQL Video Tutorial: UNION Queries - What They Are and How to Use Them (SQL Server 2000)

UNION Queries - What They Are and How to Use Them (SQL Server 2000) - view details
Although less popular than JOINs, UNIONs are another way to work with multiple tables in the same query. Much of the time UNIONs are used to generate lists of things; i.e., "Find all Customers and Suppliers in the United States". This video gives you the basic syntax and, more importantly, the logic behind how it works and when to use UNION vs. UNION ALL.

Note: This video was shot on SQL Server 2000's Query Analyzer but the same logic applies for SQL Server 2005

Highlights from this video:

  • Difference between UNION and UNION ALL
  • Performance with UNION
  • Including indicators in result sets to identify which table a row comes from
  • Writing UNION compatible queries
  • Datatype mismatches in UNIONs and how to avoid them
  • ORDER BY in UNION queries

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: distinct, union all

posted by Scott Whigham @ 9:00 AM    

SQL Server 2000 Video Tutorial: Installing SQL Server 2000 - Basic Overview

Installing SQL Server 2000 - Basic Overview - view details
This video is a quick walk-through of the SQL Server install. It is aimed for those viewers wanting to see a quick install and then, after they have a good overview of how it works, want to delve deeper (by watching the other installation videos). Perfect for newbies and people migrating to SQL Server from other systems
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

Keywords Associated with this video: quick install sql server, sql server basic installation, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 8:34 AM