Tuesday, June 30, 2009

C# Programming Video Tutorial: Installing Visual C# and Visual Ba sic Express Editions

Installing Visual C# and Visual Basic Express Editions - view details
Before you can begin writing .NET applications, you'll need the right tools installed. The Express Edition(s) of Visual Studio (in our case, the C# edition) allow you to develop extremely rich client applications for FREE.

Highlights from this video:
  • Installing Visual Basic Express
  • Installing Visual C# Express
  • Updating Visual C# Express with Service Pack 1
  • Options during setup and recommendations
and much more
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: beginner, beginning, intro, intr oduction, msde, starter

This video comes from the C# online training course, C# Programming with Visual Studio 2005. And be sure to check out even more C# Programming training videos.

posted by Scott Whigham @ 11:53 PM  

MSSQL Programming and Query Writing Video Tutorial: Pt. 4 - INSER Ts and Identity Columns: An Overview

Pt. 4 - INSERTs and Identity Columns: An Overview - view details
This video hosts the final part 4 of the 4 part Data Manipulation Language INSERT STATEMENT video section and describes in detail how to properly work with IDENTITY COLUMNS. This video is a phenomenal resource of informative data that will boost your knowledge of IDENTITY COLUMNs and INSERT statements. You can expect to find information on the following topics within this video:
  • Proper use and explanation of IDENTITY COLUMNS
  • Common errors with using the INSERT statement when using Identity Columns
  • Working with IDENTITY INSERT ON and OFF
  • Introduction to SQL SERVER 2005 Specific OUTPUT inserted statment
  • Introduction, explanation and definition of the SCOPE_IDENTITY() function
  • Introduction to proper syntax for table creation
  • Introduction to logic warnings for usage of @@IDENTITY vs SCOPE_IDENTITY()
This video is made so that you do not even have to see the first three videos in order to follow and absorb the knowledge held within. The video is so easy to follow a caveman could do it. :D If you are looking for a reference, help or just simply need to learn about working with the IDENTITY COLUMN and INSERTS this is the video for you.

NOTE: This video was reviewed and this description was written by one of our members, Wayne Leiser. Thanks,Wayne!
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: DML, data manipulation language, INSERT, identity column

This video comes from the SQL Server Programming and Queries online training course, SQL Server Programming (SQL Server 2005/2000) : Transact SQL. And be sure to check out even more MSSQL Programming and Query Writing training videos.

posted by Scott Whigham @ 10:53 PM  

SQL 2005 Integration Services Video Tutorial: Part 1 - An Introdu ction to Regular Expressions

Part 1 - An Introduction to Regular Expressions - view details
In this video section we will be talking about regular expressions, a topic that many find to be semi-confusing. In the first video, you will be provided with an in-depth introduction to the concept of Regular Expressions, one of the most efficient and easiest ways to work with text data or strings. Also in this video, Scott will demonstrate where regular expressions can help.

Highlights from this video:
  • How are Regular Expressions useful?
  • Languages that support RegEx
  • Simplifying tasks via regular exressions
    • Real-life scenario
and much more
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: regular expressions, regex, expression, language, text, script, string,

This video comes from the SSIS 2005 online training course, SQL Server 2005 Integration Services. And be sure to check out even more SQL 2005 Integration Services training videos.

posted by Scott Whigham @ 9:53 PM  

MS Exchange 2007 Video Tutorial: LCR Configuration

LCR Configuration - view details
One of the new features in Exchange 2007 is 'Local Continuous Replication' (LCR) and it's definitely something you'll want to know the details about.

Highlights from this video:
  • Walking through the 'Enable Storage Group Local Continuous Replication' Wizard
  • How LCR works and the purpose of LCR
  • Managing storage groups
  • Disaster recovery concepts and scenarios in Exchange 2007
  • Best Practices for using LCR
and much more
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: disks, san, setup, installing, configuration, configuring

This video comes from the Exchange 2007 online training course, Exchang e Server 2007 Administration. And be sure to check out even more MS Exchange 2007 training videos.

posted by Scott Whigham @ 8:53 PM  

Windows Server 2003 Video Tutorial: Add New Disks to Windows 2003

Add New Disks to Windows 2003 - view details
An important need is to add new disks to Windows 2003 and this video shows you the ins and outs!
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: add new disk to Windows 2003, beginner, beginning, for beginners, introduction, step by step

This video comes from the Windows 2003 online training course, Windows Server 2003 Administration. And be sure to check out even more Windows Server 2003 training videos.

posted by Scott Whigham @ 7:53 PM  

SQL 2005 Reporting Services Video Tutorial: Pt. 4 - Best Practice s for Maximum SQL Server Reporting Services Performance: Shared Data Sourc es

Pt. 4 - Best Practices for Maximum SQL Server Reporting Services Performance: Shared Data Sources - view details
In this final video, your instructor will provide you with an overview/summary of the previous videos in this section, including shared data sources and ��how best to manage your shared data sources.

Highlights from this video:

  • What is Impersonation?
  • How to take max. advantage of connection pooling
  • Steps to configure security and connection pooling

and much more!

To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: shared data sources, best pract ices, reporting services, summary,

This video comes from the SSRS 2005 online training course, SQL Server 2005 Reporting Services. And be sure to check out even more SQL 2005 Reporting Services training videos.

posted by Scott Whigham @ 6:53 PM  

MSSQL Programming and Query Writing Video Tutorial: Variables - U nderstanding the Difference Between Using SET and SELECT to Assign Values

Variables - Understanding the Difference Between Using SET and SELECT to Assign Values - view details
This video is designed to help you understand when you should use SET @Variable = value and SELECT @Variable = value. For new people coming into T-SQL programming, it's often quite confusing when to use SET vs. SELECT for variable assignment.
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: assign variable from database

This video comes from the SQL Server Programming and Queries online training course, SQL Server Programming (SQL Server 2005/2000): Transact SQL. And be sure to check out even more MSSQL Programming and Query Writing training videos.

posted by Scott Whigham @ 5:53 PM  

MS Exchange 2003 Video Tutorial: POP3 Testing

POP3 Testing - view details
If you have clients that can only use POP3 to connect to your Exchange server then this video can help you understand the basics of POP3 configuration in Exchange and how it works with Exchange. You'll use the Exchange System Manager to manage POP3 and the Telnet utility to test a few POP3 emails
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: test pop3 Exchange, pop3 with Exchange

This video comes from the Exchange 2003 online training course, Exchange Server 2003 Administration. And be sure to check out even more MS Exchange 2003 training videos.

posted by Scott Whigham @ 4:53 PM  

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

Pt. 5 - An In-Depth Case Study of Migrating a DTS Package to SSIS - view details
More, more, more! Fixing common problems with the Package Migration Wizard's packages
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: upgrading, upgrade, migrating, data transformation services, migrate

This video comes from the SSIS 2005 online training course, SQL Server 2005 Integration Services. And be sure to check out even more SQL 2005 Integration Services training videos.

posted by Scott Whigham @ 3:53 PM  

SQL 2005 Integration Services Video Tutorial: Tips on Documenting and Annotating Your SSIS Packages

Tips on Documenting and Annotating Your SSIS Packages - view details
This video covers the basics of documenting, printing, and annotating (i.e., marking up) your SSIS packages. You'll see more than the basics however, you'll also see a few best practices and common uses.

Highlights from this video:
  • Using the Text Annotations Effectively
  • Arranging and Formatting Your Annotations
  • Printing and Documenting Your Packages and Tasks
  • Formatting Your Text for Clear Documentation
  • Grouping and anchoring text
and much more

*** This is an updated video
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: documentation, printing, printer, printed, dictionary, generate, annotate, annotating, documenting

This video comes from the SSIS 2005 online training course, SQL Server 2005 Integration Services. And be sure to check out even more SQL 2005 Integration Services training videos.

posted by Scott Whigham @ 2:53 PM  

SQL 2005 Integration Services Video Tutorial: Pt. 2 - Expressions - Using Expressions In SSIS Tasks

Pt. 2 - Expressions - Using Expressions In SSIS Tasks - view details
This video continues our section on using Expressions by focusing on using Expressions in SSIS tasks and using the Expression Builder. Also, Best Practices for Expressions and more
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: expression builder, expressions, @counter, variables, iteration, iterate, recursion, tasks, F4

This video comes from the SSIS 2005 online training course, SQL Server 2005 Integration Services. And be sure to check out even more SQL 2005 Integration Services training videos.

posted by Scott Whigham @ 1:53 PM  

MSSQL Server 2005 Video Tutorial: Pt. 3 - Performance Tuning Prof iler and Traces By Adding Filters and Working with Large Traces

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

Highlights from this video:
  • What filters should I use when I want to filter for long running/slow queries?
  • What are Reads and Duration and why are they important?
  • How can I only trace my application (not SQL Server Agent, for example)
  • Tracing for performance tuning
  • What Event Classes use what Filters
  • Suggestions for using filters to create more manageable traces
and much more
To download this video, log in then th en visit the video's detail page and click "download".

Keywords for this video: sql trace, sql profiler, sql server 2000 profiler, profiling, sql sniffer, sniffing sql, tracing sql, grouping, filtering, limiting

This video comes from the SQL Server 2005 DBA online training course, SQL Server 2005 Database Administration. And be sure to check out even more MSSQL Server 2005 training videos.

posted by Scott Whigham @ 12:53 PM  

SQL 2005 Integration Services Video Tutorial: Part 4 - Best Pract ices for Managing SSIS Package Configurations Stored in SQL Server (Pt. B)

Part 4 - Best Practices for Managing SSIS Package Configurations Stored in SQL Server (Pt. B) - view details
In this fourth video in the section, Scott will really delve into the best practices on the package configurations table and discuss why those settings are optimal.

Highlights from this video:
  • Problems with using the ConfigurationFilter defaults
    • Table logic
    • How to effectively run commands
    • Specifying PackagePath correctly
  • Modifying the configuration table
    • Primary key
    • Indexes
      • Where to place an index
and much more
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: package, configure, package configuration, best practice, table, configuration, sql, ssis.

This video comes from the SSIS 2005 online training course, SQL Server 2005 Integration Services. And be sure to check out even more SQL 2005 Integration Services training videos.

posted by Scott Whigham @ 11:53 AM  

MSSQL Programming and Query Writing Video Tutorial: Pt. 4 - Intro duction to Using XML with SQL Server

Pt. 4 - Introduction to Using XML with SQL Server - view details
This video discusses using XQuery, XPath and XML DML as options for working with XML data.
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: xquery standard, xdr

This video comes from the SQL Server Programming and Queries online training course, SQL Server Programming (SQL Server 2005/2000): Transact SQL. And be sure to check out even more MSSQL Programming and Query Writing training videos.

posted by Scott Whigham @ 10:53 AM  

MSSQL Server DTS Video Tutorial: Open a .dts File (Structured Sto rage File) and Managing File-Based DTS Package(s)

Open a .dts File (Structured Storage File) and Managing File-Based DTS Package(s) - view details
Have you received (or do you have to manage) a .dts file? For the uninitiated, opening such a file in the DTS Designer is VERY confusing. This video shows you not only how to open .dts files but it also shows you how to save your DTS packages as .dts files (a.k.a. Structured Storage Files).
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: .dts files

This video comes from the SQL Server 2000 DTS online tr aining course, SQL Server 2000 DTS. And be sure to check out even more MSSQL Server DTS training videos.

posted by Scott Whigham @ 9:53 AM  

SharePoint (MOSS/WSS) Video Tutorial: How to Create a Survey wit h SharePoint Services 3.0

How to Create a Survey with SharePoint Services 3.0 - view details
In this video you will learn how to add a survey to your SharePoint site, how to add questions to your survey, how to use branching logic, how export data from survey, how to customize the way your survey looks, and how to set-up a required response survey.

Highlights:
  • How to adjust the title of your survey
  • How to customize the way your survey looks
  • Customizing the set-up of your survey in WSS
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: create survey ,add survey, customize, survey, branching logic, export survey dat a,

This video comes from the SharePoint 2007 online training course, Building Portals with SharePoint 2007. And be sure to check out even more SharePoint (MOSS/WSS) training videos.

posted by Scott Whigham @ 8:53 AM  

SQL 2005 Integration Services Video Tutorial: Pt. 4 - How to Perf orm Set-Based Incremental Updates (SQL Server to SQL Server)

Pt. 4 - How to Perform Set-Based Incremental Updates (SQL Server to SQL Server) - view details
This video is really more like Part 3b since it picks right up where Part 3 left off. You'll learn about how to take the queries in the last video and create the OLE-DB Command transformation to actually perform the update.
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: disaster recovery, incremental updates, incremental delta, incremental uploads, append data to table

This video comes from the SSIS 2005 online training course, SQL Server 2005 Integration Services. And be sure to check out even more SQL 2005 Integration Services training videos.

posted by Scott Whigham @ 7:53 AM  

MSSQL Programming and Query Writing Video Tutorial: Design Patter n for Finding Duplicate Data - A Simple Way to Spot Non-Unique Rows (Multi Column Test)

