Friday, July 31, 2009

MSSQL Server 2005 Video Tutorial: Pt. 10 - SQL Server Intergratio n Services BULK INSERT Task

Pt. 10 - SQL Server Intergration Services BULK INSERT Task - view details
This video will show you how to create a BULK INSERT task in SQL Server Integration Services, SSIS, with Microsoft Visual Studio
  • Using the BULK INSERT task in an SSIS project
  • Configuring destination connection and options of task
  • Comparison against other tools
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: BULKINSERT, SSIS, sql server integration services, destination connection,compare

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

posted by LearnItFirst.com @ 11:53 PM  

Windows Server 2003 Video Tutorial: How to Join a Computer to the Domain with Basic Troubleshooting

How to Join a Computer to the Domain with Basic Troubleshooting - view details
This video shows you how to add a computer to the domain and the effects on the local user accounts.
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: join computer to domain

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 LearnItFirst.com @ 10:53 PM  

MS Exchange 2007 Video Tutorial: Building Mail Universal Distribu tion Groups and Dynamic Distribution Groups

Building Mail Universal Distribution Groups and Dynamic Distribution Groups - view details
How to Build Mail Universal Distribution Groups and Dynamic Distribution Groups
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: How to Build Mail Universal Distribution Groups and Dynamic Distribution Groups

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 LearnItFirst.com @ 9:53 PM  

MSSQL Server 2008 Video Tutorial: Creating SQL Server Authenticat ion Logins and Working with Policies

Creating SQL Server Authentication Logins and Working with Policies - view details
Continuing in this video is our discussion on Logins and authentication. We will specifically cover the SQL Server Authentication Logins and demonstrate how to change your authentication mode as well as explore security for Loginpasswords.

Highlights from this video:
  • What are SQL Server Authentication Logins and how do they differ from Windows Authentication?
  • About SQL Server Logins and password policies
  • Logins for specific situations
      • Logins mapped to asymmetric key or credential
  • How to change your authentication mode
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: Login, password, security, sql, server, 2008, sql authentication, authentication mode,

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 LearnItFirst.com @ 8:53 PM  

SQL 2005 Reporting Services Video Tutorial: Pt. 1 - Data Sources in SSRS: An Intro to Shared and Report-Specific Data Sources

Pt. 1 - Data Sources in SSRS: An Intro to Shared and Report-Specific Data Sources - view details
One of the fundamental aspects of creating reports and working with projects in Reporting Services is understanding the data sources that we use, as everything is built off a data source. In this video, Scott will introduce you to the Shared data sources and Report-Specific data sources.

Highlights from this video:

  • Exploring the sample reports
  • What is a Shared Data Source and how is it used?
  • Defining Report-Specific data source

and much more!

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

Keywords for this video: data sources, shared data source, report specific data source, intro SSRS

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 LearnItFirst.com @ 7:53 PM  

Windows Server 2003 Video Tutorial: Shadow Copies of Shared Folde rs - Basic

Shadow Copies of Shared Folders - Basic - view details
Grant Moyle's favorite feature of Windows Server 2003 is Shadow Copies of Shared Folders and, in this video, he explains that full details of Shadow Copies
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: Shadow Copying Windows

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 LearnItFirst.com @ 6:53 PM  

MSSQL Server 2005 Video Tutorial: Pt. 4 - Managing, Viewing and I nterpreting SQL Server Traces

Pt. 4 - Managing, Viewing and Interpreting SQL Server Traces - view details
This is a huge video - one that you should definitely watch if you'll be working with Profiler often. In this video our resident guru, Scott Whigham, walks you through all the various techniques for saving and exporting trace data: saving trace data as SQL files (for performance tuning and index tuning), exporting as a template, saving your traces as a SQL Server table and more. One of the best things in this video is seeing how, once you export/save your trace to a SQL table, you can write queries against the data. You could write queries that would tell you how many times a particular table appears in the trace, average/min/max execution times, and more.

Highlights from this video:
  • Importing and Exporting trace data and trace files
  • Working with TextData column in your trace table
  • Interpreting Reads/CPU/Duration and other information
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: profile, profiler table, write queries against profiler data, save trace to sql file

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 LearnItFirst.com @ 5:53 PM  

MSSQL Server 2005 Video Tutorial: Part 6 - Verifying Our Installa tion and Reviewing The Install Logs

Part 6 - Verifying Our Installation and Reviewing The Install Logs - view details
This is, as the title implies, Part 6 in our 7-part section on installing SQL Server 2005 for the first time. In this video, SQL guru Scott Whigham has finished the installation and shows you the logs that SQL Server uses to track the installation along with several of the changes that have now occurred on your system.
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: sql install, setup, sql server log, setup log, sql set up logs, beginner, beginning, for beginners, introduction, step by step

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 LearnItFirst.com @ 4:53 PM  

SQL 2005 Integration Services Video Tutorial: Part1-An Introducti on to Using Variables in SQL Server Integration Services

Part1-An Introduction to Using Variables in SQL Server Integration Services - view details
Variables are a very flexible addition to the SQL Services Integration Services package that store values for passing data from Task A to Task B. In this essential introduction to the world of variables in SSIS, Scott will show you how to get started using variables in Integration Services, both directly and indirectly within certain tasks like the script task or the Execute SQL, as well as show you the many things in SSIS they actually can do. Many find that variables are a worthwhile subject for enhancing your SSIS knowledge and this video section will help you to do just that!

Highlights from this video:
    < li>About the two types of variables and their uses
    • System Variables
    • User-defined Variables
  • Adding new variables and setting their credentials (Name, Scope, Data Type, etc)
  • Namespace differentiations between system variables and user variables
  • Technicalities of names and namespaces
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: variables, variable, script task, user defined variables, system 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 LearnItFirst.com @ 3:53 PM  

MSSQL Server 2000 Video Tutorial: Pt. 3 - Using the Access Upsizi ng Wizard

Pt. 3 - Using the Access Upsizing Wizard - view details
The Access Upsizing Wizard is the preferred way to migrate from Access to SQL Server when you only want to move the data but you want the reports/forms/modules/etc to still exist in Access.

Highlights from this video:
  • How to install the Upsizing Wizard
  • Overcoming limitations of the Upsizing Wizard
  • Understanding the options in the wizard
  • Best Practices for migrating from Access to SQL Server
  • Understanding the .ADP file (the Access Client/Server application)
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: upgrade, upgrading, migrate, migrating, migration,

This video comes fro m 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 LearnItFirst.com @ 2:53 PM  

MSSQL Programming and Query Writing Video Tutorial: XML Schema Co llections and Using Typed and Untyped XML Data

XML Schema Collections and Using Typed and Untyped XML Data - view details
This video is a high-level overview of using XML Schema Collections to constrain the XML data stored in an XML datatype-based column or variable. You'll also learn about using typed and untyped xml data and when to use each.

Highlights from this video:
  • Discussion of the XML schema standard
  • Discussion of how to create XML Schemas
  • Syntax for schemas
  • What are xml schemas and when would I use one?
  • Working with XML datatype variables
  • Creating XML Schema Collections
  • Difference between an XML schema and an XML schema collection
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: typed data, untyped xml data, create xml schema collection, xml dml

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 LearnItFirst.com @ 1:53 PM  

Windows Server 2008 Video Tutorial: Installation and Management o f a Windows Server 2008 Core Installation, Part B

Installation and Management of a Windows Server 2008 Core Installation, Part B - view details
With a Windows 2008 Server Core installation there are certain things you can and cannot do. In this video we will continue exploring the functionalities of a Server Core installation.����

Highlights from this video:
  • Running common commands in a Windows Server core without a GUI
    • Renaming the computer
    • Assigning a static IP address
  • Viewing the current roles installed
  • Installing DNS Server Core role without a GUI
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for t his video: windows server, windows 2008, server core, 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 LearnItFirst.com @ 12:53 PM  

SQL 2005 Integration Services Video Tutorial: Pt. 2 - SQL Server Management Studio (SSMS) Functionality and Available Options (Including Wr iting Queries)

Pt. 2 - SQL Server Management Studio (SSMS) Functionality and Available Options (Including Writing Queries) - view details
Another great introduction video to SQL SERVER MANAGEMENT STUDIO (SSMS) by Scott Whigham. This video leaps us onto the next stepping stone for SSMS. Scott not only continues his teachings about Generating Scripts within SSMS, he also gives is the another basic introduction to SSMS and explains why SSMS is the sole tool to utilize when writing TSQL. Included in this video are the following excellent features:
  • SQL SERVER Connection Requirements in 7.0 or 2000
  • SQL SERVER 2005 Color Coded Syntax
  • Disconnect and Switch Connection options
  • Basic Introduction to SAVE ME Asterisks
  • Basic In troduction to MDX and DMX Queries inside SSMS
  • Lack of Intellisense within SSMS
  • History of Intellisense
  • Third party Intellisense software is available
  • SSMS available options
  • Hot keys within SSMS and where to set them
  • SQL SERVER 2005 Chords - ie. Commenting out blocks of code (CTRL+K, CTRL+C)
  • How to comment and uncomment blocks of code with a couple pushes of keys
  • Funny SSMS non malicious bug in SSMS
This video is a must see, even if only for the bug within SSMS SP2. It is funny once you know about it and can be confusing if you see it before you know it is a BUG. Scott does a fantastic job of bringing us up to speed on the newest software used in developing TSQL (SSMS). This video is extremely easy to follow and is very well done.

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

Keywords for th is video: SQL SERVER MANAGEMENT STUDIO, SSMS, Object Explorer, SQL SERVER 2005, SSMS Terminology, SSMS Options, SSMS BUG, COLOR CODED SYNTAX, Intellisense, Hotkeys in SSMS, Chords, TSQL Comments

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 LearnItFirst.com @ 11: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, Login 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 LearnItFirst.com @ 10:53 AM  

C# Programming Video Tutorial: Installing and Configuring IIS on Windows XP to Run Python

Installing and Configuring IIS on Windows XP to Run Python - view details
So you want Python to run in IIS? Well then this video is just for you as Python is not served by default in IIS. Your instructor, Scott, will walk you through the basic installation and configuration of IIS on Windows XP to run Python.

Highlights:

  • Prerequisites of set-up
  • Where can I download ActivePython?
  • Installation process
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: python scripts, .py

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

posted by LearnItFirst.com @ 9:53 AM  

MS Exchange 2007 Video Tutorial: Manage Mailbox Permissions on Ex change 2007 SP1

Manage Mailbox Permissions on Exchange 2007 SP1 - view details
In SP1 for Exchange 2007, there are some new features. In this video Grant will demonstrate to you the new ability to grant users permission to another user's mailbox without using a powershell command or behind the scenes in the active directory.

