- Paperback: 480 pages
- Publisher: Microsoft Press; 1 edition (27 Oct 2000)
- Language English
- ISBN-10: 0735611297
- ISBN-13: 978-0735611290
- Product Dimensions: 20.3 x 14.2 x 3.3 cm
- Average Customer Review: 4.7 out of 5 stars See all reviews (3 customer reviews)
- Amazon Bestsellers Rank: 898,885 in Books (See Top 100 in Books)
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Plus, get an extra £5 Gift Certificate when you trade in books worth £10 or more before June 30, 2012. Visit the Books Trade-In Store for more details. |
|
There is a newer edition of this item:
|
Product details |
More About the Authors
Discover books, learn about writers, and more.
Product Description
Amazon.co.uk Review
If specialisation is for insects, those of us with only two legs are bound to need reminders when we sit down to perform a specialised task. For times when the specialised task at hand involves the latest version of Microsoft's high-end database management system (DBMS), Microsoft SQL Server 2000 Administrator's Pocket Consultant provides 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, instead assuming 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 big 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)
Product Description
MICROSOFT® SQL SERVER™ 2000 ADMINISTRATOR’S POCKET CONSULTANT is the ideal concise, immediate reference you’ll want with you at all times as you deal with the details of Microsoft SQL Server 2000 database administration. Whether you handle administration for 50 users or 5000, this hands-on, fast-answers guide focuses on what you need to do to get the job done quickly.
With extensive easy-to-read tables, lists, and step-by-step instructions, it’s the portable, readable guide that will consistently save you time and minimize system downtime by giving you the right information right now.
This hands-on guide gives you the fast answers you need to:
- Grasp the fundamentals. Understand the SQL Server 2000 architecture; learn administration tools, techniques, and concepts; and discover how to modify configuration settings to optimize memory usage, take advantage of parallel processors, and more.
- Complete core tasks. Perform basic tasks to create and manage databases, servers, and server groups; and create logons, configure logon permissions, assign roles, and conduct other essential security measures.
- Administer databases. Manage tables, indexes, and views; query and manipulate data; import and export data; and integrate SQL Server data with other data sources.
- Control distributed data. Administer linked servers and distributed transactions, configure data merging and replication, and supervise data publication and subscription.
- Optimize and maintain databases. Profile and monitor SQL Server, conduct data backup and recovery, and take charge of automation and maintenance.
Inside This Book
(Learn More)
First Sentence
As you get started with Microsoft SQL Server 2000, you should concentrate on these areas: How SQL Server 2000 works with your hardware Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
As you get started with Microsoft SQL Server 2000, you should concentrate on these areas: How SQL Server 2000 works with your hardware Read the first page
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Reviews
Most Helpful Customer Reviews
3 of 3 people found the following review helpful
Format:Paperback
This book gives simple straightforward answers to commonly encountered questions, and I find I use often. Although most of the information could also be found in Books Online, Stanek presents it in a more user-friendly format. Particularly useful are the detailed step-by-step instructions: how to rename a database (5 steps), how to create a maintenance plan for log shipping (29 steps), etc.. He covers T-SQL commands as well as Enterprise Manager methods.
Obviously, when working though any of these processes, you will want to have the book open on your desk. Unfortunately, that is not possible. The publishers have chosen to bind it with a glued spine rather than a proper sewn spine, with the result that the book will not stay open. In fact, it's difficult to part the covers more than 90 degrees at all, and if you force it open then the binding will break and the pages fall out.
The index seems comprehensive, the text is well laid out, and I haven't discovered any errors. Despite the apalling binding, it's worth having.
2 of 2 people found the following review helpful
Format:Paperback
I have been developing with MSSQL Server for a number of years. This is the best reference book I have read so far.
I think what separates this book from the rest is that it is built on wisdom rather than simple knowledge.
When administrating any system, the questions you need to ask can be as important as the answers. This book helps ask the right questions. For example, Chapter 11 helps to create a backup and recovery plan and encourages the reader to think about the data importance and the infrastructure as well as recommending best practice.
I believe any SQL Server Administrator will become more valuable to their company, if they apply the principles of this book.
My only criticism is it is slightly too big to fit in my pocket. However, there is nothing you'd want to take out of this book.
I think what separates this book from the rest is that it is built on wisdom rather than simple knowledge.
When administrating any system, the questions you need to ask can be as important as the answers. This book helps ask the right questions. For example, Chapter 11 helps to create a backup and recovery plan and encourages the reader to think about the data importance and the infrastructure as well as recommending best practice.
I believe any SQL Server Administrator will become more valuable to their company, if they apply the principles of this book.
My only criticism is it is slightly too big to fit in my pocket. However, there is nothing you'd want to take out of this book.
8 of 11 people found the following review helpful
Format:Paperback
For the working database developer, this is probably all you need. It is terse, and covers all the essential points.
Would you like to see more reviews about this item?
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
- Books > Computing & Internet > Databases > Applications > Microsoft SQL Server
- Books > Computing & Internet > Databases > Applications > SQL > Microsoft SQL Server
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > Database Theory
- Books > Computing & Internet > Networking & Security > Network Topics > Microsoft Windows
- Books > Computing & Internet > Programming > Languages > C & C++
- Books > Computing & Internet > Web Development > Web-server Software > Microsoft
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
