Saturday, January 20, 2007

SQL Server 2005 Video Tutorial: JOINs and UNIONs - How Do I Know When to Use a JOIN or a UNION?

JOINs and UNIONs - How Do I Know When to Use a JOIN or a UNION? - view details
So many newbies to Transact-SQL have difficulties determing when to use a UNION or a JOIN to satisy their query. This video teaches you some guidelines to help you quickly and easily identify whether your query will likely need to become a JOIN or UNION. Disclaimer: these are just guidelines and they will not work in every situation but they are applicable for most SQL developers most of the time.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: join union, sql ansi join, sql union all

posted by Scott Whigham @ 11:00 PM    

Visual C# Video Tutorial: Pt. 2 - Understanding the Properties, the Toolbox, and Design Time Programming

Pt. 2 - Understanding the Properties, the Toolbox, and Design Time Programming - view details
Pt. 2 - Understanding the Properties, the Toolbox, and Design Time Programming
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: props

posted by Scott Whigham @ 11:00 PM    

Windows 2003 Video Tutorial: Creating Screen Captures of the Desktop and Individual Windows (Screenshots)

Creating Screen Captures of the Desktop and Individual Windows (Screenshots) - view details
Creating Screen Captures of the Desktop and Individual Windows (Screenshots)
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: Creating Screen Captures of the Desktop and Individual Windows (Screenshots), beginner, beginning, for beginners, introduction,

posted by Scott Whigham @ 10:00 PM    

Exchange 2003 Video Tutorial: Clustering Exchange - Pt. 2 - Installing Exchange Server on the First Node (Node 1) of Your Cluster

Clustering Exchange - Pt. 2 - Installing Exchange Server on the First Node (Node 1) of Your Cluster - view details
Now that you have the cluster built and the prerequisites installed, you can install Exchange on the first node. This video walks you through setting up Exchange 2003 on Node1 (or whatever your cluster machine name is).
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: node 1, node1, first node, cluster, mscs, cluster administrator, clustering exchange, exchange clustered, exchange cluster setup

posted by Scott Whigham @ 10:00 PM    

Microsoft SQL Server Video Tutorial: Pt. 1 - Setting Up the Distributor and Publisher for Transactional Replication

Pt. 1 - Setting Up the Distributor and Publisher for Transactional Replication - view details
This video is a continuation from our introductory series on SQL Server replication and walks you through setting up the distributor and the publisher for transactional replication. You'll walk through setting up replication using the "Configure Distribution Wizard" to configure each option. Included is a detailed explanation of each of the screens in the wizard and recommendations for best practices.

Highlights from this video:
  • Replication architecture
  • What is the "distribution" database?
  • Suggestions for configuring the SQL Server agent for replication
  • What is the snapshot? Where is it stored? How often should it be generated?
  • Scripting the wizard's output for easier replay/debugging/maintenance
  • Using the Replication Monitor
  • Using the Distributor Properties and Publisher Properties
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: replication architecture, transactional, beginning, beginner, intro, introduction, snapshot folder, snapshot

posted by Scott Whigham @ 10:00 PM    

Windows 2003 Video Tutorial: Customize Login Wallpaper

Customize Login Wallpaper - view details
Since so many servers sit at the Windows Logon screen for much of their 'life' many administrators want to change these default screens to something more entertaining and/or useful (such as a clock, calendar, etc). This helps you customize the experience on Windows Server 2003 but the same process will work for Windows XP clients
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: customize login wallpaper, wall paper, change wall paper, modify, computer name, domain name, bginfo

posted by Scott Whigham @ 9:00 PM    

SQL Server 2005 Video Tutorial: Pt. 4 - OUTPUT Parameters and How to Use Them

Pt. 4 - OUTPUT Parameters and How to Use Them - view details
One of the more confusing aspects of the stored procedure is the syntax and usage of OUTPUT parameters. This video tutorial will help you understand what OUTPUT params are, where they are used (in a Singleton pattern, for example), and how to access/assign the values to local variables. Don't miss this video!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: stored proc output params, OUT parameters, advanced stored procedures

posted by Scott Whigham @ 8:00 PM    