Highlights from this video:
  • Two options for reciepient configuration:
    • Manage full access permissions
    • Manage Send-As permissions
  • Where might I use these configurations?
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: mailbox permissions , exchange sp1, service pack 1, , introduction, step by step, beginner, beginning, for dummies

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 LearnItFirst.com @ 8:53 AM  

ISA 2006 Admin Video Tutorial: How to Configure IP Protection to Deny Packets Based on Criteria

How to Configure IP Protection to Deny Packets Based on Criteria - view details
The Internet Protocol (IP) has gone through a lot of changes in the years that it has been around. Many 'old' protocols that were popular a decade ago are not in use today but many networks still allow their transmission - and that is where the problem begins. Learn how to protect your network from uncommonly used protocols being used by watching this video.

Highlights from this video:
  • Denying packets based on protocol and IP options
  • Record routes, Time Stamps, Loose Source Routes, and IP options filtering
  • Understanding what packet fragments are and how hackers try to use these
and much m ore
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: security, best practices

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

posted by LearnItFirst.com @ 7:53 AM  

C# Programming Video Tutorial: Installing the MSDN Documentation and Best Practices for Using MSDN

Installing the MSDN Documentation and Best Practices for Using MSDN - view details
This video will walk you through the installation of the rather large Microsoft Developer Network library, aka MSDN, for Visual Studios 2005.

Highlights:

  • What are the best ways to utilize the MSDN library?
  • How to use filtered searches and indexes
  • Tips and tricks��for navigating the expansive MSDN library
To download this v ideo, Login then then visit the video's detail page and click "download".

Keywords for this video: MSDN, microsoft developer network library, install, installation, filtered search, index,

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 LearnItFirst.com @ 6:53 AM  

Windows Server 2003 Video Tutorial: Force Removal of a Domain Controller

Force Removal of a Domain Controller - view details
This video covers the worst of the worst - removing a domain controller. Do you want to have to do it? No. Is it sometimes necessary? Unfortunately, yes. This video will walk you through the How-To, the Why, and Windows guru Grant Moyle shows you a few of his tips and experiences along the way. As Microsoft says, "Forced removal of a domain controller is only intended to be used as a last resort for recovering a domain controller without requiring reinstallation of the operating system." It's good to know how to do it even if you hope to never need to.
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: active dire ctory removal, uninstall active directory

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 LearnItFirst.com @ 5:53 AM  

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

Pt. 2 - Using Views in the Real World - view details
This video, part 2 in our section on using views, helps you understand the logic behind using views as well as providing real world examples for designing and using views in your databases and applications.
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: sql view, stored query, stored queries, 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 sure to check out even more MSSQL Server 2000 training videos.

posted by LearnItFirst.com @ 4: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, Login 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 LearnItFirst.com @ 3:53 AM  

MSSQL Programming and Query Writing Video Tutorial: Pt. 2 - Using Return Values to Control Program Execution

Pt. 2 - Using Return Values to Control Program Execution - view details
This video expands on the use of return values in SQL Server and shows you how to make decisions in your code based on a stored procedure's return value.

Highlights from this video:
  • What value does RETURN return by default?
  • What are the most likely conventions/uses of RETURN?
  • Using RETURN to return @@ERROR and SQL error codes
  • Best Practices for stored procedure programming
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: SqlParameter, ParameterDirection.ReturnValue, returning error, return @@ERROR, @RETURN_VALUE

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 LearnItFirst.com @ 2:53 AM  

MSSQL Programming and Query Writing Video Tutorial: Pt. 1 - An Ov erview of the Three Types of User Defined Functions (UDFs)

Pt. 1 - An Overview of the Three Types of User Defined Functions (UDFs) - view details
Scott Whigham (author of this site) is a huge fan of user defined functions (UDFs). This video is an introduction to concepts and syntax - the basics, really. This video is shot using the SQL Server Management Studio (SSMS) on SQL Server 2005 but the concepts are identical in SQL Server 2000.

Highlights from this video:
  • Different types of functions available
  • Syntax differences
  • Differences between scalar functions and table-valued functions
  • An overview of usage
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: getdate, app_name, host_name, niladic, system

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 LearnItFirst.com @ 1:53 AM  

SQL 2005 Reporting Services Video Tutorial: Part 3 - Determining Whether to Use One Result Set or Multiple Result Sets

Part 3 - Determining Whether to Use One Result Set or Multiple Result Sets - view details
Once you have your summary query with order and product information, you will have two choices for assembling your invoice. In this third video Scott will present your two options and begin to demonstrate how to create your invoice using multiple result sets.

Highlights from this video:
  • Does it matter if I use one result set or multiple result sets?
  • Difference between using the one-query option and the multi-query option

and much more

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

Keywords for this video: create invoice, invoice, generate, adventure works, result set,

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 LearnItFirst.com @ 12:53 AM  

Thursday, July 30, 2009

SQL 2005 Reporting Services Video Tutorial: Part 3 - Details On U sing the ReportViewer's Properties, ReportDataSources and More

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

Highlights from this video:
  • The importance of registering the assembly of the ReportViewer
    • ReportDataSource
    • Classes
    • Referencing correctly
  • Local reports vs. Server Reports
  • Defining data sources and data sets within your report
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: reportdatasource, reportviewer, report viewer, report, data source,

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 LearnItFirst.com @ 11:53 PM  

C# Programming Video Tutorial: Pt. 6 - Report Security and Integr ating Reports with ASP.NET, C# and Visual Basic

Pt. 6 - Report Security and Integrating Reports with ASP.NET, C# and Visual Basic - view details
Our final video, part six, is about how security is implemented in SQL Server Reporting Services with a finish on how to integrate Reporting Services reports with the Visual Studio using the Report Viewer Control.

Highlights from this video:
  • Integrating reports with C#, Visual Basic (WinForm/ASP.NET) applications using the Report Viewer Control
  • How roles - system and user-defined - work in Reporting Services
  • How are folders implemented in Reporting Services?
and much more
To download this video, Login 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 LearnItFirst.com @ 10:53 PM  

MS Exchange 2003 Video Tutorial: Installing Exchange 2003 SP2 and Checking Microsoft Update

Installing Exchange 2003 SP2 and Checking Microsoft Update - view details
This could really be part 4 in the section on upgrading Exchange 2000 to Exchange 2003
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: install exchange sp2, update 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 LearnItFirst.com @ 9:53 PM  

Windows Server 2003 Video Tutorial: Configure Primary Domain Cont roller (PDC) Emulator as a Reliable Time Source

Configure Primary Domain Controller (PDC) Emulator as a Reliable Time Source - view details
When reviewing an Active Directory, do you ever get warning messages in the Event Log saying that the domain heirarchy is used to determine its time source, but your machine is the Primary Domain Controller (PDC) that isn't a reliable source. In this video tutorial, Grant will show you how to quickly solve this problem.

Highlights from this video:
  • About domain heirarchy and time source
  • Primary Domain Controller (PDC) Emulator's job
  • Setting up a server as a reliable time source via command prompt
  • Pointing your Domain Controller to an external time sourc e
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: primary domain controller, pdc, emulator, time source, reliable time, domain controller,

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 LearnItFirst.com @ 8:53 PM  

MSSQL Server 2005 Video Tutorial: Pt. 1 - Introduction to SQL Ser ver 2005 Maintenance Plans

Pt. 1 - Introduction to SQL Server 2005 Maintenance Plans - view details
Maintenance Plans (and the Maintenance Plan Wizard) are not new in SQL Server; Microsoft introduced Maintenance Plans in SQL Server 7.0 as a great way to automatically schedule common DBA tasks such as backups. In SQL Server 2005 Microsoft has really listened to its customers and vastly improved the Maintenance Plans (and wizard). If you've used Maintenance Plans in the past, things have changed considerably but for the good.

This video walks you through (1) what maintenance plans are, (2) launching the Maintenance Plan Wizard, and the basic choices of the wizard. There are so many choices in the Maintenance Plan Wizard that this video can only cover so many; the remaining videos of the sections will help you walk through all of the choices in the maintenance plans. This particular video focuses on the "Check Database Integrity" choice including a walk-through of DBCC CHECKDB and what impact selecting this option may have on your server and a discussion on how often you'll want to schedule this option.

Another option covered in this video is the "Shrink Database" task along with Scott Whigham's discussion of Best Practices for shrinking databases
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: sql server maintenance plan, maintenance plans, maintenance plan task, maintenance plan wizard

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 LearnItFirst.com @ 7:53 PM  

MSSQL Programming and Query Writing Video Tutorial: Pt 1 - How to Delete Duplicate Rows in a SQL Server Table Using the Rank() Function

Pt 1 - How to Delete Duplicate Rows in a SQL Server Table Using the Rank() Function - view details
Ever find yourself with multiple/duplicated rows in your SQL Server table? This video tutorial will show you the quickest way to get rid of those "imposter" rows by introducing you to the first couple of steps in the process.

Highlights:
  • How to identify the duplicate values
  • What does the RANK function basically do?
  • Where/when to use the RANK function
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: duplicate,rows,values,RANK, function,

This video comes from the SQL Serv er 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 LearnItFirst.com @ 6:53 PM  

MS Exchange 2007 Video Tutorial: Part 6 - Testing Creation of a N ew Mailbox on the Cluster and Moving a Mailbox to the Cluster

Part 6 - Testing Creation of a New Mailbox on the Cluster and Moving a Mailbox to the Cluster - view details
Once you have an Exchange cluster up and running, you will want to begin putting some mailboxes on it. In this video, your instructor will present you with two scenarios for putting a new mailbox on the cluster: creating a new mailbox and/or moving a mailbox.

Highlights from this video:
  • Creating a new user mailbox
    • Proving the mailbox exists on the cluster
  • Cluster administration and about front-end interaction
  • How to move a users mailbox from the standalone server to the cluster
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: cluster, mailbox, create, move, moving, creating, mail box,

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 LearnItFirst.com @ 5:53 PM  

SQL 2005 Reporting Services Video Tutorial: How to Change the Rep ortingServicesService.exe Service Account Password

How to Change the ReportingServicesService.exe Service Account Password - view details
Just as with SQL Server 2005, Reporting Services has a little bit of a trick to it when you're going to change the service account password. This great video tutorial will lead you through the process of making that change!

Highlights:

  • Password expiration/history
  • Local/Group/Domain security��policies
  • Stopping/starting SSRS
  • Wrong Way vs Correct Way to change password

and much more!

To download this vi deo, Login then then visit the video's detail page and click "download".

