BN.com Gift Guide

Professional SQL Server 2000 Programming

Overview

What is this book about?

SQL Server 2000 is the latest and most powerful version of Microsoft's data warehousing and relational database management system. This new release is tightly integrated with Windows 2000 and offers more support for XML, as well as improved Analysis Services for OLAP and data mining.

Professional SQL Server 2000 provides a comprehensive guide to programming with SQL Server 2000, from a complete tutorial on Transact-SQL ...

See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (33) from $1.99   
  • New (6) from $12.23   
  • Used (27) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$12.23
Seller since 2009

Feedback rating:

(2562)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
2000-11-15 Paperback 1 New 0764543792 Ships Within 24 Hours. Tracking Number available for all USA orders. Excellent Customer Service. Upto 15 Days 100% Money Back Gurantee. Try ... Our Fast! ! ! ! Shipping With Tracking Number. Read more Show Less

Ships from: Bensalem, PA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$12.25
Seller since 2010

Feedback rating:

(1022)

Condition: New
PAPERBACK New 0764543792 Friendly Return Policy. A+++ Customer Service!

Ships from: Philadelphia, PA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$12.23
Seller since 2014

Feedback rating:

(316)

Condition: New
PAPERBACK New 0764543792 XCITING PRICES JUST FOR YOU. Ships within 24 hours. Best customer service. 100% money back return policy.

Ships from: Bensalem, PA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$12.23
Seller since 2014

Feedback rating:

(490)

Condition: New
PAPERBACK New 0764543792! ! KNOWLEDGE IS POWER! ! ENJOY OUR BEST PRICES! ! ! Ships Fast. All standard orders delivered within 5 to 12 business days.

Ships from: Southampton, PA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$12.23
Seller since 2010

Feedback rating:

(772)

Condition: New
PAPERBACK New 0764543792! ! ! ! BEST PRICES WITH A SERVICE YOU CAN RELY! ! !

Ships from: Philadelphia, PA

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$107.98
Seller since 2005

Feedback rating:

(808)

Condition: New
2000 Paperback New Tracking provided on most orders.

Ships from: Grand Rapids, MI

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Overview

What is this book about?

SQL Server 2000 is the latest and most powerful version of Microsoft's data warehousing and relational database management system. This new release is tightly integrated with Windows 2000 and offers more support for XML, as well as improved Analysis Services for OLAP and data mining.

Professional SQL Server 2000 provides a comprehensive guide to programming with SQL Server 2000, from a complete tutorial on Transact-SQL to an in-depth discussion of new features, such as indexed views, user-defined functions, and the wealth of new SQL Server features to support XML. Whether you're coming to SQL Server 2000 from another relational database management system, upgrading your existing system, or perhaps wanting to add programming skills to your DBA knowledge, you'll find what you need in this book to get to grips with SQL Server 2000 development.

What does this book cover?

Here are just a few of the things covered in this book:

  • A complete introduction to Transact-SQL
  • Database design issues
  • Creating and using views, stored procedures, and user- defined functions
  • Responding to events with triggers
  • Making your SQL Server secure
  • Retrieving your data as XML
  • An introduction to Analysis Services
  • Moving data using Data Transformation Services and the bulk copy program
  • Maintaining the integrity of distributed data with replication

Who is this book for?

This book is aimed at the SQL Server developer who wants to make the most out of the new features of SQL Server 2000. No knowledge of SQL Server is assumed, although in order to follow this book, you do need to have an understanding of programming basics such as variables, data types, and procedural programming. Database administration is also covered but only as it affects the SQL Server developer.

Read More Show Less

Product Details

  • ISBN-13: 9780764543791
  • Publisher: Wiley
  • Publication date: 12/1/2000
  • Series: Programmer to Programmer Series
  • Edition number: 1
  • Pages: 1440
  • Product dimensions: 7.14 (w) x 9.18 (h) x 2.52 (d)

Meet the Author

