Free Downloads
Microsoft SQL Server 2008 Administrator's Pocket Consultant

From the author and series editor of the immensely popular ADMINISTRATOR'S POCKET CONSULTANT series from Microsoft Press-this pocket-size guide delivers fast, accurate answers on the spot for IT professionals. Microsoft SQL Server 2008 Administrator's Pocket Consultant, 2nd Edition is the ideal concise, immediate reference you'll want with you at all times as you deal with Microsoft SQL Server 2008 and SQL Server 2008 R2 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 you consistently save you time and minimize system downtime by giving you the right information right now. Get fast facts to: Plan, deploy, and configure SQL Server 2008 R2 Administer server and surface security, access, and network configuration Import, export, transform, and replicate data Use SQL Server Management Studio for core administrative tasks Manipulate schemas, tables, indexes, and views Automate maintenance and implement policy-based management Monitor server activity and tune performance Manage log shipping and database mirroring Perform backups and recovery

File Size: 5970 KB

Print Length: 735 pages

Page Numbers Source ISBN: 073562738X

Simultaneous Device Usage: Up to 5 simultaneous devices, per publisher limits

Publisher: Microsoft Press; 2 edition (April 21, 2010)

Publication Date: April 21, 2010

Sold by:  Digital Services LLC

Language: English


Text-to-Speech: Enabled

X-Ray: Not Enabled

Word Wise: Not Enabled

Lending: Not Enabled

Enhanced Typesetting: Not Enabled

Best Sellers Rank: #1,188,253 Paid in Kindle Store (See Top 100 Paid in Kindle Store) #288 in Books > Computers & Technology > Programming > Microsoft Programming > SQL Server #526 in Books > Computers & Technology > Software > Databases #908 in Books > Computers & Technology > Databases & Big Data > SQL

Well, I am not a SQL Server DBA. I am an Oracle DBA. But as all Oracle DBAs know, there are more SQL Server databases at Oracle sites then ever before. So, it makes sense to see what is going on over there in SQL Server land.This is a good book for me - a DBA, not a developer. I did not want a 'how to create an online bookstore with SQL Server' type of book. What I wanted was DBA-info. I was looking for features, commands, syntax, uses, notes, etc.I think this is a good reference for anyone trying to get info about SQL Server. And for me, a DBA who does not write code, this is a very good book.

William Stanek is the #1 Windows authority for a reason, his books are excellent and packed with useful information. This 696-page book is no exception. As with Stanek'sMicrosoft Exchange Server 2007 Administrator's Pocket Consultant Second Edition, I don't see how any SQL admin can live without this book. We're so understaffed and I jump around so many different servers I couldn't function without this.

First thing I was not that familiar with SQL. I have done minor queries but that was it. Besides that I have had nothing to do with SQL. My boss then decided I should start administering our SQL server because the other 15 machines I administer was just not enough and it is the same as a server 2003 machine right? Whatever.I bought this book with the hopes it could help me with the day to day operations backup of the database, run clean-ups, etc. This book came back aces. The very first section I looked up was backup. It walked me through step by step explaining everything. The next section was restoration. So I tried it. I created a VM and followed the steps shown. Restored perfectly. I could not be happier.Everything I have tried in this book has worked the way it was supposed to. It is easy to follow and does not go off in techno babble until it tells you a definition.I think this is required for anyone administering a SQL Server 2008 machine.

I had an unexpected gap (like 2 years!) between the two prerequisite classes and the actual exams for SQL Server certification. This book was helpful as I got caught up. I imagine it will continue to come in handy during my normal work day as well. If you are planning on getting 2008 SQL Server MCTS or MCITP certifications, this book can help.

I always liked the Administrator Pocket Consultant series having several of them, going all the way back to Windows 2000. They are half the height and width of a regular book, but packed full on information (this one at almost 700 pages). The title really says what the book is and what it is good for. It is a great reference book.I am not a DBA, but a developer that at times must work SQL Server. The book gives enough of an explanation to perform the required tasks and understand what I am doing and why. Need to know how to do something or forgot how to do something, a quick look up and you have the answer. The book is straight forward, informative and easy to understand. There are lots of examples and step by step instructions. Even though it more of a reference book, I like just opening it up and reading a section.

