Microsoft SQL Server 2000 DBA Survival GuideMicrosoft SQL Server 2000 DBA Survival Guide is organized into several parts that comprise the various jobs and tasks the DBA performs. Each chapter is presented with the goal of providing knowledge and "know-how" to Database Administrators of a SQL Server database. The chapters also offer real-world insight and experience by passing on tips, tricks, and suggestions based on what the authors have learned the hard way. The book also takes time to provide checklists and examples for various SQL Server DBA tasks. The book also provides insight into the tasks that make-up a DBA's job including discussions of topics such as the creation of naming standards and conventions which are essential for efficient administration. |
Contents
Introduction | 1 |
Overview | 7 |
The Evolution of SQL Server | 45 |
Installing and Upgrading SQL Server | 51 |
Installing or Upgrading SQL Server | 77 |
SQL Server Management and Configuration | 109 |
Configuring and Tuning SQL Server | 139 |
Configuration Parameters | 150 |
Database Design Issues | 467 |
Denormalization | 475 |
Performance and Tuning | 481 |
Query Optimization | 507 |
Multiuser Issues | 537 |
TransactSQL | 563 |
Using Stored Procedures and Cursors | 593 |
Advanced DBA Topics | 637 |
Configuration FAQ | 163 |
Managing Databases | 165 |
Managing SQL Server Users and Security | 203 |
Database Backup and Recovery | 237 |
Backup Wizard | 257 |
Restoring the master Database | 271 |
Backup and Restore FAQ | 294 |
SQL Database Maintenance | 299 |
Automating Database Administration Tasks | 313 |
Importing and Exporting Data | 353 |
Using BCP and BULK INSERT | 397 |
Troubleshooting | 427 |
Architecture and Database Design | 457 |
Common terms and phrases
ActiveX alert Analysis Services application BIGHAMMER button Cancel Help FIGURE Chapter clustered index column command configuration create cube cursor data source Data Transformation Data Transformation Services database backup DBCC default DELETE dialog box appears disk distribution database DTS package error log error messages example execute filegroup Functions installation lock Log Shipping login Maintenance Plan memory menu Microsoft SQL Server Monitor object ODBC OLAP OLE DB option parameters password performance processors Properties dialog box provides publisher pubs Query Analyzer RAID Right-click rows schedule Server Enterprise Manager shown in Figure snapshot specify SQL Server 2000 SQL Server Agent SQL Server Enterprise SQL statement SQL-DMO steps stored procedure subscribers syntax task Tools Transact-SQL transaction log transaction log backup transactional replication UPDATE upgrade varchar Visual Basic Windows 9x Windows NT Wizard
References to this book
Enhanced Active Databases for Federated Information Systems Christopher Popfinger Limited preview - 2007 |