Saturday, January 20, 2007

Free SQL Server Integration Services Video Tutorial: Using the Package Migration Wizard to Upgrade Your DTS Packages to SSIS

Using the Package Migration Wizard to Upgrade Your DTS Packages to SSIS - download
This video is an excellent overview of what to expect when running SQL Server 2005's Package Migration Wizard, the tool that migrates/upgrades your DTS packages to SSIS packages. If you are running SQL Server 2000 currently and want to know what challenges you face when moving to SSIS (as if you don't already know), then this video can help you spot common issues and recommend alternative techniques.

Highlights from this video:
  • What options you have for migrating from SQL Server 2000 to SQL Server 2005 (with respect to Data Tranformation Services)
  • Migrating one package or multiple packages (such as all packages)
  • Launching the Package Migration Wizard (PMW) from the command line (DOS prompt)
  • Common failures/challenges/issues with the PMW
  • Migrating the Dynamic Properties Task
  • Migrating Variables and the Execute SQL Task
  • Upgrading ActiveX Script Tasks
  • Migraitng FTP Tasks
  • Moving Transform Data Tasks and the common choices/options the PMW will use
and much more.

In the end, you have to decide whether to rewrite/redesign/rearchitect your DTS packages when you move to SSIS or you can use the Package Migration Wizard. This video (and the rest of the videos on the PMW) will help you make this choice.
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: Execute DTS 2000 Package task, upgrade, upgrading, migration, migrate, legacy

posted by Scott Whigham @ 8:07 AM   0 comments links to this post

Free SQL Server Integration Services Video Tutorial: Pt. 1 - An Overview of Using SSIS for Newbies and Beginners

Pt. 1 - An Overview of Using SSIS for Newbies and Beginners - download
If you are just getting started with Integration Services, then you need to START HERE. This video, part one of a whole series on SSIS for beginners, starts you out with an introduction of what SSIS will be used for and the different tools that you'll be using. This video is more of an overview and is designed to give you the view of SSIS from 50,000 feet, if you will. The remaining videos in this series will dig down in to the topics posed in this video and help you get started with SSIS the right way.

Highlights from this video:
  • Which tools do you use to schedule and execute SSIS packages?
  • What tool(s) do you use to edit and develop SSIS packages?
  • What can you do within SSMS (SQL Ser ver Management Studio)?
  • What can you do within BIDS (Business Intelligence Development Studio)?
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: in tro, introduction, beginning, newbs, newbies, starters, first time, overview, technology overview

posted by Scott Whigham @ 8:07 AM   0 comments links to this post

Thursday, January 18, 2007

Free Transact SQL Video Tutorial: Auto-Numbering Rows with IDENTITY Columns - How Identity Columns Work

Auto-Numbering Rows with IDENTITY Columns - How Identity Columns Work - download
This video is mainly an architecture/sysinternals type of video designed to show you how things work "behind the scenes" with IDENTITY columns. You'll learn how SQL Server chooses the values, how you can influence those values as well as tips and tricks for using IDENTITY columns and Best Practices. IDENTITY columns (and all surrogate keys) are often easy to use but not completely understand by new users. If you use IDENTITY columns in your databases then you'll appreicate this thorough treatment of how IDENTITY columns work in SQL Server.
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: IDENTITY, auto number, sequence, surrogate key, alternate key

posted by Scott Whigham @ 6:46 AM   0 comments links to this post

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 @ 6:46 AM   0 comments links to this post

Free Transact SQL Video Tutorial: Part 1 - Identity Columns - When Should I Use an Identity Column?

Part 1 - Identity Columns - When Should I Use an Identity Column? - download
IDENTITY columns are some data modeler's Best Friend yet others avoid them like the plague in favor of "Natural Keys" only and/or GUIDs. This video, part one in a series, walks you through the if, ands, and buts of using IDENTITY columns, points out some suggested use of IDENTITY columns and finished with a few Gotchas of using IDENTITY columns.
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: identity, update identity, autonumber, auto-number, auto number, seed, increment, beginner, beginning, for beginners, introducti

posted by Scott Whigham @ 6:32 AM   0 comments links to this post

Free Transact SQL Video Tutorial: Auto-Numbering Rows with IDENTITY Columns - How Identity Columns Work

Auto-Numbering Rows with IDENTITY Columns - How Identity Columns Work - download
This video is mainly an architecture/sysinternals type of video designed to show you how things work "behind the scenes" with IDENTITY columns. You'll learn how SQL Server chooses the values, how you can influence those values as well as tips and tricks for using IDENTITY columns and Best Practices. IDENTITY columns (and all surrogate keys) are often easy to use but not completely understand by new users. If you use IDENTITY columns in your databases then you'll appreicate this thorough treatment of how IDENTITY columns work in SQL Server.
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: IDENTITY, auto number, sequence, surrogate key, alternate key

posted by Scott Whigham @ 6:32 AM   0 comments links to this post

Wednesday, January 17, 2007

Free Visual C# Video Tutorial: Pt. 1 - Building the Website and Adding Pages

Pt. 1 - Building the Website and Adding Pages - download
Let's get started learning ASP.NET with this excellent video. This video shows you how to setup new websites, walks you through creating projects and templates, and more.