Keywords for this video: change service account password, service account password, change password, 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 LearnItFirst.com @ 4:53 PM  

Windows Server 2003 Video Tutorial: Display Information about Non -present (Hidden) Devices

Display Information about Non-present (Hidden) Devices - view details
When you install a new system Windows will attempt to install drivers and load the device. This video shows you where this information is held within the system and how you can use this for troubleshooting device drivers and installation issues
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: configure hidden devices

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

posted by LearnItFirst.com @ 3:53 PM  

Windows Server 2008 Video Tutorial: Install a Network Printer, Di scussion of Print Drivers and Sharing of 32-bit and 64-bit Drivers, Part B

Install a Network Printer, Discussion of Print Drivers and Sharing of 32-bit and 64-bit Drivers, Part B - view details
In Part B of this video we will continue by exploring your newly installed printer's preferences and other properties.

Highlights from this video:
  • Installing printer drivers
  • Adding an additional network printer
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: windows server, windows 2008, print server, print driver, install network printer

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

posted by LearnItFirst.com @ 2:53 PM  

SQL 2005 Reporting Services Video Tutorial: Pt. 3 - SQL Server Re porting Services 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, Login 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 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 LearnItFirst.com @ 1:53 PM  

Windows Server 2003 Video Tutorial: How to Join a Computer to the Domain

How to Join a Computer 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, Login then then visit the video's detail page and click "download".

Keywords for this video: join Windows 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 LearnItFirst.com @ 12:53 PM  

MSSQL Server 2005 Video Tutorial: Part 1 - An Overview of the Def ault SQL Server Installation

Part 1 - An Overview of the Default SQL Server Installation - view details
SQL trainer Scott Whigham walks you through the default installation of SQL Server 2005 in this video. You'll learn about the instances, folders, services, and options chosen during the default install.
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: sql 2005 overview, sql server change, beginner, beginning, for beginners, introduction, step by step

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 LearnItFirst.com @ 11:53 AM  

SQL 2005 Reporting Services Video Tutorial: Pt. 2 - Configuring S QL Server Reporting Services Manually

Pt. 2 - Configuring SQL Server Reporting Services Manually - view details
After the install of Reporting Services, it will now be neccesary to configure Reporting Services to get it up and running. In this second video tutorial in the section your instructor will walk you through the manual configuration and set-up of SQL Server Reporting Services.
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: configure reporting services, manual configuration sql server reporting services, service account

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 LearnItFirst.com @ 10:53 AM  

MSSQL Server 2000 Video Tutorial: Pt. 3 - What Do You Do With You r Trace Data? How to Write Queries Against Your Trace

Pt. 3 - What Do You Do With Your Trace Data? How to Write Queries Against Your Trace - view details
Do you want to know how many times a query has run in your trace? What about finding aggregates like what the minimum duration, maximum duration, and average durations/page reads/CPU? This is a great video that teaches you how to manipulate the trace data into a table for querying. Even then, you still have some work to do...

Highlights from this video:
  • How to save a trace to a table
  • Querying trace tables
  • Writing reporting-style queries against traces
  • Working with ntext data types and GROUP BY/WHERE clauses
  • Modifying your trace table to make it usable in aggregates
  • Saving the queries traced to a SQL file
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: profile, profiler table, write queries against profiler data

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 LearnItFirst.com @ 9:53 AM  

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, Login 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 LearnItFirst.com @ 8:53 AM  

SQL 2005 Integration Services Video Tutorial: Part 1 - How to Imp ort Microsoft Access Tables to SQL Server Using SSIS

Part 1 - How to Import Microsoft Access Tables to SQL Server Using SSIS - view details
In this first video in the section, Scott will show you how to import your Microsoft Access data into a Sql Server via SSIS. There are two different ways to import Access data, depending on importing frequency, and in this video you will be setting up the import for converting data, like tables and queries, in a recurring basis.
Highlights from this video:
  • When not to use SSIS for importing Access tables
  • Working with the Import and Export Wizard
  • Connecting to your Access datasource
  • Choosing which tables and views/queries to import
and more!
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: access, microsoft acces, import tables, import access

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 LearnItFirst.com @ 7:53 AM  

MSSQL Programming and Query Writing Video Tutorial: Part 8 - Usin g Regular Expressions in Everyday Applications

Part 8 - Using Regular Expressions in Everyday Applications - view details
In this final video in our section, your instructor will demonstrate how to use a text editor to do regular expressions searches. Also in this video, your instructor will expose the uses of regular expressions in everyday applications like Sql Server Management Studio and Visual Studio.

Highlights from this video:
  • Can I use a generic text editor?
  • Regex searches in text editors with "^"
  • Navigating with regular expresssions in SSMS
  • Using the Find feature in VS
and much more
To download this video, Login then then v isit the video's detail page and click "download".

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

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 LearnItFirst.com @ 6:53 AM  

MSSQL Programming and Query Writing Video Tutorial: How to Return Identity Value for a Just-Inserted Row

How to Return Identity Value for a Just-Inserted Row - view details
So many SQL developers use IDENTITY columns (a.k.a. sequences and/or auto-number columns) therefore this video is essential knowledge for SQL developers, DBAs, and even application developers. This tutorial focuses on working with IDENTITY columns as primary keys and how you can retrieve the just-inserted row's primary key value. Several techniques are discussed here with a final discussion on perhaps the "safest" (and recommended) technique.
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: identity, @@identity, scope identity, scope_identity

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 LearnItFirst.com @ 5:53 AM  

MSSQL Server 2000 Video Tutorial: Pt. 2 - Determining Which Event s, Data Columns and Filters to Use in Your Trace

Pt. 2 - Determining Which Events, Data Columns and Filters to Use in Your Trace - view details
You can significantly impact your trace's "drag" on your SQL Server by wisely choosing your events, data columns, and filters when you start your trace. This video walks you through the Event Classes (and makes suggestions as to which to use for what purpose), what common Data Columns are used (and what are Data Columns anyway?), and how filters can be used (what Event Classes use what Filters?).

Highlights from this video:
  • Suggestions for using filters to create more manageable traces
  • Tracing for performance tuning
  • Tracing errors
  • Viewing trace data and interpreting Profiler's results
  • What's the difference between "Profiler" and a "trace"?
  • SQL Batches and the SP:BatchCompleted Event Class
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: sql trace, RPC:Complete, CursorOpen, Deadlock, Exception, Data File Auto Grow, SP:CacheMiss, SP:CacheInsert

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 LearnItFirst.com @ 4:53 AM  

MSSQL Programming and Query Writing Video Tutorial: Pt. 5 - RETUR N Codes and How to Use Them

Pt. 5 - RETURN Codes and How to Use Them - view details
The last video in our "Introduction to Stored Procedures" section, this video helps you understand the @RETURN_VALUE parameter when calling/executing stored procedures. The RETURN statement in SQL Server is very important - it allows you to stop execution inside a stored procedure or trigger. Did you know that it also has the ability to return a value to the caller? It sure can but there are certain rules and Best Practices. Check out this video for more!
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: RETURN, RETURN_VALUE, @@ERROR

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

posted by LearnItFirst.com @ 3:53 AM  

Visual Basic Programming Video Tutorial: Pt. 5 - Using SQL Server Management Studio (SSMS) Express

Pt. 5 - Using SQL Server Management Studio (SSMS) Express - view details
This is part 5 of a 5 part video section about installation and usage of the Express Editions of SQL Server 2005. The renowned trainer, Scott Whigham, provides us with his superior knowledge
while training us in non-technical terms in this beginner video for SQL Server. Amongst the very easy to understand detailed explanation of the introduction and configuration of the
SQL Server Management Studio Express (SSMS), connecting to a database and the major differences between starting SQL Express and SQL Enterprise you will also find the following excellent training
material:
  • Intro to authentication in SQL Server
  • Real wo rld errors when logging into SQL Express
  • How to identify and read what version of SQL Server you are currently using
  • Connecting to other SQL Instances
  • Connecting to an alias
  • Connecting to Object Explorer
  • Creation of a new database and tables
  • Navigation of Table Column Properties
  • Create Primary Keys
  • Working with the table properties
  • In depth discussion on adding data to tables via SSMS
  • Primary key error example
  • HOW TO properly backup a database
  • Discussion of lack of maintenance jobs within SQL Express
  • HOW TO properly restore a database from a backup
  • SQL Express vs Enterprise Edition security comparison
This is the icing on the cake; a wonderful end to a phenomenal section of videos that is sure to boost your knowledge up to the top along with everyone else. In less time than it takes to install SQL Server Express Editions and add-ons you can have all of th e knowledge so you know what to do and what not to do. This video and video section is perfect for all beginners and intermediate users alike. If you need to know about it within the Express Editions, chances are very good it has been covered somewhere in this video section.

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

Keywords for this video: ssms, enterprise manager, query analyzer

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 LearnItFirst.com @ 2:53 AM  

MSSQL Programming and Query Writing Video Tutorial: Pt. 2 - Using the SELECT Statement With and Without a FROM Clause

Pt. 2 - Using the SELECT Statement With and Without a FROM Clause - view details
This particular video utilized the Northwind database in order to show you one of the seven simple main sequences of SQL focusing on the SELECT statement, requirements and various uses. Amongst the previously mentioned wealth of information in itself you will also find training on the following items in this video:
  • Real life examples involving SELECT statement variations
  • Properly utilization of parsing engines prior to execution in SSMS
  • Basic introduction to scalar values
  • SELECT statement return values
  • Introduction to scientific notation
  • Properly using SQL Server calcuation functions
  • SELECT FROM statements
  • Basic definition for result sets
  • Introduction to highlight execution
  • Basic introduction to boulean testing
  • Defining new columns
  • Common error when working with multiple columns with SELECT statements
  • Introduction, definition and explanation to Column Aliases "AS"
  • Explanations to why to utilize the "AS" clause
  • Basic expression definition
  • Introduction and explanation to concatanations
This video has a wealth of knowledge for the beginner and intermediate user alike. Everyone that watches this video should learn something, novice and advanced user alike. This second video of the section is filled with an abundance of information just waiting to be absorbed. This video is definitely a must watch if you wish to learn more about the SELECT statement.

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

Keywords for this video: SELECT, FROM, clause, dml, data manipulation language, AS,

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 LearnItFirst.com @ 1:53 AM  

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

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

Highlights from this video:
  • Viewing new products and classifications recently added
  • Adding new classifications and products
  • Forcing a synchronization for updates
  • Approving updates for specific machines
  • Deploying your updates
and much more!
To download this video, Login 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 deploy, wsus product, wsus classification

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 LearnItFirst.com @ 12:53 AM  