Robert Vieira Experiencing his first bout with computing in 1978, Robert Vieira knew right away that this was something "really cool". In 1980 he began immersing himself into the computing world more fully – splitting time between building and repairing computer kits, and programming in BASIC as well as Z80 and 6502 assembly languages. In 1983, he began studies for a degree in Computer Information Systems, but found the professional mainframe environment too rigid for his tastes, dropping out in 1985 to pursue other interests. Later that year, he caught the "PC bug" and began the long road of programming in database languages from dBase to SQL Server. Rob completed a degree in Business Administration in 1990, and has since typically worked in roles that allow him to combine his knowledge of business and computing. Beyond his Bachelor's degree, he has been certified as a Certified Management Accountant as well as Microsoft Certified as a Solutions Developer (MCSD), Trainer (MCT), and Database Administrator (MCDBA).
Rob is currently the Principal Consultant for Database and Storage Technologies with the Technology and Innovation Group at STEP Technology in Portland, Oregon – a position that offers the high-end consulting and team support he craves.
He resides with his wife Nancy, elder daughter Ashley, and new addition Adrianna, in Vancouver, WA.
Read More Show Less

Table of Contents

Introduction.

Chapter 1: SQL Server 2000 – Particulars and History.

Chapter 2: RDBMS Basics: What Makes Up a SQL Server Database?

Chapter 3: Tools of the Trade.

Chapter 4: The Foundation Statements of T-SQL.

Chapter 5: Joining Tables.

Chapter 6: Creating and Altering Tables.

Chapter 7: Constraints.

Chapter 8: Normalization and Other Basic Design Issues.

Chapter 9: SQL Server Storage and Index Structures.

Chapter 10: Views.

Chapter 11: Writing Scripts and Batches.

Chapter 12: Stored Procedures.

Chapter 13: User Defined Functions.

Chapter 14: Transactions and Locks.

Chapter 15: Triggers.

Chapter 16: Advanced Queries.

Chapter 17: Distributed Queries and Transactions.

Chapter 18: SQL Cursors.

Chapter 19: A Brief XML Primer.

Chapter 20: Integration of XML into SQL Server.

Chapter 21: The Bulk Copy Program (bcp).

Chapter 22: Introduction to Data Transformation Services.

Chapter 23: Replication.

Chapter 24: Advanced Design.

Chapter 25: Analysis Services.

Chapter 26: Full-Text Search.

Chapter 27: English Query.

Chapter 28: Security.

Chapter 29: Performance Tuning.

Chapter 30: Administration Overview.

Chapter 31: Advanced DTS.

Chapter 32: Scripting Administrative Functions with WMI.

Appendix A: System Functions.

Appendix B: Function Listing.

Appendix C: Tools for Our Time.

Appendix D: Access Upsizing.

Appendix E: Microsoft Data Transformation Services Package Object Library Reference.

Index.

Read More Show Less

Interviews & Essays

An Interview with Rob Vieira author of Professional SQL Server 2000

1. You recently spoke at the Amsterdam conference. Which is more fulfilling - writing books or speaking at conferences, and why?

Tough question. Speaking gives the more immediate gratification of seeing someone face to face, answering their questions, and knowing that you really helped someone - it's simply more "real". Book writing, however, has the sheer mass advantage. It's hard to beat the literally hundreds, if not thousands, of people who have contacted me to personally say thanks.

2. What would you say are the major developments in SQL 2000?

Ouch - another tough one. The difficulty is in defining "major". For me, the single biggest addition was definitely User Defined Functions. This is a feature that's going to impact about every project out there. After that, the XML integration and INSTEAD OF triggers are probably
the biggies.

3. What further improvements would you hope/expect to see in the new few months/next version?

I'm very much looking forward to the XML Updategrams release and also seeing XML support added to the OLAP functionality. For Yukon (the next release of SQL Server), I'm looking forward to the additional language support.

4.SQL Server's support for data warehousing and mining has been improved, can you outline some of the new features?

