 See larger picture | Microsoft SQL Server(TM) 2000 Administrator's Pocket Consultant (It-Administrator's Pocket Consultant)
by
William R. Stanek
- Microsoft PressList Price: $29.99
Price at Amazon.com: $22.79
(Save
24%)
 Availability: In stock soon. Order now to get in line. First come, first served.
Shipping rates and policies |
- Average Customer Review:
Based on
16
reviews.
- Amazon.com Sales Rank: 558223
|
Product Description "Microsoft SQL Server 2000 Administrator's Pocket Consultant" is the hands-on, immediate reference you need as you deal with the details of Microsoft SQL Server administration in small, medium, and large organizations. Ideal at the desk or on the go from server to server, this fast-answers guide focuses on what you need to do in specific situations as you support and manage Microsoft SQL Server 2000. Topics covered include SQL basics, administration tools, configuring and tuning, managing the enterprise, database administration, security, backup and recovery, importing and exporting data, data replication, monitoring and profiling, creating tables and indexes, automation and maintenance, and more.If specialization is for insects, those of us who have only two legs are bound to need reminders when we sit down to perform a specialized task. For those times in which the specialized task at hand involves the latest version of Microsoft's high-end database management system (DBMS), Microsoft SQL Server 2000 Administrator's Pocket Consultant will provide how-to answers on the double-quick. This small, inch-thick volume fits nicely into a briefcase, and opens flat for easy reference. It makes little attempt to explain how SQL Server works, assuming instead that the reader knows what he or she needs. For example, a quick scan of the index for "Logins, Assigning Roles for Multiple" yields a reference to a page that explains exactly what to do, step by step. Procedures are a large part of the appeal of this book; value tables and Transact-SQL syntax documentation contribute the rest. A typical value table lists all standard database roles, along with commentary on what sort of user is appropriate for each role. Transact-SQL documentation includes generic "all available options" statements of syntax, followed by usage examples. Deeper explanations of what each option does would make the syntax documentation stronger, but what's here is certainly enough to jog readers' memories and point them to heavier reference material, if they need it. Keep this book handy if your job requires you to hop from DBMS to DBMS. --David Wall Topics covered: - Installing and configuring Microsoft SQL Server 2000
- Creating databases
- Controlling access to databases
- Manipulating database contents with Transact-SQL
- Backup, recovery, and performance tuning
- Data Transformation Services (DTS)
Featured Customer Reviews  Great if you are a DBA,
May 30, 2007
Although I've been working in SQL since 6.5 this book still comes in handy when I need to do something that I haven't done in awhile or need to confirm something.
 Good Book,
March 14, 2007Concise reference manual,
January 25, 2005 This good and concise sqlserver administration reference manual has a complete online version on microsoft.com/technet.Best for administration,
September 02, 2004 I haven't found a better book for sql admins. This book is extremely informative. I worked for a year with SQL 7 and have been studying and working with SQL Server 2000 for a year and a half. I passed Exam 70-228 in large part due to what I learned from this book. If you are looking for a how-to book that shows just exactly how to accomplish tasks associated with creating and maintaining SQL 2000 this book is for you. This is an excellent book if you want to understand how SQL Server 2000 works as well. Great Book,
August 17, 2004 A lot of SQL Server books give you the same information included already in Books Online. SQL Server 2000 Administrator's Pocket Consultant is an excellent complement for Books Online, TechNet and MSDN. It covers similar topics, but it digs in where necessary, provides best practices, tips to the internal operations, explaining how SQL Server actually works, with unique information only available in this book.
I always want to know how things work because it helps me to understand the behaviour of a system. In many cases if you don't know how things work it could drive you to some misunderstandings. Here is where SQL Server Pocket Consultant helps out and Stanek has excellent teaching skills.
The book is very compact and full of information. It's all in the details. Chapter 2 "Configuring and Tuning" is a real gem. It helped so much with server and database tuning. Chapter 5 "SQL Server Security" is excellent on the security details. Chapter 7 provides deep detail of DTS and BCP. The final part of the book is the best, in my opinion. It covers performance, maintenance and optimization.
The book's small size makes it easy to take with you where ever you go and its good enough that you'll want to. Overall excellent guide ot sql server.
You might also be interested in these items...
|
|