Microsoft SQL Server 2012 Administration

Tom Carpenter 지음

Sybex 2013년 06월 03일 출간

작품소개

책소개

Implement, maintain, and repair SQL Server 2012 databasesAs 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 certificationExplores the skills you'll need on the job as a SQL Server 2012 DBADiscusses designing and implementing database solutions Walks you through administrating, maintaining, and securing SQL Server 2012Addresses implementing high availability and data distributionIncludes bonus videos where the author walks you through some of the more difficult tasks expected of a DBAFeaturing hands-on exercises and real-world scenarios, this resource guides you through the essentials of implementing, maintaining, and repairing SQL Server 2012 databases.

목차

Introduction xxixPart I Introducing SQL Server 2012 1Chapter 1 Understanding SQL Server&'s Role 3What Is Information Technology? 4The Importance of IT 4The Components of IT 6Introduction to Databases 7Types of Databases 7Weighing the Benefits of Using a Local or Server-BasedDatabase 11Important Database Terms 16Database Servers and Applications 18Database Application Types 18SQL Server&'s Role 20New Features Introduced in SQL Server 2012 21Features Introduced in SQL Server 2008 25Features Introduced in SQL Server 2005 29Core Features of SQL Server 38SQL Server Roles 39Summary 43Chapter Essentials 43Chapter 2 Installing SQL Server 2012 45Installation Planning 46SQL Server 2012 Architecture 46Installation Planning Process 56Managing Permissions 60Installing a Default Instance 62SQL Server Installation Center Tasks 63Installation 64Installing Named Instances 73Installing to a Cluster 76Installing Extra Features 77Upgrading from Previous Versions 77Handling Upgrades 78Understanding Migrations 79Validating an Installation 79Removing an Installation 80Summary 80Chapter Essentials 80Chapter 3 Working with the Administration Tools 83SQL Server Configuration Manager 84Overview of the SSCM 85Performing Common SSCM Tasks 86SQL Server Management Studio 92Overview of the SSMS 92Performing Common SSMS Tasks 94SQL Server Data Tools 102Overview of SSDT 102Performing Common SSDT Tasks 104SQL Server Profiler 113Books Online 116Windows Server Administrationfor the DBA 118User Account Management 118File System Management 119Network Configuration Administration 120Summary 127Chapter Essent

작가정보

저자(글) Tom Carpenter

저자 :

저자 :

저자 :

저자 :

저자 :
저자 :
저자 :
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#45;world experience to his books and presentations.