Wednesday, July 29, 2009

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, Login 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 LearnItFirst.com @ 11:53 PM  

MS Exchange 2007 Video Tutorial: Manage Mailbox Permissions on Ex change 2007 SP1

Manage Mailbox Permissions on Exchange 2007 SP1 - view details
In SP1 for Exchange 2007, there are some new features. In this video Grant will demonstrate to you the new ability to grant users permission to another user's mailbox without using a powershell command or behind the scenes in the active directory.

Highlights from this video:
  • Two options for reciepient configuration:
    • Manage full access permissions
    • Manage Send-As permissions
  • Where might I use these configurations?
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: mailbox permissions , exchange sp1, service pack 1, , introduction, step by step, beginner, beginning, for dummies

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 LearnItFirst.com @ 11:22 PM  

SQL 2005 Reporting Services Video Tutorial: How to Silently Insta ll Visual Studio 2005 Service Pack 1 for Your Reporting Services Tools

How to Silently Install Visual Studio 2005 Service Pack 1 for Your Reporting Services Tools - view details
This great video tutorial will give you a walkthrough of service pack 1 silent installation for Visual Studio 2005 for your Reporting Services Tools.

Highlights from this video:

  • Where to download SP1 for VS2005
  • Executing the service pack in DOS prompt
  • What is "quiet mode"?
  • How to tell if SP1 is successfully installed
To downlo ad this video, Login then then visit the video's detail page and click "download".

Keywords for this video: quiet mode, service pack 1 visual studios, SP1 visual studio, visual studios, 2005, reporting services tools,

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 LearnItFirst.com @ 9:53 PM  

SharePoint (MOSS/WSS) Video Tutorial: Troubleshooting a Reocurri ng DCOM Permissions Error in SharePoint

Troubleshooting a Reocurring DCOM Permissions Error in SharePoint - view details
Have you seen errors like, 'Error: Access Denied" when trying to access a SharePoint site (possibly displaying something like 'Current User: You are currently signed in as MACHINENAME\Administrator')? If so, you've probably fallen victim to a commonly seen SharePoint error and, if so, this great instructional video can help!
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: DCOM Permissions Error, error:access denied, common errors, error

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 LearnItFirst.com @ 8:53 PM  

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, Login 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 LearnItFirst.com @ 7:53 PM  

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, Login 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 LearnItFirst.com @ 6:53 PM  

MSSQL Server 2005 Video Tutorial: Part 1 - An Overview of the Set up Process Including Installing the Pre-Requisites

Part 1 - An Overview of the Setup Process Including Installing the Pre-Requisites - view details
The setup process for SQL Server 2005 is very involved, may take you over an hour (depending on features you choose and speed of media) and often features cryptic messages and stringent requirements. This video is designed to help you understand the initial setup including installing the Pre-Requisites (such as the .NET 2.0 Framework). You'll also receive a few suggestions and recommendations for ensuring a smooth setup experience.
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: sql prerequisite, sql pre-requisite, minimum requirements, sql hardware, .net, setup, set up, beginner, beginning, for beginners, introduction, step by step

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 LearnItFirst.com @ 5:53 PM  

Visual Basic Programming Video Tutorial: Pt. 5 - .NET Namespace B est Practices and Do's and Don'ts

Pt. 5 - .NET Namespace Best Practices and Do's and Don'ts - view details
This video is just a collection of tips for using namespaces in your applications: do's and don'ts, assembly best practices, namespace best practices and more.

Highlights from this video:
  • Coding standard suggestions
  • Things not to do when organizing your code
  • Visual Basic tips for changing the root namespace
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: ooad, object oriented analysis and design

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 LearnItFirst.com @ 4:53 PM  

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, Login 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 LearnItFirst.com @ 3:53 PM  

MSSQL Server 2008 Video Tutorial: How to Create and Manage Applic ation Roles

How to Create and Manage Application Roles - view details
Much like our previous video, this video will demonstrate how to create and manage application roles.

Highlights from this video:
  • Creating a new application role
  • Using functions to determine server role memberships

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

Keywords for this video: application role, roles, create role, 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 Ser ver 2008 training videos.

posted by LearnItFirst.com @ 2:53 PM  

MSSQL Server 2005 Video Tutorial: Templates in SQL Server Managem ent Studio - What They Are and How to Use Them

Templates in SQL Server Management Studio - What They Are and How to Use Them - view details
Templates were added to SQL Server 2000's Query Anaylzer and were a very handy tool (though mostly unused). SQL Server 2005's Management Studio expands on SQL Server 2000's templates by allowing you to easily add your own templates, write templates in multiple languages (such as T-SQL, XMLA or MDX), and the easy-to-use Template Explorer.
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: query template, tsql template, xmla, mdx, dmx, parameter, default value

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 LearnItFirst.com @ 1:53 PM  

MSSQL Server 2005 Video Tutorial: Pt. 6 - More on Format Files, . fmt Files, and the New XML Format Files

Pt. 6 - More on Format Files, .fmt Files, and the New XML Format Files - view details
This video tutorial will continue with more information on the format files and present you with some options for making BCP run faster with data.

Highlights:
  • Effects of setting batch size too small
  • How to do a fast copy of a table with indexes
  • Using "load hints" and advantages
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: batch size, load hints, format files, BCP,

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 LearnItFirst.com @ 12:53 PM  

MSSQL Server 2005 Video Tutorial: Pt. 2 - Log Shipping Concepts, Architecture and Requirements

Pt. 2 - Log Shipping Concepts, Architecture and Requirements - view details
Part two in our SQL Server log shipping tutorial section discusses the concepts and strategies of log shipping including:
  • Requirements for implementing log shipping
  • Basics of log shipping: how synchronizations work
  • The process and architecture of how log shipping works
  • NO RECOVERY mode (sometimes called NORECOVERY) and STANDBY mode
  • How failover works in log shipping9
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: standby servers, warm standby serve rs, disaster recovery, clusters, witness

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 LearnItFirst.com @ 11:53 AM  

MSSQL Programming and Query Writing Video Tutorial: Pt. 2 - How t o Work With Arrays and Split() Functions in SQL Server

Pt. 2 - How to Work With Arrays and Split() Functions in SQL Server - view details
This video shows you one technique for working with arrays in SQL (such as a,b,c,d,e,f,g,h) and it uses a table of numbers as its 'base'.

Highlights from this video:
  • What are arrays? Why would we need them in SQL?
  • What are the elements of an array?
  • Understanding the algorithm for the dbo.Split() function
  • Working with CSV values (comma separated values)
  • Explanations of CHARINDEX, SUBSTRING, LEFT, RIGHT, LEN, and REPLACE functions
and much more

N.B. Included in this video download are the script files to create your own Split() function
To download this video, Login 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 LearnItFirst.com @ 10:53 AM  

Windows Server 2003 Video Tutorial: Part 10 - Request SSL Certifi cate and Configure WSUS to Use SSL

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

Highlights from this video:
  • Viewing WSUS Administration Properties
  • Making a request for an SSL certificate via Web Server Certificate Wizard
  • Working with a certificate authority
  • Issuing a certificate and configuring your clients
and much more!
To download this video, Login 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 ssl, ssl, ssl certificate,

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 LearnItFirst.com @ 9:53 AM  

SQL 2005 Reporting Services Video Tutorial: Pt. 1 - An Overview o f Reporting Services Security

Pt. 1 - An Overview of Reporting Services Security - view details
This first video in the four part section will begin your walkthrough of the several layers of security in Reporting services.

Highlights from this video:

  • Helpful tools with which to assign security
  • About the System Administrator and System User roles
  • Using Report Manager vs Management Studio
  • How run applications as different users

��

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

Keywords for this video: reporting services, security, roles, permissions, administrator, user, report manager, management studio,

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 LearnItFirst.com @ 8:53 AM  

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

Take (Prepare) an Exchange Backup: How to Backup Your Exchange Server's Databases - view details
One of the most important tasks for an Exchange administrator is to perform system backups. This video talks you through creating Exchange backups and gives you best practices and ideas for developing an optimal strategy for your organization
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: exchange 2003 backup, 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 LearnItFirst.com @ 7:53 AM  

ISA 2006 Admin Video Tutorial: Discussion of Enterprise and Array Configuration of ISA Server 2006

Discussion of Enterprise and Array Configuration of ISA Server 2006 - view details
After you've completed your ISA Server 2006 Enterprise Edition installation, you'll want to configure your server. When you launch the ISA Server Management tool, you see the same tool that you use to manage the Standard Edition except your have options for Enterprise Management and Arrays Management - what are those?

Highlights from this video:
  • What Enterprise Policies are and how to use them
  • What Enterprise Networks and Add-Ins are and how to use them
  • Using Array Firewall policies
  • When should you use ISA Server Enterprise Edition instead of Standard Edition?
  • Best Practices for using ISA Server
and much more
To download this video, Login then then visit the video' s detail page and click "download".

Keywords for this video: security, best practices

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

posted by LearnItFirst.com @ 6:53 AM  

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

How to Reclaim Space on Your Exchange Server By Purging Multiple Mailboxes - view details
By default Exchange holds onto deleted account mailboxes for thirty days. This takes up unnecessary space on your Exchange Server. Exchange trainer Grant Moyle shows you some best practices and how--Exchange-works for reclaiming wasted space
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: purge multiple exchange mailboxes, purge exchange mailboxes

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

posted by LearnItFirst.com @ 5:53 AM  

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

Install ADSIEdit and View Exchange Configuration in AD - view details
ADSIEdit is a fantastic tool that lets you edit the Active Directory. Exchange administrators can use this tool to configure their Exchange servers manually instead of through the GUI-based tools. This video shows you how to install ADSIEdit (via the Windows Support Tools installation) and configure your Exchange Server in a whole new way. All Exchange administrators should see this video!
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: ADSIEdit with Exchange, Exchange Active Directory configuration

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 LearnItFirst.com @ 4:53 AM  

MSSQL Programming and Query Writing Video Tutorial: Pt. 4 - How t o Use the FROM Clause in the DELETE Statement

Pt. 4 - How to Use the FROM Clause in the DELETE Statement - view details
This fourth video will detail the process of using a FROM clause in your DELETE statement to reference other tables, a slightly confusing and complex process.

Highlights from this video:

  • About the FROM clause approach
  • Where is it most commonly used?
  • FROM clause process and pattern
  • Common confusion in the FROM clause

and much more!

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

Keywords for this video: FROM. DELETE, clause, statement, reference,

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 LearnItFirst.com @ 3:53 AM  

C# Programming Video Tutorial: Part 4 - Looking at a Filename Pa ttern 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, Login 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 C# online training course, C# Programming with Visual Studio 2005. And be sure to check out even more C# Programming training videos.

