Friday, February 29, 2008

New SQL Server 2005 Video Tutorial: Part 2: How to Install SQL Server 2005 on Windows Server 2008 (for Windows admins)

Part 2: How to Install SQL Server 2005 on Windows Server 2008 (for Windows admins) - view details
This second and final video in the series will pick up where the first video left off by finishing the install of SQL Server 2005 on a Windows 2008 server.

Highlights from this video:
  • Brief overview of Collation settings
  • What do I need to do after the base installation is complete?
    • Service Packs
    • Hot fixes
    • Reporting Services
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 2005 install, install sql windows 2008, windows 2008, sql server install,

posted by Scott Whigham @ 2:26 PM  

New SQL Server 2005 Video Tutorial: Part 1: How to Install SQL Server 2005 on Windows Server 2008 (for Windows admins)

Part 1: How to Install SQL Server 2005 on Windows Server 2008 (for Windows admins) - view details
In this first video in the two-part series, Scott will give you an in-depth walkthrough and introduction to installing SQL Server on Windows Server 2008, as well give talk about the basics of the install on the your OS and what the screens/steps actually mean.

Highlights from this video:
  • Installing prerequisites server components
  • IIS Feature requirement
  • What components do I really need to install?
  • Brief overview of determining Service Accounts
  • Windows Authentication mode vs. Mixed Mode
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 2005 install, install sql windows 2008, windows 2008, sql server install,

posted by Scott Whigham @ 2:26 PM  

New Reporting Services Video Tutorial: How to Configure Windows 2008 and IIS7 for SQL Reporting Services

How to Configure Windows 2008 and IIS7 for SQL Reporting Services - view details
If you are an administrator who is thinking about installing SSRS on your Windows 2008 server, you will first want to configure IIS.�� In this video tutorial Scott Whigham will walk you through the process of configuring IIS7 to install Reporting Services on Windows 2008.You will be defining features of your Web Server Role Services, a very crucial component that will need to be done correctly in order to complete your install.

Highlights from this video:
  • Required role services
    • Security
    • Web Management Tools
    • Common HTTP Features
    • Application Development
  • Verifying/Adding/Removing Features
  • Working with Server Manager
  • Installing Prerequisites for SQL and System Comfiguration Check7
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: iis7, reporting services, role service, server manager, install iis, iis,, introduction, step by step, beginner, beginning, for

posted by Scott Whigham @ 2:16 PM  

New Reporting Services Video Tutorial: Part 1 - How to Create a Drilldown/Drillthrough Report

Part 1 - How to Create a Drilldown/Drillthrough Report - view details
In this first video tutorial in the series, Scott Whighman will show you how to create drilldown / drillthrough reports, which help to organize report data, first by using the Project Wizard, then interactively creating a drilldown report without the Wizard.

Highlights from this video:
  • Working with the Wizard
    • What will my drilldown report be grouped by?
    • Category and group syntax tips
    • Customizing the table design and appearance
  • Working without the Wizard
    • Common query style
    • What types of queries are the best ones for drilldown reports?
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: drilldown, drillthrough, drill down, drill through,

posted by Scott Whigham @ 2:15 PM  

New Reporting Services Video Tutorial: Part 2 - Creating a Drillthrough Report Without Using the Wizard

Part 2 - Creating a Drillthrough Report Without Using the Wizard - view details
This second and final video in the series will pick up right where the first video left off by concluding the demonstration of how to create a drillthrough/drilldown report without using the wizard.

Highlights from this video:
  • Making a new DataSet
  • Adding a table for your drilldown report
  • Customizing the appearance and colors of your table
  • Inserting a group for drillthrough
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: drilldown, drillthrough, drill down, drill through,

posted by Scott Whigham @ 2:15 PM  

New Reporting Services Video Tutorial: Part 5 - Using the Remote Processing Mode and Understanding ServerReport and LocalReport

Part 5 - Using the Remote Processing Mode and Understanding ServerReport and LocalReport - view details
In this fifth and final video in the series, Scott will wrap up the discussion of the ReportViewer control by discussing server reports when using the remote processing mode.

Highlights from this video:
  • Driving your ReportViewer: processing modes
  • Browsing your avaliable reports in SSRS
  • Coding your reports back to ASP.NET
  • Working with ReportPaths and Server Reports: specifying paths
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: remote processing mode, reportviewer, report viewer, server report, local report, serverreport,

posted by Scott Whigham @ 2:09 PM  

New Reporting Services Video Tutorial: Part 4 - Manipulating The ReportViewer Properties

Part 4 - Manipulating The ReportViewer Properties - view details
In this fourth video in the series, your instructor Scott will continue to cover how you can manipulate the properties with the ReportViewer control.

Highlights from this video:
  • Setting a display name
  • Successfully exposing a data table
  • Managing the report path and the .rdlc files
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: reportviewer, report viewer, report properties

posted by Scott Whigham @ 2:09 PM  

New Reporting Services Video Tutorial: Part 3 - Details On Using the ReportViewer's Properties, ReportDataSources and More

Part 3 - Details On Using the ReportViewer's Properties, ReportDataSources and More - view details
Continued in this third video in the series is more about the programmatic access of the ReportViewer, as well as about the properties that the ReportViewer control exposes.

Highlights from this video:
  • The importance of registering the assembly of the ReportViewer
    • ReportDataSource
    • Classes
    • Referencing correctly
  • Local reports vs. Server Reports
  • Defining data sources and data sets within your report
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: reportdatasource, reportviewer, report viewer, report, data source,

posted by Scott Whigham @ 2:09 PM  

New Reporting Services Video Tutorial: Part 2 - Creating a Drillthrough Report and Binding It to the ReportViewer

Part 2 - Creating a Drillthrough Report and Binding It to the ReportViewer - view details
In this second video in the series, Scott will show you how you can add dimension and appeal to your report via creation of a drillthrough and customization of�� your report's appearance.

Highlights from this video:
  • Customizing appearance and colors
  • Changing Group visibility for basic drillthrough
  • Using COUNT and SUM expressions for populating the report
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: drill through, drillthrough, report, customize report, report appearance,

posted by Scott Whigham @ 2:09 PM  

New Reporting Services Video Tutorial: Part 1 - An Overview of How to Use Reporting Services Within ASP.NET

Part 1 - An Overview of How to Use Reporting Services Within ASP.NET - view details
If you are using C#, Visual Basic and want to design reports using SSRS for an ASP.NET 2.0 or higher page, then this video is just what you need! In this first video in the five part series your instructor Scott will give you a high level overview of the report viewer control, as well as begin to discuss the functionality of some features in designing a report.

Highlights from this video:
  • About the ReportViewer Control
  • Designing a new report and .rdlc files
  • Adding a new data source and working with the TableAdapter Configuration Wizard
  • Creating a drilldown report without the wizard
  • Working with Report Items
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: report viewer, reportviewer, asp.net, report, design,

posted by Scott Whigham @ 2:08 PM  

Thursday, February 28, 2008

New Exchange Server Video Tutorial: How to Configure Outlook Anywhere and Use Outlook 2007 to Connect

How to Configure Outlook Anywhere and Use Outlook 2007 to Connect - view details
In this video, your instructor will walk you throught the steps in Outlook 2007, Exchange 2007, and Windows 2003 to sucessfully enable, test, and use Outlook Anywhere (formerly known as RPC over HTTP). Beginning with the Outlook 2007 Profile Settings, the instructor configures the client to utilize Outlook Anywhere. However, after some troubleshooting, it is determined that something isn't right on the Exchange Server.Once the server is enabled for Outlook Anywhere (very easy) and some troubleshooting, the instructor determines that something is still missing, this time in Windows. After adding the RPC over HTTP proxy service to Windows, and a reboot - Outlook Anywhere magically starts working!

Highlights from this video:
  • Certficate authorites
  • Verifying the connection used by Outlook
  • Enabling Outlook Anywhere
  • What specific Windows components do I need to install?
  • RPC over HTTP Proxy
and much more

