Professional SQL Server 2000 Programming

Amazon.com

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, Professional SQL Server 2000 Programming is an excellent choice.

In addition to providing a thorough treatment of SQL Server 2000 development, Rob 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 normalization that will help demystify 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's no accompanying CD-ROM, 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 comfortable with SQL Server 2000 development. If you are looking for a book that combines rich content with clear explanation, look no further. --Peter Lunn, Amazon.co.uk

Book Description

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.

Customer Reviews:

Best overall SQL 2000 book.......2006-12-03

By far, this is the best overall MS SQL 2000 server book written until today. Most topics are covered from basic to advance level. This book is a must have for anyone who is looking to get a well rounded knowledge of what's possible with MS SQL 2000.

The chapters I liked the most are:
Ch9 SQL Server Storage and Index Structures
Ch10 Views
Ch12 Stored Procedures
Ch15 Triggers
Ch16 Advanced Queries
Ch26 Full-Text Search
Ch29 Performance Tuning
All Appendixes

Noticed that I said "best overall" & "Most topics"; this book will not have an answer for very advance topics in areas like DTS, performance tuning, XML, & Analysis Services. There are great books out there if what you are looking for is not in Professional SQL Server 2000 Programming. The "Professional SQL Server 2000 DTS" is the best I have read when it comes to Data Transformation Services. For performance tuning and XML you may find books written by Ken Henderson to be among the best. For Analysis Services I have not found one book I will recommend yet.

Not bad not good.......2006-09-20

In general the book is ok. The author needed to make more research in some areas and not made use only of his own experience.

He does not mention about the issues with no following ANSI 92. The stored procedures and the trigger parts are really boring.

Sometimes the book is good but the author likes to move into areas he should not or he is not proficient enough. His comments on normalization and security are sometimes so strong that I tend to think that this guy is watching just one side of the coin.

Ed

Tiny font.......2006-07-07

Excellent book, but the font is VERY small which makes reading difficult even though I do not have vision problems.

One of the best!!.......2006-05-15

I have this book and I can say it is the best SQL Server book I have ever read. It may even be the best Development/Computer book I have. Every chapter is easy to read, detailed and concise. The coverage is phenomenal. I use this for reference quite a bit. The only thing that is missing is more detail on DTS... but that is a book in itself.

Un-satisfied with this book.......2006-05-10

If you ever read this book: Joe Sack' SQL server 2000 Fast Answers for DBA and Developer, then you will see Vieira's book misses so many details about SQL server 2000. Understanding that this book focuses on PROGRAMMING only, but still it misses many PROGRAMMING DETAILS of SQL server 2000. I do not have no connection to Joe Sack's business. I read and compare the two and speak out my mind.

