The Fictioning
 
 

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Tour our stores


    Recently Viewed clear list


    Original Essays | September 18, 2014

    Lin Enger: IMG Knowing vs. Knowing



    On a hot July evening years ago, my Toyota Tercel overheated on a flat stretch of highway north of Cedar Rapids, Iowa. A steam geyser shot up from... Continue »

    spacer
Qualifying orders ship free.
$49.99
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
1 Remote Warehouse Database- Design
6 Remote Warehouse Database- Design

Microsoft SQL Server 2012 Management and Administration

by

Microsoft SQL Server 2012 Management and Administration Cover

 

Synopses & Reviews

Publisher Comments:

If you need to deploy, manage, or secure Microsoft SQL Server 2012, this is the complete, fast-paced, task-based reference you’ve been searching for. Authored by a worldclass expert on running SQL Server in the enterprise, this book goes far beyond the basics, taking on the complex tasks that DBAs need to make the most of Microsoft’s first cloud-enabled database platform. Designed for maximum practical usability, it’s packed with expert tips and up-to-date real-world configuration guidance you simply won’t find anywhere else.

As someone who helped influence the design of SQL Server 2012 and drawing on many months of beta testing, Ross Mistry provides immediately usable solutions for installation and upgrades, management and monitoring, performance and availability, security, consolidation, virtualization, troubleshooting, and more. Mistry identifies new features and corresponding best practices in every chapter, helping you take full advantage of new SQL Server innovations ranging from private cloud support to AlwaysOn Availability Groups.

Understand how to:

  • Efficiently install or upgrade the SQL Server 2012 database engine
  • Administer and configure database engine settings, storage, I/O, and partitioning
  • Transfer data on-premise or to the cloud
  • Manage and optimize indexes
  • Learn how to consolidate, virtualize and optimize SQL Server for Private Clouds
  • Harden and audit SQL Server 2012 environments
  • Administer security and authorization, including new Contained Databases
  • Encrypt data and communications
  • Design and deploy new AlwaysOn high-availability and disaster recovery features
  • Implement maintenance best practices, including Policy-Based Management

Synopsis:

This is the most complete, fast-paced, task-based reference for DBAs who need to deploy, manage, and secure Microsoft SQL Server 2012. Authored by a world-class architect who now crafts SQL Server solutions for Microsoft's largest Silicon Valley customers, it goes far beyond the basics, taking on the complex tasks that DBAs need to succeed with SQL Server 2012 in mission-critical environments. Ross Mistry draws on extensive testing in large production environments to offer step-by-step solutions and tips readers won't find anywhere else. Every chapter identifies SQL Server 2012's most valuable new improvements, and concludes with a convenient summary of best practices. Coverage includes: * Choosing the right installation or upgrade strategies * Managing memory, processors, auditing, database files, autogrowth, and new FileTables * Using new Contained Databases to streamline data deployment * Leveraging full-text search * Managing backup/restore * Working with Utility Control Points * Implementing consolidation, virtualization, and the private cloud * Using the Policy Based Framework to manage compliance and configuration * Managing workloads and consumption with the new Resource Governor * Hardening SQL Server environments * Utilizing SQL Server authorization and encryption * Operating new AlwaysOn Availability Groups * Using Failover Clustering, Database Mirroring, Replication, and other enterprise capabilities * Monitoring and troubleshooting SQL Server 2012

About the Author

Ross Mistry is an author, public speaker, principal enterprise architect, and veteran in the Silicon Valley. He has published numerous books and articles and frequently speaks at conferences worldwide.

With more than 15 years of experience, Ross has been a trusted advisor providing strategic guidance for many C-level executives and has been responsible for planning and implementing technology solutions for some of the largest companies in the world. He has taken on the lead architect role for many Silicon Valley internet startups and Fortune 100 organizations, including Network Appliance, McAfee, The Sharper Image, Visa, CIBC, Levi’s, Wells Fargo, and Intel. He specializes in data platform, business productivity, unified communications, core infrastructure, and private cloud.