This is a must-see video for the configuration and also the troubleshooting techniques employed by your Expert instructor.
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 Anywhere, rpc/http, outlook 2007 connect

posted by Scott Whigham @ 4:35 AM  

New Exchange Server Video Tutorial: How to Configure Internal Access to Exchange after Installing a Commerical SSL Certificate

How to Configure Internal Access to Exchange after Installing a Commerical SSL Certificate - view details
Did you buy a commerical SSL Certificate for your Exchange Server? Did your Outlook 2007 users start getting a Certificiate error every time they open Outlook? If so then this video is just what the doctor ordered! In this video - your instructor will walk you through making the changes in the Exchange Management Console, Exchange Management Shell and DNS to allow your internal clients (including Outlook 2007) to correctly recongize the commerical SSL Certificate. This is a must-see video before configuring Outlook-Anywhere or Exchange ActiveSync.

Highlights from this video:
  • What do these annoying Security Alerts really mean?
  • Various solutions for replacing certificates
    • Which one is the best for me?
  • Modifying internal/external URLs in Client Access
  • Enabling Exchange Certificate Services for IIS,POP3,SMTP, etc
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: ssl certificate, internal access, configure, exchange, certificate,

posted by Scott Whigham @ 4:35 AM  

New Windows 2003 Video Tutorial: Part 10 - Request SSL Certificate and Configure WSUS to Use SSL

Part 10 - Request SSL Certificate and Configure WSUS to Use SSL - view details
If you are reviewing the options for WSUS, you will come across some items that you can take care of with your WSUS. One of the things you really want to do with your WSUS server is to utilize SSL if your clients are connecting to your WSUS server from off your network or if they are connecting to your WSUS server and they are standalone servers. In this final video grant will discuss how you can go about requesting an SSL certificate for WSUS server and then configuring WSUS to use your SSL certificate.

Highlights from this video:
  • Viewing WSUS Administration Properties
  • Making a request for an SSL certificate via Web Server Certificate Wizard
  • Working with a certificate authority
  • Issuing a certificate and configuring your clients
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: wsus, windows server update services 3.0, wsus 3.0, windows server update service, configure wsus ssl, ssl, ssl certificate,

posted by Scott Whigham @ 4:35 AM  

Wednesday, February 27, 2008

New Exchange Server Video Tutorial: Configure an Outlook Client to Use Outlook Anywhere from a Distant Network

Configure an Outlook Client to Use Outlook Anywhere from a Distant Network - view details
Exchange Administrators know how to get Outlook to connect to Exchange using a MAPI-based profile. But - what if the computer you are trying to connect to is off the network, and thus your only option is Outlook Anywhere/RPC over HTTP? In this video, your instructor will show you how the initial profile creation and syncronization can indeed be created across the Internet using an Outlook Anywhere/RPC over HTTP connection. Trust me - this is one you won't want to miss if you support users on the road or users who work from home.

Highlights from this video:
  • LAN manager authentication levels
  • Adding new Exchange profiles
  • Exchange Proxy settings
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: Outlook Anywhere, rpc/http, outlook 2007, connect, distant network, rpc, rpc over http, network,

posted by Scott Whigham @ 1:14 PM  

New Exchange Server Video Tutorial: How to Configure Internal Access to Exchange after Installing a Commerical SSL Certificate

How to Configure Internal Access to Exchange after Installing a Commerical SSL Certificate - view details
Did you buy a commerical SSL Certificate for your Exchange Server? Did your Outlook 2007 users start getting a Certificiate error every time they open Outlook? If so then this video is just what the doctor ordered! In this video - your instructor will walk you through making the changes in the Exchange Management Console, Exchange Management Shell and DNS to allow your internal clients (including Outlook 2007) to correctly recongize the commerical SSL Certificate. This is a must-see video before configuring Outlook-Anywhere or Exchange ActiveSync.

Highlights from this video:
  • What do these annoying Security Alerts really mean?
  • Various solutions for replacing certificates
    • Which one is the best for me?
  • Modifying internal/external URLs in Client Access
  • Enabling Exchange Certificate Services for IIS,POP3,SMTP, etc
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: ssl certificate, internal access, configure, exchange, certificate,

posted by Scott Whigham @ 1:13 PM  

New Exchange Server Video Tutorial: How to Configure Outlook Anywhere and Use Outlook 2007 to Connect

How to Configure Outlook Anywhere and Use Outlook 2007 to Connect - view details
In this video, your instructor will walk you throught the steps in Outlook 2007, Exchange 2007, and Windows 2003 to sucessfully enable, test, and use Outlook Anywhere (formerly known as RPC over HTTP). Beginning with the Outlook 2007 Profile Settings, the instructor configures the client to utilize Outlook Anywhere. However, after some troubleshooting, it is determined that something isn't right on the Exchange Server.Once the server is enabled for Outlook Anywhere (very easy) and some troubleshooting, the instructor determines that something is still missing, this time in Windows. After adding the RPC over HTTP proxy service to Windows, and a reboot - Outlook Anywhere magically starts working!

Highlights from this video:
  • Certficate authorites
  • Verifying the connection used by Outlook
  • Enabling Outlook Anywhere
  • What specific Windows components do I need to install?
  • RPC over HTTP Proxy
and much more

This is a must-see video for the configuration and also the troubleshooting techniques employed by your Expert instructor.
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 Anywhere, rpc/http, outlook 2007 connect

posted by Scott Whigham @ 1:12 PM  

Thursday, February 21, 2008

New Windows 2003 Video Tutorial: Part 9 - Configure Automatic Approvals

Part 9 - Configure Automatic Approvals - view details
One of the new features in WSUS 3.0 is the ability to determine specifc updates that will be automatically approved, saving you lots of time and trouble. In this 9th video in the series, Grant will quickly show you how you can configure those updates.

Highlights from this video:
  • Default automatic approval rule
  • Adding a new custom rule for a specific product
  • Added flexibility of new rules
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: wsus, windows server update services 3.0, wsus 3.0, windows server update service, configure automatic approval,

posted by Scott Whigham @ 7:35 AM  

New Windows 2003 Video Tutorial: Part 8 - Configure Email Notifications About WSUS Status

Part 8 - Configure Email Notifications About WSUS Status - view details
As you operate your WSUS sererver , you may want it to provide you with regular email notifications about the status of your server and also when new updates are downloaded. In this eighth video in the series, Grant will demonstrate the process of how to configure your WSUS server's email notifications.

Highlights from this video:
  • Deciding when your server will send email notifications
  • Testing Email notifications
  • Viewing/interpreting the staus report in your email
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: wsus, windows server update services 3.0, wsus 3.0, windows server update service, configure email, notifications

posted by Scott Whigham @ 7:35 AM  

New Windows 2003 Video Tutorial: Part 4 - Approving Updates and Allowing Updates to Download

Part 4 - Approving Updates and Allowing Updates to Download - view details
Once you are familiar with the basic infrastructure of your Windows Server Update Services 3.0�� server, it will be neccesary for you to then begin to approve your updates and allow them to begin to download and deployment. In this fourth video in the series, your instructor Grant will show you how to do just that!

Highlights from this video:
  • Viewing all unapproved updates
  • Approving multiple updates simultaneously
  • Filtering/ Deploying other updates
  • Viewing Download Status of updates
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: wsus, windows server update services 3.0, wsus 3.0, windows server update service, wsus updates, approve updates

posted by Scott Whigham @ 4:35 AM  

New Windows 2003 Video Tutorial: Part 6 - Use Group Policy to Configure WSUS on Workstations and Servers

Part 6 - Use Group Policy to Configure WSUS on Workstations and Servers - view details
When your WSUS 3.0 server is completely installed and all of your updates have been approved, you then will need to get your other computers to check-in to get upadtes and provide their status. In the previous video Grant showed you how to do this for standalone systems, but how do you deploy this for any computer on the domain? In this video grant will walk you through the policy of doing just that!

Highlights from this video:
  • Using Group Policy Management Console
  • Modifying default domain controllers policy and default domain policy
  • Applying WSUS policy to workstations
  • Adding Computer Groups to Update Services
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: wsus, windows server update services 3.0, wsus 3.0, windows server update service, configure wsus workstations, configure wsus s