Design Pattern for Finding Duplicate Data - A Simple Way to Spot Non-Unique Rows (Multi Column Test) - view details
We have multiple SQL tutorials for writing queries to return duplicate data in a column or multiple columns. This video focuses on spotting dupes across multiple columns. Although primary keys prevent duplicate rows, having a Primary Key on "EmployeeId" does not prevent users from entering duplicate LastName/FirstName combinations. This video shows you how to use subqueries (both correlated and simple) along with EXISTS to locate non-unique rows.
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: duplicate check

This video comes from the SQL Server Programming and Queries online training course, SQL Server Programming (SQL Server 2005/2000): Transact SQL. And be sure to check out even more MSSQL Programming and Query Writing training videos.

posted by Scott Whigham @ 6:53 AM  

ISA 2006 Admin Video Tutorial: How to Configure and Manage Loggin g in ISA Server 2006

How to Configure and Manage Logging in ISA Server 2006 - view details
Once your ISA Server is up and running, you can utilitize it to view what's happening in real time or historically on your server. This video shows you how to view the default log in ISA Server 2006 and much more.

Highlights from this video:
  • Viewing the default log
  • Writing logging queries
  • Creating and editing filters
  • Importing and exporting filter definitions
and much more
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: logging, monitoring

This video comes from the ISA 2006 on line training course, ISA Server 2006 Administration. And be sure to check out even more ISA 2006 Admin training videos.

posted by Scott Whigham @ 5:53 AM  

SQL 2005 Integration Services Video Tutorial: Pt. 1 - Understandi ng How 'Context' Works in SSIS Package Execution

Pt. 1 - Understanding How 'Context' Works in SSIS Package Execution - view details
Explained in this first video in the section is the idea of 'context' with repsect to the SQL Server Integration Services, which is a common problem in package execution.
  • Running a package as a job
  • Troubleshooting job failure due to context
  • About SQL Server Agent

and much more!

��

To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: package execution

This video comes from the SSIS 2005 online training course, SQL Server 2005 Integration Services. And be sure to check out e ven more SQL 2005 Integration Services training videos.

posted by Scott Whigham @ 4:53 AM  

MSSQL Server 2000 Video Tutorial: Master Database - An Overview o f Some of the Common System Tables and Objects

Master Database - An Overview of Some of the Common System Tables and Objects - view details
Veteran SQL trainer Scott Whigham shows you the details of the master database including a tour of the common tables (such as sysxlogins and sysconfigures), the system views (like syslogins) and the virtual tables that give performance information. You'll also learn about the system stored procedures (like sp_help, sp_helpdb and others) and much more. A must-watch-video for anyone wanting to know the sysinternals of SQL Server 2000
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: sql master database, sql architecture, sql system database

This video comes from the SQL Server 2000 DBA online training course, SQL Server 2000 Database Administration. And be sure to check out even more MSSQL Server 2000 training videos.

posted by Scott Whigham @ 3:53 AM  

SQL 2005 Reporting Services Video Tutorial: Pt. 2 - SQL Server Re porting Services Licensing and Editions

Pt. 2 - SQL Server Reporting Services Licensing and Editions - view details
This video continues where Part 1 left off: SQL Server Reporting Services licensing. Want to know what editions of SQL Server Reporting Services (SSRS) are available? What about how SSRS is licensed? This video is for you!

Highlights from this video:
  • Enterprise, Standard, Developer, Express, and Workgroup Editions
  • How SQL Server licensing works
  • CPU vs. Client Access Licenses (CALs)
  • Scale-out reporting requirements
and much more
To download this video, log in then then visit the video's detail page and click "downloa d".

Keywords for this video: introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies

This video comes from the SSRS 2005 online training course, SQL Server 2005 Reporting Services. And be sure to check out even more SQL 2005 Reporting Services training videos.

posted by Scott Whigham @ 2:53 AM  

Windows Server 2003 Video Tutorial: Install IIS and Test with Sim ple Web Page

Install IIS and Test with Simple Web Page - view details
This videos walks you through installing the web server for Windows, IIS (Internet Information Services) and helps you set up a simple test page to test the installation. Essential viewing for any administrator
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: web server Windows IIS, beginner, beginning, for beginners, introduction, step by step

This video comes from the Windows 2003 online training course, Windows Server 2003 Administration. And be sure to check out even more Windows Server 2003 training videos.

posted by Scott Whigham @ 1:53 AM  

Visual Basic Programming Video Tutorial: Pt. 2 - Options for Comm and Line Arguments

Pt. 2 - Options for Command Line Arguments - view details
Have you watched our video on how to create your own console application by just using notepad and the VB compiler? If so, then great because this video requires that you have that knowledge! In this video tutorial Scott will be discussing more options for working with command line arguments.

Highlights:

  • String/Parameter substitution methods
  • Changing foreground and background color of command prompt
  • Working with command line arguments
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: command line arguments, console application, string substituition, command prompt color,

This video comes from the Visual Basic .NET online training course, Visual Basic Programming with Visual Studio 2005. And be sure to check out even more Visual Basic Programming training videos.

posted by Scott Whigham @ 12:53 AM  

Monday, June 29, 2009

SQL 2005 Reporting Services Video Tutorial: Pt. 3 - Deploying Our Report Model and Creating Reports in Report Builder

Pt. 3 - Deploying Our Report Model and Creating Reports in Report Builder - view details
So we've just built our first Report Model and now it's time to deploy the Report Model to the Report Server, define security, and then let users create reports using the browser-based Report Builder. This video shows you exactly how easy it can be to deploy your model and create ad-hoc reports from it.
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: ad hoc, adhoc, ad-hoc, dynamically, beginning, beginner

This video comes from the SSRS 2005 online training course, SQL Server 2005 Reporting Services. And be sure to check out even more SQL 2005 Reporting Services training videos.

posted by Scott Whigham @ 11:53 PM  

C# Programming Video Tutorial: 1 - An Overview of How to Deploy Y our ASP.NET Websites and Using 'Publish Website'

1 - An Overview of How to Deploy Your ASP.NET Websites and Using 'Publish Website' - view details
You will learn about six of the various ways that you can deploy your ASP.NET website in this section. This first video focuses on the two easiest options: (1) serving a website from your development folder, and (2) using the 'Publish Website' screens inside theVisual Studio 2005 IDE.

If you are new to ASP.NET, you will want to watch all the videos in this section to gain an understanding of how xcopy deployment and various other techniques can be used to deploy your new ASP.NET websites.

Highlights from this video:
  • An overview of four possible wa ys to deploy and serve your website
  • Using the 'Publish Website' dialog box
  • Pros and Cons of using the above methods
  • Configuring IIS to server your ASP.NET website
and much more
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: deploy, deployment, xcopy, copy, install, installation, installing

This video comes from the C# online training course, C# Programming with Visual Studio 2005. And be sure to check out even more C# Programming training videos.

posted by Scott Whigham @ 10:53 PM  

MSSQL Programming and Query Writing Video Tutorial: Pt. 8 - Loadi ng an Empty Table With No Indexes vs. Empty Table With Indexes

Pt. 8 - Loading an Empty Table With No Indexes vs. Empty Table With Indexes - view details
This video will show you a comparison between running BCP to load with a table with no indexes and running with a single index.

Highlights:
  • What is clustered index order?
  • Run-time comparison
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: index, BCP, clustered index order, comparison, compare,

This video comes from the SQL Server Programming and Queries online training course, SQL Server Programming (SQL Server 2005/2000): Transact SQL . And be sure to check out even more MSSQL Programming and Query Writing training videos.

posted by Scott Whigham @ 9:53 PM  

SQL 2005 Reporting Services Video Tutorial: How to Remove/Uninsta ll Reporting Services Completely

How to Remove/Uninstall Reporting Services Completely - view details
This video tutorial will walk you through the tricky process of removing every aspect and trace of reporting services from your machine without removing your SQL Server.

Highlights from this video:

  • From where do I uninstall SSRS?
  • Clean-up work after the removal
  • How to tell if there was a successful uninstall

and much more!

To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: remove ssrs, reporting service uninstall, uninstallation, ssrs, remove reporting services,

This video comes from the SSRS 2005 online training course, SQL Server 2005 Reporting Services. And be sure to check out even more SQL 2005 Reporting Services training videos.

posted by Scott Whigham @ 8:53 PM  

MSSQL Programming and Query Writing Video Tutorial: SET Commands for Working with NULL values

SET Commands for Working with NULL values - view details
Do you know the difference between ANSI NULLS and ANSI NULL DEFAULT (or is there a difference)? If you aren't sure what an "ANSI" is, then you definitely will want to watch this video! If you have trouble with NULLs or just want a good explanation of what NULLs are and how three-valued logic works in relational databases, you'll also want to watch this video.

Highlights from this video:

  • Explanation of NULLs
  • Using SET commands and database options to control how SQL Server works with NULLs
  • Concatentation and arithmetic with NULL values
  • Changing the default behavior with CONCAT_NULL_YIELDS_NULL
  • ISNULL and COALESCE
  • Using "= NULL" and IS NULL
  • Determining SET options with DBCC USEROPTIONS
  • Defaults of SET options, database options and connection options
  • Variable assigment and whether unassigned variables are null, empty or 0

To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: SET ANSI_NULLS ON OFF

This video comes from the SQL Server Programming and Queries online training course, SQL Server Programming (SQL Server 2005/2000): Transact SQL. And be sure to check out even more MSSQL Programming and Query Writing training videos.

posted by Scott Whigham @ 7:53 PM  

MSSQL Server 2008 Video Tutorial: How to Configure SQL Server: Mo re on Network Protocols and Aliases

How to Configure SQL Server: More on Network Protocols and Aliases - view details
This video will provide you with a great demo of the Sql Server Configuration Manager, as well as things you may not have figured out on your own about the Configuration Manager��or may not have seen in regards to network protocols and aliases.

Highlights from this video:
  • About the��SQL Native Client
    • Shared memory
    • TCP/IP
    • Named pipes
  • What is an Alias?
    • Creating a new alias
  • Changing TCP/IP Ports
and much more
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: configuration manager, configure, alias, network protocol, tcp, port

This video comes from the SQL Server 2008 DBA online training course, SQL Server 2008 Database Administration. And be sure to check out even more MSSQL Server 2008 training videos.

posted by Scott Whigham @ 6:53 PM  

Windows Server 2003 Video Tutorial: Part 2 - WSUS 3.0 Configurati on 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 section 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
  • Classification s of updates
  • Setting your Sync scehdule
and much more!
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: wsus, windows server update services 3.0, wsus 3.0, windows server update service, configure wsus

This video comes from the Windows 2003 online training course, Windows Server 2003 Administration. And be sure to check out even more Windows Server 2003 training videos.

posted by Scott Whigham @ 5:53 PM  

MS Exchange 2007 Video Tutorial: Pt. 2 - Installing the Pre-Requi sites for Exchange 2007

Pt. 2 - Installing the Pre-Requisites for Exchange 2007 - view details
Hot fixes, updates, IIS, and more might await you after you run your Readiness Checks. This video walks you through each of these and talks about whether or not Exchange 2007 needs SMTP installed to run.
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: how to, guide, setup, set up, installation, installing, installed

This video comes from the Exchange 2007 online training course, Exchange Server 2007 Administration. And be sure to check out even more MS Exchange 2007 training videos.

posted by Scott Whigham @ 4:53 PM  

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

Part 2 - A Basic Walkthrough of the Built-In Tasks - view details
Part 2 - A Basic Walkthrough of the Built-In Tasks
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: Part 2 - A Basic Walkthrough of the Built-In Tasks, beginner, beginning, for beginners, introduction, step by step

This video comes from the SQL Server 2000 DTS online training course, SQL Server 2000 DTS. And be sure to check out even more MSSQL Server DTS training videos.

posted by Scott Whigham @ 3:53 PM  

MSSQL Server 2000 Video Tutorial: Pt. 3 - Input Parameters and Variables

Pt. 3 - Input Parameters and Variables - view details
The bulk of your stored procedures will be dynamic, meaning that they will have parameters and those parameters will be used to make decisions (such as what rows to return). This video talks about how to create parameters and variables as well as working with default parameters ( to make a parameter optional instead of required, for example).
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: declare, local variable, argument

This video comes from the SQL Server 2000 DBA online training course, SQL Server 2000 Database Administration. And be sure to check out even more MSSQL Server 2000 training videos.

posted by Scott Whigham @ 2:53 PM  

C# Programming Video Tutorial: Part 2 - Primitive Types in C#

Part 2 - Primitive Types in C# - view details
Continued in this second video in the section, Scott will talk about the numeric types in C# such as the integral types, which are integer based.

Highlights from this video:
  • Idea of Signed vs Unsigned types
  • Review of bytes and compiling
  • About the int/uint integral types and bytes of storage
  • About the short/ushort integral types and bytes of storage
  • About the long/ulong integral types
and much more
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: integer, numeric, type, datatype, signed,unsigned,integral,short,long,int, uint,ushort,ulong,, introduction, step by step, beginner, begin ning, for dummies

This video comes from the C# online training course, C# Programming with Visual Studio 2005. And be sure to check out even more C# Programming training videos.

posted by Scott Whigham @ 1:53 PM  

