SQL Books
Books
Microsoft SQL Server 2000(TM) Performance Tuning Technical Reference by Edward Whalen, Marcilina Garcia
Handbook of Relational Database Design by Candace Fleming and Barbara von Halle.
Inside Microsoft SQL Server 2000 by Karen Delaney.
SQL Performance Tuning by Peter Gulutzan, Trudy Pelzer
The Guru's Guide to SQL Server Stored Procedures, XML, and HTML (With CD-ROM) by Ken Henderson
Microsoft SQL Server 2000 Resource Kit (With CD-ROM)
Free Online Books
Practical Postgre SQL Online book by John Worsley and Joshua Drake
DB2 UDB V7.2 SQL Cookbook Online book (PDF) by Graeme Birchall
Postgre SQL: Introduction and Concepts Online book by Bruce Momjian
Book Excerpts & Chapters
Programming Cold Fusion By Rob Brooks-Bilson; Chapter 11 -- Advanced Database Techniques
Chapter 3 : Entity - Relationship Modeling From the book "Databases - a first course" by John Carter
Data Warehouse Design Considerations Chapter 17 of Microsoft SQL Server 2000 Resource Kit
Computing Team Standings excerpt from Chapter 12, "Using Multiple Tables," of O'Reilly's "MySQL Cookbook" by Paul DuBois
Counting and Identifying Duplicates excerpt from Chapter 7, "Generating Summaries," of O'Reilly's "MySQL Cookbook" by Paul DuBois
Summaries and NULL Values excerpt from Chapter 7, "Generating Summaries," of O'Reilly's "MySQL Cookbook" by Paul DuBois
Server Management (in 3 Online Books)
SQL Server 2000 Operations Guide: Chapter 3: Security Management.doc
SQL Server 2000 Operations Guide: Chapter 4: System Administration.doc
SQL Server 2000 Operations Guide: Chapter 5: Monitoring and Control.doc
SQL Server 2000 Operations Guide: Chapter 6: Capacity and
SQL Server 2000 Operations Guide: Chapter 7: Problem and Incident Management.doc
SQL Server 2000 Operations Guide: Chapter 8: Service Management.doc
Configuring Sql Server State Management
How to determine proper SQL Server configuration settings
HOW TO: IIS and SQL Server on Separate Machines with Trusted Connection
The links below are chapters from Microsoft® SQL Server™ 2000 Administrator's Pocket Consultant.
1 Microsoft SQL Server 2000 Administration Overview
2 Configuring and Tuning Microsoft SQL Server
3 Managing the Enterprise
4 Core Database Administration
5 Microsoft SQL Server 2000 Security
7 Importing and Exporting Data with DTS and BCP
8 Linked Servers and Distributed Transactions
9 Configuring Snapshot, Merge, and Transactional Replication
10 Profiling and Monitoring Microsoft SQL Server 2000
11 Database Backup and Recovery
12 Database Automation and Maintenance
The links below are chapters from Microsoft SQL Server DBA Survival Guide (Index)(SAMS Publishing)
Chapter 2 - The Role of the Database Administrator
Chapter 3 - The Evolution of SQL Server
Chapter 4 - SQL Server: The Big Picture
Chapter 5 - Planning an Installation or Upgrade
Chapter 6 - Installing or Upgrading SQL Server
Chapter 7 - Managing the Enterprise
Chapter 8 - Managing Devices
Chapter 9 - Managing Databases
Chapter 10 - Managing Users
Chapter 11 - Managing SQL Server Security
Chapter 12 - Replication
Chapter 13 - Distributed Transaction Coordinator
Chapter 14 - Backups
Chapter 15 - Recovery
Chapter 17 - Troubleshooting SQL Server
Chapter 18 - Monitoring SQL Server
Chapter 19 - Which Knobs Do I Turn?
Chapter 20 - Database Design Issues
Chapter 21 - Understanding Indexes
Chapter 22 - Understanding the Query Optimizer
Chapter 23 - Multi-User Considerations
Chapter 24 - Using Stored Procedures and Cursors
Chapter 25 - Developing a SQL Server Maintenance Plan
Chapter 26 - Automating Database Administration Tasks
Chapter 27 - SQL OLE Integration
Chapter 28 - New SQL Server Utilities
Back to Mike Beaver's Hypnotherapy Home Page