posted by Scott Whigham @ 4:35 AM  

New Windows 2003 Video Tutorial: Part 1 - Windows Server Update Services 3.0 Installation

Part 1 - Windows Server Update Services 3.0 Installation - view details
WSUS, or Windows Server Update Services, is an essential component you can download from Microsoft to run on one of the servers on your network. The idea behind WSUS is that WSUS will go to the Windows web site and download the updates for your various Microsoft products you run on your newtwork and deploy those updates when ready. In this first video in this 10-part series, Grant Moyle will walk you through the beginning of the installation of WSUS 3.0 and help you set it up!

Highlights from this video:
  • System requirements for WSUS 3.0 installation
  • Installing other required components, IIS and .NET Framework
  • From where can I download the WSUS setup?
  • Kicking off the Full WSUS 3.0 Service installation
  • Working through the WSUS 3.0 Setup Wizard
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: wsus, windows server update services 3.0, wsus 3.0, windows server update service, install wsus

posted by Scott Whigham @ 4:35 AM  

New Windows 2003 Video Tutorial: Part 3 - WSUS 3.0 Infrastructure Overview

Part 3 - WSUS 3.0 Infrastructure Overview - view details
After completion of the configuration wizard, you will need to familiarize yourself with the heirarchy of the WSUS infrastructure. In this third video in the series, Grant Moyle will give you an essential overview of your newly configured Windows Server Update Services server.

Highlights from this video:
  • About the Update Services snap-in
  • Viewing the status of your server
  • Obtaining a summary of the updates you have
    • WSUS updates
    • Critical updates
    • All updates
    • Security updates
  • Available reports from WSUS
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: wsus, windows server update services 3.0, wsus 3.0, windows server update service, infrastructure windows update service

posted by Scott Whigham @ 4:35 AM  

New Transact SQL Video Tutorial: What Is Modulo? When Would I Use It?

What Is Modulo? When Would I Use It? - view details
The modulo operator in tsql is a very handy tool when working with leap years, alternating items, etc. In this video tutorial Scott will introduce you to the Modulo operator and show you when, where, and how to use it!

Highlights from this video:
  • What does the Modulo operator do?
  • When does Modulo = 0?
  • Interpreting the Modulo
  • Using the Modulo to return alternating rows

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: modulo operator, modulo,

posted by Scott Whigham @ 4:35 AM  

New Windows 2003 Video Tutorial: Part 7 - Approve New Product and Classification for Deployment

Part 7 - Approve New Product and Classification for Deployment - view details
Periodically you will want to review what products and what classifications you are actually updating. In this seventh video in the ten-part series, Grant will show you how you can approve new products and classifications for deployment���� ������ ������ ��

Highlights from this video:
  • Viewing new products and classifications recently added
  • Adding new classifications and products
  • Forcing a synchronization for updates
  • Approving updates for specific machines
  • Deploying your updates
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: wsus, windows server update services 3.0, wsus 3.0, windows server update service, wsus deploy, wsus product, wsus classificatio

posted by Scott Whigham @ 4:35 AM  

New Windows 2003 Video Tutorial: Event Log Management and Archiving Event Logs

Event Log Management and Archiving Event Logs - view details
One of the things an administrator must do on a regular basis is review event logs on the servers. In addition to that,�� an admin also archives those logs so you will have a continuous log for whatever happens on that server. In this video Grant Moyle will show you a simple way to manage your event logs via some helpful VB scripts.

Highlights from this video:
  • 7 different log files in Event Viewer
  • Why do I want to keep my old logs?
  • Included Scripts:
    • ��SimpleEventLogClear.vbs
    • EventLogClear.vbs
  • Testing your scripts
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: event log management, archive event logs, event log,

posted by Scott Whigham @ 4:35 AM  

New Windows 2003 Video Tutorial: Part 5 - Configuring Individual Servers and Workstations to Obtain Updates from WSUS 3.0

Part 5 - Configuring Individual Servers and Workstations to Obtain Updates from WSUS 3.0 - view details
Once your WSUS server has been fully synchronized you will then be able to configure it's local policy so it can perform updates for itself. In this fifth video, Grant Moyle will walk you through the process of modifying your group policies and also how to register and set-up other client machines to update from the WSUS server.

Highlgihts from this video:
  • What group policies do I want to edit?
  • Viewing computer reports on your WSUS server
  • Configuring other machines to your WSUS server
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: wsus, windows server update services 3.0, wsus 3.0, windows server update service, wsus updates, configure wsus, 3.0

posted by Scott Whigham @ 4:35 AM  

New Windows 2003 Video Tutorial: Part 2 - WSUS 3.0 Configuration Wizard

Part 2 - WSUS 3.0 Configuration Wizard - view details
Once the prepwork and installation of Windows Server Update Services 3.0 have finished, it will now be time for you to set up your server based on how your configurations are needed. In this second video in the series Grant Moyle will walk you through the WSUS 3.0 Configuration Wizard and explain each individual step in completing the Configuration Wizard.

Highlights from this video:
  • WSUS server and other client machines
  • About the Microsoft Update Improvement Program
  • From where do I want to obtain my udates for my server?
  • Specifying your Proxy server
  • Choosing which products will receive updates from the WSUS server
  • Classifications of updates
  • Setting your Sync scehdule
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: wsus, windows server update services 3.0, wsus 3.0, windows server update service, configure wsus

posted by Scott Whigham @ 4:35 AM  

Wednesday, February 20, 2008

New Windows 2003 Video Tutorial: Part 2 - WSUS 3.0 Configuration Wizard

Part 2 - WSUS 3.0 Configuration Wizard - view details
Once the prepwork and installation of Windows Server Update Services 3.0 have finished, it will now be time for you to set up your server based on how your configurations are needed. In this second video in the series Grant Moyle will walk you through the WSUS 3.0 Configuration Wizard and explain each individual step in completing the Configuration Wizard.

Highlights from this video:
  • WSUS server and other client machines
  • About the Microsoft Update Improvement Program
  • From where do I want to obtain my udates for my server?
  • Specifying your Proxy server
  • Choosing which products will receive updates from the WSUS server
  • Classifications of updates
  • Setting your Sync scehdule
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: wsus, windows server update services 3.0, wsus 3.0, windows server update service, configure wsus

posted by Scott Whigham @ 2:48 PM  

New Windows 2003 Video Tutorial: Part 3 - WSUS 3.0 Infrastructure Overview

Part 3 - WSUS 3.0 Infrastructure Overview - view details
After completion of the configuration wizard, you will need to familiarize yourself with the heirarchy of the WSUS infrastructure. In this third video in the series, Grant Moyle will give you an essential overview of your newly configured Windows Server Update Services server.

Highlights from this video:
  • About the Update Services snap-in
  • Viewing the status of your server
  • Obtaining a summary of the updates you have
    • WSUS updates
    • Critical updates
    • All updates
    • Security updates
  • Available reports from WSUS
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: wsus, windows server update services 3.0, wsus 3.0, windows server update service, infrastructure windows update service

posted by Scott Whigham @ 2:48 PM  

New Windows 2003 Video Tutorial: Part 4 - Approving Updates and Allowing Updates to Download

Part 4 - Approving Updates and Allowing Updates to Download - view details
Once you are familiar with the basic infrastructure of your Windows Server Update Services 3.0�� server, it will be neccesary for you to then begin to approve your updates and allow them to begin to download and deployment. In this fourth video in the series, your instructor Grant will show you how to do just that!

Highlights from this video:
  • Viewing all unapproved updates
  • Approving multiple updates simultaneously
  • Filtering/ Deploying other updates
  • Viewing Download Status of updates
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: wsus, windows server update services 3.0, wsus 3.0, windows server update service, wsus updates, approve updates

posted by Scott Whigham @ 2:48 PM  

New Windows 2003 Video Tutorial: Part 5 - Configuring Individual Servers and Workstations to Obtain Updates from WSUS 3.0

