Saturday, December 16, 2006

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

Keywords Associated with this video: ntdsutil, Ntds.dit, active directory maintenance, optimize active directory

posted by Scott Whigham @ 11:00 PM    

Windows 2003 Video Tutorial: Mapping Processes to Port Usage

Mapping Processes to Port Usage - view details
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, 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: map processes to port numbers

posted by Scott Whigham @ 11:00 PM    

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

Part 2 - A Basic Walkthrough of the Built-In Tasks - view details
Part 2 - A Basic Walkthrough of the Built-In Tasks
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: Part 2 - A Basic Walkthrough of the Built-In Tasks, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 11:00 PM    

SQL Server 2000 Video Tutorial: Building a Customized Microsoft Management Console (MMC) for Use with SQL Server

Building a Customized Microsoft Management Console (MMC) for Use with SQL Server - view details
Scott Whigham says that this is one of the very first things that he does whenever he builds or works on a new server - it's one of his favorite little tweaks for working with SQL Server. This video shows you how you can create your own "version" of the Enterprise Manager inside a custom MMC (Microsoft Management Console). Not only is this an easier to way to work with SQL Server but it shows that you know what you're doing when you sit down at a new SQL Server!
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: custom MMC, how to customize MMC

posted by Scott Whigham @ 10:00 PM    

Exchange 2003 Video Tutorial: How to Install Windows Server 2003 R2 Standard Edition

How to Install Windows Server 2003 R2 Standard Edition - view details
In this video, consultant Grant A. Moyle shows you how to install Microsoft Windows 2003 R2, Standard Edition. You'll see the features of the Windows Server R2 setup and learn all the details about a typical Windows Server installation
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: setup windows 2003 r2, install windows server 2003 r2

posted by Scott Whigham @ 10:00 PM    

Transact SQL Video Tutorial: Part 2 - Design Pattern for JOINs - A Simple Way to Look at Joining Tables

Part 2 - Design Pattern for JOINs - A Simple Way to Look at Joining Tables - view details
The second in our two-part series on JOIN patterns, this video shows you the final pattern and walks you through creating your own template that you can use to simplify your use of the design pattern.
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: sql join pattern, join tables

posted by Scott Whigham @ 10:00 PM    

Windows 2003 Video Tutorial: Add New Disks to Windows 2003

Add New Disks to Windows 2003 - view details
An important need is to add new disks to Windows 2003 and this video shows you the ins and outs!
To download this video, log in, then visit th e 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: add new disk to Windows 2003, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 9:00 PM    

Microsoft SQL Server Video Tutorial: Pt. 1 - Using SQL Profiler - Concepts, Terms and Screens

Pt. 1 - Using SQL Profiler - Concepts, Terms and Screens - view details
SQL Server Profiler is just an amazing tool and one that every sysadmin should know "backwards and forwards." This video, the first in our series, covers what Profiler is, what traces are, and gives you an introduction to using Profiler. You'll also cover the basic screens when you start Profiler.

Highlights from this video:
  • Differences between SQL Server 2000 Profiler and SQL Server 2005 Profiler
  • Permissions required for SQL Server 2005 Profiler
  • Making decisions on the "General" screen
  • Should you save to file or save to table?
  • Using templates with Profiler
  • What sort of performance impact will Profiler cause? How much?
  • How to minimize the "drag" that Profiler creates
  • Server side vs. client side traces
  • What are rollover files (file rollover)? What should the setting be?
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: sql trace, sql profiler, sql server 2005 profiler, profiling, sql sniffer, sniffing sql, tracing sql

posted by Scott Whigham @ 9:00 PM    

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 @ 8:00 PM    

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 @ 8:00 PM    

SQL Server 2000 Video Tutorial: Using Aliases and the Client Network Utility

Using Aliases and the Client Network Utility - view details
Scott Whigham, our resident SQL Guru, says that creating aliases for his SQL Servers is one of his favorite "little things" to do on his servers. It isn't a big thing - aliases are very simple actually - but they sure does make life easier. This video shows you how you can create aliases, what the benefits of aliases are, and when you would likely use them. A great video for all skill levels
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: sql alias, client alias sql server

posted by Scott Whigham @ 7:00 PM    

