Saturday, April 21, 2007

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 - view details
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, 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: , beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 6:00 AM    

SQL Server 2000 Video Tutorial: Pt. 3 - Using the Access Upsizing 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, 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: upgrade, upgrading, migrate, migrating, migration,

posted by Scott Whigham @ 4:00 AM    

Friday, April 20, 2007

SQL Server 2005 Video Tutorial: Part 1 - How to Configure SQL Server 2005 for Remote Connections Using TCP IP and Named Pipes

Part 1 - How to Configure SQL Server 2005 for Remote Connections Using TCP IP and Named Pipes - view details
When you install SQL Server 2005, remote connections are disabled. This can cause confusion for newbies trying to install and work with SQL Server for the first time. This video shows you the secure-by-default design and how to configure your SQL Server for remote connections and TCP IP.
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 port, sql connection, connect sql server

posted by Scott Whigham @ 6:00 AM    

Windows 2003 Video Tutorial: Install And Test Simple TCPIP (TCP/IP) Services

Install And Test Simple TCPIP (TCP/IP) Services - view details
An optional component of Windows 2003, Simple TCP services can be installed. If you want to learn about the Character Generator, Quote of the Day, or even Discard features, check out this video. Grant Moyle uses Telnet to display how Simple TCP Services can be used to ensure that your data reaches its destination in the desired state
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: Simple TCP services

posted by Scott Whigham @ 4:00 AM    

Thursday, April 19, 2007

Visual Basic Video Tutorial: Pt. 2 - Installing VS2005 Team Suite Edition

Pt. 2 - Installing VS2005 Team Suite Edition - view details
Pt. 2 - Installing VS2005 Team Suite Edition
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: Pt. 2 - Installing VS2005 Team Suite Edition

posted by Scott Whigham @ 11:27 AM    

DTS Video Tutorial: Transform Data Task - An Overview of the Screens/Tabs

Transform Data Task - An Overview of the Screens/Tabs - view details
Do you want to learn DTS? Then watch this video! It's very important that you know the Transform Data Task backwards and forwards!
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: Transform Data Task - An Overview of the Screens/Tabs, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 6:00 AM    

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

Pt. 2 - Further Uses of the Unattended Execution Account - view details
Pt. 2 - Further Uses of the Unattended Execution Account
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: Pt. 2 - Further Uses of the Unattended Execution Account

posted by Scott Whigham @ 4:00 AM    

Wednesday, April 18, 2007

Reporting Services Video Tutorial: Pt. 2 - How to Develop and Integrate Custom Reports Into SQL Server Management Studio (SSMS)

Pt. 2 - How to Develop and Integrate Custom Reports Into SQL Server Management Studio (SSMS) - view details
Pt. 2 - How to Develop and Integrate Custom Reports Into SQL Server Management Studio (SSMS)
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: Pt. 2 - How to Develop and Integrate Custom Reports Into SQL Server Management Studio (SSMS)

posted by Scott Whigham @ 6:00 AM    

SQL Server Integration Services Video Tutorial: Pt. 2 - Using the HtmlLogProvider Custom Log Provider to Log Package Data to a Web Page

Pt. 2 - Using the HtmlLogProvider Custom Log Provider to Log Package Data to a Web Page - view details
Pt. 2 - Using the HtmlLogProvider Custom Log Provider to Log Package Data to a Web Page
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: Pt. 2 - Using the HtmlLogProvider Custom Log Provider to Log Package Data to a Web Page

posted by Scott Whigham @ 4:00 AM    

Tuesday, April 17, 2007

SQL Server 2005 Video Tutorial: Pt. 3 - Setting Up Push and Pull Subscriptions

Pt. 3 - Setting Up Push and Pull Subscriptions - view details
This video walks you through setting up a push subscriptions and pull subscriptions as well as synchronizing servers. You'll be able to view latency and how to diagnose replication problems.

Highlights from this video:
  • Push Subscriptions vs. Pull Subscriptions
  • Synchronization Schedules and Latency
  • How to initialize a new publication using the "New Publication Wizard"
  • Discussion of the Distribution Agent and how it works (does it run at subscriber?)
  • Discussion of using non-SQL Server subscribers (Oracle subscribers, DB2 subscribers for example)
  • Discussion of service account usage and recommendations
  • Snapshot initialization and how to start the Snapshot Agent
  • Working with multiple subscriptions for a single publication
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, publication, article, pu

posted by Scott Whigham @ 6:00 AM    

SQL Server 2000 Video Tutorial: Query Analyzer - Beyond the Basics (SQL Server 2000)

Query Analyzer - Beyond the Basics (SQL Server 2000) - view details
For those of you who want to go beyond the basics of hitting F5 to execute your query (CTRL+E works as well), this video walks you through some of Scott Whigham's favorite "tweaks" to the SQL Server 2000 Query Analyzer. Scott Whigham is the author of LearnSqlServer.com, LearnDTS.com and LearnTransactSql.com and has many, many years customizing and optimizing SQL Server including the tools. This video will really give you some good ideas for using the Query Analyzer and will help you speed up your day-to-day tasks.
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: query analyzer, object browser, object search

posted by Scott Whigham @ 4:00 AM    

Monday, April 16, 2007

Exchange 2007/2003 Video Tutorial: Building a New User With Mailbox

Building a New User With Mailbox - view details
In this video you'll add new users to your Active Directory and setup a mailbox (and test it) for each. Required viewing for all new Exchange admins!
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 new Exchange user, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 6:00 AM    

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

Pt. 5 - Using SQL Server Management Studio (SSMS) Express - view details
Pt. 5 - Using SQL Server Management Studio (SSMS) Express
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: ssms, enterprise manager, query analyzer

posted by Scott Whigham @ 4:00 AM    

Sunday, April 15, 2007

Windows 2003 Video Tutorial: Using Removable USB and Firewire Disks

Using Removable USB and Firewire Disks - view details
Many users and administrators today are using removable USB/Firewire drives (often called 'Flash' drives). In this video you'll see how to configure these for use with your Windows 2003 system
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: removable USB, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 6:00 AM