posted by LearnItFirst.com @ 2:53 AM  

C# Programming Video Tutorial: Pt. 4 - Working With SQL Server 20 05 Management Studio Express Edition

Pt. 4 - Working With SQL Server 2005 Management Studio Express Edition - view details
This is the 4th of four very informative and enterprising videos about installing SQL Server 2005 Express Edition on a Windows Vista Operating System (OS). Renowned trainer, Scott Whigham, takes us to the next level, sharing his knowledge and expertise when training us in a non technical fashion on an introduction to SQL Server Management Studio (SSMS). In this video you can also expect to learn:
  • Properly Launching SSMS
  • Connect to Server Window
  • Properly setting your server name
  • Default Instance in SQL Server
  • Resolving the Common "Trusted Connection" Error within SSMS
  • Properly C onnecting to SQL Server
  • Identifying what version of SSMS you are utilizing
  • Intro to proper navigation with SSMS
  • Advanced Technique for speeding up SQL Server Management Studio
  • Creation of a new database
  • Changing the standard pathway for your database
  • Common tasks for your new database
  • Creation of new tables
  • Creation of new database diagrams
  • Creating primary keys
  • Creating columns within tables using database diagrams
  • Intro to basic troubleshooting for SSMS
  • Properly populating columns using the GUI interface within SSMS
This video is yet another absolutely astounding conclusion to a video section provided by trainer, Scott Whigham. The amount of information enclosed into this video section will not only start you on your journey of download, installing and working with SQL Server 2005 Express Editions with Advanced Services and the SQL Server Management Studio but will also walk you step by step for all of the pertinent processes and teach you some TSQL along the way. This video section is the absolute best way to make your life a so much easier and relieve the frustration that is involved with WINDOWS VISTA AND the 2005 version of SQL SERVER Express Editions.

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

Keywords for this video: management studio, create, tables, diagrams, primary key, troubleshoot,

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 LearnItFirst.com @ 1:53 AM  

Visual Basic Programming Video Tutorial: Pt. 5 - Using Javascript , CSS, Favicons and More

Pt. 5 - Using Javascript, CSS, Favicons and More - view details
This final video in the section on creating your first web project will cover using javascript, css, and favicons.

Highlights:

  • Rollover image effects using javascript
  • Making a consistent set of rules across a website using CSS
  • File association
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: javascript, favicons,css, rules, customize, customizing

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 Basi c Programming training videos.

posted by LearnItFirst.com @ 12:53 AM  

Tuesday, July 28, 2009

Windows Server 2003 Video Tutorial: Pt 2. - Writing Your First Po werShell Script

Pt 2. - Writing Your First PowerShell Script - view details
In this video, Grant Moyle walks you through using PowerShell for your first script - pretty simple really.

Highlights from this video:
  • Using write-warning, Set-ItemProperty, -path, HKLM and generating code comments
  • Using start-sleep and launching applications from PowerShell
  • Writing a ps1 PowerShell script
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: scripting, wmi, vbs, batch files, dos prompt, command prompt

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

posted by LearnItFirst.com @ 11:53 PM  

Visual Basic Programming Video Tutorial: Pt. 9 - sp_start_job Opt ions and Security: Credentials, Proxy Accounts and More

Pt. 9 - sp_start_job Options and Security: Credentials, Proxy Accounts and More - view details
This is one of Scott's favorites - how to run an SSIS job from a remote machine using a stored procedure called sp_start_job. In this video, Scott talks about how to execute packages remotely using T-SQL as well as discussions on executing remote jobs using .NET. This video talks about scheduling SSIS jobs, credentials, proxy accounts, and more - this is a very 'deep' video.

Highlights from this video:
  • What are SQL credentials?
  • How can I force execution of the SSIS package with a certain account?
  • What are proxies and proxy accounts in SQL?
  • Should I run my SSIS package as the SQL Agent Service Account or is there a better, more secure way?
  • How to assign parameter values when you execute/call a SQL job for SSIS
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: sql server proxy account, job credentials

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 LearnItFirst.com @ 10:53 PM  

MS Exchange 2003 Video Tutorial: How to Delegate Administrative P ermissions & Responsibilities

How to Delegate Administrative Permissions & Responsibilities - view details
This video walks you through the advanced permissions in Exchange Server 2003 including how to delegate permissions and how to use the Exchange Administration Delegation Wizard. Delegation, in Exchange and Active Directory parlance, is the ability to give (delegate) Exchange-related task permissions to Active Directory Users and Groups (objects). You'll learn about how to delegate, the roles within Exchange, and Exchange Server Best Practices for security. This video is primarily targeted for those of working on large Active Directories and possibly multiple Exchange Servers. To learn more about Active Directory permissio ns and Exchange Server 2003, watch this video!
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: exchange server security, exchange best practices, exchange delegate, delegate, permission,

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 LearnItFirst.com @ 9:53 PM  

C# Programming Video Tutorial: Pt. 1 - Installing VS2005 Team Sui te Edition

Pt. 1 - Installing VS2005 Team Suite Edition - view details
This video will introduce you to the process of installing the Team Suite Edition of Visual Studio 2005.

Highlights:
  • What are the different versions of Visual Studio 2005?
  • What is included in the Team Suite Edition?
  • Custom features to install
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: team suite, edition, custom features, 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 LearnItFirst.com @ 8: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, Login 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 LearnItFirst.com @ 7:53 PM  

MS Exchange 2007 Video Tutorial: How to Add a New Disk and Move Y our Exchange Databases

How to Add a New Disk and Move Your Exchange Databases - view details
When you're configuring an Exchange 2007 server to act as a mailbox server, you want to make sure that the disks that hold the database (the mailboxes) are not doing anything else like file shares, SQL Server databases, etc. This is for performance as well as recoverability.

Highlights from this video:
  • How to add a disk and partition to your system
  • Changing the Storage Group Name and Database Name
  • Changing the Database file path
  • Best Practices for Exchange 2007 databases
  • How dismounting works in Exchange 2007
  • The "Move Database Path" wizard
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: disaster recovery, multiple hard drives, database files, log files, logging

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 LearnItFirst.com @ 6:53 PM  

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

Things You Have to Know Before You Install SQL Server - Part 1 - view details
In this video, your instructor will go over a lot of different decisions you need to make as well as things you need to know before you install SQL Server 2008. There's a lot of prep work that is needed before the actual install, and in this video tutorial your instructor will cover just that. This video begins by discussing two questions that will help you determine what to do for your install of SQL Server 2008: "What type of server?" and "What is the role of the server?".

Highlights from this video:
  • What type of server are you installing?
    • How to determine what server you're working with
  • What is the main role of your particular server?
    • SSRS?
    • Domain controller?
    • SharePoint? etc
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: install, sql, server, 2008, role, db,, 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 LearnItFirst.com @ 5:53 PM  

C# Programming Video Tutorial: Pt. 4 - Nesting Namespaces and Org anizing Your Classes and Code

Pt. 4 - Nesting Namespaces and Organizing Your Classes and Code - view details
��This video shows namespace clashes, more on organizing code, and shows you how to use the C# using statement and the VB Imports statement to reference namespaces. You'll see both VB.NET and C# code for managing namespaces.

Highlights from this video:
  • Imports vs. using for declaring namespace references in .NET
  • Adding references to assemblies from a VS project
  • How Intellisense works with namespaces
  • Icons of the Intellisense
  • Multiple techniques for resolving namespace naming clashes
  • Using aliases such as
    • using as = AssemblyName;
    • Imports as = AssemblyName
      • < /ul>
    and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: ooad, object oriented analysis and design

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 LearnItFirst.com @ 4:53 PM  

Visual Basic Programming Video Tutorial: Pt. 1 - Understanding th e Different Filetypes and Items Available

Pt. 1 - Understanding the Different Filetypes and Items Available - view details
This video walks you through several of the New Item options (Web form, User Control, Class, etc) and talks about the various file extensions and types (.aspx, .ascx, .asmx, for example).

Highlights from this video:
  • A detailed walk through (with examples) of the majority of the file types
  • Learning how User Controls are used
  • Classes, XML files, static files
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: web services, xml, xsd
< br />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 LearnItFirst.com @ 3:53 PM  

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, Login 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 LearnItFirst.com @ 2:53 PM  

MS Exchange 2003 Video Tutorial: How to Build a User With Establi shed Email (Forward Mail to Another Account)

How to Build a User With Established Email (Forward Mail to Another Account) - view details
Infrequently you need to give users access to your Active Directory who have limited access. This video shows you how to forward messages sent to an Active Directory contact to an 'outside' email address. This user will be able to log on to the network but will not have a mailbox on our system
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: forward email 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 LearnItFirst.com @ 1:53 PM  

MSSQL Server DTS Video Tutorial: DTS Architecture - Using Profile r to Learn DTS

DTS Architecture - Using Profiler to Learn DTS - view details
Yet another tutorial in our section on the inner workings of DTS, this video shows you how you can learn the system stored procedures and tables that are used by the Enterprise Manager if you'll use Profiler to trace the SQL passed by the Enterprise Manager. Using Profiler is an excellent way to learn the language of SQL and it's also a helpful tool to learn DTS from the inside out.
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: tracing, profiler, SQL trace, sp_adddtspackage, sysdtspackages

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 LearnItFirst.com @ 12:53 PM  

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

Pt. 2 - Using Views in the Real World - view details
This video, part 2 in our section on using views, helps you understand the logic behind using views as well as providing real world examples for designing and using views in your databases and applications.
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: sql view, stored query, stored queries, 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 sure to check out even more MSSQL Server 2000 training videos.

posted by LearnItFirst.com @ 11:53 AM  

MSSQL Server 2005 Video Tutorial: Pt. 2 - How to View and Underst and a SQL Server Data Page (and Index Pages, GAM, IAM, PFS, etc)

Pt. 2 - How to View and Understand a SQL Server Data Page (and Index Pages, GAM, IAM, PFS, etc) - view details
This is the second video of a section of 5 highly advanced and extensive videos about page splits. This incredible video houses a variety of some phenomenal information. There is some SQL Server advanced knowledge required to get the most out of this video. You can expect to see the following items within this video:
  • Introduction and detailed explanation of the DBCC PAGE() function
  • Proper syntax while utilizing the DBCC PAGE() function
  • Explanation of the functionality of the DBCC PAGE() function
  • Basic introduction to DB_NAME() function
  • Introduction to trace flag 3604 (DBCC Page Output)
  • Intro duction to DBCC TRACEON() function
  • Detailed descriptions and discussion on DBCC PAGE() function Output
  • Introduction to the use of the OBJECT_NAME() function
  • Introduction to pminlen, m_slotCnt, m_pageID, bstat, MetaDeta, m_objID, m_ghostRecCnt,
  • Page Types, Byte Length, Page Splits, m_freeCnt
  • Properly Adding new records utilizing TSQL
