Not Quite Complete

Missing T-SQL coverage mars an otherwise thorough reference


While preparing to take my SQL 2000 exams, I was looking for an all-in-one book that would or could help me on this quest. Based on the cover of the book, I thought I had found what I was looking for. It claimed to have complete coverage of all material on both exams, 70-228 and 70-229.

First of all, let me say that the book does indeed provide information on all exam objectives. There is sufficient coverage to give you a good grounding in SQL Server 2000 Administrative and Design aspects. There was a contradiction, however, in what the book cover stated and what the author stated in the book. In order to pass the Designing exam and, indeed, the Administration exam, you need to be well versed in Transact-SQL, which is the SQL dialect used by Microsoft's SQL Server products. The author states that this book does not cover T-SQL in depth and that you will need to look elsewhere for in-depth SQL knowledge.

I can tell you that I did indeed pass both exams on the first try. This book was an excellent source of information for the exam, if only because it compliments the other two required factors for exam success: hands-on and test practice. With the use of the exam tips, the hands-on exercises, as well as the help of some practice tests—both in the book and those you'd have to acquire from third parties—you should be able to pass the SQL exams. Nothing beats hands on experience with any product to get a feel for it.

There are areas on the exams that require you to have a firm understanding of the concepts of the software and its use that no book can give you. The author, Dave Perkovich, brings his experiences to the book and provides good tips and pointers throughout the text to relevant topics as they relate to the exam. The fact that he is an MCSD and MCT I feel has only helped the book to be more complete as each certification provides its own advantages to a project such as this.

Writing a book to cover an entire product such as SQL Server 2000, especially for exam preparation, is no easy task. I have used books from various publishers and authors as well as books written specifically for Microsoft Press that are indicated as being Microsoft Approved Study Guides. Some do not even come close to preparing you for an exam. Somehow they always leave your short.

There are really only two issues that really stand out for me in this book that need to be looked at if there is to be a second edition or second printing. First: Gather some more technical reviewers and proofreaders to clean up some minors errors in the text. Second: Either add more T-SQL content or remove the reference that the book contains "complete coverage." Other than these two points, I'd recommend this book to anyone looking for an all-in-one study guide for the SQL 2000 exams. Hey, I passed them; you can too!

About the Author

Gerry O'Brien, MCSE, MCSD, MCDBA, MCT, has been working with computers since the days of the Commodore VIC-20. Over the past five years he's done network administration for The Hardman Group Ltd., a real estate management/development company, and owns Canadian-Based GK ComputerConsulting, which provides hardware and software sales, consulting, and development services to a wide range of clients.

Featured

  • Microsoft Appoints Althoff as New CEO for Commercial Business

    Microsoft CEO and chairman Satya Nadella on Wednesday announced the promotion of Judson Althoff to CEO of the company's commercial business, presenting the move as a response to the dramatic industrywide shifts caused by AI.

  • Broadcom Revamps VMware Partner Program Again

    Broadcom recently announced a significant update regarding its VMware Cloud Service Provider (VCSP) program, coinciding with the release of VMware Cloud Foundation (VCF) 9.0, a key component in Broadcom’s private cloud strategy.

  • Closeup of the new Copilot keyboard key

    Microsoft Updates Copilot To Add Context-Sensitive Agents to Teams, SharePoint

    Microsoft has rolled out a new public preview for collaborative "always on" agents in Microsoft 365 Copilot, bringing enhanced, context-aware tools into Teams channels, meetings, SharePoint sites, Planner workstreams and Viva Engage communities.

  • Windows 365 Cloud Apps Now Available for Public Preview

    Microsoft announced this week that Windows 365 Cloud Apps are now available for public preview. This aims to allow IT administrators to stream individual Windows applications from the cloud, removing the need to assign Cloud PCs to every user.