Sunday, December 24, 2006

Windows 2003 Video Tutorial: Pt. 3 - Configuring the Shared Disks and Quorum

Pt. 3 - Configuring the Shared Disks and Quorum - view details
This video talks you through setting up the disk arrays and disk subsystem for your cluster. It discusses options for building your cluster as well as costs.

Highlights from this video:
  • Options for storage with clusters
  • Disk configuration
  • Storage Arrays
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: cluster, clustering, clustered, setup, setting up, install, installing clusters, san, shared storage, disc, disk, array, array c

posted by Scott Whigham @ 7:00 AM    

Exchange 2003 Video Tutorial: How to Purge Deleted Items and Manage Delete Item Retention Period

How to Purge Deleted Items and Manage Delete Item Retention Period - view details
This is an excellent video if you're struggling to understand the underpinnings of Microsoft Exchange Server 2003. You'll learn how Exchange works with deleted items, what the 'Deleted Item Retention Period' is and how to configure it. A must-see 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: delete items exchange retention

posted by Scott Whigham @ 7:00 AM    

SQL Server 2000 Video Tutorial: OSQL - What It Is and How to Use It

OSQL - What It Is and How to Use It - view details
OSQL is to the DOS Prompt what Query Analyzer is to Windows; i.e., OSQL is your query writing tool for working in DOS. You can interactively write code and run SQL queries, updates and the like if you want but you can also tell it to execute a script file using the "-i" switch. This video, recorded by SQL guru Scott Whigham, shows you how to use OSQL in your organization to run batch files (.bat files that run SQL scripts) and 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 osql, sql batch file

posted by Scott Whigham @ 7:00 AM    

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

Result sets, Recordsets, and the Client Server model - view details
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, 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 resultset, client/server, beginner, beginning, for beginners, intro duction, step by step

posted by Scott Whigham @ 6:00 AM    

Exchange 2003 Video Tutorial: Phase 2, Pt. 3 - Understanding the ADC with Exchange

Phase 2, Pt. 3 - Understanding the ADC with Exchange - view details
Part 3 of Phase 2 is more about the ADC including tips and tricks and some of the architecture. This video helps you complete Phase 2 which will complete the copying/replicating objects from Exchange 5.5 into the Active Directory.
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: adc, directory services

posted by Scott Whigham @ 6:00 AM    

Windows 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    

SQL Server 2000 Video Tutorial: Peculiarities of the Database Role ddl_admin

Peculiarities of the Database Role ddl_admin - view details
Chances are that you've never either experienced any significant "weirdness" with the fixed database role "ddl_admin" but it does have a few little peculiarities. In this video, Scott Whigham shows you how the ddl_admin works, whether you should use it or not, and some Best Practices for assigning your users membership into ddl_admin
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: ddl_admin, create table

posted by Scott Whigham @ 5:00 AM    

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

Microsoft SQL Server Video Tutorial: Master Database - An Overview of Some of the Common System Tables and Objects

Master Database - An Overview of Some of the Common System Tables and Objects - view details
Veteran SQL trainer Scott Whigham shows you the details of the master database including a tour of the common tables (such as sysxlogins and sysconfigures), the system views (like syslogins) and the virtual tables that give performance information. You'll also learn about the system stored procedures (like sp_help, sp_helpdb and others) and much more. A must-watch-video for anyone wanting to know the sysinternals of SQL Server 2000
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 master database, sql architecture, sql system database

posted by Scott Whigham @ 5:00 AM    

SQL Server Integration Services Video Tutorial: Pt. 1 - An In-Depth Case Study of Migrating a DTS Package to SSIS

Pt. 1 - An In-Depth Case Study of Migrating a DTS Package to SSIS - view details
This is the first video in our series on migrating a DTS package to SSIS package. If you're looking for an exhaustive treatment of how to migrate a complex DTS package to SSIS, then you definitely will want to watch this series. This series takes an interesting DTS package - iterating through each file returned from a result set, downloading that file via FTP, and then inserting that text file's data in a SQL Server table - and lets you see exactly how to migrate this package to SSIS.

Highlights from this video:
  • Using the Package Migration Wizard (PMW)
  • Limitations of the PMW
  • What to Do When the PMW Reports Success But Your SSIS Packages Fail< br />
  • Should You Rewrite Your DTS Package or Use the PMW?
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-on ly video so a subscription is required.

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

Keywords Associated with this video: migrate, migrating, upgrade, upgrading, fails, failure

posted by Scott Whigham @ 4:45 AM    

SQL Server 2005 Video Tutorial: TempDb Database - An Overview of How it Works and When to Use It

TempDb Database - An Overview of How it Works and When to Use It - view details
Yet another excellent video in our series on SQL Server 2005's system databases, this video teaches you the ins and outs of tempdb. SQL Server guru Scott Whigham, author of LearnSqlServer.com and LearnTransactSql.com, walks you through the layout of the main tables, how things have changed, working with temporary tables and table variables and more. A good video to help learn more about the SQL Server architecture.
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: system database, table variable, temp table, temp db

posted by Scott Whigham @ 4:45 AM    

