Microsoft SQL Server 2012 Management and Administration
Home > Computing and Information Technology > Databases > Microsoft SQL Server 2012 Management and Administration
Microsoft SQL Server 2012 Management and Administration

Microsoft SQL Server 2012 Management and Administration

|
     0     
5
4
3
2
1




Out of Stock


Notify me when this book is in stock
About the Book

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

Table of Contents:
Introduction     1 Part I: SQL Server 2012 Database Engine Administration and Management Topics 1 Installing or Upgrading the Database Engine to SQL Server 2012     13 What’s New for Installation with SQL Server 2012?     14 Preplanning and Preparing a SQL Server 2012 Server Database Engine Installation     16 Gathering Additional Information Necessary to Proceed     25 Installing a New Installation of SQL Server 2012     31 Upgrading the Database Engine to SQL Server 2012     40 Finalizing the SQL Server 2012 Installation or Upgrade     51 Installing SQL Server 2012 on Windows Server Core     53 Managing SQL Server 2012 Installations     62 Summary     64 Best Practices     64 2 Administering and Configuring the Database Engine Settings     67 What’s New for DBAs When Administering the Database Engine on SQL Server 2012     68 Administering SQL Server 2012 Server Properties     68 Administering the SQL Server Database Engine Folders     87 Administering Database Properties     98 SQL Server Database Engine Management Tasks     114 Administering the SQL Server Agent.     119 Summary     123 Best Practices     124 3 Administering Storage, I/O, and Partitioning     127 What’s New for DBAs When Administering Storage on SQL Server 2012     128 Storage Hardware Overview     129 Designing and Administering Storage on SQL Server 2012     140 Designing for BLOB Storage     158 Designing and Administrating Partitions in SQL Server 2012     164 Data Compression in SQL Server 2012     172 Summary     175 Best Practices     175 4 Creating Packages and Transferring Data On-Premise and to the Cloud.     179 What’s New in Integration Services for SQL Server 2012.     180 Options for Creating Packages     181 Integration Services Packages     182 Developing Packages     189 Enhancing Packages     199 Deploying and Running IntegrationServices Packages     212 Transferring Data with Integration Services     221 Moving Data to the Cloud     224 Summary     228 Best Practices     228 5 Managing and Optimizing SQL Server 2012 Indexes     229 What’s New for Indexes with SQL Server 2012     229 The Importance of Indexes     230 How Indexes Work     230 General Index Characteristics     238 Index Design and Strategy     242 Administering Indexes     247 Configuring Indexes for Maximum Performance     268 Summary     280 Best Practices     280 6 Backing Up and Restoring SQL Server 2012 Databases     283 What’s New for Backup and Recovery with SQL Server 2012?     283 The Importance of Backups     285 Backing Up and Recovering the Database Engine     289 Backup and Recovery Impact on Other Database Engine Features     324 Summary     330 Best Practices     330 Part II: Hardening, Auditing, and Securing SQL Server 2012 7 Hardening and Auditing a SQL Server 2012 Implementation     335 What’s New for Hardening and Auditing SQL Server 2012 Implementation?     336 Windows and SQL Server Authentication     337 Using Configuration Tools to Harden the Installation     343 Hardening SQL Server Service Accounts     350 Installing Service Packs and Critical Fixes     355 Leveraging SQL Server Auditing Strategies     357 Monitoring Events with SQL Server Audit     359 Additional SQL Server Hardening Recommendations     373 Summary     379 Best Practices     380 8 Administering SQL Server 2012 Security and Authorization     383 What’s New for Security and Authorization with SQL Server 2012?     383 SQL Server Security     385 Security Management DDL     398 Administering SQL Server Security     404 Contained Database Authentication     421 Summary     427 Best Practices     427 9 Encrypting SQL Server 2012 Data and Communications     429 What’s New for Encryption with SQL Server 2012?     430 Encryption in SQL     431 Column Encryption     432 Securing the Data Storage     435 Extensible Key Management     444 Transparent Data Encryption     446 Securing Connections     452 Using Certificates     456 SQL Server and BitLocker Drive Encryption     465 Configuring BitLocker Drive Encryption on a SQL Server System     469 Summary     478 Best Practices     478 Part III: SQL Server 2012 AlwaysOn High-Availability and Disaster Recovery Alternatives 10 Implementing and Managing AlwaysOn Availability Groups     483 SQL Server 2012 AlwaysOn Availability Groups Overview     484 Implementing AlwaysOn Availability Groups     490 Managing AlwaysOn Availability Groups     509 Monitoring and Troubleshooting AlwaysOn Availability Groups     520 Summary     525 Best Practices     526 11 Implementing and Managing AlwaysOn Failover Cluster Instances     527 SQL Server 2012 AlwaysOn Failover Cluster Instances Overview     527 What’s New for SQL Server 2012 AlwaysOn Failover Cluster Instances?     528 Additional Elements of AlwaysOn Failover Cluster Instances     537 Implementing a Single-Instance SQL Server 2012 Failover Cluster.     544 Implementing a Multiple-Instance SQL Server 2012 Failover Cluster     564 Multi-subnet SQL Server 2012 Failover Cluster Overview     568 Implementing Multi-subnet SQL Server 2012 Failover Cluster     571 Managing Failover Clusters from a SQL Server 2012 Perspective     574 Verifying the Status of Clustered Service and Applications, Nodes, Storage, and Networks     574 Managing Failover Clusters from a Windows Server 2008 R2 Perspective     580 Summary     583 Best Practices     583  12 Implementing and Managing Database Mirroring     587 SQL Server 2012 Database Mirroring Overview     588 Combining Database Mirroring with Other SQL Server 2012 Technologies     596 Implementing a Database Mirroring Session     599 Managing a Database Mirroring Session     607 Monitoring and Troubleshooting a Database Mirroring Session     614 Summary     618 Best Practices     619 13 Implementing and Managing Replication     621 SQL Server 2012 Replication Essentials     622 Implementing SQL Server Replication     639 Managing SQL Server 2012 Replication     667 Monitoring and Troubleshooting SQL Server Replication     670 Summary     672 Best Practices     672 Part IV: Performance Tuning, Monitoring, Troubleshooting, and Maintenance 14 Performance Tuning and Troubleshooting SQL Server 2012     677 Platform Troubleshooting and Optimization     680 Database Troubleshooting and Optimization     691 Application Optimization and Troubleshooting     714 Introducing Extended Events to Troubleshoot SQL Server     718 Summary     726 Best Practices     726 15 Monitoring SQL Server 2012.     729 What’s New for Monitoring in SQL Server 2012?     730 Gaining Quick Insight into a SQL Server System     731 The Data Collector and the Management Data Warehouse     744 SQL Server Utilities     757 Creating Operators and Sending Email Alerts     763 Using the Windows Server 2008 R2 Performance Monitoring Tools     769 Additional Tools to Monitor SQL Server 2012     776 Summary     777 Best Practices     777 16 SQL Server 2012 Maintenance Practices     779 What’s New for Maintenance with SQL Server 2012?     779 Establishing a SQL Server Maintenance Plan     780 Creating a Maintenance Plan     792 Establishing Maintenance Schedules for SQL Server     805 Summary     807 Best Practices     807 Part V: Multi-Instance Management, Consolidation, and Private Clouds 17 Implementing and Managing Policy-Based Management     811 Introduction to Policy-Based Management     811 Policy-Based Management Concepts     813 Implementing Policy-Based Management     819 Monitoring and Enforcing Best Practices by Using Policy-Based Management     830 Summary     836 Best Practices     836 18 Managing Workloads with Resource Governor     839 What’s New for Resource Governor in SQL Server 2012     840 Overview of Resource Governor Concepts, Workflow, and Scenarios     841 Implementing and Configuring Resource Governor     845 Creating a Workload Group     852 Understanding Default Transact-SQL Syntax with Resource Governor     858 Managing Resource Governor     860 Monitoring Resource Governor     862 Summary     867 Best Practices     868 19 Consolidation, Virtualization, and Private Clouds     869 Understanding Consolidation, Virtualization, and Private Cloud Strategies     870 Planning Your Implementation of Hyper-V     878 Installation of the Microsoft Hyper-V Server Role     883 Becoming Familiar with the Hyper-V Administrative Console     886 Installing a SQL Server 2012 Guest Operating System Session     889 Modifying SQL Server 2012 Guest Session Configuration Settings     893 Launching a Hyper-V Guest Session     898 Using Snapshots of Guest Operating System Sessions     900 Optimizing SQL Server 2012 for Private Cloud     903 Summary     905 Best Practices     905 Index     909


Best Sellers


Product Details
  • ISBN-13: 9780132977654
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Addison Wesley
  • Language: English
  • ISBN-10: 0132977656
  • Publisher Date: 06 Sep 2012
  • Binding: Digital download
  • Weight: 1 gr


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Microsoft SQL Server 2012 Management and Administration
Pearson Education (US) -
Microsoft SQL Server 2012 Management and Administration
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Microsoft SQL Server 2012 Management and Administration

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals

    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!