Part 5 - Configuring Individual Servers and Workstations to Obtain Updates from WSUS 3.0 - view details
Once your WSUS server has been fully synchronized you will then be able to configure it's local policy so it can perform updates for itself. In this fifth video, Grant Moyle will walk you through the process of modifying your group policies and also how to register and set-up other client machines to update from the WSUS server.

Highlgihts from this video:
  • What group policies do I want to edit?
  • Viewing computer reports on your WSUS server
  • Configuring other machines to your WSUS server
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: wsus, windows server update services 3.0, wsus 3.0, windows server update service, wsus updates, configure wsus, 3.0

posted by Scott Whigham @ 2:47 PM  

New Windows 2003 Video Tutorial: Part 6 - Use Group Policy to Configure WSUS on Workstations and Servers

Part 6 - Use Group Policy to Configure WSUS on Workstations and Servers - view details
When your WSUS 3.0 server is completely installed and all of your updates have been approved, you then will need to get your other computers to check-in to get upadtes and provide their status. In the previous video Grant showed you how to do this for standalone systems, but how do you deploy this for any computer on the domain? In this video grant will walk you through the policy of doing just that!

Highlights from this video:
  • Using Group Policy Management Console
  • Modifying default domain controllers policy and default domain policy
  • Applying WSUS policy to workstations
  • Adding Computer Groups to Update Services
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: wsus, windows server update services 3.0, wsus 3.0, windows server update service, configure wsus workstations, configure wsus s

posted by Scott Whigham @ 2:47 PM  

New Windows 2003 Video Tutorial: Part 7 - Approve New Product and Classification for Deployment

Part 7 - Approve New Product and Classification for Deployment - view details
Periodically you will want to review what products and what classifications you are actually updating. In this seventh video in the ten-part series, Grant will show you how you can approve new products and classifications for deployment���� ������ ������ ��

Highlights from this video:
  • Viewing new products and classifications recently added
  • Adding new classifications and products
  • Forcing a synchronization for updates
  • Approving updates for specific machines
  • Deploying your updates
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: wsus, windows server update services 3.0, wsus 3.0, windows server update service, wsus deploy, wsus product, wsus classificatio

posted by Scott Whigham @ 2:47 PM  

New Windows 2003 Video Tutorial: Part 7 - Approve New Product and Classification for Deployment

Part 7 - Approve New Product and Classification for Deployment - view details
Periodically you will want to review what products and what classifications you are actually updating. In this seventh video in the ten-part series, Grant will show you how you can approve new products and classifications for deployment���� ������ ������ ��

Highlights from this video:
  • Viewing new products and classifications recently added
  • Adding new classifications and products
  • Forcing a synchronization for updates
  • Approving updates for specific machines
  • Deploying your updates
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: wsus, windows server update services 3.0, wsus 3.0, windows server update service, wsus deploy, wsus product, wsus classificatio

posted by Scott Whigham @ 2:47 PM  

New Windows 2003 Video Tutorial: Part 8 - Configure Email Notifications About WSUS Status

Part 8 - Configure Email Notifications About WSUS Status - view details
As you operate your WSUS sererver , you may want it to provide you with regular email notifications about the status of your server and also when new updates are downloaded. In this eighth video in the series, Grant will demonstrate the process of how to configure your WSUS server's email notifications.

Highlights from this video:
  • Deciding when your server will send email notifications
  • Testing Email notifications
  • Viewing/interpreting the staus report in your email
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: wsus, windows server update services 3.0, wsus 3.0, windows server update service, configure email, notifications

posted by Scott Whigham @ 2:47 PM  

New Windows 2003 Video Tutorial: Part 9 - Configure Automatic Approvals

Part 9 - Configure Automatic Approvals - view details
One of the new features in WSUS 3.0 is the ability to determine specifc updates that will be automatically approved, saving you lots of time and trouble. In this 9th video in the series, Grant will quickly show you how you can configure those updates.

Highlights from this video:
  • Default automatic approval rule
  • Adding a new custom rule for a specific product
  • Added flexibility of new rules
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: wsus, windows server update services 3.0, wsus 3.0, windows server update service, configure automatic approval,

posted by Scott Whigham @ 2:46 PM  

New Windows 2003 Video Tutorial: Part 10 - Request SSL Certificate and Configure WSUS to Use SSL

Part 10 - Request SSL Certificate and Configure WSUS to Use SSL - view details
If you are reviewing the options for WSUS, you will come across some items that you can take care of with your WSUS. One of the things you really want to do with your WSUS server is to utilize SSL if your clients are connecting to your WSUS server from off your network or if they are connecting to your WSUS server and they are standalone servers. In this final video grant will discuss how you can go about requesting an SSL certificate for WSUS server and then configuring WSUS to use your SSL certificate.

Highlights from this video:
  • Viewing WSUS Administration Properties
  • Making a request for an SSL certificate via Web Server Certificate Wizard
  • Working with a certificate authority
  • Issuing a certificate and configuring your clients
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: wsus, windows server update services 3.0, wsus 3.0, windows server update service, configure wsus ssl, ssl, ssl certificate,

posted by Scott Whigham @ 2:46 PM  

Tuesday, February 19, 2008

New Transact SQL Video Tutorial: A Comparison of DISTINCT and GROUP BY: When to Use Each

A Comparison of DISTINCT and GROUP BY: When to Use Each - view details
In this video tutorial Scott Whigham will breakdown the differences and similarities between using the DISTINCT and GROUP BY clauses.

Highlights from this video:
  • Where do these clauses respectively operate?
  • What kind of relationships are drawn between base table and your result set?
  • Purpose of GROUP BY and DISTINCT and how SQL Server treats them
  • Comparing/Contrasting the two clauses
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: distinct, group by, clause,

posted by Scott Whigham @ 7:35 AM  

New Transact SQL Video Tutorial: How to Add In a Row Number Column That Numbers the Rows of Your Result Set

How to Add In a Row Number Column That Numbers the Rows of Your Result Set - view details
Ever find yourself in need of a way to number a result set, or to insert a seperate column that is numbered? By using the row number function, which is new to SQL 2005, your instructor will show you a very simple process for adding in a row number column that will number or count the rows in your result set.

Highlights from this video:
  • About working with the ROW NUMBER function
  • Step-by-step process of adding row number counts
  • Modifying how your results are ordered or ranked
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: row number column, row number, row count,

posted by Scott Whigham @ 7:35 AM  

New Transact SQL Video Tutorial: The Basics of the HAVING Clause

The Basics of the HAVING Clause - view details
In this essential video tutorial, Scott Whigham will explain to you what exactly the HAVING clause specifically, and define the HAVING clause, which isone of two filters you can use in your queries.

Highlights from this video:
  • What can the HAVING clause filter?
  • Working with the HAVING clause
  • Specific places to use HAVING clause
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: having clause, about having clause

posted by Scott Whigham @ 7:35 AM  

New SQL Server Integration Services Video Tutorial: How to Add a Progress Bar/Indicator to Your SSIS Packages

How to Add a Progress Bar/Indicator to Your SSIS Packages - view details
Do you ever want an indicator or an idea of how long your package execution will take? In this video tutorial Scott Whigham will introduce you to the simple method and code of adding a progress bar to your SSIS packages!
Highlights from this video:
  • About the Fire Progress Event and the Fire Information Event
  • Obtaining a _% complete reading based on provided parameters
  • Other advanced Firing events
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: packages, fire event, progress bar, progress indicator, package execution

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Troubleshooting SSIS: Identify and Repair Common Connection/Password Problems

Troubleshooting SSIS: Identify and Repair Common Connection/Password Problems - view details
Have you ever found that your SSIS package doesn't work due to a failed login validation, or it cannot acquire the connection? In this essential video tutorial Scott will demonstrate how to debug your password/connection problems even when password is "saved" by modifying your package-level security levels.

Highlights from this video:
  • About package-level security
  • Encrypting your password with user key
  • Sharing packages in multi-user environment
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: troubleshooting, failed login, password, connection, package security,

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Part 4 - Queries, Scripting, NOT EXISTS, and Final Thoughts