SQL Server 2000 Video Tutorial: Part 2 - Network Libraries and Authentication Modes - Choosing What's Right for Your Organization

Part 2 - Network Libraries and Authentication Modes - Choosing What's Right for Your Organization - view details
Part 2 in our series on SQL Server Netlibs
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: sql server netlibs, sql server network libraries, sql server appletalk, multiprotocol, protocol encryption

posted by Scott Whigham @ 8:00 PM    

Windows 2003 Video Tutorial: Configure Windows 2000 Terminal Services for Remote Administration and Windows 2003 Remote Desktop and Contrast

Configure Windows 2000 Terminal Services for Remote Administration and Windows 2003 Remote Desktop and Contrast - view details
Configure Windows 2000 Terminal Services for Remote Administration and Windows 2003 Remote Desktop and Contrast
To do wnload this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: Configure Windows 2000 Terminal Services for Remote Administration and Windows 2003 Remote Desktop and Contrast

posted by Scott Whigham @ 7:00 PM    

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

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

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

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

Keywords Associated with this video: replication architecture, merge, transactional, snapshot, dr, beginning, beginner, intro, introduction

posted by Scott Whigham @ 7:00 PM    

SQL Server Integration Services Video Tutorial: Pt. 2 of Working with the Container Tasks - the For Loop Container

Pt. 2 of Working with the Container Tasks - the For Loop Container - view details
The For Loop Container is akin to working with a programming language like C/C#/VB/Java in this respect:

for (int i = 0; i < 10; i++ )
{
���� // do something here
}

or, in a SQL language:

DECLARE @i INT
SET @i = 0
WHILE @i < 10
������ BEGIN
������ ���� -- do something here
������ ���� SET @i = @i + 1
������ END

These types of loops/iterations are very commonly needed in programming languages and, if you need to do them in SSIS, you can - BUT you have to know the expression syntax to do so!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: expression builder, expressions, @counter, variables, iteration, iterate, recursion

posted by Scott Whigham @ 7:00 PM    

Microsoft SQL Server Video Tutorial: Master Database - An Overview of Some of the Common System Tables and Objects

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

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

Keywords Associated with this video: sql master database, sql architecture, sql system database

posted by Scott Whigham @ 6:00 PM    

Exchange 2003 Video Tutorial: Message Queues

Message Queues - view details
If you want to know how Message Queues (message queuing) works then check out this video on queues. You'll learn how to manage the queue, pause the messages in a queue and more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: configure Exchange message queues, message queues in Exchange

posted by Scott Whigham @ 6:00 PM    

Microsoft SQL Server 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, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: identity, @@identity, scope identity, scope_identity

posted by Scott Whigham @ 5:00 PM    

Transact SQL Video Tutorial: User-Defined Functions (UDFs) - What They Are and How to Use Them (SQL Server 2000)

User-Defined Functions (UDFs) - What They Are and How to Use Them (SQL Server 2000) - view details
User-Defined Functions (UDFs) in SQL Server 2000 are so helpful and are one of Scott Whigham's (author of this site) favorite additions to TSQL. This video walks you through the syntax of the three different types and provides the context for when/where to use each.

Note: This video was shot for SQL Server 2000 but the same concepts apply in SQL Server 2005

Highlights from this video:

  • Scalar Functions
  • Writing a TRIM() function
  • Single-statement (inline) UDFs
  • Multistatement UDFs
  • Syntax differences between the table-valued functions
  • Performance implications of UDFs in the wrong spots

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: RTRIM, LTRIM, basics of udfs

posted by Scott Whigham @ 5:00 PM    

Microsoft SQL Server Video Tutorial: Enterprise Manager - Registering a server

Enterprise Manager - Registering a server - view details
If you are just getting started with SQL Server and want to know how to use the Enterprise Manager, this video is for you. Before you start working with a SQL Server in the Enterprise Manager, you must "register" that server (which writes information into the Registry). This video, by SQL Server guru Scott Whigham, contains lots of tips and tricks, some well-hidden techniques and features, and a lot of good, solid information to get you started
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: register sql server, sql server enterprise manager, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 4:00 PM    

Microsoft SQL Server Video Tutorial: Part 5 - How to Configure SQL Server 2005 to Listen on Multiple TCP IP Ports