At Microsoft, Ross is a director and principal enterprise architect at the Microsoft Technology Centers (MTCs). The MTCs are collaborative environments that provide access to innovative technologies and world-class expertise, giving organizations the ability to envision, design, and deploy solutions to meet their exact needs. He is currently in the process of launching and leading the first MTC in Canada.

Ross is an active participant in the SQL Server community. He comanaged the main Microsoft SQL Server Twitter account @SQLServer and frequently speaks at technology conferences around the world. He has recently spoken at TechEd, PASS Summit, SQL Connections, and SQL BITS. He is a series author and has formulated many best practices and written many whitepapers and articles for Microsoft, SQL Server Magazine, and Techtarget.com.

Table of Contents

Part I. SQL Server 2012 Database Engine Administration and Management Topics

1. Installing and Upgrading to SQL Server 2012

2. Administering the SQL Server 2012 Database Engine

3. Copying and Transferring Data or Databases

4. Managing and Optimizing SQL Server 2012 Indexes

5. Managing Data Compression and Table Partitions.

6. SQL Server 2012 Maintenance Practices

7. Backing up and Restoring a Database

Part II. Application and Multi-Instance Management

8. Implementing and Managing a Utility Control Point

9. Implementing and Managing Data-Tier Applications

10. Consolidation, Virtualization and Private Cloud

11. Administering Policy Based Management

12. Managing Workloads and Consumption with Resource Governor

Part III. Securing the SQL Server Implementation

13. Hardening a SQL Server Environment

14. Administering SQL Server Authorization

15. Encrypting SQL Server Data and Communications

Part IV. SQL Server 2012 High Availability Alternatives

16. Administering and Managing AlwaysOn Availability Groups

17. Administering and Managing Failover Clustering

18. Administering and Managing Database Mirroring

19. Administering and Managing Log Shipping

20. Administering Replication

Part IV. Monitoring and Troubleshooting SQL Server

21. Monitoring SQL Server 2012

22. Performance Tuning and Troubleshooting SQL Server 2012

Product Details

ISBN:
9780672336003
Author:
Mistry, Ross
Publisher:
Sams
Author:
Seenarine, Shirmattie
Subject:
Database design
Subject:
Database Management - General
Copyright:
Edition Description:
Trade paper
Publication Date:
20120615
Binding:
TRADE PAPER
Language:
English
Pages:
912
Dimensions:
8.18 x 5.4 x 1.966 in 1023 gr

Other books you might like

  1. Little Black Book of Washington DC,... New Hardcover $14.95

Related Subjects

Computers and Internet » Computer Languages » SQL
Computers and Internet » Database » Applications
Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Software Engineering » Software Management

Microsoft SQL Server 2012 Management and Administration New Trade Paper
0 stars - 0 reviews
$49.99 In Stock
Product details 912 pages Sams - English 9780672336003 Reviews:
"Synopsis" by , This is the most complete, fast-paced, task-based reference for DBAs who need to deploy, manage, and secure Microsoft SQL Server 2012. Authored by a world-class architect who now crafts SQL Server solutions for Microsoft's largest Silicon Valley customers, it goes far beyond the basics, taking on the complex tasks that DBAs need to succeed with SQL Server 2012 in mission-critical environments. Ross Mistry draws on extensive testing in large production environments to offer step-by-step solutions and tips readers won't find anywhere else. Every chapter identifies SQL Server 2012's most valuable new improvements, and concludes with a convenient summary of best practices. Coverage includes: * Choosing the right installation or upgrade strategies * Managing memory, processors, auditing, database files, autogrowth, and new FileTables * Using new Contained Databases to streamline data deployment * Leveraging full-text search * Managing backup/restore * Working with Utility Control Points * Implementing consolidation, virtualization, and the private cloud * Using the Policy Based Framework to manage compliance and configuration * Managing workloads and consumption with the new Resource Governor * Hardening SQL Server environments * Utilizing SQL Server authorization and encryption * Operating new AlwaysOn Availability Groups * Using Failover Clustering, Database Mirroring, Replication, and other enterprise capabilities * Monitoring and troubleshooting SQL Server 2012
spacer
spacer
  • back to top

FOLLOW US ON...

     
Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.