Friday, December 22, 2006

Free DTS Video Tutorial: Excel Named Ranges (Named Regions) - How to Import Into SQL Server Using DTS

Excel Named Ranges (Named Regions) - How to Import Into SQL Server Using DTS - download
This video could be subtitled, 'How to Import Very Complex Excel Spreadsheets into SQL Server the Easy Way' just for easier classification.

In this example, you'll learn how to deal with worksheets that have multiple data sets on them (multiple named ranges) so that you can load these into SQL Server. This is absolutely essential knowledge for anyone who works seriously with DTS! This video uses a complex Excel example and loads it into multiple SQL Server tables in one DTS package using the Import/Export wizard.

Highlights from this video:
  • Creating and managing named ranges in Microsoft Excel
  • Dealing with complex Excel spreadsheets and locating just one piece of data
  • Writing JOIN queries in Jet-SQL using the Query Builder
  • Best Practices for datatype mapping from Excel to SQL Server
  • Adding primary keys to the destination table
  • Writing ActiveX Script transformations using VBscript
  • Dealing with Sheet1$, Customers$, Orders$ and worksheets
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: named region, named range, set of cells, named cells, excel data, excel spreadsheet, subset, data type

posted by LearnItFirst.com @ 6:41 AM   links to this post

Free DTS Video Tutorial: Pt. 1 - An Introduction to the FTP Task (the File Transfer Protocol Task) and How to Download Files

Pt. 1 - An Introduction to the FTP Task (the File Transfer Protocol Task) and How to Download Files - download
This video, the first in our series on using the FTP task, will help you understand the basic screens inside the FTP task and also get you acquantied with using Internet Site versus 'Directory mode.

Highlights from this video:
  • Understanding when to use an Internet Site or a Directory
  • Certain Limitations of the FTP task
  • Concepts and Architecture of when and where to use the FTP task.
and much more. It's pretty safe to say that just about anyone using DTS today uses FTP so watch this 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: ftp, ftp.exe, get, put, makefile, mget, mput

posted by LearnItFirst.com @ 6:41 AM   links to this post

Free DTS Video Tutorial: Importing Text Files Into a SQL Server Table Using the Import/Export Wizard

Importing Text Files Into a SQL Server Table Using the Import/Export Wizard - download
One of the first things that people often need to do in SQL Server is to upload text files and store these rows in a SQL Server table. This video walks you through using the Import/Export wizard as well as giving you some ideas and Best Practices for using it. The Import/Export wizard is a great way to get started with DTS and it does the hard work for you automatically.

Highlights from this video:
  • Importing .dat, .data., .csv, .txt, and .whatever files (flat files) into SQL Server tables
  • Creating the destination tables using the wizard - ideas and Best Practices
  • Datatype management
  • Dealing with Col001, Col002, Col003 errors (troubleshooting DTS)
  • Editing the SQL that the wizard auto-generates for best performance and maintainability
and much more
To download this video, visit the Free Videos page, cli ck "download" and enter the correct security code.

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

Keywords Associated with this video: csv file, flat file, import textfile, upload text file, beginner, beginning, for beginners, introduction, step by step

posted by LearnItFirst.com @ 6:41 AM   links to this post

Free Windows 2003 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 LearnItFirst.com @ 6:00 AM   links to this post

Free Windows 2003 Video Tutorial: Pt. 1 - Installing, Setup and Basic Configuration of Distributed File System (DFS) Replication

Pt. 1 - Installing, Setup and Basic Configuration of Distributed File System (DFS) Replication - download
This is our first video that focuses on using DFS Replication. In this video, you'll see how to install and set up DFS for replication and get a great breakdown of when/how to use it. This is one of Grant Moyle's favorite features in Windows Server 2003 R2, by the way.

Highlights from this video:
  • How to replicate files and folders across your network using DFS
  • Replicating permissions
  • Gotchas in replication
  • When sshould you use DFS replication?
  • What types of topologies should you use?
  • Using the New Replication Group Wizard
  • How the schedule and bandwidth options work
  • How to choose files and folders to replicate
  • Setting up the primary members
  • Is DFS a replacement or enhancement for FSR?
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 in stalled to view this video