Windows Server 2003 Video Tutorial: Installing a New Hard Disk Drive

Installing a New Hard Disk Drive - view details
Grant Moyle walks you through adding new hard drives to your Windows Server 2003. Microsoft changed how hard drives are recognized in Windows Server 2003 and before you can use a new disk you must go through a few simple steps. In this video you'll learn how to assign drive letters and the basics of partitioning and formatting a new hard drive. Once you finish this video you'll be comfortable adding drives to your Windows 2003 Server. This video could've been titled 'Add a New Hard Drive to Your Server'
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: install new hard drive Windows, beginner, beginning, for beginners, introduction, step by step

This video comes from the W indows 2003 online training course, Windows Server 2003 Administration. And be sure to check out even more Windows Server 2003 training videos.

posted by Scott Whigham @ 12:53 PM  

SQL 2005 Integration Services Video Tutorial: Pt. 3 - Introductio n to SSIS Package Deployment

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

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

This video comes from the SSIS 2005 online training course, SQL Server 2005 Integration Services. And be sure to check out even more SQL 2005 Integration Services training videos.

posted by Scott Whigham @ 11:53 AM  

Visual Basic Programming Video Tutorial: Pt. 3 - Using Error Hand lers and Try/Catch Blocks in Visual Basic

Pt. 3 - Using Error Handlers and Try/Catch Blocks in Visual Basic - view details
This third video tutorial in the section will discuss how to use error handlers via Try/Catch blocks.

Highlights:

  • Managed/Structured exception handlers
  • What��can Try/Catch blocks do?
  • Property types in Try/Catch blocks
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: error handlers, Try/Catch blocks, managed exception handlers

This video comes from the Visual Basic .NET online training course, Visual Basic Programming with Visual Studio 2005. And be sure to check out even more Visual Basic Programming training videos.

posted by Scott Whigham @ 10:53 AM  

Windows Server 2003 Video Tutorial: Part 3 - WSUS 3.0 Infrastruct ure 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 section, 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 then visit the video's detail page and click "download".

Keywords for thi s video: wsus, windows server update services 3.0, wsus 3.0, windows server update service, infrastructure windows update service

This video comes from the Windows 2003 online training course, Windows Server 2003 Administration. And be sure to check out even more Windows Server 2003 training videos.

posted by Scott Whigham @ 9:53 AM  

MS Exchange 2007 Video Tutorial: Enable and Test Exchange Journal ing in Exchange 2007

Enable and Test Exchange Journaling in Exchange 2007 - view details
Many organizations require the ability to 'journal' messages - in other words, they want to be able to keep track of messages as they come in or go out (i.e., an audit). Some organizations even spend millions on message auditing in Exchange 2007.

Highlights from this video:
  • Setting up Journal rules
  • How journaling works in Exchange 2007
  • Best Practices for journaling and auditing in Exchange 2007
and much more
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: audits, C@, comm on criteria, compliance

This video comes from the Exchange 2007 online training course, Exchange Server 2007 Administration. And be sure to check out even more MS Exchange 2007 training videos.

posted by Scott Whigham @ 8:53 AM  

SQL 2005 Reporting Services Video Tutorial: Part 2 - Creating a D rillthrough 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 section, 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 then visit the video's detail page and click "download".

Keywords for this video: drill through, drillthrough, report, customize report, report appearance,

This video comes from the SSRS 2005 online training course, SQL Server 2005 Reporting Services. And be sure to check out even more SQL 2005 Reporting Services training videos.

posted by Scott Whigham @ 7:53 AM  

MSSQL Server 2005 Video Tutorial: Pt. 5 - How to Install and Use the SQL Server 2005 Performance Dashboard Reports

Pt. 5 - How to Install and Use the SQL Server 2005 Performance Dashboard Reports - view details
This fifth video of a five video section about the newest features in Service Pack 2 (SP2) trains us on how to properly download and install the performance dashboard. Scott Whigham unleashes his years of knowledge and training skills when he teaches about the performance dashboard and what it can and will do for us in our SQL endeavors. You can expect to learn about the following in this astounding video:
  • Searching for the performance dashboard correctly
  • highlights on installation location
  • Step by step installation
  • Feature update on SQL Server SP2
  • Basic explanation of the SETUP.SQL file for the performance dashboard
  • Proper shortcut creation
  • Common frustratingn real world error preventing the performance dashboard reports from running properly
  • Proper troubleshooting of a very common and frustrating error
    • There is no resolution to this error provided in the video however the resolution to the error is to run the performance_dashboard_main.rdl before you run any of the other RDL files.
This video takes you step by step through the download and installation of the performance dashboards. This video does have an error within it and will teach you the proper troubleshooting techniques in an attempt to rectify that error. You will learn everything you need to know about downloading, installing, and using the performance dashboard from this video. This will help and train the beginner, intermediate or any user that wishes to learn more about the performance dashboard in general.

NOTE: This video's de scription was written by one of our members, Wayne Leiser. Thanks, Wayne!
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: Performance Dashboard Reports, performance dashboard, SP2

This video comes from the SQL Server 2005 DBA online training course, SQL Server 2005 Database Administration. And be sure to check out even more MSSQL Server 2005 training videos.

posted by Scott Whigham @ 6:53 AM  

MS Exchange 2003 Video Tutorial: Configure and Use OMA - Outlook Mobile Access

Configure and Use OMA - Outlook Mobile Access - view details
OMA (Outlook Mobile Access) is designed for users with very small displays: cell phones, PDAs, and other small devices. This video shows you how to configure Exchange to enabled Outlook Mobile Access and enabling unsupported devices and mobile devices.
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: Outlook Mobile Access configuration, OMA config

This video comes from the Exchange 2003 online training course, Exchange Server 2003 Administration. And be sure to check out even more MS Exchange 2003 training videos.

posted by Scott Whigham @ 5:53 AM  

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

MSDB Database - An Overview of Some of the Common System Tables and Objects - view details
The MSDB database is one of the heaviest-used system databases. It stores everything from DTS packages to Jobs (and the history of each). This video walks you through the common tables (what are those RTBl_% tables anyway?), the common stored procedures and gives you an excellent insight into how SQL Server works
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: sql system db, msdb

This video comes from the SQL Server 2000 DBA online training course, SQL Server 2000 Database Administration. And be sure to check out even more MSSQL Server 2000 training videos.

posted by Scott Whigham @ 4:53 AM  

MSSQL Programming and Query Writing Video Tutorial: Pt. 1 - Insta llation and Configuration of the SQL Server 2005 Sample Applications for S QL, Reporting Services, C#, VB, and SSIS

Pt. 1 - Installation and Configuration of the SQL Server 2005 Sample Applications for SQL, Reporting Services, C#, VB, and SSIS - view details
This video (part one in this section) helps you install and, most importantly, configure the sample applications. It provides an overview of some of the common/best samples as well as discussions on when to use each.
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: sql server sample applications, sample databases, integrated samples

This video comes from the SQL Server Programming and Queries online training course, SQL Server P rogramming (SQL Server 2005/2000): Transact SQL. And be sure to check out even more MSSQL Programming and Query Writing training videos.

posted by Scott Whigham @ 3:53 AM  

MS Exchange 2007 Video Tutorial: How to Build a Custom Address Li st With Windows Power Shell

How to Build a Custom Address List With Windows Power Shell - view details
Do you feel that the current address list builder in Exchange 2007 is not as good as you might have had in the Exchange 2003? In this video tutorial, Grant will show you how you can build intricate,custom address lists with Windows Power Shell, which will give you more flexibility in creating your address lists.

Highlights from this video:
  • Creating new address list with address list wizard
  • Assigning/working with custom attributes
  • Creating/updating address lists in Power Shell
  • GUI vs EMS
and more!
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: custom address list, power shell, address list,

This video comes from the Exchange 2007 online training course, Exchange Server 2007 Administration. And be sure to check out even more MS Exchange 2007 training videos.

posted by Scott Whigham @ 2:53 AM  

Windows Server 2008 Video Tutorial: Windows Server 2008 Core Inst allation Basic Management

Windows Server 2008 Core Installation Basic Management - view details
Once you have a core server installation completed, there's probably a few housekeeping items you'll need to take care of. In this video we'll cover some of those basic post-install steps.


Highlights from this video:

  • Changing the name of a server core
  • Assigning a static IP address
  • How to join the server core to an Active Directory domain
  • Enabling ICMP to allow the server core to respond to PING
and much more
To download this video, log in then then visit t he video's detail page and click "download".

Keywords for this video: windows server, 2008, server core, management, active directory, icmp, assign ip address

This video comes from the Windows 2008 online training course, Windows Server 2008 Administration. And be sure to check out even more Windows Server 2008 training videos.

posted by Scott Whigham @ 1:53 AM  

MSSQL Server 2008 Video Tutorial: Things You Have to Know Before You Install SQL Server - Part 3

Things You Have to Know Before You Install SQL Server - Part 3 - view details
We will continue our discussion on what you need to know before you install SQL Server 2008 by covering the topic of security models, account provisioning, and we'll wrap up with a brief discussion on��some of the best practices for SQL security.

Highlights from this video:
  • Two security model choices:Windows Authentication or Mixed Mode
    • Examples of when to use, Pros and cons
  • Account provisioning
    • What domain accounts do you want them to run under?
  • Best practices and suggestions for security at the service level
    • Principle of least privilege
    • Separate accounts and instancing
  • About the SQL Server Database Engine
    • Domain account
    • Assigning additional permissions
and much more
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: install, sql, 2008, prereq, security, windows authentication, mixed mode, account provisioning, database engine, introduction, step by step, beginner, beginning, for dummies

This video comes from the SQL Server 2008 DBA online training course, SQL Server 2008 Database Administration. And be sure to check out even more MSSQL Server 2008 training videos.

posted by Scott Whigham @ 12:53 AM  

Sunday, June 28, 2009

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

Pt. 3 - More on Managing DFS Replication - view details
This video is a continuation of the 2nd video in this section on DFS Replication. This video discusses scheduling, optimizations, and other tools you can use to manage DFS replication.
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: dfs, distributed file system, replication, replicate, replicating, shared folders

This video comes from the Windows 2003 online training course, Windows Server 2003 Administration. And be sure to check out even more Windows Server 2003 training videos.

posted by Scott Whigham @ 11:53 PM  

MSSQL Server 2005 Video Tutorial: Part 2 - My How Things Have Cha nged - A Video Walk-Through of Some of the New Tools with SQL Server 2005

Part 2 - My How Things Have Changed - A Video Walk-Through of Some of the New Tools with SQL Server 2005 - view details
Part 2 in our section on What's New in SQL Server 2005's Toolbox, Scott Whigham walks you through a few more important tools and changes in SQL Server 2005.
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: change sql 2005, new sql 2005, feature sql 2005

This video comes from the SQL Server 2005 DBA online training course, SQL Server 2005 Database Administration. And be sure to check out even more MSSQL Server 2005 training videos.

posted by Scott Whigham @ 10:53 PM  

Windows Server 2003 Video Tutorial: Managing Policies with the Gr oup Policy Management Console (GPMC)

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

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