Beginning SQL Server 2000 DBA: From Novice to Professional (The Expert's Voice)

Average customer rating:

A review
A very good book for SQL server self-learner
Not enough T-SQL
Extensive coverage of what every SQL DBA should know

Beginning SQL Server 2000 DBA: From Novice to Professional (The Expert's Voice)
Tony Bain , Michael Benkovich , Brian Freeman , Baya Pavliashvili , and Joseph Sack
Manufacturer: Apress
ProductGroup: Book
Binding: Paperback

Database Management Systems | Databases | Computers & Internet | Subjects | Books

General | Databases | Computers & Internet | Subjects | Books

Beginning & Introductory | Databases | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books

All Deals | Blowout Books | Stores | Books

Computers & Internet | Blowout Books | Stores | Books

All Titles | Qualifying Textbooks - Fall 2007 | Stores | Books

Computers & Internet | Qualifying Textbooks - Fall 2007 | Stores | Books
Similar Items:

Accessories:

ASIN: 159059293X

Book Description

SQL Server 2000 is the leading relational database in the Windows market. The increased manageability of SQL Server 2000 has "lowered the bar" with regard to the people that can use it – anyone can use a SQL Server database. However, this book recognizes that aspiring DBAs need more than just a basic knowledge of the available features in order to be considered "a safe pair of hands" for the database and the mission-critical data that is stored in it. They require direction and advice from an expert mentor who not only understands the features available and how they should be used, but also knows what it takes to be a good and effective DBA. In essence, this book is that "mentor", and this is why the book stands apart from the "feature overview" competition.

The book teaches a database novice the core job and roles involved in administering a SQL Server database. It follows the lifecycle of the database, from installation, design and modeling, through development, tuning and securing to growth and migration. It provides practical advice ("How to..."), answers typical questions that they'll encounter from managers and developers ("How do I..."), and offers practical steps to overcome issues with which beginners traditionally struggle. At every stage, it establishes a range of tried-and-tested practices and techniques that will establish and maintain the health of a DB system ("How to be a good DBA").

Customer Reviews:

A review.......2006-11-23

Warning! This might be a wonderful book except for the fact that the publishers decided to use much smaller print than is normally used for computer manuals. If staring at small print is not a problem for you then buy this book, otherwise you might be better off buying another book with normal sized print.

A very good book for SQL server self-learner.......2006-06-21

Excellent. It is a good reference for your SQL Server examination or self-learning. The examples are listed in details. If you follow them step by step, you can 100% learn the skills for your SQL server daily maintenance. I am not a professional in SQL Server, but after reading this book, I have much stronger confidence to use it.

IF THE AUTHOR CAN WRITE THE SAME KINDS/STYLE OF MATERIAL IN ORACLE FIELD, I THINK HE/SHE WILL FURTHER HELP A LOT OF LEARNERS OR USERS.

Not enough T-SQL.......2006-03-27

Overall, I would say this book is well put together and is an excellent resource. I personally was hoping for a bit more meat on the programming of the T-SQL commands and methods, but the lack of that information is not the fault of the author, merely my selection of the wrong book.

I picked up valuable knowledge about SQL Server that will serve me well, but DBAs in my company do a heck of a lot with T-SQL that apparently is not as common in other places.

Extensive coverage of what every SQL DBA should know.......2004-05-03

Packed with practical, real-world information for anyone involved with SQL Server Administration, "Beginning SQL Server 2000 DBA: From Novice to Professional" is one of the most complete administration books available. It is not without its problems but they are generally pretty minor and in fact somewhat humorous at times. For example, page 84 has a section titled "Upgrading to SQL Server 6.5" and page 90 a section titled "Upgrading to Earlier Versions of SQL Server". Obviously you don't upgrade to an earlier version nor do you upgrade from 2000 to 6.5. So, while there are errors, they are so obvious as to not be a big problem. When it comes to the technical details where accuracy is critical, I didn't find any obvious errors.

So what does the book cover? It starts with the different types of DBAs, the different versions of SQL Server 2000 available, installation methods and resolving installation problems. After getting everything installed and working correctly it moves on to working with the database with things like creating a database, basic considerations for databases (such as raid levels), and everyday administrative activities like making the database read-only, removing databases, adding databases, changing the path, creating and deleting tables. One of the things I liked about this section (and most of the sections of the book) was that it explained how to do each task by using the database manager and by using the Transact-SQL language.

Each of the sections follows logically from the prior one. With all the database management section completed the next part covers doing queries, joins, creating indexes, and similar tasks, basic backing up and restoring databases, generating a database script, creating and adding jobs, working with security and authentication, user permissions, roles, application security, ODBC, ADO, performance monitoring, and other tasks.

Although it was mentioned in brief in an earlier chapter, chapter eight provides a thorough treatment of backup and recovery. This is a very important chapter, I have run across many, many SQL installations where people did not understand the correct backup and restore procedures for SQL and made a complete mess of their system using copy and paste techniques. The author does an excellent job here and it will keep you out of trouble if you follow his advice.

The remaining portion of the book covers replication (a particularly well-done chapter), writing Transact-SQL code, creating views, error handling, writing triggers, data warehousing, data analysis, and creating a data transformation package using the data transformation package editor. Due to the breadth of coverage "Beginning SQL Server 2000 DBA: From Novice to Professional" is exactly as advertised and useful to both the complete novice and the experienced professional. Note that although it covers some of the more common uses of T-SQL for administrative purposes it is not a book on programming, it is a book on administration and within that defined area it is excellent. "Beginning SQL Server 2000 DBA" is a highly recommended read.

Average customer rating:

Very Good Book for DTS

Forget about this.

Not worth it

a nice laid out wrox book

a nice laid out wrox book

Professional SQL Server 2000 DTS (Data Transformation Services) (Programmer to Programmer)
Mark Chaffin , Brian Knight , and Todd Robinson
Manufacturer: Wrox
ProductGroup: Book
Binding: Paperback

General | SQL | Databases | Computers & Internet | Subjects | Books
Database Management Systems | Databases | Computers & Internet | Subjects | Books
General | Databases | Computers & Internet | Subjects | Books
SQL Server | Development | Microsoft | Computers & Internet | Subjects | Books
Databases | Software | Computers & Internet | Subjects | Books
General | Software | Computers & Internet | Subjects | Books
General | Programming | Computers & Internet | Subjects | Books
General | Computers & Internet | Subjects | Books
All Amazon Upgrade | Amazon Upgrade | Stores | Books
Computers & Internet | Amazon Upgrade | Stores | Books
All Titles | Qualifying Textbooks - Fall 2007 | Stores | Books
Similar Items:

Microsoft SQL Server(TM) 2000 DTS Step by Step (Step By Step (Microsoft))

Professional SQL Server 2005 Integration Services (Programmer to Programmer)

Professional SQL Server 2000 Programming (Programmer to Programmer)

The Guru's Guide to Transact-SQL

SQL Server DTS

ASIN: 0764543687

Amazon.com

A lot of corporate databases are what's behind the Internet revolution. Professional SQL Server 2000 DTS gives DBAs and programmers a handy guide to getting the most out of the Data Transformation Services (DTS)--a flexible set of tools that work on a wide variety of databases--that are available in SQL Server 2000.

The hands-on focus of the book makes it a win for readers of all backgrounds. While online help for DTS is not always easy to decipher, this book remedies the situation with plenty of screen shots of all of the major tools in action. Early sections examine nearly two dozen built-in tasks or functions in DTS--from the obvious (copying data from one database to another) to the more esoteric (sending files via FTP within DTS).

A gentle introduction to using VBScript and ActiveX objects gets at the DTS object model to design "custom tasks." By using this approach, you can automate and transform data reliably among different formats, including mainframe and Office documents. (Specific tips guide you in working with DB2 and Excel data.) A standout section looks at "linking" servers and querying data from heterogeneous sources.

You also learn how to build a Web front end (using ASPs) for a data application that uses SQL-DMO APIs to automate database tasks through a browser. Later, there's an excellent tutorial on data warehousing, done the Microsoft way--from the basics of the star, snowflake, and hybrid fact tables for a data mart to setting up and loading the data using DTS, and then running the database with Microsoft Analysis Services. The book closes with a thorough reference section that lists the objects and methods in the DTS object model.

Whether you're performing normal database administration or setting up a data warehouse--or you just want to work with data more effectively within your applications--Professional SQL Server 2000 DTS gives you all of the information that you need to be productive with a powerful (and sometimes overlooked) set of database tools and components. --Richard Dragan

Topics covered:

Introduction to Data Transformation Services (DTS)
Survey of DTS wizards and tools
The Import/Export Wizard
The Copy Database Wizard
The DTS Designer
Survey of automated tasks in SQL Server 2000, including the Bulk Insert, Execute SQL, Copy SQL Server Objects, and Transfer Databases tasks
The Multiphase Data Pump
Using a Data Driven Query (DDQ)
The FTP Task
The Execute Package Task
The Message Queue Task
Advanced package options
General package properties
Transfer Data Task options
Data scrubbing
Working with heterogeneous data (using linked servers from mainframe and legacy servers)
Tips for converting Excel and DB2 data
DTS ActiveX Script basics
Quick tutorial for VBScript syntax
The DTS Object Model
File management with the FileSystemObject object
DTS security issues
Meta Data Services
Backing up databases
DTS error handling
Building custom tasks in DTS
Star, snowflake, and hybrid designs for data warehouses
Extract, Transformation, and Load (ETL) with DTS
Microsoft Analysis Services
Creating Web front ends for DTS applications
Reference to the DTS and ADO object models
Reference to essential VB functions and keywords
Microsoft Scripting Run-Time Reference

Book Description

What is this book about?

(DTS) Data Transformation Services helps you create a transactional system to load and transform your data from and to a wide variety of sources. SQL Server DTS was introduced in the release of SQL Server 7.0; however, SQL Server 2000 sees the functionality and power of this outstanding and incredibly useful tool greatly increased. DTS can be used to maximum effect in data-driven applications, offering rapid and effective solutions to a wide range of common problems.

Professional SQL Server 2000 DTS provides a complete introduction to DTS fundamentals and architecture before exploring the more complex data transformations involved in moving data between different servers, applications, and providers. The book then focuses on DTS programming via the DTS object model, enabling developers to incorporate custom transformations and reporting capabilities into their applications. Advanced topics are explained including error handling, dynamic data loading, and data warehouses. With code and case studies, this book gives the reader a complete picture of how to use DTS to its fullest potential.

What does this book cover?

Here are just a few of the things you'll find covered in this book:

A detailed explanation of the seventeen principal DTS tasks
Connecting to, querying, and converting heterogeneous data
Dynamic configuration of your DTS packages
Enhancing your DTS packages with VBScript and Visual Basic
Writing your own custom tasks
Using DTS in a data-warehousing environment
Employing DTS in other applications

Who is this book for?

This book is principally aimed at database programmers and administrators who have a working knowledge of SQL Server, and who wish to take DTS beyond its most basic level and tailor it to their needs. It will also appeal to managers and project managers who want to gain an understanding of DTS and how it could benefit their businesses.

Download Description

What is this book about? (DTS) Data Transformation Services helps you create a transactional system to load and transform your data from and to a wide variety of sources. SQL Server DTS was introduced in the release of SQL Server 7.0; however, SQL Server 2000 sees the functionality and power of this outstanding and incredibly useful tool greatly increased. DTS can be used to maximum effect in data-driven applications, offering rapid and effective solutions to a wide range of common problems. Professional SQL Server 2000 DS provides a complete introduction to DTS fundamentals and architecture before exploring the more complex data transformations involved in moving data between different servers, applications, and providers. The book then focuses on DTS programming via the DTS object model, enabling developers to incorporate custom transformations and reporting capabilities into their applications. Advanced topics are explained including error handling, dynamic data loading, and data warehouses. With code and case studies, this book gives the reader a complete picture of how to use DTS to its fullest potential. What does this book cover? Here are just a few of the things you'll find covered in this book: A detailed explanation of the seventeen principal DTS tasks Connecting to, querying, and converting heterogeneous data Dynamic configuration of your DTS packages Enhancing your DTS packages with VBScript and Visual Basic Writing your own custom tasks Using DTS in a data-warehousing environment Employing DTS in other applications Who is this book for? This book is principally aimed at database programmers and administrators who have a working knowledge of SQL Server, and who wish to take DTS beyond its most basic level and tailor it to their needs. It will also appeal to managers and project managers who want to gain an understanding of DTS and how it could benefit their businesses.

Customer Reviews:

Very Good Book for DTS.......2005-10-03

This book clearly explains what DTS Package is ,about Datawarehousing and some conceopts about SQL Server Security...I liked this book very much and helped me a lot for my project

Forget about this........2005-06-28

Expect to see "foobar","Hello world", "The time is blah blah blah" and all that useless examples. This book is entitled "Professional" SQL Server 2000 DTS but you will end up getting (chicken) scratch on the surface: it tells you little about everything. Good only if you are a in the management, it will make you sound like you know what you are talking about. if you are a developer, better off find something else.

Not worth it.......2004-02-24

You'd think an 880-page tome from Wrox on something as specialised as DTS would pretty much have you covered anytime you need a reliable DTS reference to get you through your Data Transformation tasks. I have found myself looking to this book for guidance on many occasions during development, only to be consistently disappointed. For a start, the Index is downright useless, since I was never able to find words I would expected to, such as delimiter, lineage, disconnected edit, parameterised query, identity insert, but it has an entry for DNS?? (which, btw refers to a 3-line explanation of URLs when using Internet Explorer!) The book is so large mainly because every other page is a GUI snapshot, most of which are unnecessary. I don't need a whole page dedicated to the "Syntax check was successful" message box.

I give it 3 stars because they do a good job of at least mentioning probably every concept that relates to DTS, but coverage is mostly shallow and out of focus. There does seem to be heavy emphasis on data warehousing, which I haven't used so far, so I'll give it the benefit of the doubt regarding coverage there. Overall I still think I might find something good when I need a reference but so far I have mostly found SQL Books Online equally, or sometimes more useful.

a nice laid out wrox book.......2003-08-29

I have used dts for a long time but only got to grips with the
dts deseigner recently. This is book is very good for the
dba who has never tried manipulating dts packages.
Good job by the authors.

a nice laid out wrox book.......2003-08-29

I have used dts for a long time but only got to grips with the
dts deseigner recently. This is book is very good for the
dba who has never tried manipulating dts packages.
Good job by the authors.

Professional SQL Server 2000 Database Design

Average customer rating:

Why WROX is overrated
Not the be all end all, but a good place to start
disappointing
Buenisimo para todo nivel!
Soup To Nuts Engineering For Database Design, A Keeper

Professional SQL Server 2000 Database Design
Louis Davidson , and Wrox Author Team
Manufacturer: Wrox Press
ProductGroup: Book
Binding: Paperback

Database Management Systems | Databases | Computers & Internet | Subjects | Books

General | Databases | Computers & Internet | Subjects | Books

Databases | Software | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books

General | Programming | Computers & Internet | Subjects | Books

General | Computers & Internet | Subjects | Books

Look Inside Computer Books | Trip | Specialty Stores | Books
Similar Items:

ASIN: 1861004761

Book Description

SQL Server 2000 is the latest and most powerful version of Microsoft's data warehousing and relational database management system.

Professional SQL Server 2000 Database Design provides an outline of the techniques that the designer can employ to make effective use of the full range of facilities that SQL Server 2000 offers. It attempts to move away from traditional texts on relational database design by considering design issues from a 'real world' point of view. To that end, it provides a full case study illustrating the scope of the designer's role - right from initial discussions regarding a client's needs, through development of a logical model, to full implementation of the system.

Customer Reviews:

Why WROX is overrated.......2003-04-14

I've been reading many reviews about WROX books and people make it sound like WROX is the next O'Reilly of tech books. So when I needed a MSS-QL design book I figured I'd give them a try, especially after their good reviews on this book.

Leave it to say I'm very dissapointed. I own well over 100 tech books and this is by far the most wordy book I've read. This extra detail of wordiness does not offer some great insight into the subject but seems to serve as a way for the author(s) to turn what should be a 250 page book into a long and boring 600 page read.

I prefer books that get "right to the point". Theory is good and all but not in excessiveness. What it really boils down to is time, this book doubles my pacing and doesn't offer more in the line of education. If I wanted to read something big, I'll buy 'War & Peace'.

Bigger is NOT always better.

Not the be all end all, but a good place to start.......2003-01-04

This is the kind of book that will help the developer who has been working in Access and now finds the company has up sized to SQL Server. It's one of those books you add to your library that you read to make sure you have all the basics covered. I also like the fact that it gave the developer a look at the DBA side of the coin, which I'm sure will help the guy or gal who finds their the whole ball of SQL Server wax and has to do it all from developer to DBA.
Well Worth the investment in time and money.

disappointing.......2002-08-10

My background is as an ASP developer and new dedicated DBA / Data Architect. I've done pretty extensive data modeling and implementation for several small to medium sized ASP applications. I am a big fan of the Wrox P2P series. This is my 8th Wrox purchase.

I was disappointed in this book, but I'm having trouble putting my finger on exactly why I was disappointed. I read every word, which is rare for a technical book, but I just don't feel like I learned in the areas that I really wanted to learn. My two main goals for this read were to learn how to better build business rules into my databases and to reinforce and validate data modeling techniques I have been taught from mentors.

Extensive coverage is given in the first half of the book to the logical design (extensive to the point of obnoxious). Tips on how to break down your notes for entities and relationships and the like are abundant. A theme I kept repeating to myself over and over as I read was that this is big-time overkill for anything other than an enterprise-scale application. I'm as big an advocate of documenting client interviews as the next guy, but come on - breaking down every paragraph looking for verbs is just overkill. There was no advice given on how to solicit valuable information. Reports are discussed, but I'm a firm believer that reports can tell you much more about an application's true value than anything else. I very much prefer to start by asking the question "What information do you need from the system to do your job better than you do today?" than to start out by asking, "What do you do all day?" I find it the only way to break users out of the paradigm that they have worked in for so long and it leads to much more innovative useful applications. Nothing like this was in the book. I learned how to go through notes that magically appear, and that reports will shed light on missed pieces of information and new pieces of functionality, but who doesn't know that that has designed a database?

Davidson is a BIG advocate of normalization. And while there is no substitute for a well-normalized database for application stability and data integrity, Davidson advocates the breaking out of tables for the most meaningless of reasons. Those that develop applications on top of his databases much hate all the extra work he builds in. I disagree with his assertion that the database should be built to anticipate any possible changes to the user-expected data. You will spend forever trying to anticipate changes, and even longer coding over the massive database you have built. For example, in order to store a user's address, Davidson advocates a six-table structure with five joins. Are you kidding me? What coder wants to deal with all that just for the possibility that some time down the road the users may want to add Address Line 10 to the application.

Davidson also follows an annoying pattern for demonstrating his normalization techniques. He presents a data model with problems, introduces a concept, applies the concept to the tables and comes up with a better model. This is great, except that he continues to build on the same example throughout the book. So, other than the very last model, all the ones before it are incorrect. You have to read every word in order to get to the correct answer. It makes it impossible to pick up a chapter to use as a reference, because if you create a solution similar to the one demonstrated, you will have an improperly normalized database. Fine for a book you read front to back, but not so good for a reference manual.

The implementation details of the book were even more disappointing. Davidson is not an advocate of an N-Tier approach to coding. He believes that as many of the business rules that can be incorporated into the database should be built there. He openly says that he butts heads with his developers and system architects over this issue. I'm not surprised. While I suppose that building the business rules into the database is good for data integrity, I think the biggest advantage for the DBA is job security. I believe that a well-built database should be flexible to changes in business rules and that the data should be stored independent of those rules whenever possible. We all know rules change, and I don't like messing with a production database if I can help it. I would rather have flexibility in the model and trust my business tier coders to do their job.

The chapters on Stored Procedures, UDFs, Triggers, and the like are too complicated for a newbie and too un-detailed for an experienced developer. I found Professional SQL Server 2000 Programming by Robert Vieira a much better reference for both the basics and best practices.

I guess I've written enough. I still feel there is value in this book. For someone that has never designed a database before or has no formal training, it may be a good reference, but I fear it will be too complicated for a true newbie. There are valuable bits of advice and I broke out my highlighter more than once. In particular, Davidson offers some simple modes for overcoming common problems such as attribute change history.

Three stars - I just had too many disagreements with the author to go any higher.

-HawkeyeGK

Buenisimo para todo nivel!.......2002-06-21

Este libro no es solo para profesionales, también sirve para aquellas personas que poseen conocimientos básicos de SQL Server 2000 y de Diseño de Base de Datos y desean ampliar sus conocimientos.

Te lleva de la mano en todo momento, desde el momento de la toma de información y las entrevistas con el cliente hasta el proceso de Diseño de la Base de Datos como tal en SQL Server 2000.

Además utiliza un lenguaje muy cotidiano, lo cual hace el libro un poco particular.

Soup To Nuts Engineering For Database Design, A Keeper.......2001-11-25

I am old veteran engineer (hardware and software) working mostly alone on a new project for the .NET platform with SQL Server underneath for data. I am using Embarcadero ERStudio for database modeling. I have a great library (more than 20 titles) on relational database modeling and design; but this is the one that I keep on my desk. I am pretty much following this book step by step on my current project. The author uses the IDEF1X diagramming notation for logical design, which, quite conveniently, is what I use in ERStudio.

This is a great guide for the experienced professional developer who may do database design only occasionally. Examples are all from the business world. The book is filled with code, which can be downloaded.

The 606-page book has two sections: (1) logical design and (2) physical design and implementation. So far I have only completed the first section, but looking ahead it seems that this book will carry me all the way through actual testing of my finished application.

Book Description

Includes 100% complete coverage of all exam objectives, hundreds of practice questions, and hands-on exercises This exam is required for MCDBA certification and a popular elective for both the MCSE and MCSD certifications Previous edition sold more than XX,XXX copies CD-ROM contains CertTrainer software with interactive tutorials and lab simulations and ExamSim practice exam software

Customer Reviews:

Vague, poorly edited, and generally useless.......2003-09-15

After having read eight syngress books for certifications, this is the first time I had to get supplemental material to pass an exam. This book is vague, poorly organized, full of typos and syntax errors. It does not go into enough detail to help you pass the 70-229 exam or even gain a usable knowledge of MS SQL. This book is a waste of money. TRY SOMETHING ELSE!!!! I read "Inside SQL Server 2000" by Microsoft Press in order to pass the exam.

Quite good from novice perspective.......2003-05-12

This book is a great primer for the Exam and SQL Server development in general. While you obviously need to live, eat, and sleep Books On Line to pass the exam, this was a great place to start. I found the chapter on T-SQL to be one of the better ones I've ever read, and I still refer to it often. While no book gives you the test answers (try brain dumps if you want that), I find this a great book.

Not very good for 70-229..........2002-10-09

Needing to pass another test to keep my MCSD cert, I tried this book as prep for 70-229. Did the whole thing and examples. From passing other cert tests I knew it was LIGHT on specifics!. Talkes a lot about SQL server and new features in a general way but skirts around necessary details, specifics and examples needed to pass...

Had to buy another book(Que Exam Geer: 70-229 SQL Design/Implement) and then went and past the test...

A fairly good book for MCDBA and MCSD Preparation.......2002-05-08

I recently passed 70-229 exam. I used this book as my preparation guide though I frequently referred to SQL Server Books Online. The book is easy to read and explains the topics well. The review questions at the end of chapters are quite good to test your understanding of the materials. However, expect much tougher scenario based questions in exams. I found the book somewhat lacking in depth in the coverage of replication, the use of query analyzer tools, and transaction and locking issues. So, you may want to turn to Books Online to help you out there...

Not for the uninitiated.......2002-04-22

I found this an excellent reference, but not a "SQL for Idiots" guide that I think many IT new-comers are looking for. Having a working grasp of relational database systems is required.

This book helped me prepare for the obscurities of the MCDBA test that I would not normally run across in the real world.

One thing that I did notice is the drastically different
styles of the chapters, it was clear that it was a group collaboration with some gifted writers and some not (The style of chapter 2 should have persisted throughout the book, it would have been much more enjoyable!)

Amazon.com

Key to the interoperability of Microsoft SQL Server 2000--its ability to exchange information with other database management systems and with client applications--is its support of Extensible Markup Language (XML). Regardless of whether you're a database administrator charged with designing and maintaining databases or a software developer who uses SQL Server at the back end of a multitiered application, you need to understand what XML is all about, and how SQL Server goes about reading and writing it. Professional SQL Server 2000 XML uses an approach typical of Wrox Press--liberal commentary interspersed with plenty of examples that build on one another--to help its readers learn about its subject.

This book was written by a team of authors, each of whom wrote a few chapters in his or her specialty area. Like any book written by several people, this one displays different writing styles throughout, but the effect is not striking if you use the book mainly as a reference. Each author typically takes on the capabilities of SQL Server and XML one at a time, explaining what each is all about before launching into examples (complete with code) that reveal the mechanisms at work. It's a lot of information to absorb, but the authors do a fine job of presenting it logically. Case studies present big projects that each employ several of SQL Server's XML capabilities. --David Wall

Topics covered: The XML capabilities of Microsoft SQL Server 2000, including the FOR XML clauses in Transact-SQL, the OpenXML specification, XDR and XSD schemas, templates, views, and updategrams.

Book Description

The most important new features of SQL Server 2000 concern XML and the added functionality that it provides. This includes the ability to use XML documents to update your database, access SQL Server through HTTP and retrieve data from your database in XML format.

Building extensively on the new features introduced in Professional SQL Server 2000 (1-861004-48-6) this book goes beyond just the key issues and provides blanket in-depth coverage of advanced topics, including both XDR and XSD schemas (support for which has been added in the new Web Release 2), and additions in Web Release 1, such as Updategrams and XML Bulk Load. This book also includes five real-world case studies that show exactly how the XML capabilities of SQL Server 2000 can best be exploited with technologies as diverse as ASP, C#, and SOAP.

This book covers:
An introduction to XML
How to retrieve XML data from your database using FOR XML
Exposing XML documents as relational resultsets using OPENXML
Using XDR and XSD schemas to retrieve results through HTTP requests
Describing SQL Server tables using XML Views
A detailed discussion of the use of XPath queries with SQL Server
Modifying your database with Updategrams
Importing XML documents into your database with XML Bulk Load
An overview of the new features provided with Beta 1 of Web Release 2

Customer Reviews:

Not that good for .Net developers.......2002-08-20

It is a good book as far as explaning what SQL Server has to offer regarding XML capabilities but it should have covered the case studies fully with the .Net Framework. Also, it covers very good the IIS configuration, and how to manage XML Templates, XPath and Schemas. The book has a migration example from ASP to ASP.Net which does not cover ADO.Net. If you want a rich source on how to integrate SQLXML and the .Net Framework THIS IS NOT THE BOOK.

No other book covers SQL XML features like this one does.......2001-12-13

I looked at two other SQL Server 2000 XML books, but found this one to be the best - covering almost everything on SQL Server 2000 XML. Very well written, nice examples help understand the technology better. The chapter on Updategrams is very useful. I wanted to learn updategrams and this chapter covers it nicely to get started using them in production.

All that glitters is not Rob Vieira.......2001-12-04

I had mistakenly thought that Wrox books were held to a higher standard. First getting a taste for them going through both of Rob Vieira's two SQL Server Programming books and regarding them as the finest technical books I've ever seen. However this Professional SQL Server 2000 XML is a disappointment. Part of the problem lies with having 12 different authors because it seems a bit jumpy. I think I'll really try to limit my future purchases to single source efforts. Also, no care was taken with the code examples that you can download from the Wrox website. The book shows the source but there is really no way of really matching the example to the source other than guessing the name. Often I've needed to open up all 15 or so files in the directory to realize that the particular example is not included. I'm picking my way through but it is not pleasant.

Nice book, lots of code.......2001-08-11

Wrox has always prided themselves on code intensive books, and this is no exception. Unfortunately, they are also getting a bit intensive in the area of adding authors to be the first one to market. This leads to a book that seems a bit disjointed. With as few chapters as this book has, I do not see the need for so many authors. I guess it is the length.

Pluses in this book include the chapter on FOR XML and the chapter on OPENXML. I believe this is the area where most developers will like to spend the most of their time. I would have liked to see FOR XML EXPLICIT get a bit more coverage, as this is the bear, but the examples are workable, so I cannot complain too much.

I also enjoyed the updategram chapter. This ability was highly touted in Microsoft marketing events, but took quite some time to surface. The case studies help put the technology in a real world light.

The negatives are few. First, I believe far too much time is spent on XSD schemas, at least with the way it is presented. In a real world scenario, you are probably going to pull the schema from an existing database, which makes this material NULL and void. If you do get into writing XSD, you will find this material far too shallow.

Book Description

Data warehouses have evolved to cope with the huge volumes of data flowing through the workplace by separating the data used for reporting and decision making from the operational systems. The purpose of the data warehouse is simply to store the raw data, and in combination with Microsoft SQL Server 2000 Analysis Services, this data can be transformed into accessible information that reflects the real factors affecting the enterprise.

In this book, we introduce the key concepts of data warehousing, OLAP, and data mining. In addition to coverage of Data Transformation Services (DTS) and MDX, this book also demonstrates how to develop an Analysis Services client application, and how to secure and optimize your data warehouse. There is also an in-depth discussion of the exciting new topic of Web Housing.

By reading this book, you will learn how best to employ data warehousing and OLAP in your business, and how to leverage it to provide your organization with improved revenue and profitability.

This book covers:

Understanding Analysis Services Architecture
Designing Data Warehouses and Data Marts
Using Data Transformation Services (DTS) in Data Warehousing
Techniques for Data Mining and Analysis
Building OLAP cubes with Analysis Manager, and programmatically through DSO
Securing, Administrating and Optimizing a Data Warehouse and OLAP system
Using Multidimensional Expressions (MDX) to query OLAP cubes
Building OLAP client applications with Visual Basic and ASP
English Query, PivotTable Service

Customer Reviews:

Poorly Written and Confusing.......2003-09-05

Avoid this book. It was written by ten different people and it shows in the text - overlapping material and total lack of flow make it impossible to get a grasp on Analysis Services. It appears that many of the authors have difficulty understanding and adequately explaining the concepts themselves.

The Analysis Services tutorials included with SQL Server and Books Online are much more informative - with deliberate, well documented hands-on tutorials.

This is NOT the reference you are looking for.

Better than the last book!.......2002-01-07

I bought Sakhrs version of this book for SQL Server 7. This is not just an upgrade but a look at the new functionlity found within SQL Server 2000.

This book is a dream if you are involved within Analysis and even looking at the new DTS Analysis functions has helped me.

Comparing this with other books, by far this is the one that is well written and doesnt just come out with the obvious.

A Light in the Data Mining Tunnel.......2001-12-27

I found this book to be helpful in understanding how to utilize multidimensional database design. It was nice to see that Microsoft has some affordable alternatives one can turn to in the data mining and data warehousing market. Once again WROX has produced a helpful product for professionals in the computer industry.

Step by Step is Better.......2001-12-17

Been a Wrox fan for some time. This is the worst book their team has produced. The material is cursory at best and totally theoretical. Very few practical examples. Never thought I would point to an MSPress Step-by-Step book, however it is far superior to this junk.

Scripting XML and WMI for Microsoft(r) SQL Server 2000: Professional Developer's Guide

Average customer rating:

Get it for the WMI coverage
Good Book
Save Yer Dough
Use MSDN Instead
Use MSDN Instead

Scripting XML and WMI for Microsoft(r) SQL Server 2000: Professional Developer's Guide
Tobias Martinsson
Manufacturer: John Wiley & Sons
ProductGroup: Book
Binding: Paperback

Database Management Systems | Databases | Computers & Internet | Subjects | Books

XML & Databases | Databases | Computers & Internet | Subjects | Books

General | Programming | Computers & Internet | Subjects | Books

Databases | Software | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books

General | Computers & Internet | Subjects | Books
ASIN: 0471399515

Book Description

A quick-start guide to mastering all of SQL Server 2000's hot new Web development and database programming features
SQL Server 2000's new XML features, Windows Management Instrumentation (WMI), and scripting capabilities make it easier than ever for Web developers to create and manage flexible, scalable database applications optimized for the Internet--especially e-commerce applications. This quick-start guide is for Web developers and database programmers who need to get up to speed on these powerful new features. It begins with a no-frills tutorial on SQL programming basics and all the new SQL features. Then, step-by-step, it shows readers how to use those features to build cool database applications and to optimize database performance.

Customer Reviews:

Get it for the WMI coverage.......2001-11-16

I read Mr. Martinsson's other book, ActivePerl, and I really enjoy his writing style. I guess some people get it, and some don't. This book is especially strong if you are interested in WMI. While it touches on XML, it may be misleading to put XML first in the title. Nonetheless, it is an excellent treatment of scripting for SQL Server 2000 ...

Good Book.......2001-04-30

Wanted to learn programming SQL Server 2000 with WMI. I'm a programmer, so the book's approach fits me. WMI text and samples worked for me. I learned WMI. I'm happy.

XML is not what I bought it for. I know MSXML, XSLT, XPath, yada yada yada. But I found some stuff I can use with ADO and MSXML. It's a bonus.

Another bonus: the code samples are available in Perl. Found them on the CD-ROM next to the VBScript samples. A pleasant surprise because the booktext shows example-code in VBScript.

Save Yer Dough.......2001-04-24

I thought this book was one of the worst I have ever purchased. There are annoying mistakes in the sample queries, e.g., mispelled field names that will just drive you crazy. I can't speak for the WMI section, I bought this book for the SQL Server 2000 with XML info. I learned more at MSDN.

Use MSDN Instead.......2001-04-23

This book has several frustrating errors in the examples, you have to find the errors to make the example work, e.g., mispelled field name in SQL statement. I was only interested in the XML portion of the book and learned far more by digging in at MSDN's XML site.

Use MSDN Instead.......2001-04-23

MCSE Training Kit: Microsoft(r) SQL Server(tm) 2000 System Administration

Average customer rating:

Incomplete book for the 70-228 exam
Great buy!
Good book
A good place to start
Best Book Overall for Test Preparation

MCSE Training Kit: Microsoft(r) SQL Server(tm) 2000 System Administration
Microsoft Corporation
Manufacturer: Microsoft Press
ProductGroup: Book
Binding: Hardcover

MS SQL Server | Certification Central | Computers & Internet | Subjects | Books

General | Certification Central | Computers & Internet | Subjects | Books

Relational Databases | Databases | Computers & Internet | Subjects | Books

Database Management Systems | Databases | Computers & Internet | Subjects | Books

Databases | Software | Computers & Internet | Subjects | Books

General | Software | Computers & Internet | Subjects | Books

Databases | Apple | Computers & Internet | Subjects | Books

General | Computers & Internet | Subjects | Books

General | Computer Science | Computers & Internet | Subjects | Books

Look Inside Computer Books | Trip | Specialty Stores | Books
Similar Items:

ASIN: 0735612471

Book Description

This official MCSE TRAINING KIT teaches database administrators how to set up and support SQL Server 2000-as they prepare for MCP Exam 70-228, an elective on the MCSE track for Microsoft Windows(r) 2000 and a core exam for MCDBA certification. Topics map directly to the objectives measured by the MCP exam, including installing and configuring SQL Server 2000, creating databases, optimizing database performance, extracting and transforming data, managing security, and monitoring and troubleshooting SQL Server system activity. Students learn through an integrated system of skill-building tutorials, case study examples, and self-assessment exercises. An economical alternative to classroom instruction, this kit enables students to set their own pace and learn by doing!

Customer Reviews:

Incomplete book for the 70-228 exam.......2003-11-29

I started studying for the exam with this book and I noticed that this book has poor information for the following areas:

Clustering
DTS packages
Stored procedures, triggers, views.

I recommend to look for the 70-229 training book to complement to this one and study the books online.

This book contains useful information for the following areas:

Installation
Upgrades
Replications

Great buy!.......2002-12-27

Though I have not yet taken any exam (aiming for mcdba), I find this book really good. I am one of those who wants to learn a bit a theory as well, not just the practical parts. And I find this book to cover all of my expetations... A little minus for the boring chapters about upgrading Sql-s 6.5 and 7.0 though:), I hope that when I get to the age when I am supposed to find me a work (and hopefully something that has with sql-s to do) that they have done the upgrading before I arrive:D

Good book.......2002-12-06

I just recently started my SQL class, so I don't know everything, but I do know that as far as books go, this one isn't bad. For people who just want to get a paper certifiction as soon as possible...and then get fired job after job after job because they still don't know..., I suppose it isn't so hot....maybe that's why these kind of books get a lot of bad reviews. Here's a hint: I think it was meant to be used in a course with an actual instructor, and yes, you just might have to think and put some time in on it. SQL takes a good year to get down anyways, this book is just meant to introduce concepts, terms, and other information.

A good place to start.......2002-08-25

I have taken 6 of 7 exams for MCSE. I agree with the previous review that this is a very difficult exam. I doubt that any one book will do it for you on this one unless you have a lot of hands on experience.

The book covers all the basics but you must also know the following that this book does NOT cover:
1. Know your T-SQL very well.
2. Know all about indexes and how they affect performance.
3. Know some about db design, keys etc.
4. Know how to diagnose poor query performance.

Good Luck

Best Book Overall for Test Preparation.......2002-08-20

I've worked on SQL Server, taken this exam, and tutored others in SQL Server. Overall this book is as at least as good as the competition. It is much better written and editted than most other books on SQL Server, although as some other reviewers have said you sometimes hope for more detail. This book alone won't prepare you for the test, but it is a required one in my opinion. Some other good books are Sybex's "Mastering SQL Server 2000", Microsoft's "Inside SQL Server 2000", and of course SQL Server's "Books Online". Practice tests like Transcender or the Microsoft Readiness Review are an absolute requirement to pass the test, which is in my opinion one of the harder ones given by Microsoft.

Amazon.com

Professional SQL Server Development with Access 2000 shows the experienced database programmer or administrator how to take advantage of SQL Server using the built-in tools and capabilities of Access 2000. Filled with screen shots and plenty of practical advice for working with data, this book proves that Access is a great tool for getting the most out of SQL Server.

Usually associated with the lower end, Access 2000 has clearly grown up with the features that let you connect to SQL Server 7/2000, but with the convenience of a graphical tool. The book covers not only the features of Microsoft databases, but also how to rely on Access 2000 as your tool of choice for common administrative and programming tasks. Starting from table design, and the powerful database diagramming tools available in Access, you learn how to create effective database designs. And a full discussion of joins, indexes, constraints, views, and other advanced features make this book good for even more advanced readers. Besides admin functionality, there's coverage of VBA for database programmers, and T-SQL (Microsoft's version of SQL), including an excellent section on stored procedures and triggers.