Trainer, Scott Whigham, introduces to us to a variety of functions and other items you will see during page splits. This is an excellent following video to start you in the right direction to show you what happens during a page split. All levels whether you are beginner, intermediate or advanced will be smarter for having watched this video. You can very easily follow this video even if you have had no experience with page splits. Beginner levels should come back and watch the video section again to get the most of out this video.

NOTE: This description was written by one of our me mbers, Wayne Leiser. Thanks, Wayne!
To download this video, Login then then visit the video's detail pa ge and click "download".

Keywords for this video: data page, Index Pages, GAM, IAM, PFS, dbcc

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 LearnItFirst.com @ 10:53 AM  

MSSQL Server 2005 Video Tutorial: Pt. 1 - Event Notifications in SQL Server 2005: How to Perform Extensive Auditing of All Logins

Pt. 1 - Event Notifications in SQL Server 2005: How to Perform Extensive Auditing of All Logins - view details
This is the first of three very excellent advanced videos detailing out specific information towards Service Brokers in SQL Server. This video starts out with an introduction to Event Notification, Service Broker, Routes, Queues and Services and proceeds on with the following:
  • Advanced creation of a logon, trapping type of a table
  • Complex script automatically provided with this video
  • Starts out with the end result prior to training
  • Proper Utilization of the Windows Event Viewer
  • Review of types of information logged in with event logging
  • HOW TO Filter Events
  • Comm on Error resolution when working with event logging
  • Introduction to Database Creation utilizing TSQL
  • Minor Review of SSRS ServiceAccount
  • Basic overview of table creation utilizing TSQL
  • Introduction and proper use of ENABLE_BROKER
  • ENABLE_BROKER definition and explanation
  • Basic explanation to QUEUE creation
  • Basic explanation to ROUTE and SERVICE creation
  • Intro to AUDIT_Login, AUDIT_Login_FAILED
  • Intro to Event Notification Creation
  • Intermediate to Advanced Explanation of the Event Notification
  • Explanation of the importance of ANSI_NULLS, QUOTED_IDENTIFIER and NOCOUNT
Trainer extraordanaire, Scott Whigham, starts another excellent section of videos to help teach us step by step exactly what we should know in order to work with Service Brokers. This is an advanced video and you should have some intermediate to advanced knowledge about SQL Server in order to understand and follow this video.

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

Keywords for this video: service broker, routes,queues, service, event notification, audit,

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 LearnItFirst.com @ 9:53 AM  

MSSQL Programming and Query Writing Video Tutorial: TempDb Databa se - An Overview of How it Works and When to Use It

TempDb Database - An Overview of How it Works and When to Use It - view details
Yet another excellent video in our section on SQL Server 2005's system databases, this video teaches you the ins and outs of tempdb. SQL Server guru Scott Whigham walks you through the layout of the main tables, how things have changed, working with temporary tables and table variables and more. A good video to help learn more about the SQL Server architecture.
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: system database, table variable, temp table, temp db

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 LearnItFirst.com @ 8:53 AM  

Visual Basic Programming Video Tutorial: Pt. 2 - Adding Objects a nd Working With Events, Properties and More

Pt. 2 - Adding Objects and Working With Events, Properties and More - view details
This great video tutorial will walk you through the process of customizing your default.aspxpage by adding objects and working with events, properties, and more!

Highlights:

  • Customizing default.aspxpage
  • How to set properties inside of code
  • Adding images,tables, etc.
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: web application, .aspx, objects, event, properties, add, customize, customizing

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 LearnItFirst.com @ 7:53 AM  

C# Programming Video Tutorial: Tips for Writing Effecient If, Swi tch, and Select Case Statements

Tips for Writing Effecient If, Switch, and Select Case Statements - view details
This instructional video will walk you through the��concept of writing itterations,loops and If statements. This video will cover just about any programming language in Visual Studios, as well as boosting your code.

Highlights:

  • How to write conscise IF/SWITCH/CASE�� statements
  • Blocking the thread for a given amount of time
  • Common logic among languages
  • Creating a variable, i.
To do wnload this video, Login then then visit the video's detail page and click "download".

Keywords for this video: If, Switch, Select Case, Statements, i, case, data structure, loops,loop, iteration

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 LearnItFirst.com @ 6:53 AM  

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, Login 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 LearnItFirst.com @ 5:53 AM  

MSSQL Programming and Query Writing Video Tutorial: Part 3 - Work ing with Prepared Plans

Part 3 - Working with Prepared Plans - view details
In this third video in the section, we will continue working with the case when you have two different parameterized values in your queries. Does this result in multiple Prepared plans or just one Prepared plan?Will SQL be able to re-use or will it have to create a new plan? SQL files included in the download.

Highlights from this video:
  • Viewing how Adhoc references the Prepared Queries
  • When does SQL Server have to come up with a new Prepared plan?
  • Implicit datatype conversion and efficiency
  • Various techniques for Dynamic SQL and Prepared Plan
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this v ideo: adhoc, prepared, plan, query, cache, parameter,

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 LearnItFirst.com @ 4:53 AM  

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

Configure OWA (Outlook Web Access) with a Simple Redirect Page - view details
Make it easier for your users to use Webmail by watching this helpful video. With Webmail, by default, your users have to remember to type in a few options (slash exchange and to use https, for example). You'll learn how to simplify the GUI for your users in this video and configure your web server to forward to your Exchange server. This video contains several helpful tips and tricks for working with Webmail and Exchange
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: Outlook Web Access with Simple Redirect Page, OWA with Simple Redirect Page

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 LearnItFirst.com @ 3: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, Login 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 LearnItFirst.com @ 2:53 AM  

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

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

Highlights from this video:
  • Default automatic approval rule
  • Adding a new custom rule for a specific product
  • Added flexibility of new rules
and much more!
To download this video, Login 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 automatic approval,

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

posted by LearnItFirst.com @ 1:53 AM  

C# Programming Video Tutorial: Pt. 3 - Working with Unary Operators in C#

Pt. 3 - Working with Unary Operators in C# - view details
The C# unary operators are covered in this video including prefix/postfix increment and decrement operators as well as negation and more.
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: ++, ==, --, arguments, expressions

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 LearnItFirst.com @ 12:53 AM  

Monday, July 27, 2009

MSSQL Server 2000 Video Tutorial: Part 2 - Cross Database Ownersh ip Chaining - What It Is and When to Use It

Part 2 - Cross Database Ownership Chaining - What It Is and When to Use It - view details
This video is part 2 in our section on Cross Database Ownership Chaining
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: sql cross-database ownership chaining

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 LearnItFirst.com @ 11:53 PM  

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

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

Highlights from this video:
  • Managing multipl e file types with SyncToy
  • Keeping local directories in sync
  • Keeping remote directories in sync
  • Synchronizing USB drives
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: synctoy, synchronization, copy file, merge, powertoy, power toy

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 LearnItFirst.com @ 10:53 PM  

MSSQL Server 2000 Video Tutorial: Creating and Altering Views in the Enterprise Manager (SQL Server 2000)

Creating and Altering Views in the Enterprise Manager (SQL Server 2000) - view details
If you are new to working with SQL Server (and views), then this is an excellent introduction to creating and altering views using SQL Server 2000's Enterprise Manager. This video is focused on SQL Server 2000 but, for those of you using SQL Server 2005, the screens are almost identical in the SQL Server Management Studio.
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: create view, alter view, drop view

This video comes from the S QL 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 LearnItFirst.com @ 9:53 PM  

MS Exchange 2007 Video Tutorial: Reinstall a Server Role for Exch ange 2007

Reinstall a Server Role for Exchange 2007 - view details
As an Exchange administrator, there may be a time when you need to reinstall a component of Exchange Server 2007. Initially, this sounds like it should be straightforward, and once Grant Moyle shows you the tricks, it will be! In this video, we will uninstall the Client Access Role, a server role, from Exchange Server and then reinstall that component again.

Highlights from this video:
  • Two ways to uninstall the Client Access Role
    • Exchange Management Shell
    • Add/Remove Programs
  • What are our options for reinstalling the particular components?
  • How to successfully complete the install
and muc h more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: role, client access, component,install, uninstall,reinstall

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 LearnItFirst.com @ 8:53 PM  

SharePoint (MOSS/WSS) Video Tutorial: Office 2007 Installation, Tour and Discussion of Using Office 2007 With SharePoint Services 3.0

Office 2007 Installation, Tour and Discussion of Using Office 2007 With SharePoint Services 3.0 - view details
This great instructional video will show you the major advantages of Windows SharePoint Services 3.0 and it's integration with Office 2007.

Highlights:
  • How to install the Office 2007 Enterprise edition
  • What are some of the major differences between Office 2007 and Office 2003 in Powerpoint, Word, and Excel?
To download this video, Login then then visit the video's detail page and cl ick "download".

Keywords for this video: Office 2007 Installation, enterprise edition, Office 2007, integrate, moss, powerpoint, word, excel,

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 LearnItFirst.com @ 7:53 PM  

MSSQL Server 2008 Video Tutorial: Quick Demo: How to Create a SQL Server Login

Quick Demo: How to Create a SQL Server Login - view details
In this short video we will take a look at a demonstration of how to create a SQL Server Loginand what it looks like in the SQL Server Management Studio.

Highlights from this video:
  • How to create a new Login
    • Logging in with your newly created Login
  • Diagram of Logins
  • Using code to change databases
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: sql, server, 2008, Login, create Login, user, database, how to

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 LearnItFirst.com @ 6:53 PM  

SQL 2005 Integration Services Video Tutorial: How to Move a Datab ase Using Backup and Restore

How to Move a Database Using Backup and Restore - view details
This video tutorial shows you one technique for moving/copying a database from one server/instance to another using backup and recovery. There are many techniques for moving and copying databases and, if you haven't moved databases from server to server before, you'll want to be familiar with all techniques.

Highlights from this video:
  • Taking and restoring backups
  • Understanding the RESTORE DATABASE dialog box
  • Resolving issues with restoring databases on other servers
  • Discussion of orphaned Logins
  • Discussion of database compatibility and using sp_dbcmptlevel to view/change compatibility level
  • How to view the SQL Server version in T-SQL
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: backups, restores, disaster recovery

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 LearnItFirst.com @ 5:53 PM  

C# Programming Video Tutorial: Pt. 4 - Working With SQL Server 20 05 Management Studio Express Edition