Part 4 - Queries, Scripting, NOT EXISTS, and Final Thoughts - view details
In this final video in the series, Scott will cover more about custom queries and scripts you can generate for importing Access data, as well as give you some of his final thoughts on Access, importing data, and SQL Server.
Highlights from this video:
  • Writing a custom query to store results in SQL Server tables
  • Scripting a table as a CREATE
  • Using IF NOT EXISTS
��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: access, microsoft access, import tables, import access, if not exists,

posted by Scott Whigham @ 4:35 AM  

New SQL Server Video Tutorial: Part 6 - SQL Server 2005 WMI Event Alerts: How to Write WQL for WMI

Part 6 - SQL Server 2005 WMI Event Alerts: How to Write WQL for WMI - view details
This final video in the series will cover the final type of alert, the WMI event, which is new for SQL Server 2005. You'll learn about the syntax for writing WQL queries and how you can understand the WMI namespaces.

Highlights from this video:
  • WMI Code Creator
  • Writing WQL to identify events in SQL Server
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: alerts, DBA, management, SQL Agent, WMI, Error Handling, Performance, WQL

posted by Scott Whigham @ 4:35 AM  

New Transact SQL Video Tutorial: SQL Server Internals - The Steps SQL Server Goes Through to Run a Command

SQL Server Internals - The Steps SQL Server Goes Through to Run a Command - view details
SQL Server goes through 4 steps to run all SQL commands. In this awesome video tutorial Scott will show you the background processes that SQLServer uses when running a query, as well as describe to you the individual results of each step.

Highlights from this video:
  • About Parse
  • What is Data binding?
  • About the Execution plan
  • How to execute the plan
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 internals, run command,

posted by Scott Whigham @ 4:35 AM  

New Transact SQL Video Tutorial: What Are Computed Columns (a.k.a. Derived Fields)? When Should I Use Them?

What Are Computed Columns (a.k.a. Derived Fields)? When Should I Use Them? - view details
Do you find yourself constantly copying and pasting a specially formatted column name or expression multiple times? In this video tutorial Scott Whigham will show you how you can re-use your code via a computed column.
Highlights from this video:
  • About data storage in a computed column
  • Can you modify a computed column?
  • When to use a computed column
  • Advantages of a derived field/computed column
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: computed column, derived field,

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Part 3 - Hand-Writing Your Own Access Import Data Flow Tasks

Part 3 - Hand-Writing Your Own Access Import Data Flow Tasks - view details
An alternative to using the Import/Export Wizard is to hand-write your own Access import data flow tasks, as the Wizard has some limitations to using it. In this third video in the series your instructor will walk you through the process of doing so and configuring your options.
Highlights from this video:
  • Making a new, appropriate connection for Access versions
  • Configuring your SQL Server destination
  • Package Validation Errors
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: import access, export access, microsoft access, access, import export wizard

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Part 2 - Limitations of the Import/Export Wizard

Part 2 - Limitations of the Import/Export Wizard - view details
In this second video in the series, you will continue working in the Import and Export Wizard. Scott will also diverge some of the pitfalls and limitations of the Import and Export Wizard for migrating data from Access to SQL Server.
Highlights from this video:
  • Creating a column primary key
  • Viewing tables in SQL Server
  • Import/Export Wizard downfalls
  • Intro to the alternative to Import/Export wizard
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: import access, export access, microsoft access, access,

posted by Scott Whigham @ 4:35 AM  

New SQL Server Integration Services Video Tutorial: Part 1 - How to Import Microsoft Access Tables to SQL Server Using SSIS

Part 1 - How to Import Microsoft Access Tables to SQL Server Using SSIS - view details
In this first video in the series, Scott will show you how to import your Microsoft Access data into a Sql Server via SSIS. There are two different ways to import Access data, depending on importing frequency, and in this video you will be setting up the import for converting data, like tables and queries, in a recurring basis.
Highlights from this video:
  • When not to use SSIS for importing Access tables
  • Working with the Import and Export Wizard
  • Connecting to your Access datasource
  • Choosing which tables and views/queries to import
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: access, microsoft acces, import tables, import access

posted by Scott Whigham @ 4:35 AM  

Monday, February 18, 2008

New Transact SQL Video Tutorial: What Is Modulo? When Would I Use It?

What Is Modulo? When Would I Use It? - view details
The modulo operator in tsql is a very handy tool when working with leap years, alternating items, etc. In this video tutorial Scott will introduce you to the Modulo operator and show you when, where, and how to use it!

Highlights from this video:
  • What does the Modulo operator do?
  • When does Modulo = 0?
  • Interpreting the Modulo
  • Using the Modulo to return alternating rows

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: modulo operator, modulo,

posted by Scott Whigham @ 2:35 PM  

New Transact SQL Video Tutorial: How to Add In a Row Number Column That Numbers the Rows of Your Result Set

How to Add In a Row Number Column That Numbers the Rows of Your Result Set - view details
Ever find yourself in need of a way to number a result set, or to insert a seperate column that is numbered? By using the row number function, which is new to SQL 2005, your instructor will show you a very simple process for adding in a row number column that will number or count the rows in your result set.

Highlights from this video:
  • About working with the ROW NUMBER function
  • Step-by-step process of adding row number counts
  • Modifying how your results are ordered or ranked
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: row number column, row number, row count,

posted by Scott Whigham @ 2:35 PM  

New Transact SQL Video Tutorial: SQL Server Internals - The Steps SQL Server Goes Through to Run a Command

SQL Server Internals - The Steps SQL Server Goes Through to Run a Command - view details
SQL Server goes through 4 steps to run all SQL commands. In this awesome video tutorial Scott will show you the background processes that SQLServer uses when running a query, as well as describe to you the individual results of each step.

Highlights from this video:
  • About Parse
  • What is Data binding?
  • About the Execution plan
  • How to execute the plan
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 internals, run command,

posted by Scott Whigham @ 2:34 PM  

New Transact SQL Video Tutorial: What Are Computed Columns (a.k.a. Derived Fields)? When Should I Use Them?

What Are Computed Columns (a.k.a. Derived Fields)? When Should I Use Them? - view details
Do you find yourself constantly copying and pasting a specially formatted column name or expression multiple times? In this video tutorial Scott Whigham will show you how you can re-use your code via a computed column.
Highlights from this video:
  • About data storage in a computed column
  • Can you modify a computed column?
  • When to use a computed column
  • Advantages of a derived field/computed column
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: computed column, derived field,

posted by Scott Whigham @ 2:34 PM  

New Transact SQL Video Tutorial: The Basics of the HAVING Clause

The Basics of the HAVING Clause - view details
In this essential video tutorial, Scott Whigham will explain to you what exactly the HAVING clause specifically, and define the HAVING clause, which isone of two filters you can use in your queries.

Highlights from this video:
  • What can the HAVING clause filter?
  • Working with the HAVING clause
  • Specific places to use HAVING clause
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: having clause, about having clause

posted by Scott Whigham @ 2:33 PM  

New Transact SQL Video Tutorial: A Comparison of DISTINCT and GROUP BY: When to Use Each

A Comparison of DISTINCT and GROUP BY: When to Use Each - view details
In this video tutorial Scott Whigham will breakdown the differences and similarities between using the DISTINCT and GROUP BY clauses.

Highlights from this video:
  • Where do these clauses respectively operate?
  • What kind of relationships are drawn between base table and your result set?
  • Purpose of GROUP BY and DISTINCT and how SQL Server treats them
  • Comparing/Contrasting the two clauses
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: distinct, group by, clause,

posted by Scott Whigham @ 2:33 PM  

New SQL Server Integration Services Video Tutorial: Troubleshooting SSIS: Identify and Repair Common Connection/Password Problems

Troubleshooting SSIS: Identify and Repair Common Connection/Password Problems - view details
Have you ever found that your SSIS package doesn't work due to a failed login validation, or it cannot acquire the connection. In this essential video tutorial Scott will demonstrate how to debug your password/connection problems even when password is "saved" by modifying your package-level security levels.
Highlights from this video:
  • About package-level security
  • Encrypting your password with user key
  • Sharing packages in multi-user environment
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: troubleshooting, failed login, password, connection, package security,