Transact SQL Video Tutorial: Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys

Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys - view details
This video focuses on common SQL developer/DBA terms regarding indexes and constraints and helps you get comfortable with the SQL lexicon. The work "key" is used over and over in SQL - Primary Key, Foreign Key, Alternate key, and more - yet many developers rarely go beyond the primary key and foreign key. This makes it difficult to develop robust systems. For more on the types of keys available and their usage, watch this video from SQL consultant Scott Whigham.
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: alternate key, associative key, pk, fk, check constraint, u nique constraint

posted by Scott Whigham @ 7:00 PM    

Windows 2003 Video Tutorial: Remote Desktop: Tuning and Performance

Remote Desktop: Tuning and Performance - view details
Remote Desktop allows an administrator to work with a user to help diagnose problems and work together. This video helps you understand the differences between Remote Desktop and Terminal Services as well as going through the configuration of Remote Desktop. You'll also receive some great performance-enhancing tips (performance tuning) from veteran Windows trainer, Grant Moyle
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: remote desktop performance tuning

posted by Scott Whigham @ 7:00 PM    

SQL Server 2000 Video Tutorial: Part 1 - An Overview of the Enterprise Manager for SQL Server 2000

Part 1 - An Overview of the Enterprise Manager for SQL Server 2000 - view details
The Enterprise Manager is an essential tool for SQL developers and admins alike. This video is designed to be your first introduction to working with this critical tool. It shows you the basics of registering servers, logging in, and is designed to give you a good feel for how the Enterprise Manager helps you manage your SQL Server
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: sql enterprise manager, enterprise manager sql server, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 6:00 PM    

Windows 2003 Video Tutorial: Time Synchronization Using Active Directory

Time Synchronization Using Active Directory - view details
Do you want all of your Active Directory objects to use the same time? What about the same time zone? How can you synchronize the time across the domain? This video helps you understand AD Time Sync and shows you how to set it up for your networks.
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: ad time sync, net time

posted by Scott Whigham @ 6:00 PM    

Exchange 2003 Video Tutorial: Pt. 1 - Pre Installation Steps for Exchange 2000

Pt. 1 - Pre Installation Steps for Exchange 2000 - view details
This video walks you through the pre-requisites for installing Exchange 2000 along with some ideas for setting up the server in preparation to test your upgrade to Exchange 2003.
To downl oad 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: prereqs

posted by Scott Whigham @ 6:00 PM    

SQL Server 2000 Video Tutorial: Install SQL Server - Discussion of Collation Types and Recommendations