Pt. 4 - Working With SQL Server 2005 Management Studio Express Edition - view details
This is the 4th of four very informative and enterprising videos about installing SQL Server 2005 Express Edition on a Windows Vista Operating System (OS). Renowned trainer, Scott Whigham, takes us to the next level, sharing his knowledge and expertise when training us in a non technical fashion on an introduction to SQL Server Management Studio (SSMS). In this video you can also expect to learn:
  • Properly Launching SSMS
  • Connect to Server Window
  • Properly setting your server name
  • Default Instance in SQL Server
  • Resolving the Common "Trusted Connection" Error within SSMS
  • Properly C onnecting to SQL Server
  • Identifying what version of SSMS you are utilizing
  • Intro to proper navigation with SSMS
  • Advanced Technique for speeding up SQL Server Management Studio
  • Creation of a new database
  • Changing the standard pathway for your database
  • Common tasks for your new database
  • Creation of new tables
  • Creation of new database diagrams
  • Creating primary keys
  • Creating columns within tables using database diagrams
  • Intro to basic troubleshooting for SSMS
  • Properly populating columns using the GUI interface within SSMS
This video is yet another absolutely astounding conclusion to a video section provided by trainer, Scott Whigham. The amount of information enclosed into this video section will not only start you on your journey of download, installing and working with SQL Server 2005 Express Editions with Advanced Services and the SQL Server Management Studio but will also walk you step by step for all of the pertinent processes and teach you some TSQL along the way. This video section is the absolute best way to make your life a so much easier and relieve the frustration that is involved with WINDOWS VISTA AND the 2005 version of SQL SERVER Express Editions.

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

Keywords for this video: management studio, create, tables, diagrams, primary key, troubleshoot,

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 LearnItFirst.com @ 4:53 PM  

SQL 2005 Reporting Services Video Tutorial: Pt. 2 - Further Uses of the Unattended Execution Account

Pt. 2 - Further Uses of the Unattended Execution Account - view details
This second and final video in this short section will continue talking about the Unattended Execution Account and how it works with scheduling and subscriptions.

Highlights:

  • Item-level/ report-level security
  • 4 connection credential options
  • "Override" credentials with execution account
  • Subscription sharing credentials and impersonation
  • Reversible encryption

and much more!

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

Keywords for this video: unattended execution account, credential, scheduling, subscriptions

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 LearnItFirst.com @ 3:53 PM  

Windows Server 2003 Video Tutorial: Prevent Changes to a Customiz ed Microsoft Management Console (MMC)

Prevent Changes to a Customized Microsoft Management Console (MMC) - view details
Ever wonder how to stop other administrators from making changes to your customized Microsoft Management Console? In this quick video tutorial, your instructor will walk you through the process of preventing any changes to be made to a custom MMC.

Highlights from this video:

  • Cleaning up your customized MMC
  • User access levels

and much more!

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

Keywords for this video: admin, MMC, Microsoft management 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 LearnItFirst.com @ 2:53 PM  

ISA 2006 Admin Video Tutorial: How to Configure ISA Server to Sen d Scheduled Reports

How to Configure ISA Server to Send Scheduled Reports - view details
You can configure ISA Server reports to be automatically generated on a daily, weekly, or monthly basis. Why would want to do this? You'll often want to review usage patterns, look for problems, and even give reports to upper-level executives and management (and we know how they love charts and graphs). This video shows you how to customize the reports, manage the schedules, and handle delivery options.

Highlights from this video:
  • Setting up Report Job Schedules
  • Determining what each of the Report Content settings means
  • How to email reports
  • Array Reports
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: reporting, monitoring, analysis

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

posted by LearnItFirst.com @ 1:53 PM  

MSSQL Programming and Query Writing Video Tutorial: An Overview o f the AdventureWorksDW Database

An Overview of the AdventureWorksDW Database - view details
AdventureWorksDW, Microsoft's sample data warehouse for SQL Server 2005 and Analysis Services 2005, is a robust data warehouse design. While it is robust, if you've never worked with a data warehouse, it can be quite intimidating. This video is an overview for those of you new to data warehousing, possibly new to SQL Server and/or Analysis Services, and even for users of Reporting Services. This is a loooooong video - long so that it can cover many of the important dimension tables, measures, and other information about Adventure Works Data Warehouse.
To download this video, Login then then visit the video's detail page and click "download".

Keywords for th is video: adventureworksdw install, sample database, sql server sample database, sql server adventure works, data warehouse, olap

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 LearnItFirst.com @ 12:53 PM  

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, Login 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 LearnItFirst.com @ 11:53 AM  

MSSQL Programming and Query Writing Video Tutorial: Pt. 2 - CREAT E PROCEDURE Syntax and Execution

Pt. 2 - CREATE PROCEDURE Syntax and Execution - view details
This video walks you through the essential syntax elements of the CREATE PROC (or CREATE PROCEDURE if you prefer) statement and also helps you understand how to execute stored procs. At the end of this video, you'll also learn how to modify (ALTER) and remove (DROP) stored procedures.
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: create proc, create procedure, alter proc, alter procedure, drop proc, drop procedure

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 chec k out even more MSSQL Programming and Query Writing training videos.

posted by LearnItFirst.com @ 10:53 AM  

C# Programming Video Tutorial: Pt. 2 - Working with WinForms

Pt. 2 - Working with WinForms - view details
WinForms, short for Windows Forms, are the basis for the UI in any Windows application and this video gets you started with Visual C# Express Edition by creating a Windows application with Windows forms.
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: windows forms apps, winform apps, c# beginner

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 LearnItFirst.com @ 9:53 AM  

SQL 2005 Integration Services Video Tutorial: Part 6- Using Windo ws PowerShell to Test Regular Expressions

Part 6- Using Windows PowerShell to Test Regular Expressions - view details
Tired of all the regular expression theory? In this sixth video in the eight-part section on regular expressions, we'll finally begin writing and practicing our regular expressions via tools built into the OS and third-party applications.

Highlights from this video:
  • Introduction to PowerShell
    • Accessing/downloading PowerShell
    • Use of variables
    • PowerShell proper syntax
  • Testing regular expressions in PS
  • Defining our regular expressions in another variable
  • Using IF, ELSE statements
and much more
To download this video, Login then then vi sit the video's detail page and click "download".

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

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 LearnItFirst.com @ 8:53 AM  

MSSQL Server 2005 Video Tutorial: Pt. 2 - Setting Up Publications for Transactional Replication

Pt. 2 - Setting Up Publications for Transactional Replication - view details
This video walks you through creating publications using the "New Publication Wizard" in SQL Server Management Studio (SSMS). You'll learn about publishing tables and doing vertical as well as horizontal filters.

Highlights from this video:
  • What requirements are there for publishing tables?
  • How to publish an entire table and how to publish only certain columns
  • How to publish all columns but only rows that meet a WHERE clause
  • Should you change the destination object owner?
  • Syntax for writing filters
  • Determining snapshot creation and snapshot agent location/properties
  • How frequently should the snapshot agent run?
  • Configuring Agent Security for the snapshot agent and the log reader agent
  • Should you run the agent accounts as the SQL Server Agent service account?
  • Scripting your publication for easier maintenance/reinitialization
  • After running the wizard, how to modify and view the publication's properties
  • How to generate new snapshots
  • What does the snapshot look like? How is it implemented?
and much more

Keywords: replication architecture,�� transactional, beginning, beginner, intro, introduction, snapshot folder, snapshot, filters, horizontal filter, where clause
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: replication architecture, transactional, beginning, beginner, intro, introduction, snapshot folder, snapshot, filters, horizontal filter, where clause

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 LearnItFirst.com @ 7:53 AM  

MSSQL Server 2000 Video Tutorial: Pt. 2 - Migration and Upgrade O ptions for Moving From Access to SQL Server

Pt. 2 - Migration and Upgrade Options for Moving From Access to SQL Server - view details
This video covers the basic tools that you use to migrate from Access to SQL Server including discussions of differences in migrating the various versions of Access and SQL Server.

Highlights from this video:
  • Discussions on moving from Access 2007, 2003, 2000, XP, and even 97
  • Techniques for migrating one table at a time
  • Techniques for migrating all tables
  • Using DTS (Data Transformation Services) to upgrade to SQL Server 2000
  • Using SSIS (SQL Server Integration Services) for upgrades to SQL Server 2005
  • Text files as an upgrading option
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: migration, migrating, upgrades, upgrading

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 LearnItFirst.com @ 6:53 AM  

ISA 2006 Admin Video Tutorial: How to Install ISA Server 2006 Sta ndard Edition

How to Install ISA Server 2006 Standard Edition - view details
This video walks you through how to setup ISA Server 2006 Standard Edition. This ISA Server tutorial walks you through setting up the Core Components as well as gives you a solid understanding of all of the options in the setup.

Highlights from this video:
  • The difference between the Typical and Custom setup options
  • The details of the Custom setup choice
  • What's the difference between ISA Server and ISA Server Management?
  • What is Advanced Logging for ISA Server?
  • Determining internal network settings
  • Suggestions for configuring Firewall Client Connections
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: firewalls, introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies,start isa server

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

posted by LearnItFirst.com @ 5:53 AM  

SharePoint (MOSS/WSS) Video Tutorial: Part 1 - How to Configure a SharePoint Server to Use SSL for Secure Communications

Part 1 - How to Configure a SharePoint Server to Use SSL for Secure Communications - view details
Do you want to use SharePoint across the web? If so, you'll likely want to use an SSL certificate to secure and encrypt your communications. This video, part one in our section on how to use certificates with SharePoint 2007, shows you how to configure what are called 'alternate name mappings' or 'alternate access mappings' which is the first step in configuring your SharePoint server for secure connections.
To download this video, Login then then visit the video's detail page a nd 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 LearnItFirst.com @ 4:53 AM  

Windows Server 2003 Video Tutorial: Pt. 2 - Lecture on Why 64 Bit Is a Superior Architecture

Pt. 2 - Lecture on Why 64 Bit Is a Superior Architecture - view details
After preparing for the installation in the last video, you will be starting the install of Windows Server 2003 in this second video.

Highlights from this video:

  • Continued discussion of 64-bit processors
  • 16-bit and DOS applications
  • Completing Windows Setup

and much more!

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

Keywords for this video: 64 bit, install windows server 2003, windows server,

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 LearnItFirst.com @ 3:53 AM  

Windows Server 2003 Video Tutorial: Configure Automatic Updates

