Tuesday, September 25, 2007

Free SQL Server 2005 Video Tutorial: Pt. 1 - Why Migrate From Microsoft Access to SQL Server?

Pt. 1 - Why Migrate From Microsoft Access to SQL Server? - download
So it's time to move away from using that friendly, rapid-application-development tool Microsoft Access and start using a full-blown relational database management system such as SQL Server, eh? There are many reasons to move from Access to SQL Server and this video gives you the primary reasons why people move from Access to SQL.

Highlights from this video:
  • Differences between Access and SQL Server
  • Definitions of the ACID test and how it applies to SQL Server but not to Access
  • Memory and CPU support in SQL Server
  • How transactions are handled differently between the two systems
and much more
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: upgrade access, upgrade Access 2003, upgrade Access 2007, upgrade Access XP, upgrade Access 2000

posted by Scott Whigham @ 5:14 AM   0 comments links to this post

Free SQL Server 2005 Video Tutorial: Pt. 1 - An Introduction to Using Views in SQL Server

Pt. 1 - An Introduction to Using Views in SQL Server - download
Who uses views? We all do! Every developer, DBA, business analyst, systems analyst, manager, CEO, etc uses views to access the data in the database. Views make life so much easier - they are, for many people, the first choice to simplify query-writing and/or create reusable queries.

This video, recorded by resident expert Scott Whigham, is a great introduction to using views and helps with:
  • When should I use a view?
  • Should I use a view or a stored procedure?
  • What is the basic syntax for creating views in SQL Server?
and much more.
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 view, stored query, stored queries, views, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 5:14 AM   0 comments links to this post

Free Exchange 2007/2003 Video Tutorial: Public Folder Database Properties

Public Folder Database Properties - download
Learn about public folders and the MAPI public folders in Exchange and Outlook Web Access (OWA). This video walks you through the properties and configuration options for managing a single public folder so that it is available in Outlook 2003
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: exchange 2003 public folders, exchange public folder properties

posted by Scott Whigham @ 5:13 AM   0 comments links to this post

Free Exchange 2007/2003 Video Tutorial: What Are Recipients and Recipient Update Services?

What Are Recipients and Recipient Update Services? - download
There are two Recipient Update Services - do you know what each one does? This video explains both services - the Recipient Update Service (Enterprise Configuration) and the one for your organization. A must-see video for beginners!
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: exchange recipient update services, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 5:13 AM   0 comments links to this post

Thursday, September 20, 2007

Free Windows 2003 Video Tutorial: Create a Shortcut to a Blank Screen or a Screensaver

Create a Shortcut to a Blank Screen or a Screensaver - download
In this short video, Grant Moyle (our author) shows you how to create a shortcut that pops up a blank screen or a screensaver. This is really useful if you use PowerPoint or if you give presentations and you want to blank the screen or to show a quick screensaver.

This is a great tip for Windows users and admins alike!

Highlights from this video:
  • Screensaver files and creating shortcuts
  • how to assign key stroke combinations to cut to a blank screen (using your new shortcut)
and much more.
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

posted by Scott Whigham @ 3:16 PM   0 comments links to this post

Free Windows 2003 Video Tutorial: Customize Internet Explorer and the Desktop Using Local Policy

Customize Internet Explorer and the Desktop Using Local Policy - download
You can change the computer's Local Policy (using gpedit.msc) to influence Internet Explorer and make many desktop and user-experience customizations. In this video you'll learn how to change the browser's user interface including how to change the browser title and include custom logos inside Internet Explorer
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: Change internet explorer logo

posted by Scott Whigham @ 3:16 PM   0 comments links to this post

Free Transact SQL Video Tutorial: Design Patterns and SQL Programming - How You Can Use Patterns to Simplify Your Life

Design Patterns and SQL Programming - How You Can Use Patterns to Simplify Your Life - download
Think of this video as the introduction to Design Patters and SQL. This video, recored by Scott Whigham, walks you through the idea of using patterns to simplify your SQL programming. Design Patterns are in nearly every modern language yet they are not often seen in SQL. This video shows you the basics of design patterns and how to use some common patterns. It is suggested that you watch this video before continuing on to the other Design Pattern videos.
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: design pattern, go4

posted by Scott Whigham @ 2:35 PM   0 comments links to this post

Free Transact SQL Video Tutorial: Pt. 1 - An Overview of the SELECT Statement: Clauses and Sequence

Pt. 1 - An Overview of the SELECT Statement: Clauses and Sequence - download
Welcome to video number 1 of a series of 7 masterfully recorded videos about working with the Data Manipulation Language (DML) SELECT statement. This fantastic introduction to the SELECT statement
will astound you with its extremely informative information. This video and the series will save you hours upon hours of research. Along with the introduction to usage and common terminology
of the SELECT statement you will also find the following extremely helpful information packed inside this video:
  • Returns from a SELECT statement
  • Introduction to the SELECT, FROM, JOIN, WHERE, GROUP BY, HAVING, ORDER BY statements
  • Transact SQL (T-SQL) definitions
  • Minimal requirements in T-SQL when writing statments
  • SELECT statement definition and explanation
  • FROM clause definition and explanation
  • JOIN statement definition and explanation
  • WHERE clause definition and explanation
  • GROUP BY statement definition and explanation
  • HAVING clause definition and explanation
  • ORDER BY statement definition and explanation
This video is definitely a great start to understanding the many variable functions for the SELECT statement. This video and the video series is a must see for anyone looking to further their knowledge or education about the SELECT statement. This video is good for the beginner and more advanced users alike whether you are looking for a reference to save yourself lots of time with a proven more effective learning process.

NOTE: This video was reviewed and this description was written by one of our members, Wayne Leiser. Thanks,Wayne!
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 - An Overview of the SELECT Statement: Clauses and Sequence

posted by Scott Whigham @ 2:35 PM   0 comments links to this post

Thursday, September 06, 2007

Free SQL Server 2005 Video Tutorial: Installing an FTP Server on Your Windows 2003 Server

Installing an FTP Server on Your Windows 2003 Server - download
This video helps you install an FTP (File Transfer Protocol) server onto your Windows 2003 Server. You will set up account logging, throttling (the number of users), and set up the IUSER account(s).
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: FTP Server Windows 2003, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 10:24 AM   0 comments links to this post

Free SQL Server 2005 Video Tutorial: DHCP Server: Assign Reserved IP Addresses

DHCP Server: Assign Reserved IP Addresses - download
This video shows you how you can use both DHCP and static IP addresses easily with Windows Server 2003. You'll also get great explanations of DHCP address leases and expirations, the address pool and reservations. You'll assign reservations to particular machines and get an understanding of the benefits/trade-offs of using static vs dynamic IPs
To download this video, 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: DHCP reserved IP addresses

posted by Scott Whigham @ 10:24 AM   0 comments links to this post