Member of the
LearnItFirst.com Video Training Network
Related Video Training Sites:
·
SQL DTS Training Videos
·
SQL Programming Videos
SQL Server 2000 Training Videos
*
SQL DTS Training Videos
*
SQL Programming Videos
*
More Videobooks...
Search
My Account
More Videobooks
Sign in
Home
FREE Video Tutorials
Subscriber Video Tutorials
Subscriptions
FAQs
Our Other Sites
About Us
Home
Free Videos
Subscriber Videos
Buy Now (Subscriptions)
More Video Websites
Search for Videos
Tag Cloud
Subscriptions
Subscribe!
Testimonials
List of Videobooks
Quick Links
About the Author
Login
FAQs
Site Map
An Overview of the Fixed Server Roles for SQL Server 2000
Creating SQL Server Authentication Logins in the Enterprise Manag...
Creating Windows Authentication Logins in the Enterprise Manager
How to Increase a Database's Size - Multiple Techniques for Incre...
How to Increase a Database's Size Using the SQL Server Enterprise...
SQL Server 2000 Videos By Category
Home
Subscriber Videos
Administration: Tools, Utilities and Common Tasks
- Video Category
(
all video categories
)
This is an essential set of videos for all administrators. In this set of videos you'll learn all about the most common tools and how to perform common tasks. This category discusses the Enterprise Manager, Query Analyzer, Profiler, tools in the SQL Server 2000 Resource Kit and many other helpful tools such as snap-ins for the Microsoft Management Console (MMC).
This set of videos also features DOS commands and utilities, batch-file writing, and scripting topics
Versions/Editions Covered:
SQL Server 2000
Videos in this Category:
orange
= video series
blue
= individual video
Click "Download" to download the video or click the video title for more information
Title
Skill
View / Download
Length
Series (3 videos) - Migrating Microsoft Access Tables to SQL Server Using DTS an...
300
(Click for Videos)
40 mins.
Series (5 videos) - How to Migrate From Microsoft Access to SQL Server
200
(Click for Videos)
71 mins.
Building a Customized Microsoft Management Console (MMC) for Use with SQL Server
200
Download
10 mins.
Database Diagrams - An Introduction
100
Download
9 mins.
Enterprise Manager - Registering a server
100
Download
14 mins.
How to Upgrade The Documentation of SQL Server 2000 (Books Online)
200
Download
4 mins.
ODBC, DSNs, and UDLs - Creating Reusable Connection Information
200
Download
10 mins.
OSQL - What It Is and How to Use It
200
Download
11 mins.
Part 1 - An Overview of the Enterprise Manager for SQL Server 2000
100
Download
14 mins.
Query Analyzer - Beyond the Basics (SQL Server 2000)
200
Download
18 mins.
Over 3 hours of SQL Server 2000 tutorials in this category
<
Return to list of all videos
Related Links:
DBArtisan
- The standard tool suite for those DBAs and developers who work with multiple relational database management systems (such as Oracle, SQL Server, and DB2)
Ken Henderson's "The Guru's Guide to SQL Server Architecture and Internals"
- This book is written for SQL Server 2000 but many of the same concepts are still valid for SQL Server 2005.
SQL Server Worldwide Users Group
- A great newsletter and a nice site
Miscellaneous Bits & Pieces:
Performance Tip: Defragmenting your SQL Server indexes is an essential management component. Most DBAs schedule their index defragmentation at least once per month and perhaps as often as once per week depending on system delta
You can store your own custom error messages in your SQL Server's master database
osql.exe is a command-line tool that you can use to run your SQL scripts and queries; think of it as the DOS-version of Query Analyzer
Company News
»
We're also sponsoring the St Louis SQL Server User Group July 9
»
We're sponsoring the Billings, Montana .NET User Group July 8
»
We're sponsoring the San Antonio, TX Alamo Coders User Group June 10th
»
Scott had a baby!
Home
|
About Us
|
Advertising
|
Become an Author
|
Contact Us
|
Privacy
|
System Req's
|
Terms
|
Testimonials
|
Work for Us!
|
|
Site Map
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners.
This site is not affiliated in any way with the Microsoft Corporation.
7/3/2008 6:29:58 PM