Configure Automatic Updates - view details
Whenever you see that little yellow icon/shield in your system tray it's time to do something with Automatic Updates. Security expert Grant Moyle walks you through some suggested configurations of Automatic Updates in this essential video. This video shows you how to configure Automatic Updates on Windows Server 2003 but, for those of you working with Windows XP clients, the same process occurs for Windows XP
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: automatic updates 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 LearnItFirst.com @ 2:53 AM  

MSSQL Server 2000 Video Tutorial: How SQL Server Logs Errors - Th e SQL Server Error Log and Configuration

How SQL Server Logs Errors - The SQL Server Error Log and Configuration - view details
The SQL Server Error Log Viewer in SQL Server 2000 leaves quite a bit to be desired. This video shows you a few alternatives to viewing your SQL Server configuration and errors as well as tips on configuring the SQL Server error logs so that the important logs will be there when you need them. You'll also learn about the architecture of how SQL Server logs errors so that you can manage your SQL Server most effectively.
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: sql error, sql error log, sql log

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

posted by LearnItFirst.com @ 1:53 AM  

MSSQL Server 2000 Video Tutorial: Install Named Instance and View Files and Folders

Install Named Instance and View Files and Folders - view details
This video is a good introduction to installing a SQL Server named instance. It also includes a tour of the changes to the file system - the new files, the new folders, and a comparison between how a default instance works versus how a named instance works.
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: install second instance sql server, sql named 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 LearnItFirst.com @ 12:53 AM  

Sunday, July 26, 2009

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

Part 2: How to View Members of a Windows Group Using SQL - view details
Continued in this video on how to view members and users of a Windows Group via SSMS, Scott will write the actual custom script, which is included with this download, and show you how to obtain your desired result sets.

Highlights from this video:
  • Executing the custom script
  • Matching the output in the stored procedure
  • Obtaining a query-able form of data from the xp_Logininfo procedure
and much more!
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: xp_Logininfo, view members, view users, members, windows groups,

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 LearnItFirst.com @ 11:53 PM  

SQL 2005 Integration Services Video Tutorial: Pt. 1 - An Intro to Using the Script Component In a Transformation

Pt. 1 - An Intro to Using the Script Component In a Transformation - view details
The Script Component is a wonderful addition to SSIS and allows you to do transforms, source and destination components all in .NET - you can't get much more flexible that that! This video helps you understand what the Script Component is and shows you how to begin using the Script Component in a Data Flow Task transformation. The Script Component feature of SSIS is perhaps the most flexible of all the tasks/transformations in SSIS. Drag a Data Flow task onto your SSIS Designer surface and then add a Script Component to your Data Flow container. Notice how it can be either a Source, Destination or Transformation? It is clearly very flexible! But, with all that flexibility comes a price: complexity. Newbies have a particularly tough time understanding when to use the Script Component or another task. Even old-timers (that's folks with lots of DTS experience and who are used to using ActiveX/Active X Script transformations in their Transform Data Tasks) often struggle trying to figure out the best approach to solving a problem with the Script Component!

Highlights from this video:
  • Using the Script Component in your SSIS packages
  • What can you do with a Script Component?
  • When should I use the Script Component?
  • How do I use the Script component in a transformation?
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: Transform data Task

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 LearnItFirst.com @ 10:53 PM  

MSSQL Programming and Query Writing Video Tutorial: Pt. 5 - RETUR N Codes and How to Use Them

Pt. 5 - RETURN Codes and How to Use Them - view details
The last video in our "Introduction to Stored Procedures" section, this video helps you understand the @RETURN_VALUE parameter when calling/executing stored procedures. The RETURN statement in SQL Server is very important - it allows you to stop execution inside a stored procedure or trigger. Did you know that it also has the ability to return a value to the caller? It sure can but there are certain rules and Best Practices. Check out this video for more!
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: RETURN, RETURN_VALUE, @@ERROR

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

posted by LearnItFirst.com @ 9:53 PM  

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

Part 3 - Choosing Your Service Accounts and a Tour of SQL Server 2005's Services - view details
SQL Server 2005 introduces a few new services and a few new choices. This video talks about the services in SQL Server 2005 including the MSSQLServer, SqlServerAgent, SqlBrowser, and more.
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: sql service accounts, mssql, mssqlserver, mssql$, sql agent, full-text, sql browser

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 LearnItFirst.com @ 8:53 PM  

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, Login 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 LearnItFirst.com @ 7:53 PM  

MS Exchange 2003 Video Tutorial: Using Exmerge to Extract Live Mail Data

Using Exmerge to Extract Live Mail Data - view details
This video shows you how to use the Exchange Mailbox Merge Wizard (ExMerge) to extract live mail from your Exchange Server. A tool for every Exchange administrator - a must-see video
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: ExMerge tutorial, how to use ExMerge, 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 LearnItFirst.com @ 6:53 PM  

SQL 2005 Integration Services Video Tutorial: Pt. 4 - Viewing Rep orts; Configuring and Viewing the SQL Server and Windows Application Event Log

Pt. 4 - Viewing Reports; Configuring and Viewing the SQL Server and Windows Application Event Log - view details
This is an excellent conclusion to the video section introducing you to your error logs within SSMS. This video will introduce you to working with Error logs within SQL Server Management Studio (SSMS) as well as some of the following items:
  • Error log viewer
  • Windows Event Log viewable within the Error Log
  • Agents log within the viewer as well
  • Introduction and explanation of the unified log viewer
  • Introduction to integration of reports in management studio
  • Introduction to graphic reports with SSMS
  • Introduction to writing custom reports
This is a perfect conclusion to a very informative video section. After the reviewing the video section in all you should have a very good understanding of SQL Server Management Studio. The whole video section is a must see and is perfect for the newbie and a great reference to the experienced SQL programmer.

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

Keywords for this video: ssms, sql server management studio, management studio, error logs, reports,

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 LearnItFirst.com @ 5:53 PM  

C# Programming Video Tutorial: Pt. 4 - Using the SQL Server Confi guration Manager

Pt. 4 - Using the SQL Server Configuration Manager - view details
This is part 4 of a 5 part video section about installation and usage of the Express Editions of SQL Server 2005. The renowned trainer, Scott Whigham, provides us with his superior knowledge
while training us in non-technical terms in this beginner video for SQL Server. Amongst the very easy to understand detailed explanation of the Configuration Manager you will find the following
extremely informative training lessons:
  • Introduction to SQL Server Express Services
  • Introduction and detailed description of the SQL Server Browser
  • Navigation and use of the SQL Configuration Manager
  • Introduction to Instance Names
  • De finition of an Instance
  • Introduction and definition of the Default Instance vs. Named Instance
  • Introduction and definition to SQL Server Production Protocols
  • Introduction to connecting to SQL Server across a network
  • Minor discussion of Modal Dialog boxes
  • Advanced configuration changes to TCP/IP
  • Native client configuration vs. Network configuration
  • Creation, configuration, definition and explanation of alias
Once again, a superior addon for this already stunning video section. This video provides an easy to follow training session without getting over technical for the beginner. This
is a perfect video for the beginner looking to learn about the various aspects of Express Edition SQL Server software.

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

Keywords for this video: sql port number, server network utility, client network utility, services

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 LearnItFirst.com @ 4:53 PM  

Windows Server 2008 Video Tutorial: In-Place Upgrade from Windows 2003 to Windows 2008, Part B

In-Place Upgrade from Windows 2003 to Windows 2008, Part B - view details
We will continue in this video by exploring our completed upgrade to Windows Server 2008 from Windows Server 2003.

Highlights from this video:
  • What has been left from the installation?
  • Security impact of an upgrade vs a clean installation
  • Exploring the upgrade
and much more
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: upgrade, windows server 2008, windows, windows 2003, upgrading, in-place,

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

posted by LearnItFirst.com @ 3:53 PM  

SQL 2005 Reporting Services Video Tutorial: How to Silently Insta ll Visual Studio 2005 Service Pack 1 for Your Reporting Services Tools

How to Silently Install Visual Studio 2005 Service Pack 1 for Your Reporting Services Tools - view details
This great video tutorial will give you a walkthrough of service pack 1 silent installation for Visual Studio 2005 for your Reporting Services Tools.

Highlights from this video:

  • Where to download SP1 for VS2005
  • Executing the service pack in DOS prompt
  • What is "quiet mode"?
  • How to tell if SP1 is successfully installed
To downlo ad this video, Login then then visit the video's detail page and click "download".

Keywords for this video: quiet mode, service pack 1 visual studios, SP1 visual studio, visual studios, 2005, reporting services tools,

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 LearnItFirst.com @ 2: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, Login 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 LearnItFirst.com @ 1:53 PM  

SQL 2005 Integration Services Video Tutorial: Part 4 - Queries, S cripting, NOT EXISTS, and Final Thoughts

Part 4 - Queries, Scripting, NOT EXISTS, and Final Thoughts - view details
In this final video in the section, Scott will cover more about custom queries and scripts you can generate for importing Access data, as well as give you some of his final thoughts on Access, importing data, and SQL Server.
Highlights from this video:
  • Writing a custom query to store results in SQL Server tables
  • Scripting a table as a CREATE
  • Using IF NOT EXISTS
��and much more!
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: access, microsoft access, import tables, import access, if not exists,

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

posted by LearnItFirst.com @ 12:53 PM  

ISA 2006 Admin Video Tutorial: A Pre-Installation of ISA Server 2 006 Discussion: Requirements and Lecture

A Pre-Installation of ISA Server 2006 Discussion: Requirements and Lecture - view details
Microsoft Internet Security and Acceleration Server (or ISA for short) 2006 requires a few things before you try to install it. This video walks you through the requirements as well as providing Best Practices for ISA Server 2006 installations.

Highlights from this video:
  • Service Pack and Operating System requirements
  • Suggested system configurations
  • How to determine system settings prior to installation
  • Configuring IP addresses and network cards (NICs) with ISA Server
and much more
To download this video, Login then then visit the video's detail page and clic k "download".

Keywords for this video: isa 2006, firewall, introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginning, for dummies, start isa server

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

posted by LearnItFirst.com @ 11:53 AM  

MS Exchange 2003 Video Tutorial: How to Move Mailboxes from Excha nge 2000 to Exchange 2003 and Outlook Profile Reconfiguration

How to Move Mailboxes from Exchange 2000 to Exchange 2003 and Outlook Profile Reconfiguration - view details
More in our section on upgrading Exchange 2000 to Exchange 2003, this video teaches you how to move mailboxes from Exchange 2000 to Exchange 2003 and reconfigure Outlook profiles
To download this video, Login then then visit the video's detail page and click "download".

Keywords for this video: move exchange mailbox, outlook profile 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 LearnItFirst.com @ 10: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, Login 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 Integratio