Highlights from this video:
  • Creating new websites
  • Understanding the file structure of web applications (and templates)
  • Understanding Codefiles and .aspx files
  • Writing code: HTML, CSS and C#
  • Using the Style Builder to generate Cascading Style Sheets (CSS)
  • Setting properties
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: intro, beginner, beginning, introduction, newbie

posted by Scott Whigham @ 9:39 AM   0 comments links to this post

Free Visual C# Video Tutorial: Understanding and Manipulating the Express Edition Tabbed Environment

Understanding and Manipulating the Express Edition Tabbed Environment - download
Want to look (and feel) like a pro? Then you'll want to watch this video on how to manipulate the various panes in the Visual Studio (the Properties window, the Server Explorer, the Solution Explorer and others).

Highlights from this video:
  • Configuring Visual Studio for fast launch
  • How to move and configure the various panes using drag and drop
  • Customizing the environment
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: custom ide

posted by Scott Whigham @ 9:39 AM   0 comments links to this post

Friday, January 12, 2007

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

Pt. 1 - In Place Upgrade of SQL Server 2000 DTS to SQL Server 2005 SSIS - download
This series of videos (eight in all) walks you through migrating an entire SQL Server 2000 instance to SQL Server 2005's SSIS. You'll cover everything from the install/setup of SQL 2005 to moving individual packages.
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: upgrading, upgrade, migrating, data transformation services, migrate, inplace, in-place

posted by Scott Whigham @ 9:32 AM   0 comments links to this post

Free DTS Video Tutorial: A Walk-Through of the Various Tabs, Screens and Choices in the DTS Designer

A Walk-Through of the Various Tabs, Screens and Choices in the DTS Designer - download
An excellent video for those of you new to DTS, this tutorial takes you through each of the choices and options you are presented with when you launch the DTS Designer. This is a high-level overview designed to help you get comfortable working in the Enterprise Manager and creating/managing DTS packages. This should be required viewing for those of you new to DTS.
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: MSQLEM, newbie, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 9:31 AM   0 comments links to this post

Thursday, January 11, 2007

Free SQL Server 2000 Video Tutorial: Enterprise Manager - Registering a server

Enterprise Manager - Registering a server - download
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, 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: register sql server, sql server enterprise manager, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 6:40 AM   0 comments links to this post

Free SQL Server 2000 Video Tutorial: Backup and Recovery - An Introduction to the Three Main Types of Backups in SQL Server 2000

Backup and Recovery - An Introduction to the Three Main Types of Backups in SQL Server 2000 - download
Ahhhhh, backup and recovery - the "Bread and Butter" of every SQL Server DBA's life, right? This video is an excellent introduction to the different types of SQL Server backups - the full backup, the differential backup and the transaction log backup. EVERY administrator and developer should have a strong understanding of the types of backups in SQL Server 2000. Do you need to watch this video? Answer this question, "Which of the following backup types clear out the online transaction log (truncate the log) - full, differential, and/or transaction log backup?" Did you get the right answer? Oh - you don't know if you got the right answer? Then you're guessing and you should watch thi s video!
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 backup, sql server backup types, sql server transaction log backup

posted by Scott Whigham @ 6:40 AM   0 comments links to this post

Friday, January 05, 2007

Free Microsoft SQL Server Video Tutorial: Database Diagrams - An Introduction

Database Diagrams - An Introduction - download
All experienced SQL developers and administrators recognize that being able to "see" your database gives you great confidence in the queries you write. It helps speed up development, ensure correct queries, and remove guesswork from the development cycle (well, as much as possible). This video shows you how you can create your own visual diagrams for your SQL Server database. These diagrams can be generated and viewed in the Enterprise Manager and can even be printed over multiple pages (which you will tape together and hang on your wall) for easier visualization. If you struggle with JOINs, subqueries, or foreign keys and relationships, then you'll enjoy this video on creating ERDs (Entity Relationship Diagrams) in SQL Server
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 erd, sql database diagram, sql diagram, beginner, beginning, for beginners, introduction, step by step

posted by Scott Whigham @ 5:54 PM   0 comments links to this post

Free Microsoft SQL Server Video Tutorial: ODBC, DSNs, and UDLs - Creating Reusable Connection Information

ODBC, DSNs, and UDLs - Creating Reusable Connection Information - download
This video is an excellent introduction to the terms used when discussing connections to SQL Server. There are many options for connecting an application (such as Microsoft Access, ASP.NET, Java) to SQL Server and this video covers some popular options. If you've heard of ODBC and DSNs before but never really understood how they were used (or what they are) then this is a great video to watch
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 odbc, sql odbc driver, sql driver

posted by Scott Whigham @ 5:46 PM   0 comments links to this post

Thursday, January 04, 2007

Free Exchange 2003 Video Tutorial: Recipients: Recipient Update Services

Recipients: Recipient Update Services - download
There are two Recipient Update Services - do you 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
To download this video, visit the Free Videos p age, 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 @ 1:36 PM   0 comments links to this post

Free Exchange 2003 Video Tutorial: Mailbox Store Properties

Mailbox Store Properties - download
The mailbox store is the first database built by Exchange and it holds the users' mail. This video walks you through its usage, best practices, and all the properties of the mailbox store. A must for all admins
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 mailbox store properties

posted by Scott Whigham @ 1:36 PM   0 comments links to this post