posted by Scott Whigham @ 2:19 PM  

New SQL Server Integration Services Video Tutorial: How to Add a Progress Bar/Indicator to Your SSIS Packages

How to Add a Progress Bar/Indicator to Your SSIS Packages - view details
Do you ever want an indicator or an idea of how long your package execution will take? In this video tutorial Scott Whigham will introduce you to the simple method and code of adding a progress bar to your SSIS packages!
Highlights from this video:
  • About the Fire Progress Event and the Fire Information Event
  • Obtaining a _% complete reading based on provided parameters
  • Other advanced Firing events
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: packages, fire event, progress bar, progress indicator, package execution

posted by Scott Whigham @ 2:19 PM  

New SQL Server Integration Services Video Tutorial: Part 4 - Queries, Scripting, NOT EXISTS, and Final Thoughts

Part 4 - Queries, Scripting, NOT EXISTS, and Final Thoughts - view details
In this final video in the series, Scott will cover more about custom queries and scripts you can generate for importing Access data, as well as give you some of his final thoughts on Access, importing data, and SQL Server.
Highlights from this video:
  • Writing a custom query to store results in SQL Server tables
  • Scripting a table as a CREATE
  • Using IF NOT EXISTS
��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: access, microsoft access, import tables, import access, if not exists,

posted by Scott Whigham @ 2:18 PM  

New SQL Server Integration Services Video Tutorial: Part 3 - Hand-Writing Your Own Access Import Data Flow Tasks

Part 3 - Hand-Writing Your Own Access Import Data Flow Tasks - view details
An alternative to using the Import/Export Wizard is to hand-write your own Access import data flow tasks, as the Wizard has some limitations to using it. In this third video in the series your instructor will walk you through the process of doing so and configuring your options.
Highlights from this video:
  • Making a new, appropriate connection for Access versions
  • Configuring your SQL Server destination
  • Package Validation Errors
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: import access, export access, microsoft access, access, import export wizard

posted by Scott Whigham @ 2:18 PM  

New SQL Server Integration Services Video Tutorial: Part 2 - Limitations of the Import/Export Wizard

Part 2 - Limitations of the Import/Export Wizard - view details
In this second video in the series, you will continue working in the Import and Export Wizard. Scott will also diverge some of the pitfalls and limitations of the Import and Export Wizard for migrating data from Access to SQL Server.
Highlights from this video:
  • Creating a column primary key
  • Viewing tables in SQL Server
  • Import/Export Wizard downfalls
  • Intro to the alternative to Import/Export wizard
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: import access, export access, microsoft access, access,

posted by Scott Whigham @ 2:18 PM  

New SQL Server Integration Services Video Tutorial: Part 1 - How to Import Microsoft Access Tables to SQL Server Using SSIS

Part 1 - How to Import Microsoft Access Tables to SQL Server Using SSIS - view details
In this first video in the series, Scott will show you how to import your Microsoft Access data into a Sql Server via SSIS. There are two different ways to import Access data, depending on importing frequency, and in this video you will be setting up the import for converting data, like tables and queries, in a recurring basis.
Highlights from this video:
  • When not to use SSIS for importing Access tables
  • Working with the Import and Export Wizard
  • Connecting to your Access datasource
  • Choosing which tables and views/queries to import
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: access, microsoft acces, import tables, import access

posted by Scott Whigham @ 2:17 PM  

Saturday, February 16, 2008

New SQL Server Video Tutorial: Part 3 - How to Use Alerts with SQL Server System Error Messages and Events

Part 3 - How to Use Alerts with SQL Server System Error Messages and Events - view details
The alert management system has drastically changed since SQL Server 2000. In this third video of the series Scott will show you the things you now cannot use alerts for, moreso than what you can presently use alerts for!

Highlights from this video:
  • Working with Error Message 3201 in SQL Server 2000/7.0
  • Building alerts in SQL 2000 vs SQL 2005
  • Understanding Event Id's in Windows Event Viewer
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: alerts, DBA, management, SQL Agent, WMI, Error Handling, Performance

posted by Scott Whigham @ 4:35 AM  

New SQL Server Video Tutorial: Part 2 - Using Event Alerts (Error Alerts) And RAISERROR for Custom Error Alerts

Part 2 - Using Event Alerts (Error Alerts) And RAISERROR for Custom Error Alerts - view details
Continued in this second video in the series, Scott will walk you through the process of adding event alerts, working with RAISEERROR and how to customize/generate a new alert.

Highlights from this video:
  • Running RAISEERROR to show you a couple more things.
  • Ad-hoc messages: Error message 50000
  • Adding custom error messages
  • Defining the response to a SQL Server event alert
  • The importance of SQL Server Agent with alerts
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: alerts, DBA, management, SQL Agent, WMI, Error Handling, Performance

posted by Scott Whigham @ 4:35 AM  

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

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

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

posted by Scott Whigham @ 4:35 AM  

New SQL Server Video Tutorial: Part 5 - Define a Performance Condition Alert to Keep Your Log From Filling Up

Part 5 - Define a Performance Condition Alert to Keep Your Log From Filling Up - view details
A continuation from the 4th video on performance conditions, this 5th video tutorial will show you how to define your performance condition alerts, keeping your transaction log from filling completely up!

Highlights from this video:
  • Executing jobs based off alerts
  • The importance of determining the delay between responses
  • Defining your performance conditions and using the messenger service
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: alerts, DBA, management, SQL Agent, Error Handling, Performance

posted by Scott Whigham @ 4:35 AM  

New Windows 2003 Video Tutorial: Create, Extract, and Password Protect .ZIP Files

Create, Extract, and Password Protect .ZIP Files - view details
Windows server 2003 and Windows XP have some built-in functionalities when working with zip files, reducing your need for third-party software. In this video tutorial Grant will demonstrate how you can create a zip file, how you can extract a zip file, and how you can protect your zip file via password!

Highlights from this video:

  • Adding/Extracting files and folders to a zip file
  • Working with the Extraction Wizard
  • Adding a password to your zip file
  • What will the password protect in my zip file?
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: zip files, create zip, extract zip, password protect zip,, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:35 AM  

New SQL Server Video Tutorial: Part 4 - Performance Condition Alerts in SQL Server 2005

Part 4 - Performance Condition Alerts in SQL Server 2005 - view details
This fourth video in the series will cover how to use Performance Condition alerts, as there are lots of opportunities to play with these helpful alerts.

Highlights from this video:
  • When to use a performance condition alert
  • Common Performance condition scenarios
  • Manually emptying a Transaction Log via backup
  • SQL Server Object Counters
  • Creating a new performance condition alert
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: alerts, DBA, management, SQL Agent, Error Handling, Performance

posted by Scott Whigham @ 4:35 AM  

New Windows 2003 Video Tutorial: Auditing User Logon to the Active Directory

Auditing User Logon to the Active Directory - view details
As an Active Directory administrator you may want to audit who is logging in to the network and who is failing to login to the network. In this video tutorial Grant will show you the various approaches for doing so! Highlights from this video:
  • Domain Controller Security Policy vs Domain Security Policy.
  • Auditing logon events: Success and Failure
  • Testing your audited policies and viewing in Event Viewer
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: user logon, audit, active directory, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 4:35 AM  

New SQL Server Video Tutorial: Part 6 - SQL Server 2005 WMI Event Alerts: How to Write WQL for WMI

Part 6 - SQL Server 2005 WMI Event Alerts: How to Write WQL for WMI - view details
This final video in the series will cover the final type of alert, the WMI event, which is new for SQL Server 2005. You'll learn about the syntax for writing WQL queries and how you can understand the WMI namespaces.

Highlights from this video:
  • WMI Code Creator
  • Writing WQL to identify events in SQL Server
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: alerts, DBA, management, SQL Agent, WMI, Error Handling, Performance, WQL

posted by Scott Whigham @ 3:42 AM  

