Free SQL Server 2000 DBA Tutorial - Database Diagrams - An Introduction

Free Tutorial Video: Database Diagrams - An Introduction 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

Free SQL Server Training Video - Pt. 1 - How to Synchronize Login s Between Two Servers

This Free SQL Server Video Tutorial comes from LearnItFirst.com's online training videos library

Free Tutorial Video: Pt. 1 - How to Synchronize Logins Between Two Servers

More info about this video:

One of the more confusing topics for people coming into SQL Server - even if you have a lot of experience with other database management systems like Oracle, DB2, MySQL, etc - is how to move a database from Server A to Server B (or Instance A to Instance B) and how to keep the logins in sync. This video, part 1 in our section on how to sync logins between servers in SQL Server, covers the scenario, the reason we need to know this, and gets into a little bit of SQL Server security architecture.

Highlights from this video:

• How to view the orphaned logins (those Without Login)
• How SIDs work as well as what sys.server_principals and sys.syslogins are

and much more

Related Links:

• More videos like this
• More free IT Training Videos
• Free Exchange Server training

Free SQL Server Video Tutorial - Pt. 1 - An Intro to Schemas In S QL Server 2005 and SQL Server 2008

This Free MSSQL Programming and Query Writing Video comes from LearnItFirst, one of the web's largest IT training videos companies.

Pt. 1 - An Intro to Schemas In SQL Server 2005 and SQL Server 2008

Description of this free video:

One of the challenging things anyone coming into SQL Server faces is trying to figure out which version of the word 'schema' someone is using at any given time. Example: 'You need to put the Person schema in the People schema inside your database schema' is a perfectly legitimate instruction but the word schema means three different things in that sentence!

So which 'version' of the word schema does this video talk about? The second version.

:)

Okay, okay - this video talks about the container-type of schema (#1 was an Xml schema Collection and #3 was a Database Schema).

Highlights from this video:

• What are schemas? What are containers?
• How are schemas used?
• Should I use schemas?
• What about schemas like db_owner, db_ddladmin, et al - is it safe to remove those?
• Where should I put my schemas?
• I'm upgrading from SQL Server 2000 to 2005/2008 - what is different between users, object owners, and schemas?

and much more

Related Links:

• SQL Server Programming (SQL Server 2005/2000): Transact SQL training
• Free Training Videos
• Free SQL Server videos

Free Data Transformation Services Video - Pt. 1 - An Introduction to Using the Multiphase Datapump

This Data Transformation Services Free Screencast is brought to you by LearnItFirst. LearnItFirst.com has more than four hours of free I.T. training videos - LearnItFirst.com

Free Screencast: Pt. 1 - An Introduction to Using the Multiphase Datapump

This is the first video on using the Multiphase Datapump (a.k.a. the MPDP) and it is a gentle introduction to the concepts of the MPDP. If you are using the Active X Transformations in your Transform Data Task, you need to know about the MPDP!

Free Visual Basic Video Tutorial - Pt. 1 - An Introduction to the GridView and Using GridViews In Your ASP.NET Applications

This Free Visual Basic Programming Training Video is brought to you by LearnItFirst. LearnItFirst.com has more than four hours of free I.T. training videos - LearnItFirst.com

Free Training Video: Pt. 1 - An Introduction to the GridView and Using GridViews In Your ASP.NET Applications

Many people are finding that their favorite new control in Visual Studios 2005 is the GridView, which allows you to do almost everything on a single page, basically replacing the DataGrid. In this first video in the section, you will be given an introduction to the GridView and how to use the GridView in your ASP.NET applications.

Highlights from this video:

• About the GridView
• Formatting the GridView schemes
• Adding/configuring a new Data Source

and much more!

Free SQL Server Video - Pt. 1 - How to Synchronize Logins Between Two Servers

Free SharePoint Video Tutorial - How to Add a Graphics/Images/Pic tures Library to Your SharePoint Site