Saturday, December 23, 2006

Exchange 2003 Video Tutorial: Install ADSIEdit and View Exchange Configuration in AD

Install ADSIEdit and View Exchange Configuration in AD - view details
ADSIEdit is a fantastic tool that lets you edit the Active Directory. Exchange administrators can use this tool to configure their Exchange servers manually instead of through the GUI-based tools. This video shows you how to install ADSIEdit (via the Windows Support Tools installation) and configure your Exchange Server in a whole new way. All Exchange administrators should see 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: ADSIEdit with Exchange, Exchange Active Directory configuration

posted by Scott Whigham @ 11:00 PM    

Exchange 2003 Video Tutorial: How to Reclaim Space on Your Exchange Server By Purging Multiple Mailboxes

How to Reclaim Space on Your Exchange Server By Purging Multiple Mailboxes - view details
By default Exchange holds onto deleted account mailboxes for thirty days. This takes up unnecessary space on your Exchange Server. Exchange trainer Grant Moyle shows you some best practices and how--Exchange-works for reclaiming wasted space
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: purge multiple exchange mailboxes, purge exchange mailboxes

posted by Scott Whigham @ 11:00 PM    

Windows 2003 Video Tutorial: Create and Share a Local Printer

Create and Share a Local Printer - view details
The basics of printer sharing in Windows Server 2003. Guru Grant Moyle walks you through installing an LPT1 printer and sharing this printer on the network. You'll also learn about PostScript, PCL6 and when to use which
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 share printer, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 11:00 PM    

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

SQL Server 2005 Video Tutorial: How to Return Identity Value for a Just-Inserted Row

How to Return Identity Value for a Just-Inserted Row - view details
So many SQL developers use IDENTITY columns (a.k.a. sequences and/or auto-number columns) therefore this video is essential knowledge for SQL developers, DBAs, and even application developers. This tutorial focuses on working with IDENTITY columns as primary keys and how you can retrieve the just-inserted row's primary key value. Several techniques are discussed here with a final discussion on perhaps the "safest" (and recommended) technique.
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: identity, @@identity, scope identity, scope_identity

posted by Scott Whigham @ 10:00 PM    

Windows 2003 Video Tutorial: Join Windows XP to the Domain

Join Windows XP to the Domain - view details
A quick video designed to show you how to join a computer to a domain and the benefits of doing so
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: join computer to Windows 2003 domain, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 10:00 PM    

DTS Video Tutorial: Part 2 - How to Assign Values to Global Variables Using the Execute SQL Task

Part 2 - How to Assign Values to Global Variables Using the Execute SQL Task - view details
Part 2 - How to Assign Values to Global Variables Using the Execute SQL Task
To download this video, log in, then visi t 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 - How to Assign Values to Global Variables Using the Execute SQL Task

posted by Scott Whigham @ 9:00 PM    

SQL Server 2000 Video Tutorial: Install SQL Server - Discussion of File Placement and Suggestions for High Performance

Install SQL Server - Discussion of File Placement and Suggestions for High Performance - view details
Here's a general rule of thumb for most SQL Server installations: the more hard drives that you can put your SQL Server's database files on, the faster your performance. This video talks about file placement and gives you a solid understanding of why SQL Server works better this way. If you really want to know the fundamentals and the architecture of SQL Server, this is an excellent place to start
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 file optimization, multiple hard drives, spread your database across multiple disks, raid, raid 1, raid 5

posted by Scott Whigham @ 9:00 PM    

Microsoft SQL Server Video Tutorial: Discussions on Decisions Such as What to Install, Optional Components, and Infrequently Used Terms

Discussions on Decisions Such as What to Install, Optional Components, and Infrequently Used Terms - view details
SQL Server trainer and consultant Scott Whigham talks about what each of the options mean during the install regarding what tools to install (and which are his favorites) and some of the terms you might hear or use when discussing an install 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 install, install sql server

posted by Scott Whigham @ 9:00 PM    

SQL Server 2005 Video Tutorial: Part 7 - A Look at the Installed Folders

Part 7 - A Look at the Installed Folders - view details
In our final video on installing SQL Server 2005 for the first time we take a look at what folders are installed. What does MSSQL.1 mean? What is MSSQL.2? How does SQL Server choose what goes in which folders? Learn about it here.
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 folder, sql server install, program files, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 8:00 PM    