Keywords Associated with this video: topology, dfsr, FSR, beginning, intro, setup, for dummies

posted by LearnItFirst.com @ 6:00 AM   links to this post

Free Windows 2003 Video Tutorial: Disk Defragmentation: Understanding Defragmentation and Defragging using the Default Tools

Disk Defragmentation: Understanding Defragmentation and Defragging using the Default Tools - download
A very interesting video for all administrators and even users. Windows 2003 professional consultant and expert trainer Grant Moyle walks you through how fragmentation occurs, the reasons that fragmentation can slow your system down, and how to overcome these problems using the built-in disk defragmenter.
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: windows disk defragment basics, beginner, beginning, for beginners, introduction, step by step

posted by LearnItFirst.com @ 6:00 AM   links to this post

Sunday, December 17, 2006

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

Pt. 4b - In Place Upgrade of SQL Server 2000 DTS to SQL Server 2005 SSIS - download
Yikes! While migrating from SQL 2000 to 2005 and using the DTS Designer Components (downloaded from MSFT), Scott Whigham, our author, had a little unexpected visit from the Demo Gods. This video is somewhat funny in terms of silly the issues are that you may experience and, if for nothing else other than having a laugh, you'll want to watch this 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: comedy, error, errors, failures

posted by LearnItFirst.com @ 10:10 PM   links to this post

Free SQL Server Integration Services Video Tutorial: Container Tasks in SSIS - An Overview of the For Loop, Foreach Loop and Sequence Containers

Container Tasks in SSIS - An Overview of the For Loop, Foreach Loop and Sequence Containers - download
Some of the greatest time savers in all of SSIS involve using the container tasks, the For Loop Container, the Foreach Loop Container, and (to a lesser degree) the Sequence Container. If you find yourself needing to iterate through a set of data (i.e., loop through a recordset) or loop through all files in a folder, then you'll need a solid understanding of the Container tasks. The BIDS environment (Business Intelligence Development Studio) does not do the best job at explaining what these tasks do and the documentation (the Books Online) are often quite difficult to work with thus making these container objects difficult to work with initially for many people.

This video is part 1 in our series and it's purpose is to explain the different types of container tasks, walk through their likely uses, and explain the use of the Sequence Container Task. The other videos in this series will go in-depth into the other container tasks in detail.

