Tom Carpenter: Microsoft SQL Server 2012 Administration, Kartoniert / Broschiert

Beschreibung

Implement, maintain, and repair SQL Server 2012 databases
As the most significant update since 2008, Microsoft SQL Server 2012 boasts updates and new features that are critical to understand. Whether you manage and administer SQL Server 2012 or are planning to get your MCSA: SQL Server 2012 certification, this book is the perfect supplement to your learning and preparation. From understanding SQL Server's roles to implementing business intelligence and reporting, this practical book explores tasks and scenarios that a working SQL Server DBA faces regularly and shows you step by step how to handle them.
Includes practice exams and coverage of exam objectives for those seeking MSCA: SQL Server 2012 certification
Explores the skills you'll need on the job as a SQL Server 2012 DBA
Discusses designing and implementing database solutions
Walks you through administrating, maintaining, and securing SQL Server 2012
Addresses implementing high availability and data distribution
Includes bonus videos where the author walks you through some of the more difficult tasks expected of a DBA
Featuring hands-on exercises and real-world scenarios, this resource guides you through the essentials of implementing, maintaining, and repairing SQL Server 2012 databases.

Inhaltsangabe

Introduction xxix
Part I Introducing SQL Server 2012 1
Chapter 1 Understanding SQL Server's Role 3
Chapter 2 Installing SQL Server 2012 45
Chapter 3 Working with the Administration Tools 83
Chapter 4 SQL Server Command-Line Administration 129
Chapter 5 Querying SQL Server 171
Part Il Designing Database Solutions 223
Chapter 6 Database Concepts and Terminology 225
Chapter 7 ERD and Capacity Planning 249
Chapter 8 Normalization and Other Design Issues 279
Part Ill Implementing Database Solutions 299
Chapter 9 Creating SQL Server Databases 301
Chapter 10 Creating Tables 337
Chapter 11 Indexes and Views 363
Chapter 12 Triggers and Stored Procedures 395
Chapter 13 Implementing Advanced Features 411
Part IV Administering and Maintaining SQL Server 2012 447
Chapter 14 Creating Jobs, Operators, and Alerts 449
Chapter 15 Performance Monitoring and Tuning 491
Chapter 16 Policy-Based Management 533
Chapter 17 Backup and Restoration 569
Part V SQL Server Security 597
Chapter 18 Security Threats and Principles 599
Chapter 19 Authentication and Encryption 641
Chapter 20 Security Best Practices 677
Part VI Implementing High Availability and Data Distribution 719
Chapter 21 AlwaysOn and High Availability 721
Chapter 22 SQL Server Failover Clustering 733
Chapter 23 Database Mirroring and Snapshots 753
Chapter 24 Implementing Replication 773
Part VII Implementing Business Intelligence and Reporting 799
Chapter 25 Data Warehousing 801
Chapter 26 SQL Server Integration Services 813
Chapter 27 Data Quality Solutions 837
Appendices 849
Appendix A Microsoft's Certification Program 851
Appendix B About the Additional Study Tools 859
Index 863

Klappentext

Take Your Career to the Next Level with This Practical Guide

SQL Server expert Tom Carpenter teaches you skills to help you excel in your job as a SQL Server 2012 database administrator. From designing and implementing database solutions with SQL Server 2012 to querying, repairing data, maintaining high availability, and managing always-on technology, he explores the real-world tasks and scenarios you'll face as a SQL Server database administrator and shows you how to handle them. This book also serves as an ideal resource for those preparing for their MCSA: SQL Server 2012 certification.

• Install and configure SQL Server 2012
• Design, implement, and effectively manage database solutions
• Learn basic and advanced querying techniques
• Understand triggers, stored procedures, and indexing
• Standardize, automate, and update jobs, operators, and alerts
• Monitor and manage a SQL Server cluster and learn mirroring
• Initiate backup and restore, and learn security best practices
• Plan for high availability, data warehousing, and business intelligence
• Discover how to clean data and improve data quality

ACCESS practice exams, electronic flashcards, and author videos of critical tasks at www. sybex. com / go / sqlserver12admin

An ideal supplement to help you prepare for:

Exam 70-461: Querying Microsoft SQL Server 2012

Exam 70-462: Administering a Microsoft SQL Server 2012 Database

Exam 70-463: Implementing Data Warehouses with Microsoft SQL Server 2012