Microsoft SQL Server Video Tutorial: An Overview of the Database Files - Data Files (MDF), the Transaction Log (LDF) and Additional Data Files (NDF)

An Overview of the Database Files - Data Files (MDF), the Transaction Log (LDF) and Additional Data Files (NDF) - view details
All SQL Server developers and administrators should have an excellent understanding of the file architecture for SQL databases. This video helps you learn about the different file types, their usage in SQL Server, and when and where to use the .NDF files (additional data files)
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 filetype, sql server file types, sql database files, sql server database files

posted by Scott Whigham @ 8:00 PM    

Transact SQL Video Tutorial: Pages, Extents, and Blocksizes - What They Are and How They Work

Pages, Extents, and Blocksizes - What They Are and How They Work - view details
If knowing the architecture of SQL Server is interesting to you, then you'll enjoy this video from Scott Whigham on how things like pages and indexes work in SQL Server. This is more of a theoretical discussion that discusses the sysinternals of SQL Server at a high level. The goal is to give you an understanding of how SQL Server stores data and indexes and how your index and table design decisions can influence SQL Server in multiple ways
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 architecture, sql design, sql internal design, index pages, extents

posted by Scott Whigham @ 8:00 PM    

Transact SQL Video Tutorial: Variables and Scoping - Local Variables and Batch Terminators

Variables and Scoping - Local Variables and Batch Terminators - view details
Variables and Scoping - Local Variables and Batch Terminators
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: Variables and Scoping - Local Variables and Batch Terminators

posted by Scott Whigham @ 7:00 PM    

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 PM    

Microsoft SQL Server Video Tutorial: Pt. 4 - Updateable Views in SQL Server (How to Update the Database Through a View)

Pt. 4 - Updateable Views in SQL Server (How to Update the Database Through a View) - view details
Pt. 4 - Updateable Views in SQL Server (How to Update the Database Through a View)
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: update sql view, updateable view, views as security mechanism, view security

posted by Scott Whigham @ 7:00 PM    

Exchange 2003 Video Tutorial: Creating an Offline Backup of a Database

Creating an Offline Backup of a Database - view details
Normally we want to take an online backup - a backup while users are still sending/receiving emails - but, for administrative purposes, you might need to take an offline backup from time to time. In this video you'll learn how to dismount your data store, take an offline backup, and use it for disaster recovery
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 offline backup

posted by Scott Whigham @ 6:00 PM    

Free SQL Server 2005 Video Tutorial: Part 1 - An Overview of the Default SQL Server Installation

Part 1 - An Overview of the Default SQL Server Installation - download
SQL trainer Scott Whigham walks you through the default installation of SQL Server 2005 in this video, part 1 in a series on installing SQL Server 2005. In this video you'll learn about the instances, folders, services, and options chosen during the default install.
To downlo ad 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 2005 overview, sql server change, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 6:00 PM    

Microsoft SQL Server Video Tutorial: Pt. 3 - Introduction to SSIS Package Deployment

Pt. 3 - Introduction to SSIS Package Deployment - view details
How do you get an SSIS package "into" SQL Server 2005? Give up? It is quite confusing and one of the more common questions people have as they start looking at SSIS for the first time. If you want to schedule an SSIS package, there are several options but perhaps the easiest and most manageable technique is to (1) store the SSIS package in MSDB, and (2) schedule a job to execute the package. This video walks you through creating a "Deployment Utility" which is really just a euphemism for an XML file with a .SSISDeploymentManifest extension. If you double-click on the .SSISDeploymentManifest file, it launches the Package Installation Wizard that allows you to easily deploy an entire project's worth of SSIS packages. This is not the only technique but definitely the easiest way to deploy a series of related SSIS 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 mu st have the TSCC codec installed to view this video

Keywords Associated with this video: SSISDeploymentManifest, deploy ssis package, build SSIS package, schedule ssis package, ssis package job step, deploy .dtsx

posted by Scott Whigham @ 6:00 PM    

SQL Server 2005 Video Tutorial: Part 3 - Choosing Your Service Accounts and a Tour of SQL Server 2005's Services

Part 3 - Choosing Your Service Accounts and a Tour of SQL Server 2005's Services - view details
SQL Server 2005 introduces a few new services and a few new choices. This video talks about the services in SQL Server 2005 including the MSSQLServer, SqlServerAgent, SqlBrowser, 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 service accounts, mssql, mssqlserver, mssql$, sql agent, full-text, sql browser