Probably the glitziest of all the new features is the new data mining functionality. Microsoft has added some features here that are normally only found is outrageously expensive (often 6 figures per seat) software. Data Mining allows you to see relationships that are not always intuitive (answer questions you didn't even know you should be asking) and can even do some predictive modeling.

On more general use, however, is the new parent-child hierarchy. One of the problems with the old OLAP Services (what Analysis Services was called under 7.0) was that it couldn't handle what is called a "ragged hierarchy" - that is, a hierarchy where the depth of the hierarchy was variable - often totally unpredictable. The new parent-child approach deals with this problem rather elegantly.

5. Do you see the PDA version of SQL spawning many apps?

That rides on the future of the CE and PocketPC platforms in general. The concept of code compatibility and replication between devices is something that is a major advantage versus the Palm world (where DB work is painful at best) - I'm hoping for good things, but only time will tell.

6. SQL Server 2000 features XML intergration - what do you see as the major benefits of this and what do you see as the future for this?

Today there are some serious security issues to be dealt with. You can beat them, but it removes much of the ease that one expects when they first look at the product. I'm expecting much of that to be taken care of with some of the web releases over the next year.

7. How can you see the .Net implementation fitting with SQL Server?

I don't think there's all that much that's .NET specific about this release of SQL Server. There will, however, likely be much simplified database access in the .NET environment. I'm also looking forward to having C# as a development language for SQL Server when we get to Yukon.

8. SQL Server 2000 reportedly marks the last release of SQL Server's previous management API (SQL-DMO) - WMI will take its place. Why is WMI the way forward?

WMI offers the advantage of requiring less "new" knowledge for the developer. WMI will be very similar to use for SQL Server, Exchange, and the other back office products. Perhaps the biggest advantage, however, is that you loose the dependency on the specific COM Interface id's from version to version. As long as the general syntax is still sound, things should still work fine with a new release. For those that have had to deal with DMO in the past this should be a major relief.

9. What does the year ahead hold for you?

A lot more time with my family. I'll be doing a few speaking events and probably contributing a few articles to SQL Server Magazine, but I'm taking time away from writing for the forseeable future.

10. If you could write/have written any non-computer book, which would it be and why?

A Science Fiction humor book. I started to write one about 15 years ago, but the manuscript was lost in a series of moves, and I've just never gotten back there. Perhaps someday that concept will live again - but not anytime soon.


Courtesy for Wrox Press
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 5 Customer Reviews
  • Anonymous

    Posted January 8, 2006

    An excellent book for preparing exam 70229 !

    I strongly recommend this excellent book to those who is going to take the Microsoft exam 70229. I just passed the exam 70229, and I used this book as my main reference. Comparing it with Microsoft Training kit, this book contains exclusive examples with readily understandable explanations. It also provides very good practice in each subject, which can be done in a single computer networking environment. The author is obviously very experienced in relational database field and in 70229 exams. All of the exam contents are included in this book. This book is also a very good learning tool for DBA who is starting to learn MS SQL 2K. The author provides lots of T-SQL examples and those good and bad programming habits. The only weakness of this book is that it is a little bit wordy. I guess this is because the author is too much experienced in MS SQL Server and try to share all his ideas to the readers. In a word, this is an excellent book for learning SQL Server 2000.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted April 1, 2003

    SQL

    the book is really good for beginners

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted August 26, 2002

    Awesome book

    This book is great for beginners/people with a little knowledge of SQL server/T-SQL and for advanced users.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted May 28, 2002

    Best book for total over view of SQL Server

    This is great book to get real world practical uses of SQL Server. I learned a lot of details about all facets of SQL Server. I am an MCDBA and this book really improved on a lot of the information I already knew. I used Enterprise Manger to do a lot of my task. Now I feel really comfortable and have found many uses for programming SQL Server.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted January 29, 2002

    Great But .....

    I bought the book holding in mind that it is dedicated to people having experience with SQL Server and seeking more deep looks into things but I am now in page 300 and still reading things that I know ... but I would like to mention 1 fact that even though the materials so far are Deja Vus but I learned some tips and tricks ... I skipped to some chapters on query Design and they are very good

    Was this review helpful? Yes  No   Report this review
Sort by: Showing all of 5 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)