Free Visual Basic Video Tutorial: Pt. 1 - Writing If Statements and Boolean Tests

Pt. 1 - Writing If Statements and Boolean Tests - download

Pt. 1 - Writing If Statements and Boolean Tests

---

• Source: http://www.LearnVBProgramming.com
• Category: Visual Studio .NET Videobooks
• Skill Level: 200 (Beginner - Intermediate)
• Length: 13:00 (8.22MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

---

Keywords Associated with this video: Pt. 1 - Writing If Statements and Boolean Tests

Free Visual Basic Video Tutorial: Getting Comfortable with the Visual Web Developer Environment: Menus

Getting Comfortable with the Visual Web Developer Environment: Menus - download

If you are just starting out and are a little overwhelmed at just how big the Visual Web Developer seems to be (and the other Express Editions for that matter) then you'll get a lot out of this video.

Highlights from this video:

• Getting comfortable in the environment
  
• Tours of the menus and choices and what they mean
• Configuring options for the environment and coding
  

and much more

---

• Source: http://www.LearnVBProgramming.com
• Category: Visual Studio .NET Videobooks
• Skill Level: 100 (Beginner)
• Length: 14:00 (10.6MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

---

Keywords Associated with this video: setup, configuration, configuring

Free SQL Server Integration Services Video Tutorial: Upgrading from DTS to SSIS: Running the SQL Server 2005 Upgrade Advisor

Upgrading from DTS to SSIS: Running the SQL Server 2005 Upgrade Advisor - download

The first thing you'll want to do before migrating to SSIS/SQL 2005 is to run the SQL Server 2005 Upgrade Advisor. However, don't expect great things from it with respect to DTS/SSIS; it only has certain generalities that it will provide you.

---

• Source: http://www.LearnIntegrationServices.com
• Category: SQL Server Videobooks
• Skill Level: 200 (Beginner - Intermediate)
• Length: 14:54 (12.1MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

---

Keywords Associated with this video: SSUA, migrate, migrating, upgrading

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

Tips on Documenting and Annotating Your SSIS Packages - download

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

Highlights from this video:

• Using the Text Annotations Effectively
  
• Arranging and Formatting Your Annotations
  
• Printing and Documenting Your Packages and Tasks
  
• Formatting Your Text for Clear Documentation
  
• Grouping and anchoring text
  

and much more

*** This is an updated video

---

• Source: http://www.LearnIntegrationServices.com
• Category: SQL Server Videobooks
• Skill Level: 100 (Beginner)
• Length: 9:00 (8.50MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

---

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

Free Reporting Services Video Tutorial: Pt. 1 - How to Install SQL Server 2005 Service Pack 2 for Your Reporting Services Installation

Pt. 1 - How to Install SQL Server 2005 Service Pack 2 for Your Reporting Services Installation - download

Pt. 1 - How to Install SQL Server 2005 Service Pack 2 for Your Reporting Services Installation

---

• Source: http://www.learnreportingservices.com
• Category: SQL Server Videobooks
• Skill Level: 200 (Beginner - Intermediate)
• Length: 6:15 (4.58MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

---

Keywords Associated with this video: Pt. 1 - How to Install SQL Server 2005 Service Pack 2 for Your Reporting Services Installation

Free Reporting Services Video Tutorial: Pt. 1 - An Introduction to SQL Server Reporting Services

Pt. 1 - An Introduction to SQL Server Reporting Services - download

This video, part one in a six-part series, talks about what SQL Server Reporting Services (SSRS) is and designed for the absolute beginner - someone who wants a high-level overview of Reporting Services. If you want to get a solid Technology Overview of Reporting Services, this is it.

Highlights from this video:

• Concepts of Server-Based Reporting
• Where is the report stored?
• What are .rdl files?
• Data sources (OLE-DB, ODBC, XML)
• Licensing options
• Types of reports available
  

and much more

---

• Source: http://www.learnreportingservices.com
• Category: SQL Server Videobooks
• Skill Level: 100 (Beginner)
• Length: 9:45 (6.0MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

---

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

Free Windows 2003 Video Tutorial: Configure Your Server Wizard - Setup an Active Directory

Configure Your Server Wizard - Setup an Active Directory - download

Most administrators will run the Configure Your Server wizard at least once when they are learning to configure Windows Server 2003. The Configure Your Server wizard, in this video, is used to build the Active Directory (where information like domain users and permissions are stored). There are many changes to the Active Directory in Windows 2003 and this video highlights several of the new features, the changes, and helps you understand the basics of AD in Windows. This video could also be titled 'Promote Your Windows Server 2003 to a Domain Controller'

---

• Source: http://www.learnwindows2003.com
• Category: Windows Server Videobooks
• Skill Level: 200 (Beginner - Intermediate)
• Length: 6:51 (4.5MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

---

Keywords Associated with this video: Configure Your Server for Windows Server 2003

Free Windows 2003 Video Tutorial: Control the Time/Clock Placement on the Desktop

Control the Time/Clock Placement on the Desktop - download

A user calls you up and says, 'I can't find the clock on my desktop - where is it?' Well? Where is it? Why isn't it in the System Tray?

Did you know that you can hide the clock from the user?

Or that you can prevent the user from changing the date/time on the computer?

This video shows you exactly how to change the settings through policies that allow the user to be able to (or not) change/show the clock.

---

• Source: http://www.learnwindows2003.com
• Category: Windows Server Videobooks
• Skill Level: 100 (Beginner)
• Length: 3:30 (4.0MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

---

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

Free Transact SQL Video Tutorial: Pt. 1 - An Introduction to the UPDATE Statement and Modifying Data With Transact SQL

Pt. 1 - An Introduction to the UPDATE Statement and Modifying Data With Transact SQL - download

Scott Whigham masterfully surprises us once again with this brilliant part 1 video on the proper syntax for the 4 part video series on the Data Manipulation Language (DML) UPDATE STATEMENT. This video is a must have. This video not only demonstrates exactly how to utilize proper syntax and rules when working with the UPDATE statement but is filled with vast amounts of other data and knowledge such as the following:

• Working with Literal values and the updating based upon another table.
• What syntax is available whether this is standard or proprietary.
• Introduction to creating a database with SQL Server Management Studio
• Simplistic table creation (CREATE TABLE)
• Introduction to database backup
• Explaining errors with security privileges when backing up a database.
• Default database backup syntax and location on a local hard drive.
• Introduction and explanation of the SET NOCOUNT ON option.
• Creation and termination of an infinite WHILE LOOP
• Introduction and Explanation of the three SQL Language Classifications:
• Data Manipulation Language (DML): SELECT, INSERT, UPDATE, DELETE
• Data Definition Language (DDL): CREATE, ALTER, DROP (Manipulating Objects in the database)
• Permissions Based Data Control Language (DCL) GRANT, DENY, REVOKE
• Real world common error examples and how to properly prevent these errors.
• Proper syntax for the update statement.
• Proper formatting of your T-SQL Code and common mistakes when improperly formatting and executing your T-SQL Code.
• Introduction of the TOP statement, variable declarations and more.

This video is filled with the proper ways to perform a variety of actions within T-SQL.

NOTE: This video description was written by one of our members, Wayne Leiser. Thanks, Wayne!

---

• Source: http://www.LearnTransactSQL.com
• Category: SQL Server Videobooks
• Skill Level: 200 (Beginner - Intermediate)
• Length: 13:50 (9.16MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

---

Keywords Associated with this video: UPDATE STATEMENT, UPDATE syntax, Data Manipulation Langauge, Data Definition Language, Data Control Langauge, DML, DDL, DCL, CRE

Free Transact SQL Video Tutorial: An Overview of the Northwind Database

An Overview of the Northwind Database - download

Scott Whigham walks you through the layout of the Northwind database in this video. Northwind is used for many demos and videos throughout the site due to how easy it is to work with. This is not a long video but will serve to familiarize you with the sample database used in many of the T-SQL-based videos.

NOTE: You can download the Northwind (and Pubs) sample databases from the microsoft.com website here

---

• Source: http://www.LearnTransactSQL.com
• Category: SQL Server Videobooks
• Skill Level: 100 (Beginner)
• Length: 13:41 (8.36MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

---

Keywords Associated with this video: sample database, sample db, install sample, oltp database, beginner, beginning, for beginners, introduction, step by step

Free Exchange 2007/2003 Video Tutorial: Building Mail Universal Distribution Groups and Dynamic Distribution Groups

Building Mail Universal Distribution Groups and Dynamic Distribution Groups - download

How to Build Mail Universal Distribution Groups and Dynamic Distribution Groups

---

• Source: http://www.learnexchange.com
• Category: Exchange Server Videobooks
• Skill Level: 200 (Beginner - Intermediate)
• Length: 13:16 (9.43MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

---

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

Free Exchange 2007/2003 Video Tutorial: Outlook Web Access (OWA) Tour

Outlook Web Access (OWA) Tour - download

How close to Outlook 2003 is Outlook Web Access? Very close! This video details how to use OWA (Outlook Web Access) with Exchange. An essential video for all Exchange administrators

---

• Source: http://www.learnexchange.com
• Category: Exchange Server Videobooks
• Skill Level: 100 (Beginner)
• Length: 7:59 (11.05MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

---

Keywords Associated with this video: Outlook Web Access intro, OWA intro, Outlook Web Access tutorial, OWA tutorial, beginner, beginning, for beginners, introduction

Free ISA Server Video Tutorial: Assigning and Testing Administrative Roles in ISA Server 2006

Assigning and Testing Administrative Roles in ISA Server 2006 - download

In a lot of small and medium companies, the administrator account(s) are known by way too many people. One of the first items a security consultant often suggests changing is to limit the Administrator�� account access and to give each administrator an individual account.

ISA Server is no different: you should create a separate user account for each ISA Server administrator. This video shows you exactly how to do just that!

---

• Source: http://www.learnisaserver.com
• Category: Microsoft Server System Videobooks
• Skill Level: 200 (Beginner - Intermediate)
• Length: 7:30 (7.0MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

---

Keywords Associated with this video: security, best practices, isa server securtiy

Free ISA Server Video Tutorial: A Pre-Installation of ISA Server 2006 Discussion: Requirements and Lecture

A Pre-Installation of ISA Server 2006 Discussion: Requirements and Lecture - download

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

---

• Source: http://www.learnisaserver.com
• Category: Microsoft Server System Videobooks
• Skill Level: 100 (Beginner)
• Length: 7:45 (4.5MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

---

Keywords Associated with this video: isa 2006, firewall, introduction, step by step, beginner, beginning, for dummies, introduction, step by step, beginner, beginnin

Free SQL Server 2005 Video Tutorial: How to Move a Database Using Detach and Attach

How to Move a Database Using Detach and Attach - download

Yet another way to move a database from one instance/server to another is to detach the database from the source and then attach the database to the destination (or to both the source and destination if you want to just copy the database).

Highlights from this video:

• When should I use detach/attach instead of backup/restore to copy/move my database to a new server?
  
• Best practices using detach/attach
  
• Detaching using SSMS and T-SQL
• Attaching using SSMS and T-SQL

and much more

---

• Source: http://www.learnsqlserver.com
• Category: SQL Server Videobooks
• Skill Level: 200 (Beginner - Intermediate)
• Length: 10:30 (9.0MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

---

Keywords Associated with this video: move drive, new servers

Free SQL Server 2005 Video Tutorial: My Favorite SSMS Tweak (by Scott Whigham)

My Favorite SSMS Tweak (by Scott Whigham) - download

This is a quick video that shows Scott Whigham, author of LearnSqlServer.com, talking about his favorite SQL Server Management Studio (SSMS) tweak. This is only about 6:45 but it could save you a few minutes each day!

---

• Source: http://www.learnsqlserver.com
• Category: SQL Server Videobooks
• Skill Level: 100 (Beginner)
• Length: 6:45 (6.65MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

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

---

Keywords Associated with this video: sql tweak, tips and tricks, best practices, sqlwb.exe