New SQL Server Video Tutorial: Part 5 - Define a Performance Condition Alert to Keep Your Log From Filling Up

Part 5 - Define a Performance Condition Alert to Keep Your Log From Filling Up - view details
A continuation from the 4th video on performance conditions, this 5th video tutorial will show you how to define your performance condition alerts, keeping your transaction log from filling completely up!

Highlights from this video:
  • Executing jobs based off alerts
  • The importance of determining the delay between responses
  • Defining your performance conditions and using the messenger service
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: alerts, DBA, management, SQL Agent, Error Handling, Performance

posted by Scott Whigham @ 3:42 AM  

New SQL Server Video Tutorial: Part 4 - Performance Condition Alerts in SQL Server 2005

Part 4 - Performance Condition Alerts in SQL Server 2005 - view details
This fourth video in the series will cover how to use Performance Condition alerts, as there are lots of opportunities to play with these helpful alerts.

Highlights from this video:
  • When to use a performance condition alert
  • Common Performance condition scenarios
  • Manually emptying a Transaction Log via backup
  • SQL Server Object Counters
  • Creating a new performance condition alert
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: alerts, DBA, management, SQL Agent, Error Handling, Performance

posted by Scott Whigham @ 3:42 AM  

New SQL Server Video Tutorial: Part 3 - How to Use Alerts with SQL Server System Error Messages and Events

Part 3 - How to Use Alerts with SQL Server System Error Messages and Events - view details
The alert management system has drastically changed since SQL Server 2000. In this third video of the series Scott will show you the things you now cannot use alerts for, moreso than what you can presently use alerts for!

Highlights from this video:
  • Working with Error Message 3201 in SQL Server 2000/7.0
  • Building alerts in SQL 2000 vs SQL 2005
  • Understanding Event Id's in Windows Event Viewer
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: alerts, DBA, management, SQL Agent, WMI, Error Handling, Performance

posted by Scott Whigham @ 3:41 AM  

New SQL Server Video Tutorial: Part 2 - Using Event Alerts (Error Alerts) And RAISERROR for Custom Error Alerts

Part 2 - Using Event Alerts (Error Alerts) And RAISERROR for Custom Error Alerts - view details
Continued in this second video in the series, Scott will walk you through the process of adding event alerts, working with RAISEERROR and how to customize/generate a new alert.

Highlights from this video:
  • Running RAISEERROR to show you a couple more things.
  • Ad-hoc messages: Error message 50000
  • Adding custom error messages
  • Defining the response to a SQL Server event alert
  • The importance of SQL Server Agent with alerts
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: alerts, DBA, management, SQL Agent, WMI, Error Handling, Performance

posted by Scott Whigham @ 3:41 AM  

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

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

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

posted by Scott Whigham @ 3:41 AM  

New Windows 2003 Video Tutorial: Create, Extract, and Password Protect .ZIP Files

Create, Extract, and Password Protect .ZIP Files - view details
Windows server 2003 and Windows XP have some built-in functionalities when working with zip files, reducing your need for third-party software. In this video tutorial Grant will demonstrate how you can create a zip file, how you can extract a zip file, and how you can protect your zip file via password!

Highlights from this video:

  • Adding/Extracting files and folders to a zip file
  • Working with the Extraction Wizard
  • Adding a password to your zip file
  • What will the password protect in my zip file?
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: zip files, create zip, extract zip, password protect zip,, introduction, step by step, beginner, beginning, for dummies

posted by Scott Whigham @ 3:05 AM  

Thursday, February 14, 2008

New Exchange Server Video Tutorial: Request and Obtain a Commercial SSL Certificate

