Microsoft SQL Server 2000 Bible
Rights Contact Login For More Details
More About This Title Microsoft SQL Server 2000 Bible
English
Paul Nielsen (Hickory, North Carolina) has been a programmer, computer trainer, and consultant, focusing exclusively on database development. Currently, he is a SQL Server trainer at Learning Tree International and publishes "www.IsNotNull.com,"a free, weekly newsletter for SQL Server developers. Paul co-authored Inside the Norton Antivirus (Brady, 1993) with Peter Norton. He also served as the Technical Editor for "Access Advisor" Magazine and has written over 110 computer-related articles.
English
Preface.
Acknowledgments.
Part I: Laying the Foundation.
Chapter 1: Introducing SQL Server.
Chapter 2: Modeling the Logical Database Schema.
Chapter 3: Installing and Configuring SQL Server.
Chapter 4: Using SQL Servers Developer Tools.
Part II: Developing SQL Server Databases.
Chapter 5: Implementing the Physical Database Schema.
Chapter 6: Retrieving Data with Select.
Chapter 7: Merging Data Using Relational Algebra.
Chapter 8: Searching Full-Text Indexes.
Chapter 9: Creating Views.
Chapter 10: Modifying Data.
Chapter 11: Transactional Integrity.
Chapter 12: Programming with Transact-SQL.
Chapter 13: Developing Stored Procedures.
Chapter 14: Building User-Defined Functions.
Chapter 15: Implementing Triggers.
Chapter 16: Advanced Server-Side Programming.
Part III: Data Connectivity.
Chapter 17: Transferring Databases.
Chapter 18: Working with Distributed Queries.
Chapter 19: Migrating Data with DTS.
Chapter 20: Replicating Databases.
Chapter 21: ADO and ADO.NET.
Chapter 22: XML and Web Publishing.
Part IV: Administering SQL Server.
Chapter 23: Configuring SQL Server.
Chapter 24: Maintaining the Database.
Chapter 25: Automating Database Maintenance with SQL Server Agent.
Chapter 26: Recovery Planning.
Chapter 27: Securing Databases.
Part V: Advanced Issues.
Chapter 28: Advanced Performance.
Chapter 29: Advanced Availability.
Chapter 30: Advanced Scalability.
Chapter 31: Analysis Services.
Chapter 32: Advanced Portability.
Appendix A: Resources.
Appendix B: Sample Databases.
Appendix C: SQL Server 2000 Specifications.
Appendix D: Whats on the CD?
Index.
End-User License Agreement.
Acknowledgments.
Part I: Laying the Foundation.
Chapter 1: Introducing SQL Server.
Chapter 2: Modeling the Logical Database Schema.
Chapter 3: Installing and Configuring SQL Server.
Chapter 4: Using SQL Servers Developer Tools.
Part II: Developing SQL Server Databases.
Chapter 5: Implementing the Physical Database Schema.
Chapter 6: Retrieving Data with Select.
Chapter 7: Merging Data Using Relational Algebra.
Chapter 8: Searching Full-Text Indexes.
Chapter 9: Creating Views.
Chapter 10: Modifying Data.
Chapter 11: Transactional Integrity.
Chapter 12: Programming with Transact-SQL.
Chapter 13: Developing Stored Procedures.
Chapter 14: Building User-Defined Functions.
Chapter 15: Implementing Triggers.
Chapter 16: Advanced Server-Side Programming.
Part III: Data Connectivity.
Chapter 17: Transferring Databases.
Chapter 18: Working with Distributed Queries.
Chapter 19: Migrating Data with DTS.
Chapter 20: Replicating Databases.
Chapter 21: ADO and ADO.NET.
Chapter 22: XML and Web Publishing.
Part IV: Administering SQL Server.
Chapter 23: Configuring SQL Server.
Chapter 24: Maintaining the Database.
Chapter 25: Automating Database Maintenance with SQL Server Agent.
Chapter 26: Recovery Planning.
Chapter 27: Securing Databases.
Part V: Advanced Issues.
Chapter 28: Advanced Performance.
Chapter 29: Advanced Availability.
Chapter 30: Advanced Scalability.
Chapter 31: Analysis Services.
Chapter 32: Advanced Portability.
Appendix A: Resources.
Appendix B: Sample Databases.
Appendix C: SQL Server 2000 Specifications.
Appendix D: Whats on the CD?
Index.
End-User License Agreement.