While there's a lot of textual description in this book, there are also plenty of easy-to-understand screen shots, making this a useful resource to have at your desk. The graphics that detail the use of Access 2000 toolbars (which list the functions for each tiny button) are very good. The tutorial turns toward using Access 2000 features (forms and reports) to work with SQL Server data on the back end. Later sections examine the options you have for Web development, including Access's own Data Access Pages, data sheets, and a short introduction to using Active Server Pages on Microsoft IIS.

Reference sections of database security and upsizing older Access databases to SQL Server help round out this comprehensive and thoughtfully written book, which shows that Access 2000 really can let you access higher-end features on today's Windows platform. This book is perfect for any administrator or database programmer who wants to benefit from Access and SQL Server used together. --Richard Dragan

Topics covered:

Introduction to relational databases and Access 2000
Installing SQL Server 7/2000 and the Microsoft Data Engine (MSDE)
SQL Server data types
Creating and managing tables
Using constraints
Database diagramming in Access 2000
Using SQL Server views
Programming the SQL Distributed Management Objects (SQL-DMO)
Stored procedures and triggers (including VBA and ADO programming techniques)
Access forms (bound and programmatic access to form controls)
Report design in Access 2000 (including conditional formatting and charts)
Publishing datasheets for Internet applications
Quick introduction to form design using Active Server Pages (ASPs)
Data Access Pages
Office Web Components (including spread sheets and charts)
Programming SQL Server in Access (including basic ADO programming)
SQL Server security tutorial
Upsizing Access databases to SQL Server
ADO 2.1 object model reference