Part 5 - How to Configure SQL Server 2005 to Listen on Multiple TCP IP Ports - view details
Another in our series on SQL Server 2005's Network Libraries, this video shows you a rather obscure and not-often-used technique of configuring your SQL Server to listen on multiple TCP/IP ports. TCP/IP is the most common way to connect to SQL Servers (including 7.0 and 2000) so the more you know, the better you are!
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: sql server multiple ips, multiple tcp/ip ports

posted by Scott Whigham @ 4:00 PM    

Windows 2003 Video Tutorial: Creating a Mail-Enabled Contact In the Active Directory

Creating a Mail-Enabled Contact In the Active Directory - view details
A contact is an object that is present in the Active Directory and also present in our Exchange Global Address List but the user cannot log onto our system nor while they have a mailbox. Contacts are used to allow foreign email accounts but to still have them show up in the Global Address List. This video shows you the how, the why, and the how-to work with contacts with Exchange 2003
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: mail-enabled contact AD, mail-enabled contact Active Directory

posted by Scott Whigham @ 4:00 PM    

Microsoft SQL Server Video Tutorial: Database Compatibility Levels and sp_dbcmptlevel

Database Compatibility Levels and sp_dbcmptlevel - view details
Database Compatibility levels are very important when upgrading from SQL Server 2000 to 2005 or 7.0 to 2000, for example, but db compatibility levels are also important for software testing and unit testing. You can test your applications that run on SQL Server 2005 as though they were running on SQL Server 2000 - a very handy backward compatibility feature! The ability to set the compatibility level of your SQL Server database is a tremendous feature, one that is not highlighted often or championed nearly often enough. This video gives you the how and the why of using database compatibility levels including scenarios when this is appropriate and even talks about how when you do certain actions in SQL Server, your database may automatically use an older compatibility level.

NOTE: This video is shot using SQL Server 2005 but the concepts are valid for all versions of SQL Server

Highlights from this video:
  • Valid compatibility levels
  • How to force SQL Server Management Studio (SSMS) in SQL Server 2005 to use the 65 compatibility mode
  • sp_dbcmptlevel and its parameters
  • Upgrading and migrating from previous versions
  • Backwards compatibility options in SQL Server
  • Uses both SQL Server 2005 and SQL Server 2000
  • Changing Compatibility levels with dbcmptlevel and the GUI (SSMS and SQLEM)
  • Migration scenarios and testing scenarios where older compatibility levels are appropriate
  • How to force SQL Server 2005 to use 65 compatibility level
  • Discussions of 60, 65, 70, 80 and 90 compatibility modes
and much more
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: sp_dbcmptlevel, 60, 65, 70, 80, 90

posted by Scott Whigham @ 3:00 PM    

Windows 2003 Video Tutorial: How to Raise Domain and Forest Functional Levels

How to Raise Domain and Forest Functional Levels - view details
Depending on the status of your Active Directory and the type of domain controllers you use, it might be time for you to update the functional level of your domain controllers. In this video you'll view the details on how to change from Mixed Mode (which supports both Windows 2000 and Windows 2003 Active Directory) to Windows 2003 Native Mode (which supports only Windows 2003 and higher).
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: Windows 2003 Raise Domain Functional Level

posted by Scott Whigham @ 3:00 PM    

DTS Video Tutorial: Who Can View DTS Packages in SQL Server 2000 and What You Can Do About It

Who Can View DTS Packages in SQL Server 2000 and What You Can Do About It - view details
Who Can View DTS Packages in SQL Server 2000 and What You Can Do About It
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: Who Can View DTS Packages in SQL Server 2000 and What You Can Do About It

posted by Scott Whigham @ 3:00 PM    

DTS Video Tutorial: Part 1 - What DTS Global Variables Are and the Architecture of Global Variables

Part 1 - What DTS Global Variables Are and the Architecture of Global Variables - view details
Part 1 - What DTS Global Variables Are and the Architecture of Global Variables
To download this video, log in, th en visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: Part 1 - What DTS Global Variables Are and the Architecture of Global Variables

posted by Scott Whigham @ 2:00 PM    