Install SQL Server - Discussion of Collation Types and Recommendations - view details
When you install SQL Server, you make perhaps one of the most important decisions you can make: which default collation you will use. Should you choose Windows Locale or a SQL Collation (and what's the difference)? Are SQL Server Authentication passwords case-sensitive (and why are you asking me that here)? Collations are incredibly important to SQL Server and the collation that you choose during setup can save you hours of frustration later on. Watch this video and get an excellent overview of what collations are and how you should go about choosing the right collation for your installation
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 Assoc iated with this video: sql collations, code page, Cp1252, CP1, Latin1_General, Latin, CP850 multi-lingual

posted by Scott Whigham @ 5:00 PM    

Exchange 2003 Video Tutorial: Mailbox Store SubContainers - Logons, Mailboxes, and Full Text Indexing

Mailbox Store SubContainers - Logons, Mailboxes, and Full Text Indexing - view details
Inside Exchange System Manager there is a series of subfolders underneath the Mailbox Store. This video walks you through how to use these subcontainers (subfolders) to manage your Exchange server. The 'Logons' folder, 'Mailboxes' and 'Full Text Indexing' folders are covered in this video
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: configure mailbox store subcontainers, configure mailbox store sub-containers, configure mailbox store sub containers

posted by Scott Whigham @ 5:00 PM    

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 @ 5:00 PM    

Exchange 2003 Video Tutorial: Intro - High-Level Overview and Walk-Through

Intro - High-Level Overview and Walk-Through - view details
This video is an overview of the process of upgrading from Exchange Server 2000 to Exchange Server 2003. This is an excellent video to watch if you are planning an Exchange Server 2000 upgrade. Watching this video, especially in conjunction with the other
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: exchange 2000 upgrade overview, exchange 2000 upgrade tutorial

posted by Scott Whigham @ 4:00 PM    

Windows 2003 Video Tutorial: Install New Hard Drive and Assign Drive Letter

Install New Hard Drive and Assign Drive Letter - view details
Grant Moyle walks you through adding new hard drives to your Windows Server 2003. Microsoft changed how hard drives are recognized in Windows Server 2003 and before you can use a new disk you must go through a few simple steps. In this video you'll learn how to assign drive letters and the basics of partitioning and formatting a new hard drive. Once you finish this video you'll be comfortable adding drives to your Windows 2003 Server. This video could've been titled 'Add a New Hard Drive to Your Server'
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: Windows 2003 hard drive installation, change drive letters

posted by Scott Whigham @ 4:00 PM    

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

Microsoft Firewall: Configuration and Setup for Windows 2003 - view details
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, 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: Windows Firewall Configuration, Windows Firewall Windows 2003

posted by Scott Whigham @ 3:00 PM    

Microsoft SQL Server Video Tutorial: Alerts in SQL Server 2000 - What They Are, How to Use Them and Best Practices

Alerts in SQL Server 2000 - What They Are, How to Use Them and Best Practices - view details
Alerts are probably one of the most under-utilized management features in SQL Server. Whether it's because most administrators do not understand what alerts are or because DBAs are too busy focusing on other aspects of the system, SQL Server's alert system is often completely overlooked. SQL guru Scott Whigham shows you the basics of alerts in this video and helps you get the "Big Picture". You'll learn about event alerts and performance condition alerts and, as the title suggests, what they are and how to use them
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: sql server alerts, how to sql alert, sql server event aler t, sql server performance condition

posted by Scott Whigham @ 3:00 PM    

Windows 2003 Video Tutorial: Managing Policies with the Group Policy Management Console (GPMC)

Managing Policies with the Group Policy Management Console (GPMC) - view details
Since Windows 2000, administrators have been able to manage and use Group Policies. The GPMC is a snap-in to the MMC (Microsoft Management Console) as well as a series of programming interfaces that allow you to manage multiple domain policies. Quite simply, it makes managing your domain policies much easier.

Highlights from this video:
  • Generating reports using GPMC
  • Group Policy Management for multiple domains and policies
  • Group Policy Modeling concepts
  • Group Policy Objects
  • Default Domain Policy
  • Group Policy Results
and much more

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

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

Keywords Associated with this video: Group Policy Management Console, GPMC, multiple domain policies, rsop,

posted by Scott Whigham @ 3:00 PM    

Transact SQL Video Tutorial: Subqueries, Nested Queries, and Derived Tables - An Introduction to Advanced SQL Constructs

Subqueries, Nested Queries, and Derived Tables - An Introduction to Advanced SQL Constructs - view details
Subqueries and derived tables can be some of the hardest constructs for people new to SQL to really grasp. This video is a "First Look" at sub-selects (another word for sub-queries) and the basic concepts of using subqueries in your SELECT statements. Perhaps the most valuable thing that even seasoned query-writers will get from watching this video is the "how"; a major focus of this video is how SQL Server processes subqueries internally. Scott Whigham, author of this site, takes you through how SQL Server will process the subquery in a step-by-step approach.

Note: This video was shot on SQL Server 2005 but the concepts are the same for SQL Server 2000.

Highlights from this video:

  • Execution plans: are they different or the same between different subqueries?
  • Using a subquery instead of a JOIN and vice-versa
  • Correlated subqueries and Simple Subqueries
  • Derived Tables; i.e., embedding a SELECT statement in the FROM clause
  • Step by step approach to writing subqueries
  • SQL Server architecture: Query Processing Sequence

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: synchronized query, sub select, nested query, virtual table, materialize

posted by Scott Whigham @ 2:00 PM    

SQL Server 2005 Video Tutorial: Using the UNPIVOT Operator to Normalize Denormalized Tables and Datasets

Using the UNPIVOT Operator to Normalize Denormalized Tables and Datasets - view details
The opposite of the PIVOT operator is UNPIVOT. Since PIVOT creates cross tab queries (or "pivots" the data across the vertical and horizontal axis by turning row values into columns), UNPIVOT can take a crosstab query's resultset and normalize the results by turning the column data into rows. Make sense? If not, you need to watch this video!
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: crosstab, cross tab, cross-tab, new feature, select, report, normalize, normalizing

posted by Scott Whigham @ 2:00 PM    

Transact SQL Video Tutorial: Part 2 - Identity Columns - When Should I Use an Identity Column?

Part 2 - Identity Columns - When Should I Use an Identity Column? - view details
Our second video in the series on using IDENTITY/sequencing columns, this video focuses on when you might consider using a system-generated identifier.
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: using identity, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 1:00 PM    

Windows 2003 Video Tutorial: Active Directory Management: Basic Group Management (Mixed Mode)

Active Directory Management: Basic Group Management (Mixed Mode) - view details
In this video you will add a new container in Active Directory and add the group Junior Staff Members as well as adding users to groups and making decisions about whether this needs to be a Local Group, a Domain Group, or a Universal Group. You'll also understand what Universal Groups are, how to enable/disable them and how to have your Active Directory interact with Windows NT 4.0 (Mixed Mode). This video could also be titled 'How to build groups in the Active Directory with Active Directory Users and Computers'
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: Windows Server 2003 Mixed Mode, Windows NT 4.0 Active Directory Migration, Create Group in Active Directory with Windows 2003, b

posted by Scott Whigham @ 12:00 PM    

Exchange 2003 Video Tutorial: How to Retrieve a Deleted User's Mailbox

How to Retrieve a Deleted User's Mailbox - view details
Problem: Someone has just deleted an Exchange user's account from the Active Directory - is there a way that you can retrieve that user's email even after that user has been deleted from the system? Yes! In this video, Exchange guru Grant Moyle shows you the proper way to retrieve this user's email. If you want to know what reconnect or purge (purging) is this is a great video for you
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: reconnect exchange mailbox, retrieve deleted users mailbox

posted by Scott Whigham @ 12:00 PM    

Microsoft SQL Server Video Tutorial: How to Upgrade The Documentation of SQL Server 2005 (Books Online)

How to Upgrade The Documentation of SQL Server 2005 (Books Online) - view details
Although the actual release for public sale of SQL Server 2005 in December of 2006, Microsoft felt compelled to release an update (a "refresh") of the documentation only a few weeks later. This video shows you how you can tell which version of Books Online (BOL) that you are running, how to update your BOL, and walks you through the process. It's actually a pretty hefty update too - over 115MB of "refreshed" documentation for a piece of software released for public sale only a few weeks earlier. You'll definitely want to upgrade your Books Online as soon as possible.
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: BOL update, books online, begi nner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 11:00 AM    

Exchange 2003 Video Tutorial: Setup Certificate Authority and Issue SSL Certificate for OWA (Outlook Web Access)

Setup Certificate Authority and Issue SSL Certificate for OWA (Outlook Web Access) - view details
There's a lot to managing certificates - this video covers the basics of getting certificates up and running so that your users can have secure connections through Outlook Web Access (OWA). Exchange guru Grant Moyle gives you several tips for installing certificates, using Exchange certificates and working with OWA
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: how to issue SSL certificate for Exchange, SSL certificate tutorial for Exchange

posted by Scott Whigham @ 11:00 AM    

Windows 2003 Video Tutorial: Windows 2000: Installing Service Pack 4 (SP4)

Windows 2000: Installing Service Pack 4 (SP4) - view details
Many administrators manage multiple operating system versions including Windows Server 2003, Windows 2000 and, of course, Windows XP. This video shows you the installation techniques for Service Pack 4 and how to determine the service pack level of any Windows machine
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: SP4 Windows 2000

posted by Scott Whigham @ 10:00 AM    

Exchange 2003 Video Tutorial: Configure OWA (Outlook Web Access) with a Simple Redirect Page

Configure OWA (Outlook Web Access) with a Simple Redirect Page - view details
Make it easier for your users to use Webmail by watching this helpful video. With Webmail, by default, your users have to remember to type in a few options (slash exchange and to use https, for example). You'll learn how to simplify the GUI for your users in this video and configure your web server to forward to your Exchange server. This video contains several helpful tips and tricks for working with Webmail and Exchange
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: Outlook Web Access with Simple Redirect Page, OWA with Simple Redirect Page

posted by Scott Whigham @ 10:00 AM    

Microsoft SQL Server Video Tutorial: When to Use HAVING Instead of WHERE - Aggregates, GROUP BY, and the HAVING Clause

When to Use HAVING Instead of WHERE - Aggregates, GROUP BY, and the HAVING Clause - view details
The traditional areas of difficulty for SQL developers are aggregates, JOINs, and subqueries. Most people have no trouble understanding when to use COUNT instead of SUM but they get "stuck" when it comes to determining how to filter the data. Suppose you are asked to find all orders in 2006 in which customers ordered more than 5 items - how would you solve this query? Obviously you need two filters: for the date (2006) and for orders with more than 5 items. People have difficulty with this type of query however; most people would approach this query along these lines: "SELECT ... FROM Orders JOIN OrderDetails ... WHERE Year(DateOrdered)=2006 AND COUNT(*) > 5". Fo cus on the WHERE clause for a moment: is that right? If you aren't sure or if you think it is right, then you need to watch this video to understanding why this query must use the HAVING clause.
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: having, aggregates where clause, group by

posted by Scott Whigham @ 9:00 AM    

Windows 2003 Video Tutorial: How to Raise Domain and Forest Functional Levels

How to Raise Domain and Forest Functional Levels - view details
Depending on the status of your Active Directory and the type of domain controllers you use, it might be time for you to update the functional level of your domain controllers. In this video you'll view the details on how to change from Mixed Mode (which supports both Windows 2000 and Windows 2003 Active Directory) to Windows 2003 Native Mode (which supports only Windows 2003 and higher).
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: Windows 2003 Raise Domain Functional Level

posted by Scott Whigham @ 9:00 AM    

Windows 2003 Video Tutorial: Using Disk Quotas to Document Disk Usage

Using Disk Quotas to Document Disk Usage - view details
Disk quotas allow the Windows administrator to ensure that certain users can only take up so much file storage. This video shows you how to audit folder space usage and set up disk quotas
To d ownload 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: Windows 2003 disk quotas

posted by Scott Whigham @ 8:00 AM    

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 @ 7:00 AM    

SQL Server 2005 Video Tutorial: Pt. 2 - Creating Your First SSIS Packages (Integration Services Packages)

Pt. 2 - Creating Your First SSIS Packages (Integration Services Packages) - view details
The second video in our introduction series on Integration Services focuses on creating, importing, and adding packages in the BI Studio (more formally known as the SQL Server Business Intelligence Design Studio). This is an introductory-level video designed as a "first look" into SSIS packages and the BI Studio. Many people get very confused with the basic concepts of the SSIS architecture and this video helps allay some of the intimidation. Scott Whigham walks you through finding the SSIS Package Store, how the file system works within SSIS, and more information about creating packages.
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: SSIS package store, create ssis package, ssis package basics, ssis package intro

posted by Scott Whigham @ 7:00 AM    

Free SQL Server 2000 Video Tutorial: Reason to Install SP3 - Buffer Overflow Attack using OPENROWSET

Reason to Install SP3 - Buffer Overflow Attack using OPENROWSET - download
Attack! Attack! You're SQL Server is under attack! You might be quite worried if what Scott Whigham shows you in this video were to happen though on your SQL Server. This is an interesting video. It shows a known exploit against SQL Server - a hack, if you will - and how to prevent it. If you haven't worked with the registry or watched the videos on SQL Server Authentication Modes, then you might have a little bit of homework to do before watching this one. It gets pretty deep but is a very interesting study in SQL Server security and patching
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 attack, sql security, sql hack

posted by Scott Whigham @ 6:00 AM    

Windows 2003 Video Tutorial: Customize Login Wallpaper

Customize Login Wallpaper - view details
Since so many servers sit at the Windows Logon screen for much of their 'life' many administrators want to change these default screens to something more entertaining and/or useful (such as a clock, calendar, etc). This helps you customize the experience on Windows Server 2003 but the same process will work for Windows XP clients