This chapter comes from our "SQL Server 2000 Database Administration" course
Visit the course home page for full details (such as the videos in the course, free videos for the course, and more)

Chapter 3: Administration: Tools, Utilities and Common Tasks

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 chapter 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.

Videos in Chapter 3

1Part 1 - An Overview of the Enterprise Manager for SQL Server 2000 Download
2Building a Customized Microsoft Management Console (MMC) for Use with SQL Server Download
3Database Diagrams - An Introduction Download
4Enterprise Manager - Registering a server Download
5How to Upgrade The Documentation of SQL Server 2000 (Books Online) Download
6ODBC, DSNs, and UDLs - Creating Reusable Connection Information Download
7OSQL - What It Is and How to Use It Download
8Query Analyzer - Beyond the Basics (SQL Server 2000) Download
9Pt. 1 - Why Migrate From Microsoft Access to SQL Server? Download
10Pt. 2 - Migration and Upgrade Options for Moving From Access to SQL Server Download
11Pt. 3 - Using the Access Upsizing Wizard Download
12Pt. 4 - Viewing the Results and Doing Repairs Download
13Pt. 5 - Working with the .ADP File Download
14Pt. 1 - Using the DTS Wizards to Migrate Tables from Access to SQL Server 2000 Download
15Pt. 2 - Using the DTS Designer to Migrate Tables from Access to SQL Server 2000 Download
16Pt. 3 - Using Integration Services (SSIS) to Migrate Tables from Access to SQL Server 2005 Download

Browse this course's videos now

© Copyright 2004-2009 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.