Thursday, July 2, 2009

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

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

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

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

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

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

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

posted by Scott Whigham @ 7:53 PM  

Windows Server 2003 Video Tutorial: How to Auto-Login the Adminis trator Account

How to Auto-Login the Administrator Account - view details
In this video you'll create a new registry key AutoAdminLogon and embed the password/user name in the registry. Even if you don't plan on ever making this change to your system it is always helpful to understand what registry settings are available especially if you are charged with auditing server security - you'll want to make certain this setting is not used on production systems. This video could also be titled 'Hack the registry and tell Windows Server 2003 to auto-login as the Administrator upon reboot'
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: Windows 2003 auto login, Windows Server 2003 auto logon, A utoAdminLogon

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

posted by Scott Whigham @ 6:53 PM  

Visual Basic Programming Video Tutorial: Pt. 2 - Using the Logica l And, Or, and Not Operators, Parentheses, and Else If

Pt. 2 - Using the Logical And, Or, and Not Operators, Parentheses, and Else If - view details
This second video in the section on If statements in Visual Basic 2005 will cover additional??branching within your If statements and the multiple conditions (And,Or,Not) you can use when writing expressions, and also using parenthesis to write even more complex expressions.

Highlights:

  • How to combine conditions using If
  • Conditional requirements??of And, Or
  • About ElseIf statements, Else statements

??

??

??

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

Keywords for this video: And, Or, Not Operators, Parentheses, Else If, statements,else, and ,or,not

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

posted by Scott Whigham @ 5:53 PM  

MS Exchange 2003 Video Tutorial: Part 3 of 4 - Install Exchange 2003

Part 3 of 4 - Install Exchange 2003 - view details
This video continues to prepare the machine for Exchange by running DomainPrep and a few other tools to prepare to install Exchange
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: Exchange 2003 installation

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

posted by Scott Whigham @ 4:53 PM  

Windows Server 2008 Video Tutorial: Overview of FTP Service Inclu ded in Windows Server 2008, Part A

Overview of FTP Service Included in Windows Server 2008, Part A - view details
If you need very basic FTP server functionality on a Windows Server 2008, it is included, but it is not installed by default.In fact, at the time of release for Windows Server 2008, FTP is running under IIS 6.0 not IIS 7.0. In this video we will install the FTP Service, examine some basic configuration and test connectivity.

Highlights from this video:
  • Security in FTP
  • Installing the FTP Server and FTP Management Console
  • Setting your FTP Service to automatically start
  • Exploring default FTP Site properties
and much more
To download this video, log in then then visit the video's detail page and click "download".

Keywords for this video: windows server 208, ftp, ftp server,

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

posted by Scott Whigham @ 3:53 PM  

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

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

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

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

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

posted by Scott Whigham @ 2: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, log in 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 Scott Whigham @ 1:53 PM