The Layout of This Book

The book is divided into the following six parts :

  • Part I, "Welcome to Microsoft SQL Server" ”This section is intended to introduce you to the Microsoft SQL Server environment and the various editions and capabilities of SQL Server that are available in the various Windows environments. In addition, it provides an overview and introduction to the features to be found in SQL Server 2000, many of which are covered in more detail throughout the book.

  • Part II, "SQL Server Tools and Utilities" ”The tools and tasks provided with SQL Server 2000 to administer and manage your SQL Server environments are covered in this section. Coverage is provided on the various management tools you will use on a daily basis, such as SQL Enterprise Manager and Query Analyzer, along with chapters on the various optimization and analysis tools, such as SQL Profiler and the new SQL Debugger available in Query Analyzer. If you are not familiar with these tools, you will want to read these chapters first as these tools are often used and referenced throughout many of the subsequent chapters in the book.

  • Part III, "SQL Server Administration" ” This section begins with coverage on the installation of SQL Server and the client component, and then goes on to discuss other administrative activities such as the creation and management of databases and the various database objects, security and user management, replication, database backups and maintenance, and remote and linked server management. A chapter on administering very large databases provides some expert advice, as well as a chapter on SQL Server clustering. Data Transformation Services (DTS), the BCP utility, and SQL Server Agent are also discussed in this section.

  • Part IV, "Transact-SQL" ”This part includes a comprehensive overview of all the Transact-SQL (T-SQL) statements. In addition to providing the syntax for the T-SQL components , it also provides expert tips and advice on optimizing the use of the various T-SQL commands along with extended coverage of the new Transact -SQL features available in SQL Server 2000. A chapter on transaction management provides information on how transactions are logged and guidelines on the correct use and management of transactions in client applications, as well as troubleshooting their use in SQL Server. A full chapter introduces you to the creation and use of user-defined functions, while other chapters provide useful tips and techniques for creating views, stored procedures, and triggers.

  • Part V, "SQL Server Internals and Performance Tuning" ”This section provides information to help you get the best performance out of SQL Server. It begins with a discussion on the internal architecture and storage structures of SQL Server to help you understand what goes on under the covers when you modify and query your data. It then builds on that with chapters on indexes, query optimization and analysis, database design and performance, and configuring and tuning SQL Server.

  • Part VI, "Additional SQL Server Features" ”This part provides detailed information on the other components and add-ons of SQL Server that further enhance and extend its capabilities. Included are chapters on using XML in SQL Server 2000, full-text search services, English Query, Analysis Services, and Microsoft Transaction Server (MTS). Additionally, chapters are provided that discuss the recently released Notification Services and the .NET Framework and ADO.NET.

Microsoft SQL Server 2000 Unleashed
Microsoft SQL Server 2000 Unleashed (2nd Edition)
ISBN: 0672324679
EAN: 2147483647
Year: 2002
Pages: 503

Similar book on Amazon © 2008-2017.
If you may any questions please contact us: