Microsoft SQL Server 2000 Bible Paperback – Sep 1 2002
No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
Getting the download link through email is temporarily not available. Please check back later.
To get the free app, enter your mobile phone number.
From the Back Cover
"Something for everyone . . . this book includes examples to demonstrate concepts along with little-known technical information about SQL Server."
-Melinda S. King, President of Best Technology Solutions, Inc.
* Master the bestselling client/server database platform
* Build high-performance, enterprise-class databases
* Analyze data with advanced SQL techniques
If Microsoft SQL Server 2000 can do it, you can do it too . . .
Here's everything you need to harness the power of SQL Server 2000, Microsoft's high-performance, Web-enabled client/server database and data analysis package. With a focus on performance and data integrity, database expert Paul Nielsen shows you how to design performance into your database from day one. From basic installation to working with XML, monitoring, and performance tuning - a topic so hot, it merits an entire section - Nielsen provides clear instructions, sound theory, and a special "Best Practice" icon that points to the most effective way to accomplish a given task. It's more than a guidebook; it's your total SQL Server 2000 toolkit.
Inside, you'll find complete coverage of SQL Server development
* Design database schemas for performance, adapt integrity, and agility
* Understand ACID and Transactional Integrity and build rock-solid databases
* Use relational algebra to write powerful queries
* Tune indexes as the bridge between data and query
* Analyze Query Execution plans for performance
* Create T-SQL stored procedures, triggers, and user-defined functions
* Share data using DTS, distributed queries, XML, and ADO.NET
* Analyze data with Analysis Services
* Add advanced scalability, availability, performance, and portability to your database
* Sample database applications and code examples from the book
* SQL Server utilities
* Links to Web sites, including the author's SQL Server Web site, www.IsNotNull.com
About the Author
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.
Top Customer Reviews
Unfortunately, it is plagued by a poor index. Even the most basic SQL is missing from the index. For example, if you are interested in the TOP clause, you won't find it between "tools, developer" and "torn-page detection". Instead you need to look under "Select statement, rows, return few (top keyword)".
With a better index, this book would be more than a great learning tool, but a great reference tool too.
If you are new to SQL it tells you all the background you need to know, if you have done any programming previously you will find it easy to use and really informative. My copy has post-it-notes sticking out of the top with useful hints written on them. It has really enthused me.
It has great sections for the DBA too, tips on improving performance and security etc.
Truly Fabulous, I love it!
One area in which it could be better is depth. It makes the mistake of trying to cover too many topics. Many of them are simply glossed over. If you need good T-SQL advice, DTS info or replication recommendations, get another book or books in addition to this one.
By and large though this is a book that you will find useful if you manage SQL Servers on a regular basis.
Thought I share the above freely downloadable treasure with my fellow Cyberfriends. PF-Merge supports over 20 database platforms and its utilities do not time-out.
Most recent customer reviews
Comparing with the other SQL Server 2000 books, this book does a poor job explaining the details of the database software and I found the writer's casual writing style very... Read morePublished on May 29 2004
The best yet I have read on SQL server.The author strings you along making you consume pages without knowing it. Read morePublished on Dec 5 2003 by Kingsley Akue
This book is GREAT!! This book has it all, but I was mostly impressed with all the SQL samples that show creative set-based solutions. Read morePublished on Aug. 22 2003 by Gary Lail
Used the Best Practices within the work environment. Great to have a guideline from which to work from. Read morePublished on July 11 2003 by Lynn Pendleton
Look for similar items by category
- Books > Computers & Technology > Databases > Database Management Systems
- Books > Computers & Technology > Databases > Relational Databases
- Books > Computers & Technology > Microsoft > Development > SQL Server
- Books > Computers & Technology > Networking & Cloud Computing > Data in the Enterprise > Client-Server Systems
- Books > Computers & Technology > Software
- Books > Computers & Technology > Web Development > Programming > SQL
- Books > Textbooks > Computer Science & Information Systems > Database Storage & Design
- Books > Textbooks > Computer Science & Information Systems > Programming Languages