< ul>
  • Source: http://www.learnitfirst.com/Course/232/Video/523/Managing-Policies-with-the-Group-Policy-Management-Console-GPMC.aspx
  • Course: http://www.learnitfirst.com/Course/232/Windows-2003.aspx
  • Skill Level: 300 (Intermediate)
  • Length: 7:15 (5.40MB)
  • Full Details
    • To download this video, log in then then visit the video's detail page and click "download".

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

    This video comes from the Windows 2003 online training course, Windows Server 2003 Administration. And be sure to check out even more Windows Server 2003 training videos.

    posted by Scott Whigham @ 9:54 PM  

    Windows Server 2003 Video Tutorial: Differences Between Windows V ista Editions

    Differences Between Windows Vista Editions - view details
    This video is a detailed discussion of what the differences are between Windows Ultimate, Home, Home Premium, and Business Editions are as well as suggestions for Best Practices.

    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: differences, editions, versions, vista, xp

    This video comes from the Windows 2003 online training course, Windows Server 2003 Administration. And be sure to check out even more Windows Server 2003 training videos.

    posted by Scott Whigham @ 8:53 PM  

    SQL 2005 Integration Services Video Tutorial: Pt. 9 - BULK INSERT and the OPENROWSET Functions as Alternatives to BCP

    Pt. 9 - BULK INSERT and the OPENROWSET Functions as Alternatives to BCP - view details
    This video will be discussing�� the details of the BULK INSERT and OPENROWSET functions, as well as comparing them back against BCP

    Highlights:
    • BULK INSERT syntax
    • Using books online for OPENROWSET
    • Comparison of OPENROWSET, BULK INSERT, and BCP timing
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: BULK INSERT, OPENROWSET,BCP, functions, timing, compare, comparison, syntax

    This video comes from the SSIS 2005 online training course, SQL Server 2005 Integratio n Services. And be sure to check out even more SQL 2005 Integration Services training videos.

    posted by Scott Whigham @ 7:54 PM  

    SharePoint (MOSS/WSS) Video Tutorial: Delete a Site From a Site Collection and Attempt to Recover Site

    Delete a Site From a Site Collection and Attempt to Recover Site - view details
    An important part of your role as SharePoint administrator is keeping your SharePoint server up to date and, periodically, that includes removing sites and site collections.

    Highlights from this video:
    • How to permanently delete a site
    • Concepts of restoring a site
    • How the SharePoint recycle bin can save you
    and much more
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: backup, backing up, disaster recovery, restoring, restored, lists, ite ms

    This video comes from the SharePoint 2007 online training course, Building Portals with SharePoint 2007. And be sure to check out even more SharePoint (MOSS/WSS) training videos.

    posted by Scott Whigham @ 6:54 PM  

    Windows Server 2003 Video Tutorial: Microsoft Firewall: Configura tion and Setup for Windows 2003

    Microsoft Firewall: Configuration and Setup for Windows 2003 - view details
    If you need to protect LAN and WAN connections incoming and outgoing to/from your Windows 2003 machine then Windows Firewall might be an option. While this is in no way a replacement for your hardware-based firewalls Microsoft's Windows Firewall may be an excellent choice to protect inter-network activity. This video shows you how to configure Windows Firewall for a File and Print server. This video could also be titled 'How to Use Microsoft Windows Firewall on Your Network'
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: Windows Firewall Configuration, Windows Firewall Windows 2003

    This video comes from the Windows 2003 online training course, Windows Server 2003 Administration. And be sure to check out even more Windows Server 2003 training videos.

    posted by Scott Whigham @ 5:53 PM  

    MSSQL Server 2005 Video Tutorial: Building a Custom MMC for Use with SQL

    Building a Custom MMC for Use with SQL - view details
    In this video tutorial, Scott will demonstrate to you how to build a custom Microsoft Mangement Console and customize it to fit your needs!

    Highlights from this video:
    • Launching your own custom MMC
    • Adding and removing snap-ins to your console
    • About the avaliable snap-ins
    and more!
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: mmc, microsoft management console, build mmc,

    This video comes from the SQL Server 2005 DBA online training course, SQL Server 2005 Database Administration. And be sure to check out even more MSSQL Server 2005 training videos.

    posted by Scott Whigham @ 4:53 PM  

    SharePoint (MOSS/WSS) Video Tutorial: Part 2B - Request an SSL C ertificate From a Trusted Certificate Authority

    Part 2B - Request an SSL Certificate From a Trusted Certificate Authority - view details
    Now that you have your requests submitted, you'll need to apply the certificates and import them into IIS. This video shows you how to import your new SSL certificate into IIS in either base-64 encoded format or as a .pfx or .cer file.

    Highlights from this video:
    • How to import your new certificate into IIS
    • How to apply certificate to IIS website for SharePoint
    • Configuring IIS for secure communication
    and much more
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: ssl, security, security best practices, certificates, certificate authority, trusted root certificates

    This video comes from the SharePoint 2007 online training course, Building Portals with SharePoint 2007. And be sure to check out even more SharePoint (MOSS/WSS) training videos.

    posted by Scott Whigham @ 3:53 PM  

    Visual Basic Programming Video Tutorial: Installing Visual Studio and SQL Server Express Edition - Part 1

    Installing Visual Studio and SQL Server Express Edition - Part 1 - view details
    This introductory video talks to you about the Visual Studio and SQL Server Express Editions - the FREE editions of SQL Server and C#/Visual Basic (among others).

    Highlights from this video:
    • Compare and contrast various Express Editions
    • Limitations of certain Express Editions
    • Updating the Express Editions
    and much more.

    If you are new to C#/SQL Server, THIS IS A GREAT FIRST VIDEO TO WATCH!

    NOTE: This video is nearly identical to the 'What Are the Express Edit ions?' video
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: beginner, beginning, intro, introduction, msde, starter

    This video comes from the Visual Basic .NET online training course, Visual Basic Programming with Visual Studio 2005. And be sure to check out even more Visual Basic Programming training videos.

    posted by Scott Whigham @ 2:53 PM  

    SQL 2005 Reporting Services Video Tutorial: Pt. 5 - Using SQL Ser ver Management Studio to Manage Reporting Services

    Pt. 5 - Using SQL Server Management Studio to Manage Reporting Services - view details
    This final video in this section will go into more depth about the SQL Server Management Studio, which you will find you'll be spending a lot of time working with. This video will show you how to use SSMS to manage your reporting services.

    Higlights:

    • Launching SSMS
    • Adding new data source
    • Management Service vs Web Service

    and much more!

    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: ssms, sql server managem ent studio, intro ssms, datasource, web service, management studio, shared schedule, report server, report

    This video comes from the SSRS 2005 online training course, SQL Server 2005 Reporting Services. And be sure to check out even more SQL 2005 Reporting Services training videos.

    posted by Scott Whigham @ 1:53 PM  

    MSSQL Server DTS Video Tutorial: Pt. 3 - In Place Upgrade of SQL Server 2000 DTS to SQL Server 2005 SSIS

    Pt. 3 - In Place Upgrade of SQL Server 2000 DTS to SQL Server 2005 SSIS - view details
    This video covers how to edit your Legacy packages inside the BIDS (Business Intelligence Development Studio). You'll need to watch this to get the full picture of working with SSIS.
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: upgrading, upgrade, migrating, data transformation services, migrate

    This video comes from the SQL Server 2000 DTS online training course, SQL Server 2000 DTS. And be sure to check out even more MSSQL Server DTS training videos.

    posted by Scott Whigham @ 12:53 PM  

    SharePoint (MOSS/WSS) Video Tutorial: Comparing Management Diffe rences Using Central Administration Utility

    Comparing Management Differences Using Central Administration Utility - view details
    In this video tutorial, your instructor Grant will demonstrate the basic differences in Sharepoint 3.0 Central Administration��for WSS (Windows Sharepoint Server)��and MOSS (Microsoft Office Sharepoint Server) via walking you through their respective interfaces.

    Highlights from this video:
    • Shared Services administration in MOSS
    • What components are different between the two?
    • Farm security configuration
    • MOSS Upgrade and Migration

    ��

    and much more
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: moss, wss, differences, comparing, compare, management, central admin, introduction, step by step, beginner, beginning, for dummies

    This video comes from the SharePoint 2007 online training course, Building Portals with SharePoint 2007. And be sure to check out even more SharePoint (MOSS/WSS) training videos.

    posted by Scott Whigham @ 11:53 AM  

    Windows Server 2008 Video Tutorial: How Windows Time Syncronizati on Works and How to Control Time in Windows Server 2008 Domains

    How Windows Time Syncronization Works and How to Control Time in Windows Server 2008 Domains - view details
    By default, Windows 2008 will keep time sychronized among all domain controllers and workstations. In every Active Directory domain, there is one domain controller with the role of PDC Emulator. This role will come in handy when it comes to time synchronization in a Windows Server 2008 network. But what happens when we change the time? In this video, Grant will show you how the system re-syncs the time as well as take a look at the infrastructure.

    Highlights from this video:
    • About the PDC Emulator, an FSMO
    • How can I make sure my PDC Emulator has good time?
    • Time synchronizing events
    and much more
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: time synchronization, time, windows, server, 2008, pdc emulator, synchronize

    This video comes from the Windows 2008 online training course, Windows Server 2008 Administration. And be sure to check out even more Windows Server 2008 training videos.

    posted by Scott Whigham @ 10:53 AM  

    MSSQL Server DTS Video Tutorial: Excel Named Ranges (Named Region s) - How to Import Into SQL Server Using DTS

    Excel Named Ranges (Named Regions) - How to Import Into SQL Server Using DTS - view details
    This video could be subtitled, 'How to Import Very Complex Excel Spreadsheets into SQL Server the Easy Way' just for easier classification.

    In this example, you'll learn how to deal with worksheets that have multiple data sets on them (multiple named ranges) so that you can load these into SQL Server. This is absolutely essential knowledge for anyone who works seriously with DTS! This video uses a complex Excel example and loads it into multiple SQL Server tables in one DTS package using the Import/Export wizard.

    Highlights from this video:
    • Creating and managing named ranges in Microsoft Excel
    • Dealing with complex Excel spreadsheets and locating just one piece of data
    • Writing JOIN queries in Jet-SQL using the Query Builder
    • Best Practices for datatype mapping from Excel to SQL Server
    • Adding primary keys to the destination table
    • Writing ActiveX Script transformations using VBscript
    • Dealing with Sheet1$, Customers$, Orders$ and worksheets
    and much more
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: named region, named range, set of cells, named cells, excel data, excel spreadsheet, subset, data type

    This video comes from the SQL Server 2000 DTS online training course, SQL Server 2000 DTS. And be sure to check out even more MSSQL Server DTS training vid eos.

    posted by Scott Whigham @ 9:53 AM  

    SharePoint (MOSS/WSS) Video Tutorial: How to Take a Backup of Yo ur SharePoint Site

    How to Take a Backup of Your SharePoint Site - view details
    This video shows you how to backup your SharePoint site using the SharePoint 3.0 Central Administration tool.

    Highlights from this video:
    • Understanding the index structure, page structure, farm structure and more in the Backup Wizard
    • Discussions of the Full and Differential backup types
    • Backing up to local directories and remote locations
    • Best Practices for SharePoint backups
    • How to verify your SharePoint backups have completed
    • How SharePoint jobs work
    and much more
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: backup, backing up, disas ter recovery

    This video comes from the SharePoint 2007 online training course, Building Portals with SharePoint 2007. And be sure to check out even more SharePoint (MOSS/WSS) training videos.

    posted by Scott Whigham @ 8:53 AM  

    SharePoint (MOSS/WSS) Video Tutorial: Part 2 - Small Business Se rver 2003: How to Install Windows SharePoint Services 3.0 on SBS 2003

    Part 2 - Small Business Server 2003: How to Install Windows SharePoint Services 3.0 on SBS 2003 - view details
    In this second half of the video section and installation process, your instructor will finish configuring SharePoint 3.0 and show you how to run both versions side-by-side.

    Highlights from this video:

    • Where did my old SBS site go?
    • Building a new SharePoint site/site collection��for 3.0 content
    • Restoring original 2.0 site

    and much more!

    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: sbs2003, windows small business server, paral lel install, upgrade share point, 3.0, 2.0

    This video comes from the SharePoint 2007 online training course, Building Portals with SharePoint 2007. And be sure to check out even more SharePoint (MOSS/WSS) training videos.

    posted by Scott Whigham @ 7:53 AM  

    MSSQL Server 2008 Video Tutorial: Creating SQL Server Databases - Part 10

    Creating SQL Server Databases - Part 10 - view details
    In our final video in this section, we will walk through the process of deleting/removing a file from a database as it is not as simple as you would think.

    Highlights from this video:
    • Setting up files to delete
    • Typical error message received when trying to delete a file
    • How do I empty a file so it is safe to delete?
    • Deleting the file

    ��

    and much more
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: empty, delete, file, create, database, sql, server, 2008

    This video comes from the SQL Server 2008 DBA online training course, SQL Server 2008 Database Administration. And be sure to check out even more MSSQL Server 2008 training videos.

    posted by Scott Whigham @ 6:53 AM  

    SQL 2005 Integration Services Video Tutorial: Pt. 3 - Using Proxi es and Credentials When Scheduling Your SSIS Package As a SQL Server Job

    Pt. 3 - Using Proxies and Credentials When Scheduling Your SSIS Package As a SQL Server Job - view details
    Ever wonder how you can simplify privileges when scheduling your SQL Server Integration Serivices package as a SQL Server job? In this thrid video tutorial in the section, Scott will demonstrate how you can do so by assigning proxies and creating credentials.
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: proxy,credentials,proxies,credentials, job, package

    This video comes from the SSIS 2005 online training course, SQL Server 2005 Integration Services . And be sure to check out even more SQL 2005 Integration Services training videos.

    posted by Scott Whigham @ 5:53 AM  

    MS Exchange 2007 Video Tutorial: How to Configure Anti-SPAM On a Hub Transport Server

    How to Configure Anti-SPAM On a Hub Transport Server - view details
    Are you in need of some help in configuring your Anti-SPAM capabilities on your Hub Transport Server? In this great video tutorial, Grant Moyle will help you to do so, as well as detail the various anti-SPAM features.

    Highlights from this video:
    • About anti-SPAM capabilities
      • Content Filtering
      • IP Allow List
      • IP Allow List Providers
      • IP Block List
      • IP Block List Providers
      • Recipient Filtering
      • Sender Filtering
      • Sender ID
      • Sender Reputation
    • Customizing feature properties
    • Filtering and defining SCL, Spam Confidence Level, thresholds
    and more!
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: Configure Anti-SPAM , antispam, anti spam

    This video comes from the Exchange 2007 online training course, Exchange Server 2007 Administration. And be sure to check out even more MS Exchange 2007 training videos.

    posted by Scott Whigham @ 4:53 AM  

    SQL 2005 Integration Services Video Tutorial: Pt. 2 - An Overview of the Various Scenarios and Tools Available for Bulk Loads

    Pt. 2 - An Overview of the Various Scenarios and Tools Available for Bulk Loads - view details
    This video will present you with the different basic and loading scenarios that you have to work with when doing bulk operations in SQL server

    Highlights:
    • Possible scenarios
    • What is BCP?
    • Advantages of using Bulk Insert over BCP
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: bulk insert, bcp, loading scenario, bulk operations

    This video comes from the SSIS 2005 online training course, SQL Server 2005 Integration Services. And be sure to check out even more SQL 2005 Integration Services training videos.

    posted by Scott Whigham @ 3:53 AM  

    MSSQL Server 2005 Video Tutorial: Part1 - Dynamic Management View s (DMVs) for Monitoring Users and Transactions

    Part1 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions - view details
    In this first video of the section you will be working with multiple connections, troubleshooting locks and blocks in your server, as well as learn who is doing what with your system by going beyond the Activity Monitor and taking advantage of the Dynamic Management Views, DMVs.

    Highlights from this video:
    • Problems with the Activity Monitor
    • Using Filter setting in the Activity Monitor
    • About the DMV categories
    and more!
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: dynamic management view, DMV, lock, block, activity monitor,

    This video comes from the SQL Server 2005 DBA online training course, SQL Server 2005 Database Administration. And be sure to check out even more MSSQL Server 2005 training videos.

    posted by Scott Whigham @ 2:53 AM  

    Visual Basic Programming Video Tutorial: Pt. 2 - Installing VS200 5 Team Suite Edition

    Pt. 2 - Installing VS2005 Team Suite Edition - view details
    This video will wrap up the tedious installaton process for Visual Studio 2005 Team Suite Edition and give you an idea of what VS2005 looks like inside.

    Highlights:

    • VS2005 and Windows Vista compatibility issues
    • Resolving application errors
    • What service packs do I need to download?

    ��

    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: team suite edition, vista, compatibility, application error, service pack

    This video comes from the Visual Basic .NET online training course, Visual Basic Programming with Visual Studio 2005. And be sure to check out even more Visual Basic Programming training videos.

    posted by Scott Whigham @ 1:53 AM  

    MSSQL Server 2005 Video Tutorial: Part 1: How to View Members of a Windows Group Using SQL

    Part 1: How to View Members of a Windows Group Using SQL - view details
    In many large environments we often see that there are a lot of Windows groups in your SQL server as logins, but do you know exactly who the users are of those groups? Consider also the servers with Windows Groups that are part of the system administrator roleand the power that they have. How can you tell which Windows users are actually the members of that group? In this video tutorial, Scott will show you a great script in SSMS that will show you how to determine the members of Windows Groups, as well as some other fun things you can do with the procedure.

    Highlights from this video:
    • Identifying groups vs users, adding new Windows group s as logins to SQL Server
    • Login limitations in SSMS ( SQL Server Management Studio)
    • Executing the user-identifying stored procedure
    • Adjusting the parameters of the stored procedure
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: windows groups, windows users, sql login, view members, view user, management studio,

    This video comes from the SQL Server 2005 DBA online training course, SQL Server 2005 Database Administration. And be sure to check out even more MSSQL Server 2005 training videos.

    posted by Scott Whigham @ 12:53 AM  

    Saturday, June 27, 2009

    MSSQL Programming and Query Writing Video Tutorial: Why You Need to Refresh Your Views After Adding Columns to a Table, Part 1

    Why You Need to Refresh Your Views After Adding Columns to a Table, Part 1 - view details
    Have you ever found yourself working in a table where you made a change to that table and now your view of the data does not reflect the changes? After you add a column to a table, the view you created will not pickup the changes. In this first video in the section Scott will set-up the situation and demonstrate the discrepancy between the table and the view. In later videos he will demonstrate who goes on behind the scenes and show you some suggested fixes.

    Highlights from this video:
    • Setting up the table and view
    • Modifying the table
    • Table vs View: Updated data
    and much mo re
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: table, view, metadata, sql, server, tsql, t-sql, column, , introduction, step by step, beginner, beginning, for dummies

    This video comes from the SQL Server Programming and Queries online training course, SQL Server Programming (SQL Server 2005/2000): Transact SQL. And be sure to check out even more MSSQL Programming and Query Writing training videos.

    posted by Scott Whigham @ 11:53 PM  

    SQL 2005 Integration Services Video Tutorial: Part 3 - The SSIS C ontainers: Containers and the Task Host Container

    Part 3 - The SSIS Containers: Containers and the Task Host Container - view details
    In this video, we will talk about the containers by taking��a quick look at the three containers built into SSIS��as well as detail one that is kind of hidden. But what exactly is a container? The answer to this question and many more will be covered in this video tutorial

    Highlights from this video:
    • Container functionality
      • Container logic flow
    • Event-handlers and variables
    • The concept of Scoping
    • Container object: Task host container
      • What it is
      • Who uses it
      • What it does
    and much more
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: toolbox, bids, bi, business intelligence, studio, project, designer, container, development, introduction, step by step, beginner, beginning, for dummies

    This video comes from the SSIS 2005 online training course, SQL Server 2005 Integration Services. And be sure to check out even more SQL 2005 Integration Services training videos.

    posted by Scott Whigham @ 10:53 PM  

    Visual Basic Programming Video Tutorial: Pt. 2 - More Controls an d Design-Time vs. Runtime

    Pt. 2 - More Controls and Design-Time vs. Runtime - view details
    This video will continue where part 1 left off by discussing more controls found in the toolbox as well as design time vs. runtime

    Highlights:

    • Checkbox property desciptions, three state
    • What is a Combo box, Radio Button?
    • Advantages of a Panel
    • How to use a Tab Control
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: windows application, toolbox, panel, combo box, radio button, tab control, design-time , runtime,customize

    This video comes from the Visual Basic .NET online training course, Visual Basic Programming with Visual Studio 2005. And be sure to check out even more Visual Basic Programming training videos.

    posted by Scott Whigham @ 9:53 PM  

    Windows Server 2003 Video Tutorial: Using and Enabling the Themes Service in Windows 2003

    Using and Enabling the Themes Service in Windows 2003 - view details
    This video is particularly helpful for those of you who run Windows Server 2003 on your desktop/laptop. This is part of a set of videos on configuring your machine to run best for desktop/laptop use. This features the Themes Service, a feature that first appeared in Windows XP, and discusses how to enable the Themes Service for Windows Server 2003. If you've ever wondered exactly how Themes work in Windows this is the video for you!
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: Themes Service Windows 2003, beginner, beginning, for beginners, introduction, step by step

    This video comes from the Windows 2003 online training course, Windows Server 2003 Administration. And be sure to check out even more Windows Server 2003 training videos.

    posted by Scott Whigham @ 8:53 PM  

    Windows Server 2003 Video Tutorial: Enable and Test Account Locko ut 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 then visit the video's detail page and click "download".

    Keywords for this video: account lockout, active directory, user, lockout, introduction, step by step, beginner, beginning, for dummies

    This video comes from the Windows 2003 online training course, Windows Server 2003 Administration. And be sure to check out even more Windows Server 2003 training videos.

    posted by Scott Whigham @ 7:53 PM  

    C# Programming Video Tutorial: Pt. 5 - How to Setup and Configure Your First NUnit Project

    Pt. 5 - How to Setup and Configure Your First NUnit Project - view details
    This video will show you how you can get your project up and running with NUnit and how to install and configure NUnit for your applications.

    Highlights:

    • Book suggestions
    • Creating TestFixture and Test method using NUnit
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: setup, configure, NUnit, unit testing, install, testfixture, test method

    This video comes from the C# online training course, C# Programming with Visual Studio 2005. And be sure to check out even more C# Programming training videos.

    posted by Scott Whigham @ 6:53 PM  

    MSSQL Server 2008 Video Tutorial: How to Configure a SQL Server D atabase - Part 3

    How to Configure a SQL Server Database - Part 3 - view details
    In this third video in our section, we will discuss the large Miscellaneous category of configurations

    Highlights from this video:
    • Settings and overriding instance-level defaults
    • Database-specific settings
      • Date Correlation Optimization Enabled
      • VarDecimal Storage Format Enabled
    • About Parameterization
      • Simple parameterization
      • Forced parameterization
    and much more
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: sql, server, database, db, configure, configuring, configuration, miscellaneous, data base

    This video comes from the SQL Server 2008 DBA online training course, SQL Server 2008 Database Administration. And be sure to check out even more MSSQL Server 2008 training videos.

    posted by Scott Whigham @ 5:53 PM  

    Windows Server 2003 Video Tutorial: File Server Resource Manager (FSRM) Storage Reports and Management

    File Server Resource Manager (FSRM) Storage Reports and Management - view details
    One fantastic feature of the File Server Resource Manager is that you can create usage reports detailing file server information from multiple servers. Watch this video to get the details on creating FSRM reports
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: generate fsrm reports, create fsrm reports

    This video comes from the Windows 2003 online training course, Windows Server 2003 Administration. And be sure to check out ev en more Windows Server 2003 training videos.

    posted by Scott Whigham @ 4:53 PM  

    Windows Server 2003 Video Tutorial: Remote Desktop: Tuning and Pe rformance

    Remote Desktop: Tuning and Performance - view details
    Remote Desktop allows an administrator to work with a user to help diagnose problems and work together. This video helps you understand the differences between Remote Desktop and Terminal Services as well as going through the configuration of Remote Desktop. You'll also receive some great performance-enhancing tips (performance tuning) from veteran Windows trainer, Grant Moyle
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: remote desktop performance tuning, terminal service, remote desktop, performance, tuning,

    This video comes from the Windows 2003 online training course, Windows Server 2003 Administ ration. And be sure to check out even more Windows Server 2003 training videos.

    posted by Scott Whigham @ 3:53 PM  

    C# Programming Video Tutorial: Pt. 7 - A Quick Tour of the Standa rd Controls

    Pt. 7 - A Quick Tour of the Standard Controls - view details
    Covered in this video will be a quick closeout of the different elements in VS2005. This video tutorial will wrap up the tour of the standard controls in Visual Studio 2005

    Highlights:

    • Advantages of dragging an image vs an HTML tag
    • Running a table tag
    • What is a HiddenField?
    • How to customize calendar objects
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: panel, placeholder, radio button, dropdownlist, controls

    This video comes from the C# online training course, C# Programming with Visual Studio 2005. And be sure to check out even more C# Programming training videos.

    posted by Scott Whigham @ 2:53 PM  

    Windows Server 2003 Video Tutorial: Join Windows XP to the Domain

    Join Windows XP to the Domain - view details
    A quick video designed to show you how to join a computer to a domain and the benefits of doing so
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: join computer to Windows 2003 domain, beginner, beginning, for beginners, introduction, step by step

    This video comes from the Windows 2003 online training course, Windows Server 2003 Administration. And be sure to check out even more Windows Server 2003 training videos.

    posted by Scott Whigham @ 1:53 PM  

    MS Exchange 2003 Video Tutorial: Building a New User With Mailbox

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

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

    This video comes from the Exchange 2003 online training course, Exchange Server 2003 Administration. And be sure to check out even more MS Exchange 2003 training videos.

    posted by Scott Whigham @ 12:53 PM  

    MS Exchange 2003 Video Tutorial: Storage Groups: What Are They an d How They Work

    Storage Groups: What Are They and How They Work - view details
    Storage Groups are inherent to Microsoft Exchange and learning the details on storage groups is a requirement for all Exchange administrators. This excellent video from Exchange guru Grant Moyle is a great tutorial on working with storage groups and the differences between the Standard and Enterprise editions with respect to working with storage groups.
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: understanding Exchange storage groups, exchange storage group tutorial, how to work with Exchange storage groups, beginner, beginning, for beginners, introduction, step by step

    This video comes from the Exchange 2 003 online training course, Exchange Server 2003 Administration. And be sure to check out even more MS Exchange 2003 training videos.

    posted by Scott Whigham @ 11:53 AM  

    MSSQL Programming and Query Writing Video Tutorial: Pt. 3 - A Sto red Procedure and Function to Return All Objects in a Given Schema

    Pt. 3 - A Stored Procedure and Function to Return All Objects in a Given Schema - view details
    Now that you have dbo.Split() created, you'll want to use it, right? This video shows you one of Scott Whigham's scripts for returning all objects in a schema. This uses dbo.Split(), the dbo.SequenceNumbers table from Part 1 of this section, and sys.objects to return all of the objects in specified schema.

    So why is this stored proc/function here in our discussion of a table of numbers and how to work with arrays? The GetObejctsInSchema stored proc has a parameter, @ObjectTypesToExclude, that allows you to specify the object types you do not want to see. You then use dbo.Split() to return each as an ele ment and then pass your array to a NOT IN statement!
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: arrays, sequence numbers, csv, comma separated values

    This video comes from the SQL Server Programming and Queries online training course, SQL Server Programming (SQL Server 2005/2000): Transact SQL. And be sure to check out even more MSSQL Programming and Query Writing training videos.

    posted by Scott Whigham @ 10:53 AM  

    Windows Server 2008 Video Tutorial: Introduction to Internet Info rmation Services 7.0 Management

    Introduction to Internet Information Services 7.0 Management - view details
    In Windows Server 2008 we have a brand new tool for managing the web services, the IIS Manager, which��looks significantly different from what you've used in previous versions. In this video, we will look at the new management interface, Server and Site management, Test a simple web site, and examine Anonymous, Basic and Integrated Authentication Components

    Highlights from this video:
    • Installing Role Services for IIS
    • About Basic, Windows and Digest authentications
    • Configuring your Sites and Server
    and much more
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: windows server, 2008, iis, internet information services, iis 7.0, iis management, introduction, step by step, beginner, beginning, for dummies

    This video comes from the Windows 2008 online training course, Windows Server 2008 Administration. And be sure to check out even more Windows Server 2008 training videos.

    posted by Scott Whigham @ 9:53 AM  

    MSSQL Server 2005 Video Tutorial: Migrating From Express Edition to SQL Server Enterprise/Standard/et al

    Migrating From Express Edition to SQL Server Enterprise/Standard/et al - view details
    Are you about to move from the free version of SQL Server 2005 (SQL Server 2005 Express Edition) to a paid-for version such as Standard Edition or Developer Edition? Then you''ll want to watch this video!

    Highlights from this video:
    • How to move databases from one server instance to another
    • What restrictions are there on migrating?
    • Migration techniques
    and much more
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: upgrade, migration, migrating, install, installing

    This video comes from the SQL Server 2005 DBA online training course, SQL Server 2005 Database Administration. And be sure to check out even more MSSQL Server 2005 training videos.

    posted by Scott Whigham @ 8:53 AM  

    MSSQL Server 2000 Video Tutorial: Pt. 2 - The Three Most Common T ypes of SQL Server Replication

    Pt. 2 - The Three Most Common Types of SQL Server Replication - view details
    This video, part 2 in our section focuses on Snapshot, Merge and Transactional replication architectures. You'll learn what the purpose of each type of replication is, common uses of each, and just a general overview of the replication types in SQL Server 2005 and SQL Server 2000.

    Highlights from this video:
    • Understanding how synchronization affects replication
    • Snapshot replication architecture
    • Merge replication architecture
    • Transactional replication architecture
    • Useful analogies that help you understand and remember each type
    • Which type(s) of replication are "One Way" by default?
    • Which type(s) of replication supports conflict resolution?
    and much more
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: replication architecture, merge, transactional, snapshot, beginning, beginner, intro, introduction

    This video comes from the SQL Server 2000 DBA online training course, SQL Server 2000 Database Administration. And be sure to check out even more MSSQL Server 2000 training videos.

    posted by Scott Whigham @ 7:53 AM  

    Windows Server 2003 Video Tutorial: Pt. 2 - Building A Second Dom ain Controller For The LearnItFirst Local Domain

    Pt. 2 - Building A Second Domain Controller For The LearnItFirst Local Domain - view details
    This video covers the addition of a 2nd domain controller to the LearnItFirst.local Active Directory for use in your private namespace domain (a.k.a. your 'local' domain). This video also discusses the idea and possibility of adding a 3rd (or nth) domain controller as well.

    Related Videos: We also have a video section on how to install Exchange Server on a private namespace domain.
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: active directory, .local, local namespace domains

    This video comes from the Windows 2003 online training course, Windows Server 2003 Administration. And be sure to check out even more Windows Server 2003 training videos.

    posted by Scott Whigham @ 6:53 AM  

    MSSQL Programming and Query Writing Video Tutorial: Using SET Com mands Inside Stored Procedures and When Executing Stored Procedures

    Using SET Commands Inside Stored Procedures and When Executing Stored Procedures - view details
    This video is "Must-See TV" for those of you wanting to be better stored procedure programmers. The focus of this video is how the scoping of the SET commands in your stored procedures can impact performance and/or results.

    This video was shot on SQL Server 2005 but the same concepts still apply for SQL Server 2000

    Highlights from this video:

    • Using SET NOCOUNT ON/OFF
    • Using TOP vs. ROWCOUNT
    • Best Practices for using SET commands in stored procedures
    • Optimizing stored procedures for faster execution and easier client use
    • Temporary tables and scoping
    • Creating temporary stored procedures
    • Using DBCC USEROPTIONS to view connection settings
    • sys.objects/sysobjects
    • Error Handling with transactions using XACT_ABORT and @@ERROR

    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: SET XACT_ABORT ON, while, declare @e int, set @e = @@error, rollback, commit

    This video comes from the SQL Server Programming and Queries online training course, SQL Server Programming (SQL Server 2005/2000): Transact SQL. And be sure to check out even more MSSQL Programming and Query Writing training videos.

    posted by Scott Whigham @ 5:53 AM  

    Windows Server 2003 Video Tutorial: Customizing and Tuning The Mo use for a Server

    Customizing and Tuning The Mouse for a Server - view details
    Grant Moyle, Windows and Exchange consultant "extraordinaire", walks you through customizing your Windows server for maximum comfort and usability in this video on tweaking the mouse. A quick video but certainly interesting.
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: customize mouse, optimize mouse, beginner, beginning, for beginners, introduction, step by step

    This video comes from the Windows 2003 online training course, Windows Server 2003 Administration. And be sure to check out even more Windows Server 2003 training videos.

    posted by Scott Whigham @ 4:53 AM  

    Windows Server 2003 Video Tutorial: Automate the Command Line FTP Utility in Windows 2003

    Automate the Command Line FTP Utility in Windows 2003 - view details
    Are you looking for an easy way to upload or download files from an FTP server instead of using daily commands? In this great video tutorial, Grant will walk you through the process of automating the command line FTP utility in Windows 2003 so you can easily use an FTP script to carry out your daily batch jobs.

    Highlights from this video:
    • Working with the FTP Utility
    • FTP scripting
    • Targeting specifc files
    and much more
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: ftp, ftp script,

    This video comes from the Windows 2003 online training course, Windows Server 2003 Administration. And be sure to check out even more Windows Server 2003 training videos.

    posted by Scott Whigham @ 3:53 AM  

    SQL 2005 Integration Services Video Tutorial: Pt. 3 - An Overview of Importing .NET Assemblies into SSIS

    Pt. 3 - An Overview of Importing .NET Assemblies into SSIS - view details
    It is quite difficult for newbies to use C# or Visual Basic code in their SSIS packages due to the number of steps required to acutally get your assembly to even show up inside of SSIS. This helpful walk-through shows you the common pitfalls that most people fall into when working with assemblies in SSIS and gets you started on the right path to setting up assemblies in SSIS.
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: gac, global assembly cache

    This video comes from the SSIS 2005 online training course, SQL Server 2005 Integratio n Services. And be sure to check out even more SQL 2005 Integration Services training videos.

    posted by Scott Whigham @ 2:53 AM  

    MS Exchange 2007 Video Tutorial: How to do Message Tracking in Ex change 2007 in the GUI and with PowerShell

    How to do Message Tracking in Exchange 2007 in the GUI and with PowerShell - view details
    This video will examine how to do message tracking via various methods when using the Exchange server.

    Highlights from this video:
    • How to change message tracking parameters
    • Viewing messages in queue
    • Utilizing various PowerShell methods to organize message tracking logs
    and much more
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: message tracking, PowerShell

    This vide o comes from the Exchange 2007 online training course, Exchange Server 2007 Administration. And be sure to check out even more MS Exchange 2007 training videos.

    posted by Scott Whigham @ 1:53 AM  

    MSSQL Server 2000 Video Tutorial: How to Increase a Database's Si ze Using the SQL Server Enterprise Manager

    How to Increase a Database's Size Using the SQL Server Enterprise Manager - view details
    If you don't know the ALTER DATABASE commands for increasing your SQL Server file sizes (or don't want to use it), then this video is a great head-start to learning file manipulation and management for SQL Server 2000. Veteran SQL Server trainer Scott Whigham shows you a few of his tips and tricks for working with the Enterprise Manager as well.
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: grow database sql server, grow sql file, increase sql database

    This video comes from the SQL Server 2000 DBA online training course, SQL Server 2000 Database Administration. And be sure to check out even more MSSQL Server 2000 training videos.

    posted by Scott Whigham @ 12:53 AM  

    Friday, June 26, 2009

    C# Programming Video Tutorial: Pt. 3 - SQL Server Reporting Servi ces Architecture

    Pt. 3 - SQL Server Reporting Services Architecture - view details
    This video talks about SSRS architecture including Report Servers, Report Manager, SQL Server database, how SQL Server is implemented as an XML web service and more.

    Highlights from this video:
    • How SSRS interacts with IIS (Internet Information Services - the Windows web server)
    • Where SSRS stores security, report definitions and cached report data
    • Tools to create reports
    • What can be a data source?
    and much more
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: , introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies

    This video comes from the C# online training course, C# Programming with Visual Studio 2005. And be sure to check out even more C# Programming training videos.

    posted by Scott Whigham @ 11:53 PM  

    Visual Basic Programming Video Tutorial: Pt. 1 - An Introduction to the GridView and Using GridViews In Your ASP.NET Applications

    Pt. 1 - An Introduction to the GridView and Using GridViews In Your ASP.NET Applications - view details
    Many people are finding that their favorite new control in Visual Studios 2005 is the GridView, which allows you to do almost everything on a single page, basically replacing the DataGrid. In this first video in the section, you will be given an introduction to the GridView and how to use the GridView in your ASP.NET applications.

    Highlights from this video:

    • About the GridView
    • Formatting the GridView schemes
    • Adding/configuring a new Data Source

    and much more!

    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: GridView, Visual Studio, GridViews

    This video comes from the Visual Basic .NET online training course, Visual Basic Programming with Visual Studio 2005. And be sure to check out even more Visual Basic Programming training videos.

    posted by Scott Whigham @ 10:53 PM  

    Windows Server 2003 Video Tutorial: How to Map Network Drives at Logon Using Login Scripts

    How to Map Network Drives at Logon Using Login Scripts - view details
    This video will show you how you can map network drives during the logon process using Windows login scripts.

    Highlights from this video:
    • Writing .vbs files that will run at logon, logout
    • Map network drives
    • Using wscript.exe to run scripts
    • VBScript
    and much more
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: logon, login, scripts, scripting, mapped drives

    This video comes from the Windows 2003 online training course, Windows Server 2003 Administration. And be sure to c heck out even more Windows Server 2003 training videos.

    posted by Scott Whigham @ 9:53 PM  

    MSSQL Programming and Query Writing Video Tutorial: Pt. 3 - Input Parameters and Variables

    Pt. 3 - Input Parameters and Variables - view details
    The bulk of your stored procedures will be dynamic, meaning that they will have parameters and those parameters will be used to make decisions (such as what rows to return). This video talks about how to create parameters and variables as well as working with default parameters ( to make a parameter optional instead of required, for example).
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: declare, local variable, argument

    This video comes from the SQL Server Programming and Queries online training course, SQL Server Programming (SQL Server 2005/2000): Transact SQL. And be sure to check out even more MSSQL Programming and Query Writing training videos.

    posted by Scott Whigham @ 8:53 PM  

    Windows Server 2003 Video Tutorial: Pt. 6 - Creating a Highly Ava ilable File Share

    Pt. 6 - Creating a Highly Available File Share - view details
    Now that our cluster is up and running, we can set up all kinds of failover-enabled services and resources. This video helsp you gain an excellent understanding of how the cluster works and shows you how to configure a file share to be clustered.
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: cluster, clustering, clustered, setup, setting up, install, installing clusters, failover, fileshare, folder

    This video comes from the Windows 2003 online training course, Windows Server 2003 Administration. And be sure to check out even more Windows Server 2003 training videos.

    posted by Scott Whigham @ 7:53 PM  

    SQL 2005 Integration Services Video Tutorial: Part 5 - Email Addr ess Validation Regular Expression

    Part 5 - Email Address Validation Regular Expression - view details
    In this fifth video in the section, your instructor will detail about validating email addresses, another way to match patterns. This is a perfect time to consider using regular expressions as it's a method that will build upon the regex syntax you've previously learned.

    Highlights from this video:
    • Defining new syntax elements
      • " [ ] " - brackets characters
      • " + " - plus character
      • " @ " - AT character
      • " { } " -curly brackets characters
      • " $ " -dollar sign character
    • Working with and defining quantifiers
    • Terminating your regex strings
    and much more
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: regular expressions, regex, expression, language, text, script, string,

    This video comes from the SSIS 2005 online training course, SQL Server 2005 Integration Services. And be sure to check out even more SQL 2005 Integration Services training videos.

    posted by Scott Whigham @ 6:53 PM  

    Visual Basic Programming Video Tutorial: Part 4 - Looking at a F ilename Pattern Regular Expression

    Part 4 - Looking at a Filename Pattern Regular Expression - view details
    In this fourth video, we will wrap up our example of filename patterns by defining the various elements found in regular expressions and demonstrate how to match and group the characters.

    Highlights from this video:
    • Defining important elements in your expressions
      • " ( ) " - parentheses characters
      • " | " - pipe character
      • " . " - period metacharacter
      • " \ " - backslash character
    • Validating against our regex
    • Using patterns to match more sample regular expressions

    Authors notes included with download

    and much more

    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: regular expressions, regex, expression, language, text, script, string,

    This video comes from the Visual Basic .NET online training course, Visual Basic Programming with Visual Studio 2005. And be sure to check out even more Visual Basic Programming training videos.

    posted by Scott Whigham @ 5:53 PM  

    MSSQL Server 2000 Video Tutorial: Pt. 3 - Create View Syntax and Creating Views in SQL Server

    Pt. 3 - Create View Syntax and Creating Views in SQL Server - view details
    Part three in our section on views focuses on the dirty work: the CREATE VIEW statement. There are various ways to write the CREATE VIEW statement, all of which end up the same way (with a new view) and this video helps you understand the syntax.
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: create sql view, create view syntax, alter view, drop view, views, beginner, beginning, for beginners, introduction, step by step

    This video comes from the SQL Server 2000 DBA online training course, SQL Server 2000 Database Administration. And be sur e to check out even more MSSQL Server 2000 training videos.

    posted by Scott Whigham @ 4:53 PM  

    MS Exchange 2003 Video Tutorial: Server Properties

    Server Properties - view details
    A must-see video for Exchange administrators of all skill levels. Exchange guru Grant Moyle shows you how to configure both the Standard Edition and Enterprise Edition of Exchange Server 2003. You will walk through the bulk of the server properties and get a great explanation of each property. This video shows you the differences between service pack 1 installations and RTM installations also
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: how to configure exchange server properties, exchange server properties tutorial, exchange server properties explanation, beginner, beginning, for beginners, introduction, step by step

    This video comes from the Exchange 2003 online training course, Exchange Server 2003 Administration. And be sure to check out even more MS Exchange 2003 training videos.

    posted by Scott Whigham @ 3:53 PM  

    SQL 2005 Integration Services Video Tutorial: Pt. 1 - Expressions - An Introduction to Using Expressions in SSIS

    Pt. 1 - Expressions - An Introduction to Using Expressions in SSIS - view details
    Expressions are new in SSIS (meaning that they were not in DTS) but they allow you to create extremely flexible packages. Expressions can be used to assign values to variables, help you determine whether to execute a task, and to assign properties. If you ever found yourself writing ActiveX code (VBScript) in DTS to determine which task to execute based on a variable's value, then you probably can forego the scripting all together in favor of expressions! They are very powerful in SSIS and you'll want to have a solid understanding of how to write them and how to use them.

    Highlights from this video:
    • When should you use expressions?
      • < li>What language is the expression syntax written in?
    • Accessing variables from expressions (using the long way and the short way)
    • How to use expressions with the For Loop container in the InitExpression, EvalExpression and the AssignExpression
    • Locating and using the Expression Builder
    • An overview of writing expressions
    and much more
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: syntax, tsql, transact-sql, c#, c, java, code, coding, writing expressions

    This video comes from the SSIS 2005 online training course, SQL Server 2005 Integration Services. And be sure to check out even more SQL 2005 Integration Services training videos.

    posted by Scott Whigham @ 2:53 PM  

    Windows Server 2003 Video Tutorial: User Principal Names: How to Use UPNs to Logon to Your Active Directory

    User Principal Names: How to Use UPNs to Logon to Your Active Directory - view details
    In this video you will work with legacy login names (pre-Windows 2000 logon name) and User Principal Names (UPNs - post-Windows 2000 logon names) in Active Directory. You will also adjust the policy via the tool Active Directory Domains and Trusts so that you can manage the UPNs. You will add multiple users to the Active Directory and logon to the domain as each to view the UPN logon results. This video could also be titled 'How to Work with User Principal Names in the Active Directory with Active Directory Users and Computers'
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: Windows Server 2003 User Accounts, Add new Active Directory accounts, Add Users to an Organizational Unit (OU) in the Active Directory, UPNs, Add UPNs to Windows 2003, User Principal Names in Windows Server 2003, beginner, beginning, for beginners

    This video comes from the Windows 2003 online training course, Windows Server 2003 Administration. And be sure to check out even more Windows Server 2003 training videos.

    posted by Scott Whigham @ 1:53 PM  

    MSSQL Programming and Query Writing Video Tutorial: Design Patter n for Finding Duplicate Data - A Simple Way to Spot Non-Unique Rows (Singl e Column Test)

    Design Pattern for Finding Duplicate Data - A Simple Way to Spot Non-Unique Rows (Single Column Test) - view details
    Let's say that you have a Primary Key on "SubscriberId" but you want to locate rows that live in the same Country - how would you do it? This query talks about spotting duplicates in a single column (like "Country" in this case). Primary Keys prevent duplicate data in the table but they don't necessarily prevent duplicates across non-key columns. This video is all about spotting single-column duplicates and it uses subqueries and the EXISTS operator to help you locate the dupes.
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: sub-query, sub-queries, subquery, correlated, simple, exists

    This video comes from the SQL Server Programming and Queries online training course, SQL Server Programming (SQL Server 2005/2000): Transact SQL. And be sure to check out even more MSSQL Programming and Query Writing training videos.

    posted by Scott Whigham @ 12:53 PM  

    MS Exchange 2003 Video Tutorial: Part 2 - Testing and Preparing t he Active Directory

    Part 2 - Testing and Preparing the Active Directory - view details
    This video shows you how to test and verify the Active Directory before your migration
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: Active Directory for Exchange, Exchange Server Active Directory

    This video comes from the Exchange 2003 online training course, Exchange Server 2003 Administration. And be sure to check out even more MS Exchange 2003 training videos.

    posted by Scott Whigham @ 11:53 AM  

    MSSQL Server 2000 Video Tutorial: Multiple Instances - Lecture on When They're Appropriate and Special Considerations

    Multiple Instances - Lecture on When They're Appropriate and Special Considerations - view details
    You probably already know that SQL Server 2000 allows you to install multiple named instances but do you know the details? When should you use named instances? How could you use them? Scott Whigham, SQL trainer, gives you his takes on working with multiple instances in this video and includes some excellent examples of when to use named instances to save yourself development and testing time
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: multiple sql instances, sql named instance, second instance

    This video comes from the SQL Server 2000 DBA online training course, SQL Server 2000 Database Administration. And be sure to check out even more MSSQL Server 2000 training videos.

    posted by Scott Whigham @ 10:53 AM  

    Windows Server 2008 Video Tutorial: Adding the Active Directory D omain Controller Role to a Windows Server 2008 Core Installation

    Adding the Active Directory Domain Controller Role to a Windows Server 2008 Core Installation - view details
    This video shows how to create an additional domain for your Active Directory using a Windows Server 2008 Core Installation.

    Highlights from this video:
    • Attempts to run dcpromo.exe stand-alone
    • About the creation of an Answer File using another system
    • Walkthrough of the actual installation of the domain controller
    • Discussion on running a Domain Controller on a Server Core
    and much more
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: windows server 2008 core, window 2008, server core, active directory, domain controller, install,

    This video comes from the Windows 2008 online training course, Windows Server 2008 Administration. And be sure to check out even more Windows Server 2008 training videos.

    posted by Scott Whigham @ 9:53 AM  

    SQL 2005 Integration Services Video Tutorial: Part 4 - Looking a t a Filename Pattern Regular Expression

    Part 4 - Looking at a Filename Pattern Regular Expression - view details
    In this fourth video, we will wrap up our example of filename patterns by defining the various elements found in regular expressions and demonstrate how to match and group the characters.

    Highlights from this video:
    • Defining important elements in your expressions
      • " ( ) " - parentheses characters
      • " | " - pipe character
      • " . " - period metacharacter
      • " \ " - backslash character
    • Validating against our regex
    • Using patterns to match more sample regular expressions

    Authors notes included with download

    and much more

    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: regular expressions, regex, expression, language, text, script, string,

    This video comes from the SSIS 2005 online training course, SQL Server 2005 Integration Services. And be sure to check out even more SQL 2005 Integration Services training videos.

    posted by Scott Whigham @ 8:53 AM  

    Windows Server 2003 Video Tutorial: How to Customize and Tune the Keyboard

    How to Customize and Tune the Keyboard - view details
    Another in our section on customizing the server environment, this video focuses on customizing the keyboard for the most optimal experience.
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: keys, keyboard, beginner, beginning, for beginners, introduction, step by step

    This video comes from the Windows 2003 online training course, Windows Server 2003 Administration. And be sure to check out even more Windows Server 2003 training videos.

    posted by Scott Whigham @ 7:53 AM  

    SQL 2005 Integration Services Video Tutorial: Part2-Setting and G etting Variables Using the Script Task and Visual Basic (VSA)

    Part2-Setting and Getting Variables Using the Script Task and Visual Basic (VSA) - view details
    Ever wonder where the box to display your variables is placed or where in the Project Explorer they are located? Well, in this second video in the section you will take a look at how to gain access to your variables using the Script Task in Microsoft Visual Studio, as it is not easily done from the script task editor interface.

    Highlights from this video:
    • Viewing/Filtering system variables vs user variables
    • Using Dts.Variables
    • Some annoyances in SSIS with variables
      • Script task editor
      • DTS Script Task Runtime Error
      • AutoSaving script changes
    • CString or ToS tring for displaying message boxes containing variables
    • ReadOnly variables and ReadWrite variables
    • Behavioral changes in SSIS from DTS
    and much more
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: variables, variable, script task, user defined variables, system variables, dts.variables

    This video comes from the SSIS 2005 online training course, SQL Server 2005 Integration Services. And be sure to check out even more SQL 2005 Integration Services training videos.

    posted by Scott Whigham @ 6:53 AM  

    Windows Server 2003 Video Tutorial: Part 4 - Approving Updates an d 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 section, 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 then visit the video's detail page and click "download".

    Keywords for this video: wsus, windows server update services 3.0, wsus 3.0, windows server update service, wsus updates, approve updates

    This video comes from the Windows 2003 online training course, Windows Server 2003 Administration. And be sure to check out even more Windows Server 2003 training videos.

    posted by Scott Whigham @ 5:53 AM  

    C# Programming Video Tutorial: Pt. 3 - SQL Server Reporting Servi ces Architecture

    Pt. 3 - SQL Server Reporting Services Architecture - view details
    This video talks about SSRS architecture including Report Servers, Report Manager, SQL Server database, how SQL Server is implemented as an XML web service and more.

    Highlights from this video:
    • How SSRS interacts with IIS (Internet Information Services - the Windows web server)
    • Where SSRS stores security, report definitions and cached report data
    • Tools to create reports
    • What can be a data source?
    and much more
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: , introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies

    This video comes from the C# online training course, C# Programming with Visual Studio 2005. And be sure to check out even more C# Programming training videos.

    posted by Scott Whigham @ 4:53 AM  

    MS Exchange 2007 Video Tutorial: Windows Services: Explanations a nd Best Practices

    Windows Services: Explanations and Best Practices - view details
    If you've ever looked in the Services applet and wondered 'What does that service do?' then this video is for you! Grant Moyle, veteran Windows trainer and consultant, explains the details of some of the most common services you'll see in Windows. All Windows admins should view this video - it is essential knowledge for any sysadmin
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: windows 2003 services

    This video comes from the Exchange 2007 online training course, Exchange Server 2007 Administration. And be sure to check out even more MS Exchange 2007 training videos.

    posted by Scott Whigham @ 3:53 AM  

    SharePoint (MOSS/WSS) Video Tutorial: Create a New SharePoint Si te/Workspace On an Existing SharePoint Server

    Create a New SharePoint Site/Workspace On an Existing SharePoint Server - view details
    This video helps you learn about creating new sites on your SharePoint server. There are multiple ways to create new sites - which is best? What are the options?

    Highlights from this video:
    • Best Practices for Choosing Site Options
    • How to create a new SharePoint site
    • Determining navigation bar placement
    • Managing security for a new site
    • Assigning permissions to a site
    and much more
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: newbie, beginner, starter, get started, accounts, roles, groups, permissions

    This video comes from the SharePoint 2007 online training course, Building Portals with SharePoint 2007. And be sure to check out even more SharePoint (MOSS/WSS) training videos.

    posted by Scott Whigham @ 2:53 AM  

    Visual Basic Programming Video Tutorial: Pt. 1 - An Introduction to the GridView and Using GridViews In Your ASP.NET Applications

    Pt. 1 - An Introduction to the GridView and Using GridViews In Your ASP.NET Applications - view details
    Many people are finding that their favorite new control in Visual Studios 2005 is the GridView, which allows you to do almost everything on a single page, basically replacing the DataGrid. In this first video in the section, you will be given an introduction to the GridView and how to use the GridView in your ASP.NET applications.

    Highlights from this video:

    • About the GridView
    • Formatting the GridView schemes
    • Adding/configuring a new Data Source

    and much more!

    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: GridView, Visual Studio, GridViews

    This video comes from the Visual Basic .NET online training course, Visual Basic Programming with Visual Studio 2005. And be sure to check out even more Visual Basic Programming training videos.

    posted by Scott Whigham @ 1:53 AM  

    MSSQL Server 2005 Video Tutorial: Part 1-A Deeper Look at Pages a nd Extents Using SQL Internals Viewer

    Part 1-A Deeper Look at Pages and Extents Using SQL Internals Viewer - view details
    SQL Internals Viewer is a free piece of fascinating beta software for SQL. In this video tutorial, Scott will get you started with an overview of using the SQL Internals Viewer,�� and understanding how it corresponds to the data inside your SQL server databases.

    Highlights from this video:
    • Navigating the SQL Internals Viewer interface
    • What does each little block represent?
    • Viewing the Transaction Log
    • Page Free Space (PFS), Buffer Pool, Allocations
    and much more!����
    To download this video, log in then then visit the video's detail page and click " download".

    Keywords for this video: SQL internals Viewer, buffer pool, allocations, Page free space,

    This video comes from the SQL Server 2005 DBA online training course, SQL Server 2005 Database Administration. And be sure to check out even more MSSQL Server 2005 training videos.

    posted by Scott Whigham @ 12:53 AM  

    Thursday, June 25, 2009

    Visual Basic Programming Video Tutorial: Pt. 5 - An Introduction to Using the SqlDataSource

    Pt. 5 - An Introduction to Using the SqlDataSource - view details
    This fifth video in the section will dicuss one of the new controls in VS2005 and .NET 2.0, the SQL Data Source, which is best used for rapid application development. Scott will provide you with a great introduction to the SqlDataSource as well as provide you with a real-world demonstration of it in use.

    Highlights from this video:

    • Working with the SQLDataSource
    • Love/Hate relationship with SqlDataSource
    • Familiarizing yourself with the SqlDataSource
    • Configuring the SQLds

    and much more!

    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: Sql Data source, data source, sql server

    This video comes from the Visual Basic .NET online training course, Visual Basic Programming with Visual Studio 2005. And be sure to check out even more Visual Basic Programming training videos.

    posted by Scott Whigham @ 11:53 PM  

    MS Exchange 2003 Video Tutorial: Clustering Exchange - Pt. 5 - Co nfiguring the Exchange Server Group in Cluster Administrator

    Clustering Exchange - Pt. 5 - Configuring the Exchange Server Group in Cluster Administrator - view details
    The last step before bringing the cluster online is to create the Exchange group.
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: mcsc, cluster administrator, exchange server

    This video comes from the Exchange 2003 online training course, Exchange Server 2003 Administration. And be sure to check out even more MS Excha nge 2003 training videos.

    posted by Scott Whigham @ 10:53 PM  

    MS Exchange 2007 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 t hese 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 then visit the video's detail page and click "download".

    Keywords for this video: ssl certificate, internal access, configure, exchange, certificate,

    This video comes from the Exchange 2007 online training course, Exchange Server 2007 Administration. And be sure to check out even more MS Exchange 2007 training videos.

    posted by Scott Whigham @ 9:53 PM  

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

    Setup Certificate Authority and Issue SSL Certificate for OWA (Outlook Web Access) - view details
    There's a lot to managing certificates - this video covers the basics of getting certificates up and running so that your users can have secure connections through Outlook Web Access (OWA). Exchange guru Grant Moyle gives you several tips for installing certificates, using Exchange certificates and working with OWA
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: how to issue SSL certificate for Exchange, SSL certificate tutorial for Exchange

    This video comes from the Exchange 2003 online training course, Exchange Server 2003 Administration. And be sure to check out even more MS Exchange 2003 training videos.

    posted by Scott Whigham @ 8:53 PM  

    SQL 2005 Reporting Services Video Tutorial: Part 8 - Multi-value Parameters

    Part 8 - Multi-value Parameters - view details
    This final video in the section 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 then visit the video's detail page and click "download".

    Keywords for this video: parameters, report parameters, ssrs, reporting services,

    This video comes from the SSRS 2005 online training course, SQL Server 2005 Reporting Services. And be sure to check out even more SQL 2005 Reporting Services training videos.

    posted by Scott Whigham @ 7:53 PM  

    Windows Server 2003 Video Tutorial: Create a User Account in the Active Directory

    Create a User Account in the Active Directory - view details
    A must-see video for all new Windows administrators. Expert Grant Moyle tells you how user security works in Windows 2003 and shows you how to add new user accounts to the Active Directory. You'll learn the basics as well as a few intermediate tips (what does ".local" mean?)
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: Add new user Windows 2003, beginner, beginning, for beginners, introduction, step by step

    This video comes from the Windows 2003 online training course, Windows Server 2003 Administration. And be sure to check out even more Windows Server 2003 training videos.

    posted by Scott Whigham @ 6:53 PM  

    Windows Server 2003 Video Tutorial: Using Recovery Console to Rep air Disks

    Using Recovery Console to Repair Disks - view details
    This video shows you how to use the Recovery Console to repair a damaged Windows installation. While no one wants to have to use the Recovery Console, expert trainer Grant Moyle shows you all the details of this infrequently-used-yet-indispensable tool
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: windows 2003 recovery console

    This video comes from the Windows 2003 online training course, Windows Server 2003 Administration. And be sure to check out even more Windows Server 2003 training videos.

    posted by Scott Whigham @ 5:53 PM  

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

    Pt. 6 - An In-Depth Case Study of Migrating a DTS Package to SSIS - view details
    More. More SSIS. More Package Migration Wizard things to fix. More.
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: upgrading, upgrade, migrating, data transformation services, migrate

    This video comes from the SSIS 2005 online training course, SQL Server 2005 Integration Services. And be sure to check out even more SQL 2005 Integration Services training videos.

    posted by Scott Whigham @ 4:53 PM  

    MSSQL Server 2005 Video Tutorial: Part 2 - An Overview of the Adv entureWorks Database - Database Diagrams and DDL Triggers

    Part 2 - An Overview of the AdventureWorks Database - Database Diagrams and DDL Triggers - view details
    Continuing our section on the AdventureWorks database, Scott Whigham walks you through how to create database diagrams using AdventureWorks as well as using the DDL triggers for database-level events. A very interesting video with some exciting new SQL Server 2005 features.
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: database events, database event trigger

    This video comes from the SQL Server 2005 DBA online training course, SQL Server 2005 Database Administration. And be sure to check o ut even more MSSQL Server 2005 training videos.

    posted by Scott Whigham @ 3:53 PM  

    C# Programming Video Tutorial: Pt. 4 - Postbacks and Events

    Pt. 4 - Postbacks and Events - view details
    This video will go into more detail about some of the most commonly used items in the toolbox when creating a web application with Microsoft Visual Studio.

    Highlights:

    • Adding list items
    • Changing/customizing��list properties
    • How to enable PostBack
    • When to use PostBack

    ��

    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: event handling, event handlers, databinding

    This video comes from the C# online training course, C# Programming with Visual Studio 2005. And be sure to check out even more C# Programmi ng training videos.

    posted by Scott Whigham @ 2:53 PM  

    MS Exchange 2003 Video Tutorial: Message Tracking Policy

    Message Tracking Policy - view details
    You'll learn how to manage Exchange by using policies. Policy management is far easier than individual server management for administrators managing multiple Exchange servers. Policies allow for conformity among multiple servers so that each server has the same settings.
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: Exchange message tracking policies, exchange policy

    This video comes from the Exchange 2003 online training course, Exchange Server 2003 Administration. And be sure to check out even more MS E xchange 2003 training videos.

    posted by Scott Whigham @ 1:53 PM  

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

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

    Keywords for this video: DHCP reserved IP addresses

    This video comes from the Windows 2003 online training course, Windows Server 2003 Administration. And be sure to check out even more Windows Server 2003 training videos.

    posted by Scott Whigham @ 12:53 PM  

    SQL 2005 Integration Services Video Tutorial: Pt. 1 - An Overview of Using SSIS for Newbies and Beginners

    Pt. 1 - An Overview of Using SSIS for Newbies and Beginners - view details
    If you are just getting started with Integration Services, then you need to START HERE. This video, part one of a whole section on SSIS for beginners, starts you out with an introduction of what SSIS will be used for and the different tools that you'll be using. This video is more of an overview and is designed to give you the view of SSIS from 50,000 feet, if you will. The remaining videos in this section will dig down in to the topics posed in this video and help you get started with SSIS the right way.

    Highlights from this video:
    • Which tools do you use to schedule and execute SSIS packages?
    • What tool(s) do you use to edit and develop SSIS packages?
    • What can you do within SSMS (SQL Server Management Studio)?
    • What can you do within BIDS (Business Intelligence Development Studio)?
    and much more
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: intro, introduction, beginning, newbs, newbies, starters, first time, overview, technology overview

    This video comes from the SSIS 2005 online training course, SQL Server 2005 Integration Services. And be sure to check out even more SQL 2005 Integration Services training videos.

    posted by Scott Whigham @ 11:53 AM  

    SQL 2005 Reporting Services Video Tutorial: Part 1 - The Chart Co ntrol: Understanding the Query/Database for the Demo

    Part 1 - The Chart Control: Understanding the Query/Database for the Demo - view details
    In this video section, Scott Whigham will introduce you to the chart control in SQL Server 2005 Reporting Services. Scott will talk about the various types of charts you can create, as there are so many different customization options, and ��walk you through the various customization options.

    In this first video in the 7-part section, Scott will walk you through the basics of creating a decent query. Scott works in the AdventureWorks database, so you can play along at home!

    Highlights from this video:

    • Building a basic dataset
    • About the master detail relationship
      • Examples form AdventureWorks
      • Identifying the master
      • Identifying the detail
    • Populating our base query

    ��

    and much more
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: chart, chart control, build, dataset, query, adventureworks, master, detail,, introduction, step by step, beginner, beginning, for dummies

    This video comes from the SSRS 2005 online training course, SQL Server 2005 Reporting Services. And be sure to check out even more SQL 2005 Reporting Services training videos.

    posted by Scott Whigham @ 10:53 AM  

    SharePoint (MOSS/WSS) Video Tutorial: Customizing a MOSS User Account

    Customizing a MOSS User Account - view details
    A key difference between WSS (Windows Sharepoint Services) and MOSS (Microsoft Office SharePoint Services) is the ability for an individual user to customize their content within a SharePoint site by creating a personalized site. In this short video tutorial, Grant will demonstrate to how you can create a personalized MOSS SP site!

    Highlights from this video:
    • Creating your custom site
    • Inputing and editing user details
    • Controlling who have viewing access to your profile
    • What else can my custom site do?
    and much more
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: moss, microsoft office sharepoint server, microsoft office sharepoint services, moss 2007, user, user account, sharepoint user,

    This video comes from the SharePoint 2007 online training course, Building Portals with SharePoint 2007. And be sure to check out even more SharePoint (MOSS/WSS) training videos.

    posted by Scott Whigham @ 9:53 AM  

    SQL 2005 Integration Services Video Tutorial: Pt. 3b - An Overvie w of Using SSIS for Newbies and Beginners - Using BIDS

    Pt. 3b - An Overview of Using SSIS for Newbies and Beginners - Using BIDS - view details
    More on working inside the Business Intelligence Development Studio (BIDS)
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: Business Intelligence Projects, Visual Studio, 2005, VS2005, Visual Studio 2005

    This video comes from the SSIS 2005 online training course, SQL Server 2005 Integration Services. And be sure to check out even more SQ L 2005 Integration Services training videos.

    posted by Scott Whigham @ 8:53 AM  

    SharePoint (MOSS/WSS) Video Tutorial: Create Recurring Events In Your SharePoint Calendar

    Create Recurring Events In Your SharePoint Calendar - view details
    You use them in Outlook/Outlook Express/Eudora/etc - recurring appointments help us be more productive. As you can imagine, you can set up recurring events ('repeating events') in SharePoint very easily.

    Highlights from this video:
    • Setting up the repeating event properties
    • How SharePoint manages the calendar for recurring events
    and much more
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: calendars, repeated, edit series

    This video comes from the SharePoint 2007 online training course, Bu ilding Portals with SharePoint 2007. And be sure to check out even more SharePoint (MOSS/WSS) training videos.

    posted by Scott Whigham @ 7:53 AM  

    MSSQL Server 2005 Video Tutorial: Pt. 3 - Setting Up Push and Pul l Subscriptions

    Pt. 3 - Setting Up Push and Pull Subscriptions - view details
    This video walks you through setting up a push subscriptions and pull subscriptions as well as synchronizing servers. You'll be able to view latency and how to diagnose replication problems.

    Highlights from this video:
    • Push Subscriptions vs. Pull Subscriptions
    • Synchronization Schedules and Latency
    • How to initialize a new publication using the "New Publication Wizard"
    • Discussion of the Distribution Agent and how it works (does it run at subscriber?)
    • Discussion of using non-SQL Server subscribers (Oracle subscribers, DB2 subscribers for example)
    • Discussion of service account usage and recommendations
    • Snapshot initialization and how to start the Snapshot Agent
    • Working with multiple subscriptions for a single publication
    and much more
    To download this video, log in then then visit the video's detail page and click "download".

    Keywords for this video: replication architecture, merge, transactional, snapshot, beginning, beginner, intro, introduction, publication, article, push, pull

    This video comes from the SQL Server 2005 DBA online training course, SQL Server 2005 Database Administration. And be sure to check out even more MSSQL Server 2005 training videos.

    posted by Scott Whigham @ 6:53 AM  

    Windows Server 2003 Video Tutorial: Differences Bet