Book Description
Microsoft SQL Server 2000 is the high-end, mission-critical relational database management system for rapidly building the next generation of scalable e-commerce, line-of-business, and data-warehousing solutions. MICROSOFT SQL SERVER 2000 RESOURCE KIT gives database administrators and other IT professionals the definitive technical information and tools they need to deploy, manage, and maintain SQL Server 2000. Delivered direct from the Microsoft SQL Server 2000 product team and Microsoft Consulting Services, it includes special information about core functionality and new features of the product, plus a CD-ROM packed with unique tools and utilities to simplify SQL Server management. It also covers vital topics such as security, clustering and scalability, and Extensible Markup Language (XML). This powerhouse reference is an essential resource for every database administrator who seeks maximum performance from SQL Server 2000.
Customer Reviews:
Somewhat useful.......2004-01-23
The information in this book is useful only to those who are clueless of SQL. Most of the insights are rudimentary and its "best practices" are common sense to most experienced SQL DBAs. If you are an experienced SQL DBA, I would recommend this book for only two reasons:
1)You want to obtain some stored procedures as a DBA utility. If you are already a good T-SQL programmer, this will bring you limited value.
2)You want to have a good understanding of SQL Clustering and Log shipping. The book does better job than most in describing both SQL clustering and Log shipping. But the explanation is very general and more architectural than explaining how to implement and manage one.
Good book.......2003-11-29
I used this book to prepare myself for the MCP Exam and I passed.
This book contains excellent examples and it is good for people who learn by modifying examples.
I recommend this book especially for DBA who worked with the SQL 7 and want to focus on new features of SQL 2K.
Great coverage of SQL Server Data Warehousing topics.......2002-10-17
I bought this book after searching for a good practical and design guide to the new data warehousing tools in SQL Server 2000. While not perfect none of the other tomes that I own on SQL Server do justice to this topic which is very hot in database circles these days.
A Good Addition to Books Online.......2002-09-05
I don't have much of a need for the first few chapters of the book. They detail how to convert to SQL Server from another RDBMS platform. However, I know others have found the text useful. What I did find of value were the parts of the book which covered day-to-day operations, disaster recovery, and handling BLOBs. Security was decent, but not very fleshed out. It's a great addition to Books Online.
Comprehensive and Essential.......2001-11-07
It's a crying shame that Microsoft's best documentation is for sale rather than free in online help.
Book Description
Not a reference book, and not a tutorial either, the new second edition of the highly regarded Access Cookbook is an uncommonly useful collection of solutions to problems that Access users and developers are likely to face as they attempt to build increasingly complex applications. Although using any single "recipe" in the book will more than pay back the cost of the book in terms of both hours saved and frustration thwarted, Access Cookbook, Second Edition is much more than a handy assortment of cut-and-paste code. Each of the "recipes" examine a particular problem--problems that commonly occur when you push the upper limits of Access, or ones that are likely to trip up a developer attempting to design a more elegant Access application--even some things you never knew Access could do. The authors then, in a clear, accessible, step-by-step style, present the problems' solution. Following each "recipe" are insights on how Access works, potential pitfalls, interesting programming techniques that are used in the solution, and how and why the solution works, so you can adapt the problem-solving techniques to other similar situations. Fully updated for Access 2003, Access Cookbook, Second Edition is also one of the first books to thoroughly explore new support for .NET managed code and XML. All of the practical, real-world examples have been tested for compatibility with Access 2003, Windows XP, and Windows Server 2003. This updated new edition also covers Access and SharePoint, Access and SmartTags, Access and .NET; and Access and XML. Access power users and programmers at all levels, from the relatively inexperienced to the most sophisticated, will rely on the Access Cookbook for quick solutions to gnarly problems. With a dog-eared copy of Access Cookbook at your side, you can spend your time and energy where it matters most: working on the interesting facets of your Access application, not just the time-consuming ones.
Customer Reviews:
One of the most invaluable references I have in my library.......2006-10-13
I'll keep this brief, as my title says it all. I have been developing access applications on a professional level for many years. Have several applications that large companies use to run there business. This cookbook has helped me in more ways then I can count. I wish I could find more like it. I use it just as a cookbook. Look thru to find a similiar situation that I am trying to solve. The examples are written very well. The code is very exact and on the money. While most of the examples listed are not always exactly like what I'm trying to solve, it definitely gets the creative juices flowing on how to solve my problem.
The other good things, there are several useful "tips" that you can use to implement in many of your applications that will help the users have a better experience.
Definitely a must have if you wish to write serious applications.
Recipes for Access Developer Success.......2005-05-21
The Access Developer's Handbook Set (search ISBN: 0782140114) and in particular, Volume 1: Desktop Edition (search ISBN: 0782123708) is my definitive resource to approximately 4 years of Access development. I've got more stickies and highlights in this set than all other Access books combined. So when I came across the Access cookbook and realized that the same two indispensible authors (Getz & Litwin) put together a resource of Access developer solutions, I had to have it.
This book has not let me down. It is certainly geared towards the intermediate to advanced Access professional developers who already understand the basics of Access and more importantly, who also understand the shortcomings of Access and the benefits of getting around those shortcomings. There are about 170 solutions in this book that are segmented into 18 chapters of high-level topics such as Queries, Forms, XML, UI, VBA, Windows APIs, even Smart Tags. I would be really surprised to find someone who picked up this text, thumbed through the solutions, and found that there was nothing they could get out of this book.
I would say that if you are developing a professional Access front-end and/or database, you owe it to yourself to buy this book and review each solution before you release or ship your product. I did, and found either new answers and existing improvements to many of the things I was struggling with during my development cycles.
Access Developers.. this is a must have!.......2005-01-20
When I started my job, my first assignment was develop several Access databases. What they wanted was beyond what I knew of Access. After buying this book and Access Database Programming and Design, I was well on my way to develop a quite advanced Access database application. I would ask myself, "I wonder if I can..." After consulting this book for the anwser, BAM! I found it there. This book covers everything from simple VBA to advanced techniques such as incorporating a email system into a database, linked dropdown combo boxes using SQL, and creating VB Form control that tells you who all is currently in a database using ADO and VBA! I would say anyone wanting to cook a mean Access database should definitely pick this one up. It is an invaluable reference if you want to develop professional Access databases with incredible functionality!
I'm a ColdFusion guy, so read this review with that in mind:.......2004-11-12
This book I would recommend for people who use Access as their back end, and need to add some automation to their back end. It deals mostly with using VBA to solve problems, like:
* How to create an input box where you can get some better info than the standard VBA one
* Call Excel functions, and apply them to Access data
* Figure out which users have a shared database open, if you're
doing a blended Access/CF solution
* Managing report printing (see next set of bullets)
I recommend checking out this book under the following circumstances:
* You have internal and external clients hitting your database. In a situation like that, you can have your internal users access the database using a well-designed Access application, which this book will give you some tricks on how to create.
* In the alternative, you want to manage and analyze your data, and create print reports. That's where Access just as a stand-alone application gives a substantial advantage over any Web technology.
For a ColdFusion developer, there are some topics in this book that probably wouldn't do much good:
* Adding Smart Tags functionality to a database - if you're expanding beyond the reach of Microsoft Office, Smart Tags prove to be a nifty proprietary parlor trick
* Using Access' security management tools to manage user rights to database objects. If I run a Windows server, I would use Challenge and Response to create NTFS based permissions on my pages in my application that manage data. Otherwise, I'll use application-based usernames and passwords, same net result.
* Exporting Access data as XML using pre-defined schemas. Not bad, but ColdFusion has far better technology.
Don't get me wrong - those last three bullets are not any disrespect to this well-written, well-organized guide. I'm just looking at, "What topics would interest you if you're a ColdFusion developer?"
If you do want to learn more about Access database development as an art unto itself, this is not the place to begin. This is the place to arrive at.
Unique resource for experienced access users.......2004-07-29
Those familiar with Access may not be familiar with O'Reilly's Cookbook series. The Cookbook series takes common tough problems and provides simple recipes, often with multiple alternative takes, to solve the problem. The value is not only in reference, it also shows you new techniques for using Access or VB is new ways that you may not have thought of.
I highly recommend this book for any experienced Access user, or anyone looking to become an Access expert. This book will stretch your skills and make it easier to nod your head yes when your boss asks you to solve some tricky problem.
Book Description
Microsoft SQL Server 2000 Unleashed, 2E offers a variety of topics for system and database administrators to help them learn new features of the product and to solve problems they face on a daily basis. It shows them how to build upon their working knowledge of the product and take their experience and knowledge to a higher level. This new edition of Microsoft SQL Server 2000 Unleashed covers the latest updates and service packs to SQL Server 2000, including full support for XML, notification services, and SQL Server CE.
Customer Reviews:
Brilliant resource.......2007-03-07
I purchased this guide based on previous recommendations and have to say that this book is extremely well done. I was put off at first by all the times the author said, "we'll cover that in detail later on in chapter number..." It broke the flow a bit, which is why I was tempted to give it only scored 4 instead of 5. However, to be fair, the enormity of what's being covered may be the reason for all the jumping around. Once you get past the first few hundred pages and into the heart of the book, that type of jumping slows down. I've learned so much and have made so many changes to my own SQL configurations as a result, I can't say enough good things about it. It also includes a PDF version on the CD, which is great both for reference and to keep your arms from getting tired holding it. ;-) Very highly recommended.
Very Complete.......2007-01-05
This book offers very complete coverage of SQL Server 2000. I recommend it to any DBA or SQL Developer who wants a handy all-in-one reference in addition to Books Online. This book includes a PDF version on the CD which is great for portability and I know many IT professionals nowadays aren't willing to buy a book unless an e-copy is included.
Big... but it reads like a novel!.......2006-05-21
Great book and easy to read! Author explain theory in basic terms and then, he give scripts or examples of how it should work or be written at TSQL level. Index's book it's almost perfect; for being a 1400 pages book it is not difficult to find any topic on it. You will find a lot of nice SQL 2000 tuning tips which add an extra value to the book itself. Could be used as a MCDBA prep. book and of course, in your job or if you're into Databases Admin. and Design business.
The SQL Administration part its my favorite. You will find how to use the GUI for create databases, tables and SQL administration tasks. This part covers almost all GUI and Enterprise Manager options, including backup methods and strategies.
Why not 5 stars?
SQL Internal part tends to be too much technical and difficult to read, IMO. It's Microsoft SQL 2000, i know, a very complex database engine, but more diagrams or explanations don't hurt on this part . If you're a newbie or have not much SQL fundamentals under your belt, you could get boring when you arrive to this. Cluster technology could be better and much more indepth also.
Fantastic book.......2006-03-01
I was suprised but the book is really good for both beginers as well as experts. I learned a lot from this book even thought I have been working with sql server for a long time.
Would definitely recomend to any level.
The best there is...ok so now i think Sams is better than Wrox...lol.......2005-10-29
Well I needed a crash course in SQL server management and some T-SQL.I attacked this book head-on. The book is very comprehensive and i am very amazed. It really is a complete guide to the GUI on SQL server. If you want some hard core T-SQL guidance then get another book...in addition. Sams teach yourself t-sql in 21 days is great.
So i am on my way to 70-228 and this awesome book has great chapters on every single knowlege set neccesary to ace this exam.
Book Description
Learn how to install, configure, and administer SQL Server 2000--as you prepare for MCP Exam 70-228, a core requirement for MCDBA certification and an elective for the MCSE and MCSA tracks.
Customer Reviews:
Pertfect e-commerce business.......2007-09-04
In just few words, you exceeded my expectations, in terms of quality of purchase, time for delivery, and follow-up you did excellent job.
Thank you
Good book for SQL 2000.......2007-01-16
I did not use this book to prep for an exam. Instead I used it for reference and it has been a good source of accurate information.
Not the best book in the world....but i would still keep it!.......2007-01-14
I used this book and went through all the 16 chapters.
This book could use some more review and additions from Microsoft. Accompanying CD barely did the job. Examples did help but limited.
You will have to use SQL BOL (Books On Line) to get the deep understanding of the subject.
Passed the test with 864 (86%). So i guess the book worked.
Not the winning exam study guide one would employ to segue into a winning sitting for Exam 70-228.......2006-05-31
I used this guide as part of my revision portfolio for Exam 70-228 (SS2K admininstration).
I got it despite the wonky caveat-type reviews because i wanted to get some specific exam lab-time in.
verdict:
Though, I applied myself to all 16 chapters as best one can with a single instance of SS2K (developer edition) running on a WinXP Pro OS laptop; It became clear to me that the quest was far from over, post the sun setting on the book.
-What i liked Re: d book (d upshot): chapters on Backup & Recovery Plus the chapter on Security , Plus the portable e-book version of d book included on the accompanying CD.
-What was more like passing-shot: the rest of book seemed just ho-hum, side-line material vis-a-vis the final exam paper questions
-what i did about it: I had to go away and button up specific topic holes/sections of knowledge via other references.
Book References: that helped: selected out were the following:
- SQL Server 2k Fast Answers: Sack ;ISBN: 1590595920
Value: Clustering , Failover clustering, Log Shipping,Security & sp_defaultdb, Cascading Updates + check constraints
- SS2k Performance Tuning & Optimization: Ken England: ISBN: 1555582419
Value: good for plugging holes Re:locks & transactions, monitoring performance & how to use System monitor & Interprete Sys Mon Counters ie: % Processor time, % Priviledge time, as well as Lock modes
- Inside SQl Server2K: ISBN: 0735609985
Value: handle on Conducting C2 Security-level Server audits + Understanding Affinity Masks + Performance Counters + RAID, Understanding Primary Domain Controllers, Data placement using filegroups, Full-text indexing + searching & catalogs, File and filegroup restores, Using Global temporary tables, Recovery models, Explicit & Implicit Tansactions & Triggers,Locking , Lock modes & Lock Granularity & Query Lock Hints, Lock Compatibility, Setting up Profiler Traces
- Professional SS2K Programming: Rob Viera:ISBN: 0764543792 Value: Practise Using DTS, Replication
- Beginning SS2K DBA : Bane and Sack ;ISBN: 159059293X (2 of my favorite authors)
Value: This is the book most beginning SS2K DBA's use (i especially like the 'try-it-out' feature peppered ,littered/implanted throughout). DML and Querying + Connectivity:Network libraries & Protocols, Security Replication, Backup & Recovery:Differential backups. How to Monitor+Profile+Tune
- Admin 911:SS2K ISBN:0072130970 Values:Backing up individual Files and File groups
However, if u dont have the time or the resources to check out these references in order to plug these exam-readiness holes up, then do this instead :
-Get a copy of Certification study guide for 70-228 from Test Killer a.k.a "troytec" (Version 3) ...google it
Value: This gets right to business & cuts right to the heart of the Exam ; u'll find only tire-meets-road stuff here, no fluff. its a ".pdf" document of 67 neatly put together pages, requiring u to only put down a Time-resource investment down-payment of 15 to 20 hrs of study time. its all packaged rather nicely for one.
use this, and your exam-topic revison will be concrete .
Bottom line: u'll get to read exactly what ur going to meet, see & get in the exam .
After the study guide, u have the basics of all u'll need. all u need now is just solid exam past question practice time .
Select the following:
- Transender 70-228, answer all 135 question; Here's the Important bit :( take care to read and understand the explanations where u go wrong)
- Testking 70-228, answer all 142, or 203 questions (get the most recent version u can find with question answers verified & mind the important bit as mentioned for Transcender.
- BrainDumps dot com's exam 70-228 slice : same as testking.
The only caveat in these various past question papers is that you need to ensure the responses have been verifed ( u may need to dip into one or two of those book references cited earlier in order to have a final authoritative stand/answer to 2 to 3 questions.
et voila! finish these properly and for sure, u are going to pass.
So, in summary, here's a recap of the formula that worked:
Starting Point:
Level :
0.) Books on Administring SS2K & then some Labs with some actual hands-on practise time in using the db application to carry out admin (u need to know your stuff)
Exam Review & Revision Practise (fast track):
Level:
1.) Study Guide : Test Killer -(troytec) Version 3.0 Study guide 70-228 (15-20 hrs)
2.) Past 70-228 Exam Questions practise: Transcenders, Testking,BrainDumps
3.) Take & Ace the exam with ease: 160minutes & 45 questions
Conclusion: your answers are weighted , so u need to choose wisely & correctly.
Otherwise, its very much like 70-229: in that you need to tackle question regarding problem scenarios in order to sharpen your wits about employing/selecting the right solution / strategy in any given problem scenario. this is the crunch of it. do that ,and u pass
End Of.
oh yeah, i sat the exam just yesterday ie:( Tuesday 30th May 2006); scored 94% ie: 948. The pass mark is 700 ie: 70%.
Good luck.
cheers :-)
Do not bother.......2005-09-07
This book is a joke. It is poorly written, the grammar is crazy and wrong, and it dwells too much on events that are not important (click next, and click next, then click ok, and then next...). You would be well-advised to read another book, as well as BOL, before attempting 70-228.
Waste of money!
Book Description
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.
ABOUT THE CD-ROM
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).
Customer Reviews:
Best reference guide for designing your SQL Server database.......2006-09-28
This guide not only provides references on SQL Server syntax, but also contains a brief review of best practices with database design. Includes all normal forms with database normalization, indexing, and data integrity.
Best IT Book I Ever Read.......2006-05-06
This book is an amazingly clear and concise book, especially for the "non-gurus" among us. The explanations of general topics like normalization, the history of markup languages (in the XML section) are so well written you could give them to management and even they would understand what you are doing (maybe that's not such a good idea). Full of tidbits like why transaction logs grow so much faster than data files. Nielson writes about SQL Server 2000 as used in the real world, not just as an interesting piece of technology. Bravo! I would give it 10 stars if I could. I leave nitpicking to the gurus.
Great for reading and as a reference guide.......2006-03-16
Very complete and illustrating. I am happy to have it on my desktop.
Very Good Book.......2006-03-14
This book is very good one, I learned a lot, ESPECIALLY about T-SQL, its sectioned in a good manner and the writer language is easy, the only negative point about the book is the briefness of explaination about (INDEXES) which i consider a very very important topic in the SQL in general.
Thanks a lot Mr. Neilsen
Very Good Book for SQL Server DBA.......2005-12-31
Currently I am preparing for the exam 70-229 and I studied a lot of SQL Server 2000 Books. But "SQL Server 2000 Bible" shows me the way to learn. It becomes a real bible for me. While I am reading this book I am able to understand what he is trying to say, but it's not happened in other books. I really appreciating his writing skills.
Customer Reviews:
SQL RS Beyond the basics (and some basics too).......2006-09-23
If you're a moderately skilled programmer, a self-learner, and you want to get beyond just "getting started" deploying and using Sql Server 2000 Reporting Services, this is the book for you.
I especially found the chapters on customized set up extremely helpful. The installation wizard doesn't offer a whole lot of options, and most of teh time you don't know fully how you want to configure it until you've tried it out. You'll get some good starters on rconfiguring your installation here.
You'll get enough basics to be ready to dive in, and then some tricks well enough beyond that to give you well on your way to devleoping customized solutions.
Excellent and surprisingly good........2006-03-24
For a total beginner (which I definately was) this is a FANTASTIC introduction to Reporting Services. Three months after starting my first job as a programmer straight out of University, and now I'm the main person in the firm with Reporting Services knowledge - and it's all thanks to this book.
The writing style is actually excellent for beginners, as I was terrified by the prospect of reading such a mammoth. But these guys make it fun and interesting to read (right down to the jokes and sidenotes) and really do touch on everything you need in a useful manner without boring you.
And excellent resource that now never leaves my desk. I can only hope these guys do a SQL Sever 2005 one. I cannot recommend this book enough for those starting on Reporting Services. It really is the book to read.
And if you are looking for a book on SQL Reportin 2005 - I would still recommend this book to give you the basics and introduction which is unbeatable thus far.
Good for developers.......2005-12-14
This book has been written from a VB programmers point of view. If you want to just start creating reports or if you're not a VB programmer (ie DBA etc) you may find this hard work.As another reviewer mentioned, you may find the authors' jokes and writing style to be a hit and miss affair.
Nevertheless, there is some depth on Reporting Services not to be found elsewhere that is quite handy.
Let's be realistic.......2005-10-15
Now that all the friends and family have promoted the book...
In order to understand something new, we all must relate that which we're learning to that which we already know.
Pete and Bill have a difficult time transitioning from campy comedians to thoughtful educators. To this extent, their writing style lacks any useful analogies whatsoever which might bridge the gap between the known and the unknown.
The book is full of droll and distracting fantasy references which are completely irrelevant to the subject matter, and are prone to taking the unsuspecting reader off task.
The potential purchaser should also be forewarned that the authors tend towards another immature trait of attempting to impress the reader with their linguistic abilities. Yet, to be effective at teaching they should have remembered to never use a complicated word where a simple one will do.
Many examples are rambling and inconcise, where step-by-step quickly degrades into an ambiguous and vague path.
Not every developer can obtain DOMAIN Authority in order to issue SSL certificates and it's too bad that the authors don't allow for this type of scenario, especially when a reporting system is on a VPN.
All of the content is there, but it's up to the reader to filter and translate most of it from the pitfalls aforementioned into something more to the center of the bell curve.
Good Book on Reporting services.......2005-10-02
I really the beginning part on the setup and installation of the reporting services themselves. At my firm we needed to set up a seperate server for this purpose and the IT group was swamped with another project and this helped a great deal. I still am workign on development but the book has been very usefula and easy to understand.
Book Description
Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days, 2E will clearly define and walk the reader through the features of SQL Server 2000. The reader will be given tips and tricks for working within the new SQL Server 2000 product environment as well as working with SQL Server databases. The book will feature information on:
- Create and alter databases.
- Manage security and implement permissions.
- Protect, backup, and restore data.
- Enforce and ensure data integrity.
- Modify and manipulate data.
- Create views, triggers, functions, and stored procedures.
Download Description
A beginning level tutorial for administrators and developers interested in learning SQL Server 2000. Written by Richard Waymire--the lead Project Manager for the Microsoft SQL Server group. Microsoft SQL Server is the fastest growing database. SQL Server 2000 improves the product with additional features that will help continue this rapid growth. Includes updated coverage of JDBC driver for SQL Server, security best practices, and SQLXML 3.0. Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days, Second Edition clearly defines and walks the reader through the features of SQL Server 2000. The reader is given tips and tricks for working within the new SQL Server 2000 product environment as well as working with SQL Server databases. The book will help the reader learn to: create and alter databases, manage security and implement permissions, protect, back-up and restore data, enforce and ensure data integrity, modify and manipulate data, and create views, triggers, functions, and stored procedures. Richard Waymire is a Program Manager with the SQL Server development team at Microsoft. He is also a Microsoft Certified Trainer (MCT), Solution Developer (MCSD), Database Administrator (MCDBA), and Systems Engineer + Internet (MCSE). He is a past president of the Pacific Northwest SQL Server User's Group. Rick Sawtell is both a Microsoft Certified Solutions Developer (MCSD) as well as a Microsoft Certified Trainer (MCT). He owns his own consulting firm and writes and trains on several Microsoft products.
Customer Reviews:
No peer........2005-08-14
I use(d) this book as the basis towards my WIN2K MCDBA...It is superior to anything out there including Microsoft's Official MCSE [Exam 70-228] SQL Server 2000 SA Training Kit... includes everything one needs assuming one immerses oneself in the book from Day 1 through Day 21 in addition to Day 22 (SQL Server Analysis Services (OLAP)) and Day 23 (English Query).It is both a superior reference book and programmer's guide. After purchasing Microsoft's official references I found myself repeatedly (frustrated by their shortcomings and referring back to this particular SAMS text). Enough cannot be said about this book.
I liked the book.......2005-06-22
The book was ok. It has taught me a lot. However, it is not without its easily seen errors.
1) Some concepts are not expounded on to make sure a newcomer or complete idiot thoroughly understands what is said. Some sentences can be so concise that it can cause you to take a word for granted (if you aren't paying extra attention) which could lead to complete confusion. thus, if there are no supporting sentences you can be completely lost. It also uses terms without explaining them or maybe expects you to know terms that a newcomer would not know. Some concepts are just not explained clearly period.
2) Some of the exercises use obsolete code. It is as if the person who wrote the chapter didn't write the exercise.
So if you need a book. Yes, buy this book. Hearing the negative comments can distract but at the same time only good comments can cause a person to wonder if something is wrong with him. The book DOES have errors! Point Blank! Some are very noticeable. Few are frustrating. My most frustrating experience so far has been chapter 5. I had to read ch 6 to understand 5 better. But you will learn a lot and the book's exercises do a good job in making sure you understand what was covered. My point is only that if something seems strange like the exercises on chapter 5 (also the exact same, word for word as exercises for ch 6, probably a mistake) it is probably the book and not you. The answers for chap 5 exercises are indeed obsolete (question 1 anyway).
Overall, the book makes learning this stuff very easy.
GREAT Book.......2005-05-26
I have a LOT of access experience and wanted to move to SQL Server.
This is a great beginner book for those with a little knowledge of SQL and a lot of knowledge of relational databases.
Great chapters on SQL usage.
GET THIS BOOK!!
Excellent exam prep.......2005-05-22
I found this book excellent prep for the MCP exam (70-229). The discussions on deadlocks, indexing, transactions, and security (specifically, application roles and ownership chains) were definitely the difference in my passing the exam.
The authors do a very good job of explaining WHY you would want to do something, not just HOW.
The only negative thing for me was the frequent references to how things used to work in SQL 7.0, 6.5 and earlier.
A very good book if you're the right audience.......2004-10-29
This is a very good book for the newcomer to SQL Server, particularly for those who have little experience with other databases.
It addresses various topics that are just enough to get you started on being able to get some work done with SQL Server and know what else you need to learn. Strange as it may sound, IMHO, discovering what you don't know is a valuable endeavour. Sure, it could've gone into a lot more detail on the query optimizer or how lock escalation really works, etc... but really, where do you draw the line? There's no good place that will please everyone. This book did a decent job.
This is not the book to make you an expert. In fact, it won't even make you an "intermediate" if there's such a state. It introduces enough to get you going. If you find yourself asking "well, what about this?" or "ok, you showed one way to use stored procedures, what if I wanted to ....", then the book has done a good job. If you have no questions or don't know what to ask, then it's failed.
As for the readers/reviewers who slammed the book for not making them experts, really, what were you expecting? You won't even know the ins and outs of installing Oracle or DB2 in 21 days much less get into any useful state (I've been an Oracle DBA for 7 years and DB2 for about 2 years, I know a thing or two about them).
If you are an experienced database administrator or developer on another database, this book is probably kinda slow for you and certainly will not contain the depth that you're probably seeking. For this audience, I'd recommend Inside SQL Server by Kalen Delaney. It's not all there but it's a great start.
Average customer rating:
- Works for getting the basics and cert prep
- Simply badly designed for exams
- This Won't Prepare You For 70-229 But a Good Starting Point.
- Book for SQL novice
- Microsoft Blew it - Again
|
MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 Database Design and Implementation, Exam 70-229, Second Edition
Microsoft Corporation , and
Microsoft Corporation
Manufacturer: Microsoft Press
ProductGroup: Book
Binding: Hardcover
 MCSE