The content of the book is excellent but the manufacturing is terrible. Pages are falling out and the spine of the book has separated right down the middle. Very poor quality control and design by Microsoft makes it hard to recommend this book, it simply does not stand up to day-to-day wear and tear. Perhaps there is a hardback version available...?

Straight forward, useful and practical value! Easy to understand, well, not totally. At some parts I wish there were drawings and charts to help readers better understand. I recommend it.

I needed a SQL Server 2008 administration book for both learning and for reference at work. Stanek has other books out that are very good. He has this pocket consultant book formula down pat. I have used his IIS Pocket Consultant and the previous book on SQL Server 2005 with good results. So, I knew that this should be a good SQL 2008 reference.I was correct. This book is thorough, informative and accessible. The presentation is very good & straightforward. Information & tasks are presented clearly, and the book has lots of pictures of the UIs and tables for information. I find the pictures can are very effective in supporting the text. The UI cannot be explained in a few words and the pictures eliminate this need. This is an administrative pocket consultant. And that is what is in the book, hundreds of pages of administrative related tasks. The book is targeted to specific tasks which makes it very helpful. I recommend this SQL2K8 Pocket Consultant.

SQL: Learn SQL In A DAY! - The Ultimate Crash Course to Learning the Basics of SQL In No Time (SQL, SQL Course, SQL Development, SQL Books, SQL for Beginners) Microsoft SQL Server 2008 Administrator's Pocket Consultant Microsoft Exchange Server 2010 Administrator's Pocket Consultant SQL: QuickStart Guide - The Simplified Beginner's Guide To SQL (SQL, SQL Server, Structured Query Language) Beginning SQL Server 2008 Express for Developers: From Novice to Professional (Expert's Voice in SQL Server) Pro SQL Server 2008 Failover Clustering (Expert's Voice in SQL Server) Pro SQL Server 2012 BI Solutions (Expert's Voice in SQL Server) SQL Server 2012 Integration Services Design Patterns (Expert's Voice in SQL Server) LINUX, UNIX, SAN, SYSTEM ADMINISTRATOR, LINUX SERVER ENGINEER, STORAGE ADMINISTRATOR LAST-MINUTE BOTTOM LINE JOB INTERVIEW PREPARATION QUESTIONS & ANSWERS Red Hat Enterprise Linux (RHEL) 7 Server Installation and Administration: Training Manual: Covering CentOS-7 Server, Cloud computing, Bind9 DNS Server and Fedora 23 Server Red Hat Enterprise Linux (RHEL) 6 Server Installation & Administration: Training Manual: Covering CentOS-6, OpenSUSE 11.3 Server, Mandriva Enterprise Server, and Fedora 14 Server Microsoft Exchange Server 2013 Pocket Consultant: Configuration & Clients Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions (Developer Reference) Microsoft SQL Server 2008 Reporting Services Unleashed Microsoft Surface Pro 4 & Microsoft Surface Book: The Beginner's Guide to Microsoft Edge, Cortana & Mail App on Microsoft Surface Pro 4 & Microsoft Surface Book SQL: Beginner's Guide for Coding SQL (database programming, computer programming, how to program, sql for dummies, java, mysql, The Oracle, python, PHP, ... (HTML, Programming, Coding, CSS Book 7) Windows Server 2012 R2 Pocket Consultant Volume 1: Essentials & Configuration Windows Server 2012 R2 Pocket Consultant Volume 2: Storage, Security, & Networking Expert T-SQL Window Functions in SQL Server The Semantic Web - ISWC 2008: 7th International Semantic Web Conference, ISWC 2008, Karlsruhe, Germany, October 26-30, 2008, Proceedings (Lecture Notes in Computer Science)