Highlights from this video:
  • Formatting the containers
  • How containers work
  • Comparing the containers to structure programming and languages like C, C#, and Java
  • Discussions of when you use the Container tasks
  • Best practices for using the Sequence Container
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: foreach, for each, for(int i, collections, arrays

posted by LearnItFirst.com @ 10:09 PM   links to this post

Free SQL Server Integration Services Video Tutorial: Pt. 1 - Expressions - An Introduction to Using Expressions in SSIS

Pt. 1 - Expressions - An Introduction to Using Expressions in SSIS - download
Expressions are new in SSIS (meaning that they were not in DTS) but they allow you to create extremely flexible packages. Expressions can be used to assign values to variables, help you determine whether to execute a task, and to assign properties. If you ever found yourself writing ActiveX code (VBScript) in DTS to determine which task to execute based on a variable's value, then you probably can forego the scripting all together in favor of expressions! They are very powerful in SSIS and you'll want to have a solid understanding of how to write them and how to use them.

Highlights from this video:
  • When should you use expressions?
  • What language is the expression syntax written in?
  • Accessing variables from expressions (using the long way and the short way)
  • How to use expressions with the For Loop container in the InitExpression, EvalExpression and the AssignExpression
  • Locating and using the Expression Builder
  • An overview of writing expressions
and much more
To download this video, visit the Free Videos page, click "download" and enter the correc t security code.

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

Keywords Associated with this video: syntax, tsql, transact-sql, c#, c, java, code, coding, writing expressions

posted by LearnItFirst.com @ 10:09 PM   links to this post

Free SQL Server Integration Services Video Tutorial: Options for Migrating from SQL Server 2000 DTS to SSIS in SQL Server 2005

Options for Migrating from SQL Server 2000 DTS to SSIS in SQL Server 2005 - download
This video is an excellent technology-overview of what options exist for moving from SQL Server 2000's DTS to SQL Server 2005's SSIS. Do you want to just migrate one package or all packages? Are you moving your entire server or just one package? What is legacy mode?

Highlights from this video:
  • Choices you have to make when moving from SQL 2000 to SQL 2005
  • Package Migration Wizard vs. an In-Place Upgrade
  • Using Legacy Mode/compatibility in SSMS (SQL Server Management Studio)
  • Issues with migrating DTS packages to SSIS
  • Benefits of in-place upgrades
  • Using the DTS Designer Components
  • How to Edit DTS Packages After Moving t o SSIS
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: upgrading, upgrade, migrating, data transformation services, migrate

posted by LearnItFirst.com @ 10:09 PM   links to this post

Free SQL Server Integration Services Video Tutorial: Tips on Documenting and Annotating Your SSIS Packages

Tips on Documenting and Annotating Your SSIS Packages - download
This video covers the basics of documenting, printing, and annotating (i.e., marking up) your SSIS packages. You'll see more than the basics however, you'll also see a few best practices and common uses.

Highlights from this video:
  • Using the Text Annotations Effectively
  • Arranging and Formatting Your Annotations
  • Printing and Documenting Your Packages and Tasks
  • Formatting Your Text for Clear Documentation
  • Limitations of the BIDS 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: documentation, printing, printer, printed, dictionary, generate, annotate, annotating, documenting

posted by LearnItFirst.com @ 10:08 PM   links to this post

Sunday, December 10, 2006

Blogger post failed

Blogger could not process your message at this time.

Error code: 6.31917B

Original message:
From: bigtoga.liffreevideos@blogger.com
Date: Sun, 10 Dec 2006 14:21:51 -0600
Subject: Free SQL Server 2000 Video Tutorial: Linked Servers - How to Query Microsoft Excel Named Ranges and Worksheets (SQL Server 2000)
<b style="font-size: 18px; color: black;">Linked Servers - How to Query Microsoft Excel Named Ranges and Worksheets (SQL Server 2000)</b> - <a href="http://www.learnsqlserver2000.com/FreeVideos/">download</a><br /><blockquote style="border: 1px dotted black; padding: 10px;">For those of you taking full advantage of Microsoft Excel's ability to expose &quot;tables&quot; to SQL Server, this videos helps you understand how you can query even the most advanced Excel spreadsheets and worksheets. No longer are you tied to querying the worksheet element; now you can query certain &quot;tables&quot; *called &quot;named regions&quot;) in the worksheet and make your life much easier.</blockquote><hr /><ul> <li>Source: <a href="http://www.learnsqlserver2000.com">http://www.learnsqlserver2000.com</a></li> <li>Category: <a href="http://www.learnitfirst.com/VideoTutorials/eLearningWebsite3.aspx">SQL Server Videobooks</a></li><li>Skill Level: 400 (Intermediate - Advanced)</li><li>Length: 10:59 (7.32MB)</li><li><a href="http://www.learnsqlserver2000.com/VideoTutorials/TechnicalTrainingVideo415.aspx">Source Videobook Entry</a> (Subscriber-only version)</li></ul><hr />To download this video, visit the <a href="http://www.learnsqlserver2000.com/FreeVideos/">Free Videos</a> page, click "download" and enter the correct security code.<br /><br /><p>Note: You must have the <a href="http://www.learnsqlserver2000.com/Faqs/TSCCCodec.aspx">TSCC codec</a> installed to view this video</p><hr />Keywords Associated with this video: excel, jet, worksheet

posted by LearnItFirst.com @ 2:25 PM   links to this post

Blogger post failed

Blogger could not process your message at this time.

Error code: 6.14E1F4D

Original message:
From: bigtoga.liffreevideos@blogger.com
Date: Sun, 10 Dec 2006 14:21:43 -0600
Subject: Free SQL Server 2000 Video Tutorial: How to Upgrade The Documentation of SQL Server 2000 (Books Online)
<b style="font-size: 18px; color: black;">How to Upgrade The Documentation of SQL Server 2000 (Books Online)</b> - <a href="http://www.learnsqlserver2000.com/FreeVideos/">download</a><br /><blockquote style="border: 1px dotted black; padding: 10px;">At the same time that Service Pack 3 for SQL Server 2000 was released, Microsoft &quot;refreshed&quot; the Books Online documentation. How can you tell whether or not you're working with the latest copy? Where do you get it? Is it installed with Service Pack 3 (and what about SP4)? This video shows you the details of Microsoft's Update to Books Online and answers all these questions</blockquote><hr /><ul> <li>Source: <a href="http://www.learnsqlserver2000.com">http://www.learnsqlserver2000.com</a></li> <li>Category: <a href="http://www.learnitfirst.com/VideoTutorials/eLearningWebsite3.aspx">SQL Server Videobooks</a></li><li>Skill Level: 200 (Beginner - Intermediate)</li><li>Length: 4:11 (4.46MB)</li><li><a href="http://www.learnsqlserver2000.com/VideoTutorials/TechnicalTrainingVideo327.aspx">Source Videobook Entry</a> (Subscriber-only version)</li></ul><hr />To download this video, visit the <a href="http://www.learnsqlserver2000.com/FreeVideos/">Free Videos</a> page, click "download" and enter the correct security code.<br /><br /><p>Note: You must have the <a href="http://www.learnsqlserver2000.com/Faqs/TSCCCodec.aspx">TSCC codec</a> installed to view this video</p><hr />Keywords Associated with this video: update sql server books online, update bol, sql server update

posted by LearnItFirst.com @ 2:25 PM   links to this post

Free SQL Server 2000 Video Tutorial: Reason to Install SP3 - Buffer Overflow Attack using OPENROWSET

Reason to Install SP3 - Buffer Overflow Attack using OPENROWSET - download
Attack! Attack! You're SQL Server is under attack! You might be quite worried if what Scott Whigham shows you in this video were to happen though on your SQL Server. This is an interesting video. It shows a known exploit against SQL Server - a hack, if you will - and how to prevent it. If you haven't worked with the registry or watched the videos on SQL Server Authentication Modes, then you might have a little bit of homework to do before watching this one. It gets pretty deep but is a very interesting study in SQL Server security and patching
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 attack, sql security, sql hack

posted by LearnItFirst.com @ 2:22 PM   links to this post

Free SQL Server 2000 Video Tutorial: Using Linked Servers In Your SQL Server SELECT Statement (SQL Server 2000)

Using Linked Servers In Your SQL Server SELECT Statement (SQL Server 2000) - download
Linked servers can really help you get "out of a jam" with SQL. If you'd like to be able towrite SQL queries against Microsoft Access and JOIN the data to a SQL Server table, for example, then you'll love the flexibility that linked servers offer you. This video is just an overview of how linked servers work and how you can use them in your queries to simplify your life.
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: excel, access, oracle, sql server 7, remote server, oledb, jet, ole-db

posted by LearnItFirst.com @ 2:22 PM   links to this post

Free SQL Server 2000 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 LearnItFirst.com @ 2:22 PM   links to this post

Tuesday, December 05, 2006

Blogger post failed

Blogger could not process your message at this time.

Error code: 6.12C95FE

Original message:
From: bigtoga.liffreevideos@blogger.com
Date: Tue, 05 Dec 2006 15:13:17 -0600
Subject: Free Exchange 2003 Video Tutorial: Create Email Group
<b style="font-size: 18px; color: black;">Create Email Group</b> - <a href="http://www.learnexchange.com/FreeVideos/">download</a><br /><blockquote style="border: 1px dotted black; padding: 10px;">Exchange 2003 can work with Active Directory groups to create Email Groups. This video shows you how to configure Active Directory groups to become email groups and gives you several tips, best practices, and ideas for creating your own</blockquote><hr /><ul> <li>Source: <a href="http://www.learnexchange.com">http://www.learnexchange.com</a></li> <li>Category: <a href="http://www.learnitfirst.com/VideoTutorials/eLearningWebsite4.aspx">Exchange Server Videobooks</a></li><li>Skill Level: 200 (Beginner - Intermediate)</li><li>Length: 12:28 (7.48MB)</li><li><a href="http://www.learnexchange.com/VideoTutorials/TechnicalTrainingVideo26.aspx">Source Videobook Entry</a> (Subscriber-only version)</li></ul><hr />To download this video, visit the <a href="http://www.learnexchange.com/FreeVideos/">Free Videos</a> page, click "download" and enter the correct security code.<br /><br /><p>Note: You must have the <a href="http://www.learnexchange.com/Faqs/TSCCCodec.aspx">TSCC codec</a> installed to view this video</p><hr />Keywords Associated with this video: create email Exchange group

posted by LearnItFirst.com @ 3:17 PM   links to this post

Free Exchange 2003 Video Tutorial: Change SMTP Connection Information

Change SMTP Connection Information - download
SMTP is the heart of Microsoft Exchange; it's how you send mail and receive mail. One common problem that administrators leave open is the SMTP connection information. When your Exchange server responds via SMTP it passes connection information back to the client. By default, this information contains sensitive information that you might wish to hide from clients. This video helps you establish some basic security guidelines and best practices for SMTP with Exchange. You'll use the IIS Metabase Explorer to view and change the Metabase
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 exchange SMTP connection

posted by LearnItFirst.com @ 3:14 PM   links to this post

Free Exchange 2003 Video Tutorial: Change SMTP Banner by Directly Editing the Metabase

Change SMTP Banner by Directly Editing the Metabase - download
Master Exchange trainer Grant Moyle shows you how you can view/modify the Exchange Server's greeting string. As a security measure and best practice, Exchange administrators do not want to advertise the type and version of their mail server. This video shows you how to modify the Metabase configuration directly to change the information sent back to the client
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: SMTP Metabase Exchange, SMTP Banner edit Metabase

posted by LearnItFirst.com @ 3:14 PM   links to this post

Free Exchange 2003 Video Tutorial: Lecture on Server Design

Lecture on Server Design - download
Exchange Server and Windows Server guru Grant Moyle lets you in his head as he talks about designing your network solution to fit your users' requirements. Grant talks about how many licenses you'll need, what types of servers (at a minimum) and more. An interesting video - not a lot of demo; mostly lecture - but you'll be glad you watched this one
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: spec out server for Exchange, Exchange server design

posted by LearnItFirst.com @ 3:14 PM   links to this post

Sunday, December 03, 2006

Blogger post failed

Blogger could not process your message at this time.

Error code: 6.D3DF08

Original message:
From: bigtoga.liffreevideos@blogger.com
Date: Sun, 03 Dec 2006 14:43:36 -0600
Subject: Free SQL Server 2005 Video Tutorial: Why You Use SCOPE_IDENTITY() Instead of @@IDENTITY
<b style="font-size: 18px; color: black;">Why You Use SCOPE_IDENTITY() Instead of @@IDENTITY</b> - <a href="http://www.learnsqlserver2005.com/FreeVideos/">download</a><br /><blockquote style="border: 1px dotted black; padding: 10px;">If your queries and stored procedures use @@IDENTITY (perhaps you have legacy code updated from SQL Server 7.0 or earlier), you'll likely get good value from watching this video on replacing @@IDENTITY calls with the T-SQL function SCOPE_IDENTITY(). This video shows very plainly the negative possiblities of using @@IDENTITY today (triggers are a real problem) and, after you watch this tutorial, you'll never want to use @@IDENTITY again!</blockquote><hr /><ul> <li>Source: <a href="http://www.learnsqlserver2005.com">http://www.learnsqlserver2005.com</a></li> <li>Category: <a href="http://www.learnitfirst.com/VideoTutorials/eLearningWebsite3.aspx">SQL Server Videobooks</a></li><li>Skill Level: 300 (Intermediate)</li><li>Length: 12:17 (9.10MB)</li><li><a href="http://www.learnsqlserver2005.com/VideoTutorials/TechnicalTrainingVideo455.aspx">Source Videobook Entry</a> (Subscriber-only version)</li></ul><hr />To download this video, visit the <a href="http://www.learnsqlserver2005.com/FreeVideos/">Free Videos</a> page, click "download" and enter the correct security code.<br /><br /><p>Note: You must have the <a href="http://www.learnsqlserver2005.com/Faqs/TSCCCodec.aspx">TSCC codec</a> installed to view this video</p><hr />Keywords Associated with this video: scope Identity, dbcc check_ident

posted by LearnItFirst.com @ 2:47 PM   links to this post

Blogger post failed

Blogger could not process your message at this time.

Error code: 6.16A55CC

Original message:
From: bigtoga.liffreevideos@blogger.com
Date: Sun, 03 Dec 2006 14:43:22 -0600
Subject: Free Microsoft SQL Server Video Tutorial: Reason to Install SP3 - Buffer Overflow Attack using OPENROWSET
<b style="font-size: 18px; color: black;">Reason to Install SP3 - Buffer Overflow Attack using OPENROWSET</b> - <a href="http://www.learnsqlserver.com/FreeVideos/">download</a><br /><blockquote style="border: 1px dotted black; padding: 10px;">Attack! Attack! You're SQL Server is under attack! You might be quite worried if what Scott Whigham shows you in this video were to happen though on your SQL Server. This is an interesting video. It shows a known exploit against SQL Server - a hack, if you will - and how to prevent it. If you haven't worked with the registry or watched the videos on SQL Server Authentication Modes, then you might have a little bit of homework to do before watching this one. It gets pretty deep but is a very interesting study in SQL Server security and patching</blockquote><hr /><ul> <li>Source: <a href="http://www.learnsqlserver.com">http://www.learnsqlserver.com</a></li> <li>Category: <a href="http://www.learnitfirst.com/VideoTutorials/eLearningWebsite3.aspx">SQL Server Videobooks</a></li><li>Skill Level: 500 (Advanced)</li><li>Length: 11:43 (7.70MB)</li><li><a href="http://www.learnsqlserver.com/VideoTutorials/TechnicalTrainingVideo346.aspx">Source Videobook Entry</a> (Subscriber-only version)</li></ul><hr />To download this video, visit the <a href="http://www.learnsqlserver.com/FreeVideos/">Free Videos</a> page, click "download" and enter the correct security code.<br /><br /><p>Note: You must have the <a href="http://www.learnsqlserver.com/Faqs/TSCCCodec.aspx">TSCC codec</a> installed to view this video</p><hr />Keywords Associated with this video: sql attack, sql security, sql hack

posted by LearnItFirst.com @ 2:47 PM   links to this post

Free SQL Server 2005 Video Tutorial: How SQL Server 2005 Uses the Registry and Changes to the Registry

How SQL Server 2005 Uses the Registry and Changes to the Registry - download
This video is an overview of the architecture of SQL Server 2005 and how it uses the registry to record certain information. There is a heavy focus on what has changed from earlier versions of SQL Server including the new keys and startup parameters. This video uses "regedit" to display the registry keys and walks you through each of the Hives that SQL Server 2005 uses. An excellent video for you "sys-internals" buffs!
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 registry, sql keys, registry entries, modify registry, change registry

posted by LearnItFirst.com @ 2:44 PM   links to this post

Free SQL Server 2005 Video Tutorial: Pt. 1 - An Introduction to the Concepts and Terms of SQL Server Replication

Pt. 1 - An Introduction to the Concepts and Terms of SQL Server Replication - download
As replication becomes easier to implement and the world becomes more "wired", replication becomes increasingly the de facto standard for synchronizing data between different databases. This video, part 1 in our "Introduction to SQL Server Replication" series, gives you the big picture of why we use replication as well as describing several key terms and definitions. This video is more of a lecture-style video instead of a demo video but do not miss it! It will help you grasp the full scope of how SQL Server can use replication to do everything from synchronizing small "slices" of data from a source to a destination (more accurately termed the publisher and subscriber) and how you can even do disaster recovery with SQL Server replication.

Highlights from this video:
  • Answers the question, "What is Replication?"
  • Definitions, terms, terminology, architecture and topology of replication
  • Understanding Distributors, Publishers, and Subscribers
  • Publications, Articles, Tables, Stored Procedures and Views
  • Common Uses of/for replication
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: replication architecture, merge, transactional, snapshot, dr, beginning, beginner, intro, introduction

posted by LearnItFirst.com @ 2:44 PM   links to this post

Free SQL Server 2005 Video Tutorial: Part 1 - An Overview of the Default SQL Server Installation

Part 1 - An Overview of the Default SQL Server Installation - download
SQL trainer Scott Whigham walks you through the default installation of SQL Server 2005 in this video, part 1 in a series on installing SQL Server 2005. In this video you'll learn about the instances, folders, services, and options chosen during the default install.
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 2005 overview, sql server change, beginner, beginning, for beginners, introduction, step by step

posted by LearnItFirst.com @ 2:44 PM   links to this post

Free Microsoft SQL Server 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? - download
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, 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: join union, sql ansi join, sql union all

posted by LearnItFirst.com @ 2:44 PM   links to this post

Free Microsoft SQL Server Video Tutorial: Part 1 - An Overview of the AdventureWorks Database

Part 1 - An Overview of the AdventureWorks Database - download
AdventureWorks - the "new standard" for sample databases out of Redmond. Scott Whigham, author of LearnSqlServer.com and LearnTransactSql.com, is certainly a fan of this new database for certain things but also feels reservations about the complexity of AdventureWorks when it comes to using it as your primary training database. Nevertheless, this video (part 1), walks you through the layout of AdventureWorks, how the schemas are used, and shows some of the "primary" relationships between the important tables and views. This video provides a good starting point for working with AdventureWorks and understanding how the tables are related.
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: adventureworks install, sample database, sql server sample database, sql server adventure works, oltp, beginner, beginning, for

posted by LearnItFirst.com @ 2:44 PM   links to this post

Free Microsoft SQL Server Video Tutorial: Enterprise Manager - Put Table On Filegroup

Enterprise Manager - Put Table On Filegroup - download
Performance tuning SQL Server often involves tuning how SQL Server stores the data and index data. This video shows you how SQL Server uses "filegroups" to control data placement. This is often a very important performance tweak and optimization for SQL Server databases. Consider this: let's say you know that 50% of your queries run against the "Customers" table, another 25% hit the "Products" table and a whopping 75% run against the "Orders" table (remember JOINs and subqueries mean it doesn't have to add up to 100%). If you could separate the Order table onto a different file (on a different drive) from the Customers and Products table, SQL Server would be able to access all three tables in parallel (depending on hardware) which means faster access to read and write data. Filegroups are the key to understanding both data and index data placement 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 server performance, sql optimization, optimizing sql server

posted by LearnItFirst.com @ 2:44 PM   links to this post

Free Microsoft SQL Server Video Tutorial: SQL Server 2005 Services and Service Accounts - What They Do and What's New

SQL Server 2005 Services and Service Accounts - What They Do and What's New - download
This video walks you through the SQL Browser service (SqlBrowser) and talks about some of the new SQL Server service accounts with a heavy focus on what's new and what's changed in SQL 2005. The service account names have changed, there are a few new services, and some new wrinkles in the still-the-same services as well.
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 service accounts, mssql, mssqlserver, mssql$, sql agent, full-text, sql browser

posted by LearnItFirst.com @ 2:44 PM   links to this post