Book Description

This book deals with the many issues involved in making the transition from Access to MS SQL Server. While Access (part of the Microsoft Office suite) has long been the small business database of choice, for enterprise level solutions SQL Server is required. Microsoft is actively encouraging users onto this more sophisticated platform by making Access 2000 compatible with SQL Server. This means solutions can be developed using Access and easily scaled up to the more powerful SQL Server when the need arises.

Customer Reviews:

Very thorough.......2007-07-07

As a professional db developer, I found this book from Rick Dobson to be an excellent guide to getting you on your way with SQL Server development. Rick takes you through every step of the way very logically, preparing you for your next benchmark. He thoughfully anticipates your next question with a paragraph or two that explains the reasons why you're doing what you're doing and how to do it. Highly recommended reading for IT developers.

Outstanding resource for making the transition to SQL Server.......2002-07-08

By far the best book I have seen regarding the difficulties encountered when moving an Access application to SQL Server. Until reading this book, I couldn't figure out why my Access queries that were 'converted' into Stored Procedures could not reference each other, why my forms would not work, why the tables weren't updateable (primary keys weren't copied during conversion), etc.
All these and many more perplexing issues are clearly explained here. For quickest results, read Appendices B and C, then the first 7 chapters before trying to convert your first Access database to SQL Server.

An invaluable guide to Access Projects.......2002-05-10

Having spent a number of years using Access to develop commercial solutions I recently moved on to Access projects and found this book a real find in getting up and running in a short space of time. Covering each topic in logical chunks I found it to be more than a good grounding in the subject. It is also well written in plain English and avoids the unnecessary complications that are often found in such books and I would thoroughly recommend it to anyone who is considering developing Access projects.

A professional "getting started" book.......2001-11-01

I have years of experience in programming but knew nothing about Access, SQL or VBA when I got my latest assignment. I can't stand those 1000 page books that want to hold me by the hand while I build some simple-minded application through eight chapters. I just need to know the basics quick and then see a few examples of some typical tasks. This book is just what I needed to quickly get me up to speed and working on my own application. There are a few minor differences with Access XP (like changed menus) so you'll need a good XP reference also. I recommend this book to any developer that needs to come up to speed quickly on either SQL or Access.

Full of typos.......2001-04-25

I just received this book so I cannot comment on its technical merits. However, I have noticed the book is littered with spelling errors and errors in general. Examples are (1) On page 11 "As but this architecture won't be specifically considered furhter".. and yes, I included all the spelling typos. (2) On page 19 "if you had an Access poject" instead of "project." Isn't this what spell checkers are made for? There is at least one more error that I glanced over but did not record. And I have only read to page 19! My experience has been when a book contains many typos then then code should be suspect. I hope not, because a good Access 2000 to SQL book is needed. Caveat emptor!! Paul

Books:

Books Index

Books Home

Recommended Books