From the author and series editor of the immensely popular ''Administrator's Pocket Consultant'' series from Microsoft Press[registered] - this pocket-size guide delivers fast, accurate answers on the spot for IT professionals. ''Microsoft[registered] SQL Server[registered] 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[registered] SQL Server[registered] 2008 and SQL Server[registered] 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[registered] 2008 R2; administer server and surface security, access, and network configuration; import, export, transform, and replicate data; use SQL Server[registered] 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; and, perform backups and recovery.