posted by Scott Whigham @ 5:00 PM    

SQL Server 2005 Video Tutorial: Part 4 - Choosing the Right SQL Server Authentication Mode

Part 4 - Choosing the Right SQL Server Authentication Mode - view details
Our fourth video in this series on installing SQL Server 2005, this video focuses on SQL Server 2005 security with a discussion of the Authentication modes. Included in this video are discussions on SQL Server Best Practices for Security, the differences between Windows Authentication Mode and Mixed Mode (which allows SQL Server login authentication) 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: windows authentication mode, mixed mode, windows login, sql login

posted by Scott Whigham @ 5:00 PM    

Microsoft SQL Server Video Tutorial: Backup Devices, Backup Sets, Database Dumps and Media Sets

Backup Devices, Backup Sets, Database Dumps and Media Sets - view details
This video is designed to help you speak the language of SQL Server (so that you at least sound like you know what you're talking about!). This video is really intended for those somewhat new to taking backups in SQL Server 2000. It covers basic topics like the terms used when discussing backups, old terms, uncommon terms that you might hear or see used for backups, and the use of the "Backup Device" in SQL Server. You'll also learn about the concepts of backup sets and media sets and how SQL Server uses each.

This video was recorded using SQL Server 2000 but the concepts and even the screens are almost identical in SQL Server 2005.
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 backup device, sql media set, sql server backup set

posted by Scott Whigham @ 5:00 PM    

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

ODBC, DSNs, and UDLs - Creating Reusable Connection Information - view details
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, 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 odbc, sql odbc driver, sql driver

posted by Scott Whigham @ 4:00 PM    

Microsoft SQL Server Video Tutorial: Pt. 1 - Introduction to Stored Procedure Concepts and Common Usage

Pt. 1 - Introduction to Stored Procedure Concepts and Common Usage - view details
Stored procedures are the way of the modern programmer and this first video in this series helps you understand the need for and the use of stored procedures in modern applications. You'll learn the basic syntax elements, where to use stored procs, who uses them, and see some rather intricate examples of usage.
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: stored procedure tutorial, stored proc help, stored proc script

posted by Scott Whigham @ 4:00 PM    

SQL Server 2000 Video Tutorial: Pt. 3 - Publications and Subscriptions

Pt. 3 - Publications and Subscriptions - view details
This video, our final overview video on SQL replication, finishes out our discussion with a lecture on publications and subscriptions.

Highlights from this video:
  • What objects (tables, views, stored procedures, etc) can I replicate?
  • Do I have to replicate the whole database or can I just replicate part of the database?
  • Can I replicate only certain columns of a table or do I have to replicate the entire table?
  • What types of subscriptions are available and what are the differences?
  • How to work with mobile and/or frequently disconnected systems
  • How synchronization schedules control replication and dictate "latency"
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: replication architecture, merge, transactional, snapshot, dr, beginning, beginner, intro, introduction, publication, article, pu

posted by Scott Whigham @ 4:00 PM    

Microsoft SQL Server Video Tutorial: Part 1 - An Overview of the Default SQL Server Installation

Part 1 - An Overview of the Default SQL Server Installation - view details
SQL trainer Scott Whigham walks you through the default installation of SQL Server 2005 in this video, part 1 in a series on installing SQL Server 2005. In this video you'll learn about the instances, folders, services, and options chosen during the default install.
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 2005 overview, sql server change, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 3:00 PM    

SQL Server 2000 Video Tutorial: Pt. 1 - An Introduction to the Concepts and Terms of SQL Server Replication

Pt. 1 - An Introduction to the Concepts and Terms of SQL Server Replication - view details
As replication becomes easier to implement and the world becomes more "wired", replication becomes increasingly the de facto standard for synchronizing data between different databases. This video, part 1 in our "Introduction to SQL Server Replication" series, gives you the big picture of why we use replication as well as describing several key terms and definitions. This video is more of a lecture-style video instead of a demo video but do not miss it! It will help you grasp the full scope of how SQL Server can use replication to do everything from synchronizing small "slices" of data from a source to a destination (more accurately termed the publisher a nd subscriber) and how you can even do disaster recovery with SQL Server replication.

Highlights from this video:
  • Answers the question, "What is Replication?"
  • Definitions, terms, terminology, architecture and topology of replication
  • Understanding Distributors, Publishers, and Subscribers
  • Publications, Articles, Tables, Stored Procedures and Views
  • Common Uses of/for replication
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: replication architecture, merge, transactional, snapshot, dr, beginning, beginner, intro, introduction

posted by Scott Whigham @ 3:00 PM    

Windows 2003 Video Tutorial: How to Configure Windows 2003 to Switch From Using Windows Update To Microsoft Update

How to Configure Windows 2003 to Switch From Using Windows Update To Microsoft Update - view details
How to Configure Windows 2003 to Switch From Using Windows Update To Microsoft Update
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 Configure Windows 2003 to Switch From Using Windows Update To Microsoft Update

posted by Scott Whigham @ 3:00 PM    

SQL Server 2000 Video Tutorial: Part 2 - Installing Service Pack 4

Part 2 - Installing Service Pack 4 - view details
Part 2 in our series on installing Service Pack
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 sql server install

posted by Scott Whigham @ 2:00 PM    

Windows 2003 Video Tutorial: Using SyncToy to Synchronize Directories/Machines

Using SyncToy to Synchronize Directories/Machines - view details
SyncToy is a new tool from Microsoft that helps you copy, move, rename, and delete files between folders and computers quickly and easily. This is a free PowerToy from MSFT that gives you the chance to copy, move, and synchronize multiple sets of directories at the same time and it can even combine files from two folders. It can also rename and delete in one folder based on the rename and delete actions in another folder. SyncToy keeps track of renames to files and will make sure those changes get carried over to the target folder. Synchronize your laptop to your local hard drive with SyncToy.

Highlights from this video:
  • Managing multiple file types with SyncToy
  • Keeping local directories in sync
  • Keeping remote directories in sync
  • Synchronizing USB drives
and much more

Link to download SyncToy here
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: synctoy, synchronization, copy file, merge, powertoy, power toy

posted by Scott Whigham @ 2:00 PM    

Microsoft SQL Server 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 @ 2:00 PM    

Windows 2003 Video Tutorial: How to Map Network Drives

How to Map Network Drives - view details
Grant Moyle shows you how to map network drives and discusses the pros and cons of doing so in this excellent video. Required viewing for any new junior sysadmin!
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: mapped drives Windows, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 1:00 PM    

Microsoft SQL Server Video Tutorial: Pt. 3 - Performance Tuning Profiler and Traces By Adding Filters and Working with Large Traces

Pt. 3 - Performance Tuning Profiler and Traces By Adding Filters and Working with Large Traces - view details
The filters you choose (or don't choose) can definitely give you improved throughput for your traces. This video walks you through how to set up the filters and designing traces for performance. At the end of this video, a great demo of how organize your traces for easier readability and troubleshooting.

Highlights from this video:
  • What filters should I use when I want to filter for long running/slow queries?
  • What are Reads and Duration and why are they important?
  • How can I only trace my application (not SQL Server Agent, for example)
  • Tracing for performance tuning
  • What Event Classes use what Filters
  • Suggestions for using filters to create more manageable traces
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 TS CC 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, grouping, filtering, limit

posted by Scott Whigham @ 1:00 PM    

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

MSDB Database - An Overview of Some of the Common System Tables and Objects - view details
The MSDB database is one of the heaviest-used system databases. It stores everything from DTS packages to Jobs (and the history of each). This video walks you through the common tables (what are those RTBl_% tables anyway?), the common stored procedures and gives you an excellent insight into how SQL Server 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: sql system db, msdb

posted by Scott Whigham @ 1:00 PM    

Exchange 2003 Video Tutorial: 5.5 Migration - Preparing a Server for running Exchange 2003

5.5 Migration - Preparing a Server for running Exchange 2003 - view details
This video shows you best practices for preparing your server to run Exchange 2003
To download this video, log in, then v isit 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 server prep

posted by Scott Whigham @ 12:00 PM    

SQL Server 2000 Video Tutorial: Pt. 2 - Using Views in the Real World

Pt. 2 - Using Views in the Real World - view details
Pt. 2 - Using Views in the Real World
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 view, stored query, stored queries, views, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 12:00 PM    

Microsoft SQL Server 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 doing yo ur 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 @ 12:00 PM    

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

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 @ 11: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 Associat