Transact SQL Video Tutorial: Pt. 2 - CREATE 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, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: create proc, create procedure, alter proc, alter procedure, drop proc, drop procedure

posted by Scott Whigham @ 2:00 PM    

Windows 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, log i n, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: join Windows domain, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 2:00 PM    

Transact SQL Video Tutorial: Naming Conventions for SQL Server Tables Constraints and Indexes (SQL Server 2000)

Naming Conventions for SQL Server Tables Constraints and Indexes (SQL Server 2000) - view details
Tis video, recorded by author and consultant Scott Whigham, walks you through some of the common naming conventions for SQL Server tables, stored procedures, triggers and more. Do you use tblCustomers, Customer, Customers? Which is "right"? How should you name your stored procedures - sp_AddCustomer, AddCustomer, usp_Customer? If you want a solid understanding of how developers name their objects, watch this video.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: sql naming convention

posted by Scott Whigham @ 1:00 PM    

SQL Server 2000 Video Tutorial: Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys

Constraint Keys, Index Keys, Composite Keys, Natural keys, and Surrogate Keys - view details
This video focuses on common SQL developer/DBA terms regarding indexes and constraints and helps you get comfortable with the SQL lexicon. The work "key" is used over and over in SQL - Primary Key, Foreign Key, Alternate key, and more - yet many developers rarely go beyond the primary key and foreign key. This makes it difficult to develop robust systems. For more on the types of keys available and their usage, watch this video from SQL consultant Scott Whigham.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: alternate key, associative key, pk, fk, check constraint, unique constr aint

posted by Scott Whigham @ 1:00 PM    

Windows 2003 Video Tutorial: Mapping Processes to Port Usage

Mapping Processes to Port Usage - view details
A very helpful video for even the most skilled sysadmins. This video helps you map a process (such as ftp.exe, for example) to the port it is using. You'll see how you can use the native tools within Windows 2003 to view the port numbers that a process is using (No, you don't need additional software installed).
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: map processes to port numbers

posted by Scott Whigham @ 12:00 PM    

Windows 2003 Video Tutorial: Mapping Processes to Port Usage

Mapping Processes to Port Usage - view details
A very helpful video for even the most skilled sysadmins. This video helps you map a process (such as ftp.exe, for example) to the port it is using. You'll see how you can use the native tools within Windows 2003 to view the port numbers that a process is using (No, you don't need additional software installed).
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: map processes to port numbers

posted by Scott Whigham @ 11:00 AM    

Exchange 2003 Video Tutorial: How to Remove And Reinstall an Exchange Server On Your Domain

How to Remove And Reinstall an Exchange Server On Your Domain - view details
This Exchange Server 2003 training video shows you how to do one of the most difficult tasks an Exchange administrator can ever have to do: uninstall Exchange completely from the machine. WARNING: You will be modifying important registry entries if you follow along on your own PC. After you completely remove Exchange Server from the machine you will then walk through re-installing Exchange. This is a very advanced video due to the number of steps involved: uninstalling Exchange requires you to uninstall/reinstall IIS, modify the registry, and re-apply any service packs/hotfixes to your newly installed Exchange Server. You will also see use of the Exchange Server 2003 Installation Wizard to uninstall/re- install in addition to removing Exchange Server from the Active Directory. If you want to be a true Exchange guru you must know how to correctly uninstall/re-install in the event you have database corruption or worse.
To download this video, log in, then visit the video's detail page and click "download". This is a subs criber-only video so a subscription is required.

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

Keywords Associated with this video: uninstall exchange, uninstall exchange 2003, uninstall exchange server 2003

posted by Scott Whigham @ 11:00 AM    

Exchange 2003 Video Tutorial: Phase 2, Pt. 2 - Using the Active Directory Connector (ADC)

Phase 2, Pt. 2 - Using the Active Directory Connector (ADC) - view details
Phase 2's second video shows you how to run the Active Directory Connector to replicate your directory objects from Exchange 5.5 into the Active Directory. Exchange guru Grant Moyle talks about which objects to bring over and gives you some Best Practices for your migration.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: adc, directory services

posted by Scott Whigham @ 10:00 AM    

Exchange 2003 Video Tutorial: Managing the Out of Office Scope of Your Organization

