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.
Autorentext
Tom Carpenter, MCSA: SQL Server 2012, is founder and senior consultant for SysEdCo, a training and consulting firm located in central Ohio. He is the author of several books on technical topics including networking infrastructure, database management, and VoIP. Having worked as a systems analyst in a large corporation with more than 20,000 network nodes, Tom brings a wealth of real-world experience to his books and presentations.
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
Zusammenfassung
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.
Inhalt
Introduction xxix
Part I Introducing SQL Server 2012 1
Chapter 1 Understanding SQL Server's Role 3
What Is Information Technology? 4
The Importance of IT 4
The Components of IT 6
Introduction to Databases 7
Types of Databases 7
Weighing the Benefits of Using a Local or Server-Based Database 11
Important Database Terms 16
Database Servers and Applications 18
Database Application Types 18
SQL Server's Role 20
New Features Introduced in SQL Server 2012 21
Features Introduced in SQL Server 2008 25
Features Introduced in SQL Server 2005 29
Core Features of SQL Server 38
SQL Server Roles 39
Summary 43
Chapter Essentials 43
Chapter 2 Installing SQL Server 2012 45
Installation Planning 46
SQL Server 2012 Architecture 46
Installation Planning Process 56
Managing Permissions 60
Installing a Default Instance 62
SQL Server Installation Center Tasks 63
Installation 64
Installing Named Instances 73
Installing to a Cluster 76
Installing Extra Features 77
Upgrading from Previous Versions 77
Handling Upgrades 78
Understanding Migrations 79
Validating an Installation 79
Removing an Installation 80
Summary 80
Chapter Essentials 80
Chapter 3 Working with the Administration Tools 83
SQL Server Configuration Manager 84
Overview of the SSCM 85
Performing Common SSCM Tasks 86
SQL Server Management Studio 92
Overview of the SSMS 92
Performing Common SSMS Tasks 94
SQL Server Data Tools 102
Overview of SSDT 102
Performing Common SSDT Tasks 104
SQL Server Profiler 113
Books Online 116
Windows Server Administration for the DBA 118
User Account Management 118
File System Management 119
Network Configuration Administration 120
Summary 127
Chapter Essentials 127
Chapter 4 SQL Server Command-Line Administration 129
Introducing the Command Prompt 130
General Command-Prompt Options 132
Font Settings 133
Screen Layout 134
Color Choices 135
General Commands 135
Directory and Folder Navigation 136
Directory and Folder Listing 137
Screen Management 141
Displaying Information 142
Redirecting Output 146
Administrative Commands 148
Batch Files 155
Using Logic (IF and GOTO) 155
Passing Data 156
Including Comments 157
Mastering SQLCMD 161
Introducing Windows PowerShell 164
Using SQL Server PowerShell Extensions 165
Summary 169
Chapter Essentials 169
Chapter 5 Querying SQL Server 171
Understanding the SQL Language 172
Queries 172
Short Learning Curve 173
Varied Query Modes 173
Standardization 175
Added Logical Capabilities of T-SQL 176
SQL Statement Types 176
Data Manipulation Language 176
Data Definition Language 177
Data Control Language 177
SQL Syntactical Elements 1…