Request and Obtain a Commercial SSL Certificate - view details
In this lengthy, but great video tutorial, Grant will be walking��the viewer��through these topics:
  • Verification of DNS records for external access to webmail
  • Initial testing, and resulting default, non-trusted SSL Certificate (and error messages)
  • Removal of default SSL Certificate
  • Generation of an SSL Certificate Request
  • Submission of SSL Certificate to a Certificate Authority
  • Validation of SSL Certificate by the owner of the Domain
  • Issuance of the SSL Certificate by the Certificate Authority
  • Download and Installation of the SSL Certificate onto the Web Server for Exchange Purposes
  • Testing from a remote site the SSL Connection, showing a trusted, valid certificate
  • Closing remarks on RPC over HTTPS.

      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: ssl, ssl certificate, dns, ssl connection, domain

      posted by Scott Whigham @ 4:35 AM  

      New Exchange Server Video Tutorial: Configure a Domain for Inbound Information

      Configure a Domain for Inbound Information - view details
      This video walks through the steps necessary to configure a single exchange server to accept e-mail from the outside world. By default, exchange only permits email from Authenticated connections - but if mail from the internet will be directly delivered to your mail server (instead of passing through third-party software, hardware or outsourcing, then watch this video to permit inbound email


      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: mail server, inbound, email

      posted by Scott Whigham @ 4:35 AM  

      New Exchange Server Video Tutorial: Mapping External DNS Entries on Internal DNS Servers

      Mapping External DNS Entries on Internal DNS Servers - view details
      Many Firewalls, including Cisco Firewalls/Network Devices, do not allow internal traffic to exit the network and come right back in. This causes issues for users on the internal network to try to utilize an externally registered Fully Qualified Domain Name (FQDN). The most common example of this is webmail. When outside the office - many organizations use webmail.mycompany.com. They register the domain, configure Inbound e-mail Traffic, and Purchase an SSL certificate for the server. However, Once deployed, internal users cannot access this public address. The solution? Duplicate the records for the public address(s) in your Internal DNS Server, substituting the public IP address for the internal private addresses.
      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: external dns, dns, internal dns, dns server,

      posted by Scott Whigham @ 4:35 AM  

      New Windows 2003 Video Tutorial: Auditing Printer Usage in the Event Log

      Auditing Printer Usage in the Event Log - view details
      You may want to audit the usage of certain printers in your organization so you can account for who uses them! In this video tutorial Grant will show you the process of enabling the printer usage auditing policy as well as introduce you to an easier, alternate technique.

      Highlights:

      • Where can I find my audit policy?
      • How to turn on auditing
      • Viewing your audits in Event Viewer
      • Alternate method for viewing/troubleshooting print jobs
      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: printer usage, audit, event log, introduction, step by step, beginner, beginning, for dummies

      posted by Scott Whigham @ 4:35 AM  

      New Windows 2003 Video Tutorial: Auditing Registry Access in the Event Log

      Auditing Registry Access in the Event Log - view details
      Auditing the registry can be quite useful for troubleshooting applications or is users are changing something in the registry on a regular basis. How exactly do you audit the registry? In this video tutorial Grant will show you how to do just that!

      Highlights:

      • ��About auditing Object Access
      • Adding auditing policies to registry keys
      • ��Viewing the audits in Event Log

      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: audit, registry access, event log, introduction, step by step, beginner, beginning, for dummies

      posted by Scott Whigham @ 4:35 AM  

      New Windows 2003 Video Tutorial: Enable and Test Account Lockout in Active Directory

      Enable and Test Account Lockout in Active Directory - view details
      How you handle user accounts in an active directory when a user enters their password incorrectly enough times to trigger the user account lockout. In this video tutorial Grant will walk you demonstrate to you how to work through the account lockout and also how to test the account lockout in the active directory. Highlights from this video:
      • Where are the policies in effect?
      • Defining account lockout duration, threshold, and counter reset
      • Testing the lockout policies
      • Unlocking user accounts via Admin privileges 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: account lockout, active directory, user, lockout, introduction, step by step, beginner, beginning, for dummies

      posted by Scott Whigham @ 4:35 AM  

      New Exchange Server Video Tutorial: Changing SMTP to a Fully Qualified Domain Name (FQDN)

      Changing SMTP to a Fully Qualified Domain Name (FQDN) - view details
      Exchange 2007 reveils the internet server name of the exchange server when someone connects to Port 25. In this video - Grant will show you how to change that value to match your externally published name.
      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: fqdn, fully qualified domain name, smtp, , introduction, step by step, beginner, beginning, for dummies

      posted by Scott Whigham @ 4:35 AM  

      New Exchange Server Video Tutorial: Registering a Domain

      Registering a Domain - view details
      This video goes through the process of Registering the Domain LearnExchange.net and setting up basic DNS records for Exchange Purposes (mail.learnexchange.net Host Record, webmail.learnexchange.com CNAME record, and learnexchange.net MX record)

      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: domain, dns, host record, record, domain name,

      posted by Scott Whigham @ 4:35 AM  

      New Reporting Services Video Tutorial: Part8-Multi-value Parameters

      Part8-Multi-value Parameters - view details
      This final video in the series will discuss how to use/how to work with multi-value parameters, which will take some experience to get used to.

      Highlights from this video:
      • What are the multi-value parameters?
      • Behind the scenes base query for the multi-value parameters
      • What rules will then apply for null values?
      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: parameters, report parameters, ssrs, reporting services,

      posted by Scott Whigham @ 4:35 AM  

      Wednesday, February 13, 2008

      New Windows 2003 Video Tutorial: Enable and Test Account Lockout in Active Directory

      Enable and Test Account Lockout in Active Directory - view details
      How you handle user accounts in an active directory when a user enters their password incorrectly enough times to trigger the user account lockout. In this video tutorial Grant will walk you demonstrate to you how to work through the account lockout and also how to test the account lockout in the active directory. Highlights from this video:
      • Where are the policies in effect?
      • Defining account lockout duration, threshold, and counter reset
      • Testing the lockout policies
      • Unlocking user accounts via Admin privileges 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: account lockout, active directory, user, lockout, introduction, step by step, beginner, beginning, for dummies

      posted by Scott Whigham @ 2:48 PM  

      New Windows 2003 Video Tutorial: Auditing Registry Access in the Event Log

      Auditing Registry Access in the Event Log - view details
      Auditing the registry can be quite useful for troubleshooting applications or is users are changing something in the registry on a regular basis. How exactly do you audit the registry? In this video tutorial Grant will show you how to do just that!

      Highlights:

      • ��About auditing Object Access
      • Adding auditing policies to registry keys
      • ��Viewing the audits in Event Log

      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: audit, registry access, event log, introduction, step by step, beginner, beginning, for dummies

      posted by Scott Whigham @ 2:48 PM  

      New Windows 2003 Video Tutorial: Auditing Printer Usage in the Event Log

      Auditing Printer Usage in the Event Log - view details
      You may want to audit the usage of certain printers in your organization so you can account for who uses them! In this video tutorial Grant will show you the process of enabling the printer usage auditing policy as well as introduce you to an easier, alternate technique.

      Highlights:

      • Where can I find my audit policy?
      • How to turn on auditing
      • Viewing your audits in Event Viewer
      • Alternate method for viewing/troubleshooting print jobs
      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: printer usage, audit, event log, introduction, step by step, beginner, beginning, for dummies

      posted by Scott Whigham @ 2:47 PM  

      New Windows 2003 Video Tutorial: Auditing Printer Usage in the Event Log

      Auditing Printer Usage in the Event Log - view details
      You may want to audit the usage of certain printers in your organization so you can account for who uses them! In this video tutorial Grant will show you the process of enabling the printer usage auditing policy as well as introduce you to an easier, alternate technique.

      Highlights:

      • Where can I find my audit policy?
      • How to turn on auditing
      • Viewing your audits in Event Viewer
      • Alternate method for viewing/troubleshooting print jobs
      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: printer usage, audit, event log, introduction, step by step, beginner, beginning, for dummies

      posted by Scott Whigham @ 2:47 PM  

      New Windows 2003 Video Tutorial: Auditing User Logon to the Active Directory

      Auditing User Logon to the Active Directory - view details
      As an Active Directory administrator you may want to audit who is logging in to the network and who is failing to login to the network. In this video tutorial Grant will show you the various approaches for doing so! Highlights from this video:
      • Domain Controller Security Policy vs Domain Security Policy.
      • Auditing logon events: Success and Failure
      • Testing your audited policies and viewing in Event Viewer
      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: user logon, audit, active directory, introduction, step by step, beginner, beginning, for dummies

      posted by Scott Whigham @ 2:45 PM  

      New Windows 2003 Video Tutorial: Enable and Test Account Lockout in Active Directory

      Enable and Test Account Lockout in Active Directory - view details
      How you handle user accounts in an active directory when a user enters their password incorrectly enough times to trigger the user account lockout. In this video tutorial Grant will walk you demonstrate to you how to work through the account lockout and also how to test the account lockout in the active directory. Highlights from this video:
      • Where are the policies in effect?
      • Defining account lockout duration, threshold, and counter reset
      • Testing the lockout policies
      • Unlocking user accounts via Admin privileges 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: account lockout, active directory, user, lockout, introduction, step by step, beginner, beginning, for dummies

      posted by Scott Whigham @ 2:44 PM  

      New Exchange Server Video Tutorial: Changing SMTP to a Fully Qualified Domain Name (FQDN)

      Changing SMTP to a Fully Qualified Domain Name (FQDN) - view details
      Exchange 2007 reveils the internet server name of the exchange server when someone connects to Port 25. In this video - Grant will show you how to change that value to match your externally published name.
      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: fqdn, fully qualified domain name, smtp, , introduction, step by step, beginner, beginning, for dummies

      posted by Scott Whigham @ 2:15 PM  

      New Exchange Server Video Tutorial: Mapping External DNS Entries on Internal DNS Servers

      Mapping External DNS Entries on Internal DNS Servers - view details
      Many Firewalls, including Cisco Firewalls/Network Devices, do not allow internal traffic to exit the network and come right back in. This causes issues for users on the internal network to try to utilize an externally registered Fully Qualified Domain Name (FQDN). The most common example of this is webmail. When outside the office - many organizations use webmail.mycompany.com. They register the domain, configure Inbound e-mail Traffic, and Purchase an SSL certificate for the server. However, Once deployed, internal users cannot access this public address. The solution? Duplicate the records for the public address(s) in your Internal DNS Server, substituting the public IP address for the internal private addresses.
      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: external dns, dns, internal dns, dns server,

      posted by Scott Whigham @ 1:48 PM  

      New Exchange Server Video Tutorial: Request and Obtain a Commercial SSL Certificate

      Request and Obtain a Commercial SSL Certificate - view details
      In this lengthy, but great video tutorial, Grant will be walking��the viewer��through these topics:
    • Verification of DNS records for external access to webmail
    • Initial testing, and resulting default, non-trusted SSL Certificate (and error messages)
    • Removal of default SSL Certificate
    • Generation of an SSL Certificate Request
    • Submission of SSL Certificate to a Certificate Authority
    • Validation of SSL Certificate by the owner of the Domain
    • Issuance of the SSL Certificate by the Certificate Authority
    • Download and Installation of the SSL Certificate onto the Web Server for Exchange Purposes
    • Testing from a remote site the SSL Connection, showing a trusted, valid certificate
    • Closing remarks on RPC over HTTPS.

        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: ssl, ssl certificate, dns, ssl connection, domain

        posted by Scott Whigham @ 1:47 PM  

        New Exchange Server Video Tutorial: Configure a Domain for Inbound Information

        Configure a Domain for Inbound Information - view details
        This video walks through the steps necessary to configure a single exchange server to accept e-mail from the outside world. By default, exchange only permits email from Authenticated connections - but if mail from the internet will be directly delivered to your mail server (instead of passing through third-party software, hardware or outsourcing, then watch this video to permit inbound email


        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: mail server, inbound, email

        posted by Scott Whigham @ 1:42 PM  

        New Exchange Server Video Tutorial: Registering a Domain

        Registering a Domain - view details
        This video goes through the process of Registering the Domain LearnExchange.net and setting up basic DNS records for Exchange Purposes (mail.learnexchange.net Host Record, webmail.learnexchange.com CNAME record, and learnexchange.net MX record)

        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: domain, dns, host record, record, domain name,

        posted by Scott Whigham @ 1:41 PM