Managing the Out of Office Scope of Your Organization - view details
Managing the Out of Office Scope of Your Organization
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: auto reply, autoreply, out of office, vacation, auto message

posted by Scott Whigham @ 10:00 AM    

Windows 2003 Video Tutorial: Windows 2000: Installing Service Pack 4 (SP4) Rollup 1

Windows 2000: Installing Service Pack 4 (SP4) Rollup 1 - view details
Microsoft recently released the Security Rollup Package for Windows 2000, a post-SP4 release designed to increase security on Windows 2000.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: rollup SP4 Windows 2000

posted by Scott Whigham @ 10:00 AM    

SQL Server 2005 Video Tutorial: Variables and Scoping - Local Variables and Batch Terminators

Variables and Scoping - Local Variables and Batch Terminators - view details
Variables and Scoping - Local Variables and Batch Terminators
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: Variables and Scoping - Local Variables and Batch Terminators

posted by Scott Whigham @ 9:00 AM    

Microsoft SQL Server Video Tutorial: Part 1 - Common Table Expressions (CTEs) - What They Are and When to Use Them

Part 1 - Common Table Expressions (CTEs) - What They Are and When to Use Them - view details
Common Table Expressions (CTEs) are an interesting addition to SQL Server 2005's Transact-SQL language. Scott Whigham, author of LearnSqlServer.com and LearnTransactSql.com, walks you through the basics of what CTEs are, the syntax and concepts of using CTE and gives you a few examples in this video. This video is part 1 in our series on CTEs and is designed to be an introduction to the syntax and the concepts of using CTEs.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: sql recursion, sql hierarchy, hierarchical query

posted by Scott Whigham @ 8:00 AM    

Windows 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, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: join computer to domain

posted by Scott Whigham @ 8:00 AM    

Transact SQL 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, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: create view, alter view, drop view

posted by Scott Whigham @ 7:00 AM    

Free Transact SQL Video Tutorial: Views: Introduction, When and Where to Use, and Using the Create View Wizard

Views: Introduction, When and Where to Use, and Using the Create View Wizard - download
Views are one of the most popular techniques to access data in the database. This video is the perfect introduction to the view which is really nothing more than a stored query. When should you use views? How do you create views? What happens to the data when you remove the view from the database? All of these questions and more are answered in this great video from our author, Scott Whigham.

Highlights from this video:

  • Best Practices for Using Views
  • Designing Manageable and Reusable SQL
  • Using Views to Control Security and Data Access
  • Using the Enterprise Manager to Create/Manage Views
  • CREATE VIEW syntax
  • ANSI-89 vs. ANSI-92 JOIN syntax (SQL-1 vs. SQL-2)
  • Designing Views with the Query Designer
  • CROSS JOINs and How to Run Out of Disk Space Quickly
  • Why You Should Always, Always, Always Test Your Queries Before Posting to Production
  • Internal Acrhitecture of Query Analyzer

Note: This should be considered a "Must-See" video for all newbies!
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: , beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 7:00 AM    

Windows 2003 Video Tutorial: Windows Resource Kit Tools

Windows Resource Kit Tools - view details
All the Microsoft major releases feature a Resource Kit with several tools and Windows 2003 is no different. In this video you'll learn about several of the most popular tools and how to use them
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: windows 2003 resource kit

posted by Scott Whigham @ 7:00 AM    

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

Pt. 4 - In Place Upgrade of SQL Server 2000 DTS to SQL Server 2005 SSIS - view details
This video goes a little bit deeper and shows you how to migrate a complex DTS package to SSIS using the Package Migration Wizard.
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

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

posted by Scott Whigham @ 6:00 AM    

SQL Server 2000 Video Tutorial: An Overview of the Database Files - Data Files (MDF), the Transaction Log (LDF) and Additional Data Files (NDF)

An Overview of the Database Files - Data Files (MDF), the Transaction Log (LDF) and Additional Data Files (NDF) - view details
All SQL Server developers and administrators should have an excellent understanding of the file architecture for SQL databases. This video helps you learn about the different file types, their usage in SQL Server, and when and where to use the .NDF files (additional data files)
To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

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

Keywords Associated with this video: sql server filetype, sql s