Tutorial: Microsoft SQL Server 2000

Please select a chapter from the "Contents" menu at the very bottom of the page.

Top

Microsoft SQL Server 2000

Part I: Welcome to Microsoft SQL Server Chapter 1. The Microsoft SQL Server Environment Overview of Client/Server SQL Server 2000 Components and Features Summary Chapter 2. SQL Server 2000 Environments and Editions SQL Server 2000 Environments SQL Server 2000 Editions SQL Server Licensing Models Summary Chapter 3. What's New in SQL Server 2000 New SQL Server 2000 Features SQL Server 2000 Enhancements SQL Server and the .NET Framework Summary Part II: SQL Server Tools and Utilities Chapter 4. SQL Server Enterprise Manager Establishing Server Groups and Registering SQL Server in Enterprise Manager Server Configuration Databases Security Server Management Data Transformation Services Support Services System Tools Replication Using the Database Taskpad Using the Query Designer Scripting Objects Getting Help Summary Chapter 5. SQL Server Command-Line Utilities BCP Data Transformation Services Utilities ISQL/OSQL 'makepipe' and 'readpipe' ODBCcmpt odbcping rebuildm regrebld Replication Utilities SQLDiag SQLMaint SQLServr VSwitch Summary Chapter 6. SQL Server Query Analyzer and SQL Debugger Query Analyzer The SQL Debugger Summary Chapter 7. Using the SQL Server Profiler SQL Server Profiler Architecture Creating Traces Saving and Exporting Traces Replaying Trace Data Defining Server-Side Traces Profiler Usage Scenarios Summary Part III: SQL Server Administration Chapter 8. Installing and Upgrading SQL Server Choosing a SQL Server Edition Hardware Requirements Software Requirements Selecting Installation Configuration Options Verifying Installation Starting, Stopping, and Pausing SQL Server Post-Installation Configuration Installation Troubleshooting Remote Installation Unattended Installation Installing a Named Instance Upgrading from Previous Versions Summary Chapter 9. Client Installation and Configuration The SQL Server Client Architecture Installing Client Tools Client Configuration Network Protocol Support Installing ODBC Microsoft Driver for JDBC Connecting to SQL Server over the Internet Summary Chapter 10. SQL Server System and Database Administration Responsibilities of the System Administrator System Databases System Tables System-Stored Procedures Useful System Procedures Other Methods of Querying the System Tables Summary Chapter 11. Creating and Managing Databases What Makes Up a SQL Server Database? Data Storage in SQL Server Database Files Creating Databases Managing Databases Setting Database Options Summary Chapter 12. Creating and Managing Tables in SQL Server Datatypes Numeric Datatypes Datatype Synonyms User-Defined Datatypes Creating Tables Creating Tables Using T-SQL Creating Tables Using Table Designer Viewing Table Properties and Data in Enterprise Manager Limitations on Table Size and Dimensions Dropping Tables Temporary Tables Summary Chapter 13. Creating and Managing Indexes Types of Indexes Creating Indexes Using T-SQL Creating Indexes Using Enterprise Manager Managing Indexes Dropping Indexes Summary Chapter 14. Implementing Data Integrity Types of Data Integrity Enforcing Data Integrity Constraints Rules Defaults Summary Chapter 15. Security and User Administration An Overview of SQL Server Security Authentication Methods SQL Server Security: Logins SQL Server Security: Users SQL Server Security: Roles Managing SQL Server Logins Managing SQL Server Users Managing Database Roles Managing SQL Server Permissions SQL Server Permission Approaches Object Owners Using Encryption Summary Chapter 16. Database Backup and Restore Developing a Backup and Restore Plan Why Back Up Your Databases? A Typical Backup and Restore Scenario Types of Backups Setting the Recovery Mode Backup Devices Media Sets and Families Creating Backup Devices with Transact-SQL Creating Backup Devices with SQL Enterprise Manager Backing Up the Database Backing Up the Transaction Log Restoring the Database Transact-SQL Restore Examples Restoring to a Different Database Restoring a File or Filegroup Restoring to a Point in Time Performing a Partial Database Restore Restoring the System Databases Additional Backup Considerations Summary Chapter 17. Database Maintenance What Needs to Be Maintained The Database Maintenance Plan Wizard Setting Up Your Own Maintenance Tasks The Database Console Commands (DBCC) Using 'SQLMAINT.EXE' for Database Maintenance Summary Chapter 18. SQL Server Scheduling and Notification SQL Agent Overview Configuring SQL Server Agent Viewing the SQL Server Agent Error Log Operators Jobs Alerts Scripting Jobs and Alerts Multiserver Job Management Event Forwarding Summary Chapter 19. Managing Linked and Remote Servers Remote Servers Linked Servers Adding, Dropping, and Configuring Linked Servers Mapping Local Logins to Logins on Linked Servers Obtaining General Information About Linked Servers Executing a Stored Procedure Via a Linked Server Setting Up Linked Servers Through Enterprise Manager Summary Chapter 20. Importing and Exporting SQL Server Data Using BCP and DTS Bulk-Copy Program (BCP) The Bulk-Copy Program Logged and Non-Logged Operations The 'BULK INSERT' Statement (Transact-SQL) Improving Load Performance BCP Extras Data Transformation Services (DTS) DTS Architecture and Concepts Package Execution Utilities Running the DTS Wizard DTS Designer A Bit More on Metadata Summary Chapter 21. Administering Very Large SQL Server Databases Do I Have a Very Large Database (VLDB)? VLDB Maintenance Issues Partitioning Data Summary Chapter 22. Data Replication What Is Replication? The Publisher, Distributor, and Subscriber Metaphor Replication Scenarios Replication Agents Planning for SQL Server Data Replication SQL Server Replication Types User Requirements Drive the Replication Design Setting Up Replication Scripting Replication Monitoring Replication Summary Chapter 23. SQL Mail Setting Up an E-Mail Client/Profile Configuring SQL Mail Configuring SQLAgentMail SQL Mail Stored Procedures Summary Chapter 24. SQL Server Clustering From Windows NT Enterprise Edition to Windows 2000 Advanced Server Cluster Services SQL Clustering and Fail-Over Support Network Load Balancing Summary Chapter 25. Defining System Administration and Naming Standards The SQL Server Environment Approach SQL Server Naming Standards Summary Part IV: Transact-SQL Chapter 26. Using Transact-SQL in SQL Server 2000 T-SQL and ANSI/ISO SQL What's New for T-SQL in SQL Server 2000 'SELECT', 'INSERT', 'UPDATE', and 'DELETE' SQL Server Functions Programming Constructs Cursors Summary Chapter 27. Creating and Managing Views in SQL Server Definition of Views Using Views to Simplify Retrieval of Data Using Views to Hide Underlying Table Structures Using Views as a Security Mechanism Data Modifications and Views Creating Views Altering and Dropping Views Partitioned Views Views and Query Performance Summary Chapter 28. Creating and Managing Stored Procedures in SQL Server Advantages of Stored Procedures