Home > Computing and Information Technology > Databases > Database software > Microsoft SQL Server 2012 Management and Administration
33%
Microsoft SQL Server 2012 Management and Administration

Microsoft SQL Server 2012 Management and Administration

          
5
4
3
2
1

Out of Stock


Premium quality
Premium quality
Bookswagon upholds the quality by delivering untarnished books. Quality, services and satisfaction are everything for us!
Easy Return
Easy return
Not satisfied with this product! Keep it in original condition and packaging to avail easy return policy.
Certified product
Certified product
First impression is the last impression! Address the book’s certification page, ISBN, publisher’s name, copyright page and print quality.
Secure Checkout
Secure checkout
Security at its finest! Login, browse, purchase and pay, every step is safe and secured.
Money back guarantee
Money-back guarantee:
It’s all about customers! For any kind of bad experience with the product, get your actual amount back after returning the product.
On time delivery
On-time delivery
At your doorstep on time! Get this book delivered without any delay.
Notify me when this book is in stock
Add to Wishlist

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: 9780672336003
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Sams Publishing
  • Depth: 51
  • Height: 208 mm
  • No of Pages: 912
  • Series Title: English
  • Weight: 1026 gr
  • ISBN-10: 0672336006
  • Publisher Date: 04 Oct 2012
  • Binding: Paperback
  • Edition: 2
  • Language: English
  • Returnable: N
  • Spine Width: 49 mm
  • Width: 140 mm


Similar Products

How would you rate your experience shopping for books on Bookswagon?

Add Photo
Add Photo

Customer Reviews

REVIEWS           
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!
    ASK VIDYA