"A great reference on SQL Server 2000, loaded with excellent code examples." --Sean O'Farrell, Manager, Business Integration, Eli Lilly and Company This book includes full coverage of Transact-SQL's DDL, and DML as well as ADO, DAO, and RDO. You'll learn to build scaleable SQL Server 2000 Web solutions and handle database management, backup, recovery, and security.
"synopsis" may belong to another edition of this title.
The book includes in-depth discussions of Transact-SQL to create and manipulate database objects, using the principal programming interfaces (e.g., ADO, DAO, ODBCDirect, ODBC, and RDO) to access the database, writing stored procedures and extended stored procedures, developing integrated, cross-platform Web applications with ASP and XML, replicating data to multiple systems, setting up security, performance monitoring and tuning, backup and recovery, managing databases with the Enterprise Manager, relational database design, and more.
SQL Server 2000 Developer’s Guide is unique in it’s comprehensive coverage of all the relevant database topics from the perspective of the database application developer. The reader gets a superb explanation of Transact-SQL, which lies at the heart of SQL Server 2000, as well as fully-working sample applications and explanations to quickly get started with any of the principal programming interfaces. But, SQL Server 2000 Developer’s Guide goes further to explain key database design and database administration topics, such as security and performance, so the developer is armed with all the knowledge needed to succeed in real-world development settings.
The 1200-plus pages include all the necessary technical information and directions for using various features and tools, but you won’t find space wasted, for example, with re-printed syntax diagrams from the on-line documentation. And, unlike the Books Online topic organization, you won’t have to bounce around to pull together all the relevant details for a particular topic. For programmers who already know the basics of SQL Server, the extensive index (over 4,000 entries) lets you can go straight to a section that covers a particular feature of interest and quickly learn about it.From the Author:
Based on our own experience as commercial application developers, we’ve tried to explain all aspects of database development you need to know to create top-quality, production databases and applications. We cover database design, T-SQL programming, writing applications with all the principal interfaces (e.g., ADO, DAO, ODBCDirect, ODBC, and RDO), and the key administrative areas of security, performance, and backup and recovery.
In writing this book, we tried to avoid simply repeating information you’ll find in the SQL Server 2000 Books Online documentation. Instead, we’ve provided tutorials on all the important SQL Server 2000 features and tools and described how to uses them to solve common development problems. You won’t find space wasted, for example, with re-printed syntax diagrams from the on-line documentation. Each chapter is designed so you can read it start-to-finish to efficiently learn all the essential aspects of the topics covered in the chapter. To bolster these explanations, we’ve included lots of examples (including full project source code on the CD), as well as specific design, coding, performance, and security “best practice” recommendations.
For those of you familiar with our previous book, SQL Server 7.0 Developer’s Guide, we want to point out we’ve completely re-structured and rewritten the new book to incorporate all the latest features and recommended techniques. We didn’t just add a “fix pack” to the previous book to produce this one. You’ll also find many more code examples and a greatly expanded index.
We hope you enjoy the book!
– Mike Otey and Paul Conte
"About this title" may belong to another edition of this title.
Book Description McGraw-Hill Osborne Media, 2000. Paperback. Book Condition: New. 2. Bookseller Inventory # DADAX0072125691
Book Description McGraw-Hill Osborne Media, 2000. Paperback. Book Condition: New. book. Bookseller Inventory # 0072125691