Professional SQL Server 2000 Programming - Softcover

Vieira, Robert

Softcover

ISBN 10: 1861004486 ISBN 13: 9781861004482

Publisher: WROX Press Ltd, 2000

Synopsis

Microsoft SQL Server 2000 will be a significant new revision of the fastest rising player in the RDBMS marketplace. Microsoft is actively encouraging a growing number of users onto the SQL platform, by making it cheaply available. The new release, SQL 2000, is tightly integrated with Windows 2000, offering more support for XML and much improved OLAP (Online Analytical Processing) services.

SQL Server is very strong in the market place, supporting both small and large Internet sites. Large users include Merryl Lynch, DELL Computer and HarperCollins Publishers. Commercial applications running on SQL Server range in size from small databases such as Sales Logix, to large ERP systems such as SAP, where it is now the SAP "preferred" database for NT based installations. SQL Server is now first choice for the developer wanting a powerful, reliable and sophisticated database.

About this title

Review

When it comes to selecting computer books, deciding which book to buy can sometimes be even more confusing than the software it is written about. However, if you are looking for a book to instruct you on the use of SQL Server 2000, choosing this book, Professional SQL Server 2000 Programming, could well simplify your selection process.

In addition to providing a thorough treatment of SQL Server 2000 development, Robert Vieira's extensive reference also devotes quite a lot of space to covering SQL in general and issues relating to database design. Included is a complete introduction to Transact-SQL and an excellent chapter on normalisation that will go a long way for many to de-mystify the mystery of an over-referenced but much misunderstood database design concept. There is also in-depth information on the new features of SQL Server 2000, including indexed views, user-defined functions and support of XML. Sadly, there is no accompanying CD, but source code for the book can be downloaded from the Wrox Web site.

While you don't need any knowledge of SQL Server or database administration to make the most of this book, you will need a reasonable understanding of programming fundamentals. That said, the author's down-to-earth style makes it possible for anyone with some programming background and the will to learn, to really get to grips with SQL Server 2000 development. If you are looking for a book that combines rich content with clear explanation, then look no further than this excellent title. --Peter Lunn

From the Publisher

This book is a revised follow on from Professional SQL Server 7.0 Programming, to address the new features of this recent release. With a general understanding of programming principles, (eg familiarity with VB, C++, VB Script) Professional SQL Server 2000 Programming provides a comprehensive overview of the new areas of SQL Server, for programmers. There is an in-depth discussion of T-SQL, the query language of Microsoft SQL Server. From basic database design concepts a tutorial explains more advanced topics and specific areas including Stored Procedures and Advanced Queries. Advanced topics - performance tuning, security and a solid description of OLAP, which is built in with SQL Server, are then introduced. The new XML features are explored to provide an understanding of this important area. With over 1,500 pages this book covers the main topics to provide an in-depth understanding of concepts and procedures, so you can get the most out of SQL Server 2000.

Edition details

• Publisher: WROX Press Ltd
• Publication date: 2000
• Language: English
• ISBN 10: 1861004486
• ISBN 13: 9781861004482
• Binding: Paperback
• Number of pages: 1400