Fishpond Gift Vouchers - Let them choose!

Shop over a million Toys in our Huge New Range

Microsoft SQL Server 2012 Management and Administration
By

Rating
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
Product Details

Table of Contents

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

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.

Look for similar items by category
How Fishpond Works
Fishpond works with suppliers all over the world to bring you a huge selection of products, really great prices, and delivery included on over 25 million products that we sell. We do our best every day to make Fishpond an awesome place for customers to shop and get what they want — all at the best prices online.
Webmasters, Bloggers & Website Owners
You can earn a 5% commission by selling Microsoft SQL Server 2012 Management and Administration on your website. It's easy to get started - we will give you example code. After you're set-up, your website can earn you money while you work, play or even sleep! You should start right now!
Authors / Publishers
Are you the Author or Publisher of a book? Or the manufacturer of one of the millions of products that we sell. You can improve sales and grow your revenue by submitting additional information on this title. The better the information we have about a product, the more we will sell!
Item ships from and is sold by Fishpond World Ltd.
Back to top