- Paperback: 550 pages
- Publisher: MICROSOFT PRESS; 1 edition (1 Nov 2005)
- Language English
- ISBN-10: 8120329201
- ISBN-13: 978-0735621077
- ASIN: 0735621071
- Product Dimensions: 20.4 x 14.4 x 3.6 cm
- Average Customer Review: 4.5 out of 5 stars See all reviews (2 customer reviews)
-
Amazon Bestsellers Rank:
350,409 in Books (See Top 100 in Books)
- #69 in Books > Computers & Internet > Computer Science > Databases > Data Storage & Management > Data Warehousing
- #95 in Books > Computers & Internet > Computer Science > Databases > Applications > Microsoft SQL Server
- See Complete Table of Contents
Microsoft® SQL ServerTM 2005 Administrators Pocket Consul...
and over one million other books are available for Amazon Kindle .
Learn more
| |||||||||||||||
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. |
Product details |
More About the Author
Product Description
Product Description
Portable and precise, this pocket-sized guide delivers immediate answers for the day-to-day administration of SQL Server 2005. Zero in on core support and maintenance tasks using quick-reference tables, instructions, and lists. You’ll get the precise information you need to solve problems and get the job done whether you’re at your desk or in the field!
Get fast facts to:
- Install, configure, and tune SQL Server
- Administer servers and server groups
- Manage and optimize schemas, tables, indexes, and views
- Create logins, configure permissions, assign roles, and perform other essential security tasks
- Import, export, and transform data from various sources
- Implement replication and data merging, and manage data publication and subscription
- Plan and implement a comprehensive backup and recovery strategy
- Monitor server activity and resolve performance issues
- Take charge of automation and maintenance
About the Author
William R. Stanek is a Microsoft MVP with 20+ years of experience in systems management and advanced programming. He is an award-winning author who’s written more than 100 books, including Windows 7 Administrator’s Pocket Consultant and Windows Server 2008 Inside Out. He is the series editor for the Pocket Consultant line of books.
Inside This Book
(Learn More)
First Sentence
Microsoft SQL Server 2005 completely redefines the SQL Server database platform and provides the bedrock foundation on which small, medium, and large organizations can build their next generation IT infrastructure. Read the first page
Front Cover | Copyright | Table of Contents | Excerpt | Index
Microsoft SQL Server 2005 completely redefines the SQL Server database platform and provides the bedrock foundation on which small, medium, and large organizations can build their next generation IT infrastructure. Read the first page
Explore More
Concordance
Browse Sample PagesConcordance
Front Cover | Copyright | Table of Contents | Excerpt | Index
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
19 of 19 people found the following review helpful
Format:Paperback
Administering SQL 2005 is quite different to previous versions of SQL Server this books provides a very useful overview of the new graphical administration programs. A great resource for anyone that is new to SQL 2005 or wishes to migrate from previous versions.
The book very readable and I especially like the side notes, which come in Note, Tip, Caution, Real World and Best Practice forms. These give very useful practical information, which will help you avoid some the common problems that get posted to newsgroups.
Format:Paperback
If you know a SQL Server DBA chances are they have a dog-eared copy of Stanek's book somewhere.
It's small enough to fit into a briefcase, but has enough content on SQL Server administration to make it the must-have reference for many of the common tasks a DBA has to cope with on a day to day basis.
Not the kind of thing you're going to read from cover to cover, but you'll always want to keep it within arm's reach, to dip into as and when you need it.
It's small enough to fit into a briefcase, but has enough content on SQL Server administration to make it the must-have reference for many of the common tasks a DBA has to cope with on a day to day basis.
Not the kind of thing you're going to read from cover to cover, but you'll always want to keep it within arm's reach, to dip into as and when you need it.
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
15 reviews
25 of 25 people found the following review helpful
THE ONE SQL SERVER BOOK EVERYONE SHOULD HAVE
22 May 2006
Format:Paperback
I picked up Stanek's SQL Server 2005 Administrator's Pocket Consultant and Windows Server 2003 Inside Out at the same time, and have found them both to be excellent. If there's one SQL Server book every developer, programmer and administrator should have, it's this one--I haven't found a better one and I've read half a dozen so far. Stanek has a gift for getting to the point, explaining the most complex concepts in ways that are easy to understand. He seems to pack a 1,000 pages of info into 550 pages. SQL Server 2005 Administrator's Pocket Consultant has a strong focus on security, configuration, optimization, and troubleshooting. Throughout the book, there's excellent coverage of T-SQL and I prefer the way T-SQL is covered in context in this book to the way it's covered in the separate T-SQL book I bought (and no longer use). Beyond core database administration, which this book covers better than any other book, it also covers full-text search, indexes, integration services (creating packages), linked servers, distributed transactions, replication, publications, etc. The maintenance chapters are some of the strongest with complete coverage of profiling, monitoring, optimizing, backup, recovery, log shipping, database mirroring, automation, etc. Thank you Mr. Stanek for an excellent book.
22 of 23 people found the following review helpful
Microsoft SQL Server 2005 Administrator's Pocket Consultant
31 Jan 2006
Format:Paperback
With a new set of tools, Administering SQL 2005 is quite different to previous versions this book provides a very useful overview of the new graphical administration programs, as well as detailing many of the commonly used administration stored procedures.
The book is very readable and I especially like the side notes, which come in Note, Tip, Caution, Real World and Best Practice forms. These give very useful practical information, which will help you avoid some the common problems that get posted to online newsgroups.
The book covers all aspects of administering SQL Server 2005 and will provide a handy reference to anyone whose function it is to maintain a SQL 2005 system.
Martin Bell (SQL Server MVP)
1/28/2006
The book is very readable and I especially like the side notes, which come in Note, Tip, Caution, Real World and Best Practice forms. These give very useful practical information, which will help you avoid some the common problems that get posted to online newsgroups.
The book covers all aspects of administering SQL Server 2005 and will provide a handy reference to anyone whose function it is to maintain a SQL 2005 system.
Martin Bell (SQL Server MVP)
1/28/2006
19 of 20 people found the following review helpful
Another Stanek Winner
15 Nov 2006
Format:Paperback
I only recently got involved with SQL Server, when work required that I shift gears after our department downsized. Therefore I was not familiar with all of the nuances of SQL Server. In true William Stanek fashion, however, this book smoothly got this newbie very familiar with the features of SQL Server, which I am finding to be a lot more than I ever thought there would be, quite truthfully, I was not expecting it to be so complicated. The book starts out explaining the SQL Server administrations, and teaches some special characteristics for selecting hardware, choosing editions, and using the GUI and CLI tools. There is a lengthy explanation on SQL Server roles and integrating roles, planning for deploying, and setting up SQL Server. I really liked how the author drew the distinction between all the nuances of security, access and configuration. The massive chapter on tuning and optimizing goes into great depth. I never really appreciated the power of SQL Server until I read this chapters on data transformation, replications, transactions. I never knew before I read this book that SQL Server had features for log shipping and mirroring. Part Three and Part Four are where I've spent so much time reading lately. Since this book is 550 information packed pages, I can't review all of it for you. However, I find it an INDISPENSIBLE SQL Server tool. I always find the answers I need in Stanek's books!
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 > Data Warehousing
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > Database Theory
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Networking & Security > Network Topics > Microsoft Windows
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.