Exchange 2003 Video Tutorial: Configuring Outlook to Access your Exchange Server (How to Setup a Mail Profile)

Configuring Outlook to Access your Exchange Server (How to Setup a Mail Profile) - view details
This user or new administrator video shows how to setup Microsoft Outlook the first time you run it to access the Exchange Server. When you launch Outlook 2000, Outlook XP, Outlook 2003 or even 2007 for the first time, it will prompt you to walk through the "Configuring Outlook" wizard (similar names among the various versions but all essentially the same). This configures what is called a "Mail Profile" that you can later access/modify via either the Control Panel or within Outlook. To be able to use MS Outlook within an organization that uses Exchange, you must set up a Mail Profile that uses Exchange Server. This video walks you through step-by-step how to configure the Mail Profile along with thorough explanations of what each box and screen means/does.

Confused about what "Use Cached Exchange Mode" is? Should you check the box for it? Watch this video and find out!

This video was a request from one of our subscribers. Do you have any video requests? We'd love to hear from you - visit our page and submit it today!
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 ha ve the TSCC codec installed to view this video

Keywords Associated with this video: configure outlook with exchange, set up outlook with Exchange, setup outlook, setup mail profile, beginner, beginning, for begin

posted by Scott Whigham @ 4:45 AM    

SQL Server 2005 Video Tutorial: Pt. 2 - Determining Which Events and Data Columns to Use in Your Trace

Pt. 2 - Determining Which Events and Data Columns to Use in Your Trace - view details
This video, part 2 in our "Intro to Profiler" series, provides a great overview of the various Events (also called "Event Classes") and how the Data Columns work. You'll also see how to choose the various options and how to group columns in Profiler for easier navigation over large traces. You can significantly impact your trace's "drag" on your SQL Server by wisely choosing your events, data columns, and filters when you start your trace. This video walks you through the Event Classes (and makes suggestions as to which to use for what purpose), what common Data Columns are used (and what are Data Columns anyway?), and gives you several creative ideas for doin g your own traces.

Highlights from this video:
  • New Events in SQL Server 2005
  • How templates affect your events and columns
  • Tracing for performance tuning
  • Tracing errors
  • What's the difference between "Profiler" and a "trace"?
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, RPC:Complete, CursorOpen, Deadlock, Exception, Data File Auto Grow, SP:CacheMiss, SP:CacheInsert

posted by Scott Whigham @ 4:45 AM    

Exchange 2003 Video Tutorial: Phase 2, Pt. 2 - Using the Active Directory Connector (ADC)

Phase 2, Pt. 2 - Using the Active Directory Connector (ADC) - view details
Phase 2's second video shows you how to run the Active Directory Connector to replicate your directory objects from Exchange 5.5 into the Active Directory. Exchange guru Grant Moyle talks about which objects to bring over and gives you some Best Practices for your migration.
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: adc, directory services

posted by Scott Whigham @ 4:00 AM    

Exchange 2003 Video Tutorial: Install Service Pack 1 for Microsoft Exchange Server 2003

Install Service Pack 1 for Microsoft Exchange Server 2003 - view details
This video shows you how to perform one of the first tasks you will usually do after installing any major Microsoft Back Office software: installing the service pack. If you want to know how to determine Exchange's Service Pack level this is a great 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: install sp1 exchange, install service pack exchange

posted by Scott Whigham @ 4:00 AM    

Windows 2003 Video Tutorial: Using Remote Assistance

Using Remote Assistance - view details
Remote Assistance, supported in Windows XP and Windows Server 2003, allows a remote administrator to assist a user who is having trouble on a system. Grant Moyle walks you through configuring Remote Assistance and walk through a great demo of how it works
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 Assistance requests

posted by Scott Whigham @ 4:00 AM    

Exchange 2003 Video Tutorial: Configure Exchange 5.5 to Exchange 5.5 Directory Replication

Configure Exchange 5.5 to Exchange 5.5 Directory Replication - view details
This video teaches you how to configure Exchange Server 5.5 for Directory Replication.
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 5.5 replication, exchange 5.5 directory replication

posted by Scott Whigham @ 3:00 AM    

SQL Server 2005 Video Tutorial: Part 1 - An Overview of the Options Available for Upgrading and Migrating

Part 1 - An Overview of the Options Available for Upgrading and Migrating - view details
This video walks you through the choices for migrating to SQL Server 2005 from prior versions (such as SQL Server 2000 or SQL Server 7.0). This is the first video in our series on upgrading to SQL Server 2005 from previous versions and highlights the different options for upgrading along with offering recommendations for your upgrade.
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: upgrade sql server 2000, upgrade sql 7.0, upgrade sql 7, migrate sql server 2000

posted by Scott Whigham @ 3:00 AM    

Windows 2003 Video Tutorial: Part 4 of 4 - Install Exchange 2003

Part 4 of 4 - Install Exchange 2003 - view details
This is the final part of our four-part series on installing Exchange for a small to medium organization (about 100 users or less). In this video everything is ready to install Exchange so we will install and configure Exchange for the first time
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 2003 installation

posted by Scott Whigham @ 3:00 AM    

