Vous voulez voir cette page en français ? Cliquez ici.

Sign in to turn on 1-Click ordering.
Amazon Prime Free Trial required. Sign up when you check out. Learn More
More Buying Choices
Have one to sell? Sell yours here
Tell the Publisher!
I'd like to read this book on Kindle

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

Microsoft SQL Server 2000 Bible [Paperback]

Paul Nielsen
4.3 out of 5 stars  See all reviews (10 customer reviews)
List Price: CDN$ 54.99
Price: CDN$ 34.64 & FREE Shipping. Details
You Save: CDN$ 20.35 (37%)
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Only 1 left in stock (more on the way).
Ships from and sold by Amazon.ca. Gift-wrap available.
Want it delivered Tuesday, October 21? Choose One-Day Shipping at checkout.
Join Amazon Student in Canada

Book Description

Sept. 1 2002 Bible (Book 49)
Organization: The book is divided into 6 parts: Preparing to Develop with SQL Server; Building and Managing Databases with SQL Server; Managing Data with SQL Server; Implementing Business Rules with SQL Server; Monitoring and Performance Tuning with SQL Server; and Advanced Data Transfer and Analysis with SQL Server.
Comprehensive coverage: This Bible covers both beginning and advanced topics. Topics covered include: installing and configuring SQL Server; using SQL server's development tools; securing databases; retrieving data; SQL Server transactions; working with XML; understanding transact SQL language extensions; developing stored procedures; tuning queries and indexes; and developing for English query.
Sample database applications: The book builds on sample database applications to demonstrate topics/concepts.
Sidebars: So as readers can focus on practical information, the author is using sidebars throughout to explain the best practices associated with the product and highlight material.
The CD-ROM contains the sample database applications and code examples in the book; SQL Server utilities; and links to Web sites, including the author's own SQL Server Web site (www.IsNotNull.com).

Customers Who Bought This Item Also Bought

Product Details

Product Description

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

Bonus CD-ROM!
* 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.

Inside This Book (Learn More)
First Sentence
As a database, SQL Server is all about efficiently storing data within tables built from rows and columns. Read the first page
Explore More
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Sell a Digital Version of This Book in the Kindle Store

If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store. Learn more

Customer Reviews

4.3 out of 5 stars
4.3 out of 5 stars
Most helpful customer reviews
3.0 out of 5 stars Great book, poor index July 18 2003
This is a great book. It's throughout and easy to read. Every time I've turned to it, it has the information I need.
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.
Was this review helpful to you?
5.0 out of 5 stars Great resource Nov. 4 2003
This is a brilliant book, easy to assimilate and quick to progress through.
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!
Was this review helpful to you?
3.0 out of 5 stars Useful book May 1 2004
I like this book and use it often. For the basic product, it is as good as Inside SQL Server.
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.
Was this review helpful to you?
5.0 out of 5 stars Concise, Entertaining, and Comprehensive Nov. 4 2003
By Steve
I've been using T-SQL professionally for over six years. SQL Server 2000 Bible has taught me more detail and depth about the tools that I use, and I enjoyed the author's style and humor. He made the concepts clear and understandable, great for the beginner or the experienced programmer. I reccomend this for anyone who wants to learn to take SQL Server to it's highest potential.
Was this review helpful to you?
5.0 out of 5 stars Auto-fill forms with SQL Server2000 data ... April 4 2004
If you have a multi-page Acrobat Form and want to automatically fill the form with SQL Server , optionally emailing/faxing it, PF-Merge will do that job for you, without programming. It also merges images!
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.
Was this review helpful to you?
Want to see more reviews on this item?

Look for similar items by category