| Exams
| Certification Central
| Computers & Internet
| Subjects
| Books
Microsoft Press
| Publisher
| Certification Central
| Computers & Internet
| Subjects
| Books
MS SQL Server
| Certification Central
| Computers & Internet
| Subjects
| Books
General
| Certification Central
| Computers & Internet
| Subjects
| Books
Relational Databases
| Databases
| Computers & Internet
| Subjects
| Books
General
| SQL
| Databases
| Computers & Internet
| Subjects
| Books
Database Design
| 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
| Computers & Internet
| Subjects
| Books
Look Inside Computer Books
| Trip
| Specialty Stores
| Books
All Titles
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Computers & Internet
| Qualifying Textbooks - Fall 2007
| Stores
| Books
Similar Items:
-
MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 System Administration, 70-228, Second Edition
-
MCAD/MCSD Self-Paced Training Kit: Microsoft (2nd Edition) .NET Core Requirements, Exams 70-305, 70-315, 70-306, 70-316, 70-310, 70-320, and 70-300 box vol. set
-
MCAD/MCSD Self-Paced Training Kit: Developing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual C# .NET, Second Edition
-
MCAD/MCSD Self-Paced Training Kit: Developing Windows-Based Applications with Microsoft Visual Basic.NET and Microsoft Visual C#.NET, Second Edition
-
Microsoft ADO.NET Step by Step
ASIN: 0735619603 |
Product Description
Learn how to deliver powerful database solutions - and prepare for MCP Exam 70-229 - with this official Microsoft study guide. Exam 70-229 is an elective for MCSE/MCSA certification and a core exam on the MCDBA track. Build your expertise designing and im
Customer Reviews:
Works for getting the basics and cert prep.......2007-06-10
Not being interested in certification, I was looking for something that would get me the basics, and tell me where to go to get the meat. This book is doing that. Includes a MS SQL Server 2000 120 day use installation disk. The install includes the "Books On Line" (a source of a lot of meat).
Not caring if this is good for cert test prep, and having never taken a cert test, I can't tell you if it is a good prep. It hase provided a good portion of the information I was looking for, and helped me understand the changes / inhancements in MS SQL 2005.
4 stars because I am seldom overwhelmed with something.
Simply badly designed for exams.......2006-05-22
I believe that the writers made some bad choices when they first began to write this book. First of all, unlike most other certification books the exam goals are not together in one section. Instead there are whole chapters for queries, indexes, views, etc with all of the information about each topic in that chapter. So if you wanted to read about 'query optimization' you would have to read the sections within that chapter about query optimation from the queries chapter, from the index chapter, some from the views chapter, etc. So if you want to review a specific topic that you are not as good at you will be doing a lot of page flipping.
Second the book is too thick. It contains a lot of information that i doudt that you will actually get on the exam (like estimating the size of a table). It also has about a 100-150 page objective by objective index at the back with questions. But these sections seem to be fragmented from the rest of the book and do not have enough information to truely learn the objective. The first part of the book seems to be written as an introduction to databases book rather then a certification book, and i dont think that i would use this book to introduce myself to databases anyway.
Third: the practice certification exam does not work. The practice exam is an exam that seems to have an embeded internet explorer and is ran by javascript. I have no clue why you would use javascript to create a practice exam. Anyway i get the 'error running these scripts, would you like to continue running scripts on this page error' and i am unable to run the exam. I am using windows xp service pack 2 internet explorer 6.1.
I personally went out and bought the exam cram for 229 and it seems to be much better.
This Won't Prepare You For 70-229 But a Good Starting Point........2005-05-17
This book is a very easy read, explains concepts clearly, but lacks the kind of detail necessary for passing the 70-229 exam, especially if you are taking this as an elective on the developer track. It will get you through most of what you need to know at 10,000 feet, but it will not take you to a passing score. It taught me things I had never used and for that it is well worth the time investment. I also love the fact that you can install the "e-book" on a laptop and a desktop at home and never carry the hard cover book around.
I had been using SQL Server 2000 for years and thought this would be a snap for me. After reading this book I thought I was ready for the test. On the practice exam I saw words that were used that I had no idea what the context was. Those functions are not discussed in this book but you can trust they will be covered completely on the test! You will thoroughly need to know things like triggers, functions and constraints, and all their possible parameters, or you will not be prepared for the exam.
After going through the book you will be ready for the material that is available at the practice test vendors Microsoft recommends at the Microsoft Web sites for MCAD & MCSD Certification. I am not trying to promote any company and I have nothing to gain by saying the following: The study guide I purchased for about the cost of this book prepared me for the exam. This book prepared me for the study guide.
Book for SQL novice.......2005-04-17
This book is good for a person whom does not know any thing about SQL and Database Designing. If you are an Experience whom trying to get ready for the exam. then save your money and look for different one. This book will just wast your time.
Microsoft Blew it - Again.......2005-03-22
This book is so full of ommissions and errors that it is virtually usless as a tutorial or reference.
Book Description
Learn from a SQL Server performance authority how to make your database run at lightning speed.
Ken England's SQL Server 6.5 Performance Optimization and Tuning Handbook is recognized by SQL Server administrators as the indispensable guide to tuning and optimization. Now he's revised the book for Microsoft's new SQL Server 2000, the most advanced and powerful version yet of SQL Server, which takes full advantage of Windows 2000's new processing capabilities. The book details the factors that determine database performance and offers readers tools, techniques and best practices they can use to tweak and tune SQL Server's configuration and operation. Readers will learn how to enhance performance through good physical design and effective internal storage structures. The book spells out methods for creating efficient indexes and techniques for tuning SQL Server's new query optimizer.
A new edition of the authoritative and bestselling guide, SQL Server 6.5 Performance Optimization and Tuning Handbook, 1555581803Targets SQL Server 2000Helps IT professionals run SQL Server more powerfully and efficiently and optimize it for e-commerce and knowledge management
Customer Reviews:
Outstanding Reference Book.......2007-02-09
I have been a DBA for a bunch of small sites for many years. Recently I committed to a job w/ a large, online OLTP retailer and needed to fine tune my knowledge of the SQL Server engine.
I was shocked at just how flawed/lacking my knowledge was after reading this book.
Let me first state this sucker isn't for people looking to get by using the Enterprise Manger GUI. This book dissects the inner most workings of the db engine and it's under lying theory. Their is a lot of TSQL. I found myself limited to reading only a small number of pages at a time and then needing a break. The book is that intense and I have a Masters of Science degree as well as MCDBA and MCITP certifications.
Probably my favorite feature of the book is its small size, under 400 pages from tip to tail. I'd suggest this book to anyone wanting an understanding of what they are actually doing in SQL Server when they issue commands from EM. This book should be a requirement for any DBA or DB Designer in my opinion.
SQL best practices bible.......2007-01-10
I have been working with SQL for several years and always felt a bit weak in my understanding of best practices. I have only absorbed a few chapters so far on index structure and execution plans but already I feel like I have fast tracked into the clever peoples class. The layout is excellent and the language unambigous.
Best overall for SQL Server Tuning.......2006-08-02
I am a SQL Server performance consultant to many large corporations and government agencies. I have read and re-read this book so many times I should know it by heart. Still, I carry it with me on consulting engagements everywhere I go. There is almost always someone at my client's site who wants to improve their performance tuning skills. I show them the book and tell them this is where you start.
I don't know if there will be a version specifically for 2005, but it really doesn't matter much. The central concepts of the book have not changed for SQL Server 2005.
Ken England's writing style is clean and lucid. He can explain complex issues in a remarkably understandable way. His explanation of indexes and strategies of indexing is a great example of readable technical writing. He also has a good understanding of what is important and what is not.
This book is accessible to anyone who has some experience with SQL Server or any relational database. Someone with little experience may not get it all in one pass, but they will be much better prepared for real-world SQL Server performance tuning.
Best book on performance tuning.......2005-09-26
This is the best book ever written on performance tuning. Excellent text and very well written too. Thanks a lot.
This book rocks!!.......2005-08-30
This book is like a SQL SERVER 2000 bible for me. It has the most wonderful information in it, clear and easy to understand. I needed to interview for a job and I looked to this book for clarity and knowledge and boy was I enlightened. A must read for a beginner DBA like myself!!!!!
Book Description
Microsoft SQL Server 2000 DBA Survival Guide is organized into several parts that comprise the various jobs and tasks the DBA performs. Each chapter is presented with the goal of providing knowledge and "know-how" to Database Administrators of a SQL Server database. The chapters also offer real-world insight and experience by passing on tips, tricks, and suggestions based on what the authors have learned the hard way. The book also takes time to provide checklists and examples for various SQL Server DBA tasks. The book also provides insight into the tasks that make-up a DBA's job including discussions of topics such as the creation of naming standards and conventions which are essential for efficient administration.
Download Description
Microsoft SQL Server 2000 DBA Survival Guide is organized into several parts that comprise the various jobs and tasks the DBA performs. Each chapter is presented with the goal of providing knowledge and "know-how" to Database Administrators of a SQL Server database. The chapters also offer real-world insight and experience by passing on tips, tricks, and suggestions based on what the authors have learned the hard way. The book also takes time to provide checklists and examples for various SQL Server DBA tasks. The book also provides insight into the tasks that make-up a DBA's job including discussions of topics such as the creation of naming standards and conventions which are essential for efficient administration.
Customer Reviews:
I still hgave not got the book yet........2007-09-17
I still have not get the book yet. Please let me know how to get it.
Good for Beginers.......2007-04-04
I read a lot on SQL Forum about this book. I am new to SQL Server 2000. So i took a chance to buy and put some of my energy into it. I am still in process of reading this book. But what i have learnt upto this point is really a big help in understanding what is SQL Server 2000 and its administration capabilities.
Have a good luck !!
Great for new DBA's.......2004-12-10
I bought this book upcoming becoming a SQL Server DBA. I had three years programming experience which included T-SQL, however, NO DBA experience! It provided excellent explanations of DBA tasks, especially the all important database backups and restorations. I did not require any other book resources. I highly recommend it for those entering the DBA field.
Side note: I only used this book for industry experience and have not used it towards an attempt at MCDBA certification. I have since read the MCSE SQL Server 2000 Administration Guide for Dummies and found the SQL Server 2000 DBA Survival Guide to provide more detail on certain subjects.
New to SQL 2K...........2003-07-15
I bought this book as a companion to my exam prep reading for Microsoft's SQL Admin exam. I only had 6 months of working with SQL2K when I started to read and study. This book gave great clarification on otherwise vague material. The detail was easy to understand on all levels. I have now been working with SQL 2K for 2 years and still go to my survival guide for reference daily. Also- it's on it's 2nd edition- How many tech books last long enough to go to a 2nd edition?!
Source code no longer available.......2003-07-07
I bought this book as it had spelt out a solution in the text and reffered to the source code suppossedly online. Tried witht eh publisher for many weeks to get the source code as promised to no avail. A good overview, but no real depth.
Books:
- Microsoft Visual Basic 6.0: Deluxe Learning
- Microsoft Windows XP Step by Step (With CD-ROM)
- Modern Operating Systems (2nd Edition)
- Network+ Exam Prep 2 (Exam Prep N10-003) (Exam Cram 2)
- Object-Oriented Thought Process, The (2nd Edition) (Developer's Library)
- PMP: Project Management Professional Study Guide, 3rd Edition
- Practical Guidelines and Best Practices for Microsoft Visual Basic and Visual C# Developers (Pro-Developer)
- Practical Switching Power Supply Design (Academic Press Professional and Technical Series)
- Pro .NET 2.0 Windows Forms and Custom Controls in C#
- Pro .NET 2.0 Windows Forms and Custom Controls in C#
Books Index
Books Home
Recommended Books
- Communication Networks: A First Course
- Van Halen-The Ultimate Song Pages
- Original Pronouncements 1996/97: Accounting Standards As of June 1, 1996
- Stewart Granger
- The McGraw-Hill 36-Hour Course In Finance for Non-Financial Managers
- Tropical Houses: Living in Nature in Jamaica, Sri Lanka, Java, Bali, and the Coasts of Mexico and Be
- The Rose That Grew From Concrete
- 2003-2004 Pia Ratios Web Offset Printers, Heatset
- Success on Our Own Terms: Tales of Extraordinary, Ordinary Business Women
- The Richest Family in the World: Family Secrets
Microsoft SQL Server 2000(TM) Performance Tuning Technical Reference (Pro-Technical Refere)
Inside Microsoft SQL Server 2000 (With CD-ROM)
Microsoft SQL Server 2000 Administrator's Companion (With CD-ROM)
Microsoft SQL Server 2000 High Availability
SQL Server Security Distilled, Second Edition