Exchange 2003 Video Tutorial: Take (Prepare) an Exchange Backup: How to Backup Your Exchange Server's Databases

Take (Prepare) an Exchange Backup: How to Backup Your Exchange Server's Databases - view details
One of the most important tasks for an Exchange administrator is to perform system backups. This video talks you through creating Exchange backups and gives you best practices and ideas for developing an optimal strategy for your organization
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 2003 backup, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 2:00 AM    

Exchange 2003 Video Tutorial: 5.5 Migration - Rehome Mailboxes from 5.5 to 2003 Server (Same Admin Group)

5.5 Migration - Rehome Mailboxes from 5.5 to 2003 Server (Same Admin Group) - view details
5.5 Migration - Rehome Mailboxes from 5.5 to 2003 Server (Same Admin Group)
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: 5.5 Migration - Rehome Mailboxes from 5.5 to 2003 Server (Same Admin Group)

posted by Scott Whigham @ 2:00 AM    

Windows 2003 Video Tutorial: Pt. 3 - More on Managing DFS Replication

Pt. 3 - More on Managing DFS Replication - view details
This video is a continuation of the 2nd video in this series on DFS Replication. This video discusses scheduling, optimizations, and other tools you can use to manage DFS replication.
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: dfs, distributed file system, replication, replicate, replicating, shared folders

posted by Scott Whigham @ 2:00 AM    

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

Customize Internet Explorer and the Desktop Using Group Policy - view details
Ever wondered how to add/change the icons displayed in the top right corner of Internet Explorer? You can change them and many companies will so that they will have a standardized installation of Internet Explorer and/or Windows. Master consultant Grant Moyle teaches you how to tweak Windows using Group Policy to affect the browser title, change logos, and more. This video could also be titled 'Add Your Own Custom Logo to Internet Explorer'
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: Customize IE logo Windows 2003, change Internet Explorer logo Windows 2003

posted by Scott Whigham @ 1:00 AM    

SQL Server 2005 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 - view details
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, 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: transaction log filled disk, disk full, tran log full, truncate log

posted by Scott Whigham @ 1:00 AM    

Microsoft SQL Server Video Tutorial: TempDb Database - An Overview of How it Works and When to Use It

TempDb Database - An Overview of How it Works and When to Use It - view details
Yet another excellent video in our series on SQL Server 2005's system databases, this video teaches you the ins and outs of tempdb. SQL Server guru Scott Whigham, author of LearnSqlServer.com and LearnTransactSql.com, walks you through the layout of the main tables, how things have changed, working with temporary tables and table variables and more. A good video to help learn more about the SQL Server architecture.
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: system database, table variable, temp table, temp db

posted by Scott Whigham @ 1:00 AM    

SQL Server Integration Services Video Tutorial: Formatting Options in SSIS - How to Make Your Packages More Manageable

Formatting Options in SSIS - How to Make Your Packages More Manageable - view details
Just like well-written source code, &quot;good looking&quot; SSIS packages are easier to manage (edit/maintain) than sloppily laid out packages. Do you want to save yourself time? Then lay out your SSIS packages carefully so that you (or others) will understand what the package flow is when you revist this package three months from now.

Highlights from this video:
  • Using the new formatting options in the Business Intelligence Development Studio (BIDS)
  • Aligning sides and centers
  • Using the Visio-style controls to manipulate task-boxes and text
  • Formatting text annotations
  • Suggestions for auto-sizing
  • Manipulating hard-to-work-with text annotations easily
  • Horizontal and Vertical spacing options
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a sub scriber-only video so a subscription is required.

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

Keywords Associated with this video: autosizing, autosize, auto-size, auto-layout, autolayout, lay out, autoformat, auto-format, pretty, prettify

posted by Scott Whigham @ 12:00 AM    

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

Pt. 1 - Using SQL Profiler - Concepts and Screens - view details
SQL Server Profiler is one of the greatest SQL Server admin tools ever - you absolutely need to know it! This video walks you through the basics of "What is SQL Server Profiler?" and "How do I run Profiler?"

Highlights from this video:
  • What traces are and how to use them
  • Security requirements for running Profiler
  • Using (local) or . or any alias in Profiler - good or bad?
  • Concepts of server-side tracing vs. client-side traces
  • Suggestions for naming traces
  • Explanation of rollover files and Best Practices for using Profiler
  • Should You Trace to File or Trace to Table? What's the "Best Practice"?
  • Using templates
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 2000 profiler, profiling, sql sniffer, sniffing sql, tracing sql

posted by Scott Whigham @ 12:00 AM    

Microsoft SQL Server Video Tutorial: OSQL - What It Is and How to Use It

OSQL - What It Is and How to Use It - view details
OSQL is to the DOS Prompt what Query Analyzer is to Windows; i.e., OSQL is your query writing tool for working in DOS. You can interactively write code and run SQL queries, updates and the like if you want but you can also tell it to execute a script file using the "-i" switch. This video, recorded by SQL guru Scott Whigham, shows you how to use OSQL in your organization to run batch files (.bat files that run SQL scripts) and 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 osql, sql batch file

posted by Scott Whigham @ 12:00 AM