{"product_id":"microsoft-sql-server-2012-administration-9781118487167","title":"Microsoft SQL Server 2012 Administration","description":"\u003cb\u003eBook Synopsis\u003c\/b\u003e\u003cbr\u003e\u003cp\u003e\u003cb\u003eImplement, maintain, and repair SQL Server 2012 databases\u003c\/b\u003e\u003c\/p\u003e \u003cp\u003eAs 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.\u003c\/p\u003e \u003cul\u003e \u003cli\u003eIncludes practice exams and coverage of exam objectives for those seeking MSCA: SQL Server 2012 certification\u003c\/li\u003e \u003cli\u003eExplores the skills you''ll need on the job as a SQL Server 2012 DBA\u003c\/li\u003e \u003cli\u003eDiscusses designing and implementing database solutions\u003c\/li\u003e \u003cli\u003eWalks you through administrating, maintaining, and securing SQL Server 2012\u003c\/li\u003e \u003cli\u003eAddresses im\u003cbr\u003e\u003cbr\u003e\u003cb\u003eTable of Contents\u003c\/b\u003e\u003cbr\u003eIntroduction xxix  \u003cp\u003ePart I Introducing SQL Server 2012 1\u003c\/p\u003e \u003cp\u003eChapter 1 Understanding SQL Server’s Role 3\u003c\/p\u003e \u003cp\u003eWhat Is Information Technology? 4\u003c\/p\u003e \u003cp\u003eThe Importance of IT 4\u003c\/p\u003e \u003cp\u003eThe Components of IT 6\u003c\/p\u003e \u003cp\u003eIntroduction to Databases 7\u003c\/p\u003e \u003cp\u003eTypes of Databases 7\u003c\/p\u003e \u003cp\u003eWeighing the Benefits of Using a Local or Server-Based Database 11\u003c\/p\u003e \u003cp\u003eImportant Database Terms 16\u003c\/p\u003e \u003cp\u003eDatabase Servers and Applications 18\u003c\/p\u003e \u003cp\u003eDatabase Application Types 18\u003c\/p\u003e \u003cp\u003eSQL Server’s Role 20\u003c\/p\u003e \u003cp\u003eNew Features Introduced in SQL Server 2012 21\u003c\/p\u003e \u003cp\u003eFeatures Introduced in SQL Server 2008 25\u003c\/p\u003e \u003cp\u003eFeatures Introduced in SQL Server 2005 29\u003c\/p\u003e \u003cp\u003eCore Features of SQL Server 38\u003c\/p\u003e \u003cp\u003eSQL Server Roles 39\u003c\/p\u003e \u003cp\u003eSummary 43\u003c\/p\u003e \u003cp\u003eChapter Essentials 43\u003c\/p\u003e \u003cp\u003eChapter 2 Installing SQL Server 2012 45\u003c\/p\u003e \u003cp\u003eInstallation Planning 46\u003c\/p\u003e \u003cp\u003eSQL Server 2012 Architecture 46\u003c\/p\u003e \u003cp\u003eInstallation Planning Process 56\u003c\/p\u003e \u003cp\u003eManaging Permissions 60\u003c\/p\u003e \u003cp\u003eInstalling a Default Instance 62\u003c\/p\u003e \u003cp\u003eSQL Server Installation Center Tasks 63\u003c\/p\u003e \u003cp\u003eInstallation 64\u003c\/p\u003e \u003cp\u003eInstalling Named Instances 73\u003c\/p\u003e \u003cp\u003eInstalling to a Cluster 76\u003c\/p\u003e \u003cp\u003eInstalling Extra Features 77\u003c\/p\u003e \u003cp\u003eUpgrading from Previous Versions 77\u003c\/p\u003e \u003cp\u003eHandling Upgrades 78\u003c\/p\u003e \u003cp\u003eUnderstanding Migrations 79\u003c\/p\u003e \u003cp\u003eValidating an Installation 79\u003c\/p\u003e \u003cp\u003eRemoving an Installation 80\u003c\/p\u003e \u003cp\u003eSummary 80\u003c\/p\u003e \u003cp\u003eChapter Essentials 80\u003c\/p\u003e \u003cp\u003eChapter 3 Working with the Administration Tools 83\u003c\/p\u003e \u003cp\u003eSQL Server Configuration Manager 84\u003c\/p\u003e \u003cp\u003eOverview of the SSCM 85\u003c\/p\u003e \u003cp\u003ePerforming Common SSCM Tasks 86\u003c\/p\u003e \u003cp\u003eSQL Server Management Studio 92\u003c\/p\u003e \u003cp\u003eOverview of the SSMS 92\u003c\/p\u003e \u003cp\u003ePerforming Common SSMS Tasks 94\u003c\/p\u003e \u003cp\u003eSQL Server Data Tools 102\u003c\/p\u003e \u003cp\u003eOverview of SSDT 102\u003c\/p\u003e \u003cp\u003ePerforming Common SSDT Tasks 104\u003c\/p\u003e \u003cp\u003eSQL Server Profiler 113\u003c\/p\u003e \u003cp\u003eBooks Online 116\u003c\/p\u003e \u003cp\u003eWindows Server Administration for the DBA 118\u003c\/p\u003e \u003cp\u003eUser Account Management 118\u003c\/p\u003e \u003cp\u003eFile System Management 119\u003c\/p\u003e \u003cp\u003eNetwork Configuration Administration 120\u003c\/p\u003e \u003cp\u003eSummary 127\u003c\/p\u003e \u003cp\u003eChapter Essentials 127\u003c\/p\u003e \u003cp\u003eChapter 4 SQL Server Command-Line Administration 129\u003c\/p\u003e \u003cp\u003eIntroducing the Command Prompt 130\u003c\/p\u003e \u003cp\u003eGeneral Command-Prompt Options 132\u003c\/p\u003e \u003cp\u003eFont Settings 133\u003c\/p\u003e \u003cp\u003eScreen Layout 134\u003c\/p\u003e \u003cp\u003eColor Choices 135\u003c\/p\u003e \u003cp\u003eGeneral Commands 135\u003c\/p\u003e \u003cp\u003eDirectory and Folder Navigation 136\u003c\/p\u003e \u003cp\u003eDirectory and Folder Listing 137\u003c\/p\u003e \u003cp\u003eScreen Management 141\u003c\/p\u003e \u003cp\u003eDisplaying Information 142\u003c\/p\u003e \u003cp\u003eRedirecting Output 146\u003c\/p\u003e \u003cp\u003eAdministrative Commands 148\u003c\/p\u003e \u003cp\u003eBatch Files 155\u003c\/p\u003e \u003cp\u003eUsing Logic (IF and GOTO) 155\u003c\/p\u003e \u003cp\u003ePassing Data 156\u003c\/p\u003e \u003cp\u003eIncluding Comments 157\u003c\/p\u003e \u003cp\u003eMastering SQLCMD 161\u003c\/p\u003e \u003cp\u003eIntroducing Windows PowerShell 164\u003c\/p\u003e \u003cp\u003eUsing SQL Server PowerShell Extensions 165\u003c\/p\u003e \u003cp\u003eSummary 169\u003c\/p\u003e \u003cp\u003eChapter Essentials 169\u003c\/p\u003e \u003cp\u003eChapter 5 Querying SQL Server 171\u003c\/p\u003e \u003cp\u003eUnderstanding the SQL Language 172\u003c\/p\u003e \u003cp\u003eQueries 172\u003c\/p\u003e \u003cp\u003eShort Learning Curve 173\u003c\/p\u003e \u003cp\u003eVaried Query Modes 173\u003c\/p\u003e \u003cp\u003eStandardization 175\u003c\/p\u003e \u003cp\u003eAdded Logical Capabilities of T-SQL 176\u003c\/p\u003e \u003cp\u003eSQL Statement Types 176\u003c\/p\u003e \u003cp\u003eData Manipulation Language 176\u003c\/p\u003e \u003cp\u003eData Definition Language 177\u003c\/p\u003e \u003cp\u003eData Control Language 177\u003c\/p\u003e \u003cp\u003eSQL Syntactical Elements 177\u003c\/p\u003e \u003cp\u003eKeywords 177\u003c\/p\u003e \u003cp\u003eComments 178\u003c\/p\u003e \u003cp\u003eBatch Directives 178\u003c\/p\u003e \u003cp\u003eSQL Statements 180\u003c\/p\u003e \u003cp\u003eClauses 180\u003c\/p\u003e \u003cp\u003eIdentifiers 180\u003c\/p\u003e \u003cp\u003eVariables 181\u003c\/p\u003e \u003cp\u003eData Types 182\u003c\/p\u003e \u003cp\u003eSystem Functions 182\u003c\/p\u003e \u003cp\u003eOperators and Expressions 182\u003c\/p\u003e \u003cp\u003eStatement Terminator 184\u003c\/p\u003e \u003cp\u003eCoding Recommendations 184\u003c\/p\u003e \u003cp\u003eCapitalize Keywords 184\u003c\/p\u003e \u003cp\u003eUse Standard SQL 185\u003c\/p\u003e \u003cp\u003eDo Not Use Keywords as Identifiers 185\u003c\/p\u003e \u003cp\u003eUsing SELECT Statements 185\u003c\/p\u003e \u003cp\u003eBasic SELECT Statements 186\u003c\/p\u003e \u003cp\u003eFiltered SELECT Statements 191\u003c\/p\u003e \u003cp\u003eSorted SELECT Statements 196\u003c\/p\u003e \u003cp\u003eHandling NULL Data 197\u003c\/p\u003e \u003cp\u003eConverting Data in Result Sets 199\u003c\/p\u003e \u003cp\u003eIdentifying Collation Details 201\u003c\/p\u003e \u003cp\u003eUsing Data from Multiple Tables 201\u003c\/p\u003e \u003cp\u003eAdvanced Query Techniques 204\u003c\/p\u003e \u003cp\u003eSubqueries 204\u003c\/p\u003e \u003cp\u003eAggregate Queries 206\u003c\/p\u003e \u003cp\u003eUsing DDL Statements 207\u003c\/p\u003e \u003cp\u003eCreating Objects 207\u003c\/p\u003e \u003cp\u003eAltering Objects 209\u003c\/p\u003e \u003cp\u003eDeleting Objects 210\u003c\/p\u003e \u003cp\u003eUsing DCL Statements 212\u003c\/p\u003e \u003cp\u003eGranting Access 212\u003c\/p\u003e \u003cp\u003eDenying Access 213\u003c\/p\u003e \u003cp\u003eRevoking Permissions 213\u003c\/p\u003e \u003cp\u003eModifying Data 214\u003c\/p\u003e \u003cp\u003eThe INSERT Statement 214\u003c\/p\u003e \u003cp\u003eThe UPDATE Statement 215\u003c\/p\u003e \u003cp\u003eThe DELETE Statement 216\u003c\/p\u003e \u003cp\u003eTuning and Optimizing Queries 216\u003c\/p\u003e \u003cp\u003eTransaction Processing 216\u003c\/p\u003e \u003cp\u003eError Handling 218\u003c\/p\u003e \u003cp\u003eSummary 220\u003c\/p\u003e \u003cp\u003eChapter Essentials 220\u003c\/p\u003e \u003cp\u003ePart Il Designing Database Solutions 223\u003c\/p\u003e \u003cp\u003eChapter 6 Database Concepts and Terminology 225\u003c\/p\u003e \u003cp\u003eRelational Database Theory 226\u003c\/p\u003e \u003cp\u003eData 226\u003c\/p\u003e \u003cp\u003eInformation 227\u003c\/p\u003e \u003cp\u003eTables 227\u003c\/p\u003e \u003cp\u003eTable Components 228\u003c\/p\u003e \u003cp\u003eRelationship Types 232\u003c\/p\u003e \u003cp\u003eDatabase Design Processes 236\u003c\/p\u003e \u003cp\u003eSystems Development Life Cycle 237\u003c\/p\u003e \u003cp\u003eDatabase Life Cycle 238\u003c\/p\u003e \u003cp\u003eBusiness, Users, Model 239\u003c\/p\u003e \u003cp\u003eProject Management for the DBA 243\u003c\/p\u003e \u003cp\u003eThe Define Phase 244\u003c\/p\u003e \u003cp\u003eThe Design Phase 246\u003c\/p\u003e \u003cp\u003eThe Deliver Phase 246\u003c\/p\u003e \u003cp\u003eThe Determine Phase 247\u003c\/p\u003e \u003cp\u003eSummary 247\u003c\/p\u003e \u003cp\u003eChapter Essentials 248\u003c\/p\u003e \u003cp\u003eChapter 7 ERD and Capacity Planning 249\u003c\/p\u003e \u003cp\u003ePlanning a Database 250\u003c\/p\u003e \u003cp\u003eUser Surveys 250\u003c\/p\u003e \u003cp\u003eEvaluating Business Processes 252\u003c\/p\u003e \u003cp\u003eDeveloping Use Cases 254\u003c\/p\u003e \u003cp\u003eUnderstanding Entity Relationship Diagramming 255\u003c\/p\u003e \u003cp\u003eBuilding an ERD 257\u003c\/p\u003e \u003cp\u003eCreating an ERD in Visio 258\u003c\/p\u003e \u003cp\u003eCreating an ERD in OSA 264\u003c\/p\u003e \u003cp\u003eCapacity Planning 271\u003c\/p\u003e \u003cp\u003eSummary 276\u003c\/p\u003e \u003cp\u003eChapter Essentials 277\u003c\/p\u003e \u003cp\u003eChapter 8 Normalization and Other Design Issues 279\u003c\/p\u003e \u003cp\u003eDesigning for Normalization 280\u003c\/p\u003e \u003cp\u003eNormal Forms 282\u003c\/p\u003e \u003cp\u003eNormalizing a Database 291\u003c\/p\u003e \u003cp\u003eDenormalizing a Database 294\u003c\/p\u003e \u003cp\u003eDesigning for Performance 295\u003c\/p\u003e \u003cp\u003eDesigning for Availability 295\u003c\/p\u003e \u003cp\u003eDesigning for Security 297\u003c\/p\u003e \u003cp\u003eSummary 297\u003c\/p\u003e \u003cp\u003eChapter Essentials 297\u003c\/p\u003e \u003cp\u003ePart Ill Implementing Database Solutions 299\u003c\/p\u003e \u003cp\u003eChapter 9 Creating SQL Server Databases 301\u003c\/p\u003e \u003cp\u003eSQL Server Databases 302\u003c\/p\u003e \u003cp\u003eSystem Databases 303\u003c\/p\u003e \u003cp\u003eUser Databases 308\u003c\/p\u003e \u003cp\u003eDatabase Storage 308\u003c\/p\u003e \u003cp\u003eDatabase Data Files 308\u003c\/p\u003e \u003cp\u003eDatabase Filegroups 309\u003c\/p\u003e \u003cp\u003eTransaction Logs 311\u003c\/p\u003e \u003cp\u003eDatabase Options and Properties 312\u003c\/p\u003e \u003cp\u003eAutogrowth 312\u003c\/p\u003e \u003cp\u003eRecovery Model 313\u003c\/p\u003e \u003cp\u003eCompatibility Level 316\u003c\/p\u003e \u003cp\u003eAuto Shrink 316\u003c\/p\u003e \u003cp\u003eRestrict Access 317\u003c\/p\u003e \u003cp\u003eMore Database Properties 318\u003c\/p\u003e \u003cp\u003eCreating Databases in the GUI 321\u003c\/p\u003e \u003cp\u003eCreating Databases with T-SQL 323\u003c\/p\u003e \u003cp\u003eCreating Databases with PowerShell 326\u003c\/p\u003e \u003cp\u003eAttaching and Detaching Databases 328\u003c\/p\u003e \u003cp\u003eDatabase Snapshots 331\u003c\/p\u003e \u003cp\u003eCreating Snapshots 332\u003c\/p\u003e \u003cp\u003eReverting to Snapshots 334\u003c\/p\u003e \u003cp\u003eSummary 335\u003c\/p\u003e \u003cp\u003eChapter Essentials 335\u003c\/p\u003e \u003cp\u003eChapter 10 Creating Tables 337\u003c\/p\u003e \u003cp\u003eData Types 338\u003c\/p\u003e \u003cp\u003eData Type Categories 340\u003c\/p\u003e \u003cp\u003eCollations 344\u003c\/p\u003e \u003cp\u003eConfiguring Server Instance Collations 345\u003c\/p\u003e \u003cp\u003eConfiguring Database Collations 346\u003c\/p\u003e \u003cp\u003eConfiguring Column Collations 346\u003c\/p\u003e \u003cp\u003eTable Creation Process 349\u003c\/p\u003e \u003cp\u003eCreating Tables with the Table Designer 349\u003c\/p\u003e \u003cp\u003eCreating Tables with T-SQL 357\u003c\/p\u003e \u003cp\u003eData Partitioning 358\u003c\/p\u003e \u003cp\u003eVertical and Horizontal Partitioning 359\u003c\/p\u003e \u003cp\u003eData Partitioning with Functions and Schemes 360\u003c\/p\u003e \u003cp\u003eSummary 361\u003c\/p\u003e \u003cp\u003eChapter Essentials 362\u003c\/p\u003e \u003cp\u003eChapter 11 Indexes and Views 363\u003c\/p\u003e \u003cp\u003eUnderstanding Indexes 364\u003c\/p\u003e \u003cp\u003eIndexes Defined 365\u003c\/p\u003e \u003cp\u003eIndex Types 369\u003c\/p\u003e \u003cp\u003eCreating Basic Indexes 373\u003c\/p\u003e \u003cp\u003eCreating a Clustered Index 374\u003c\/p\u003e \u003cp\u003eCreating a Nonclustered Index 376\u003c\/p\u003e \u003cp\u003eCreating Advanced Indexes 379\u003c\/p\u003e \u003cp\u003eCreating a Covering Index 380\u003c\/p\u003e \u003cp\u003eCreating a Filtered Index 381\u003c\/p\u003e \u003cp\u003eManaging Indexes 383\u003c\/p\u003e \u003cp\u003eDropping an Index 384\u003c\/p\u003e \u003cp\u003eDisabling and Enabling Indexes 384\u003c\/p\u003e \u003cp\u003eUnderstanding Index Fragmentation 387\u003c\/p\u003e \u003cp\u003eUnderstanding Views 389\u003c\/p\u003e \u003cp\u003eCreating Views 390\u003c\/p\u003e \u003cp\u003eSummary 392\u003c\/p\u003e \u003cp\u003eChapter Essentials 393\u003c\/p\u003e \u003cp\u003eChapter 12 Triggers and Stored Procedures 395\u003c\/p\u003e \u003cp\u003eTriggers Defined 396\u003c\/p\u003e \u003cp\u003eTypes of Triggers 397\u003c\/p\u003e \u003cp\u003eRecursive and Nested Triggers 398\u003c\/p\u003e \u003cp\u003eUsing Triggers 399\u003c\/p\u003e \u003cp\u003eCreating Triggers 401\u003c\/p\u003e \u003cp\u003eUnderstanding Stored Procedures 406\u003c\/p\u003e \u003cp\u003eCreating Stored Procedures 407\u003c\/p\u003e \u003cp\u003eHow Triggers Differ from Stored Procedures 409\u003c\/p\u003e \u003cp\u003eSummary 409\u003c\/p\u003e \u003cp\u003eChapter Essentials 409\u003c\/p\u003e \u003cp\u003eChapter 13 Implementing Advanced Features 411\u003c\/p\u003e \u003cp\u003eUnderstanding and Installing Analysis Services 413\u003c\/p\u003e \u003cp\u003eAnalysis Services Tools 413\u003c\/p\u003e \u003cp\u003eAnalysis Services Optional Components 415\u003c\/p\u003e \u003cp\u003eInstalling and Configuring Analysis Services 416\u003c\/p\u003e \u003cp\u003eUnderstanding Integration Services 419\u003c\/p\u003e \u003cp\u003eInstalling and Configuring Integration Services 419\u003c\/p\u003e \u003cp\u003eCreating a Basic Integration Services Package 421\u003c\/p\u003e \u003cp\u003eTroubleshooting and Debugging an SSIS Package 427\u003c\/p\u003e \u003cp\u003eScheduling Your Package to Run Automatically 429\u003c\/p\u003e \u003cp\u003eSecurity Protection Levels 431\u003c\/p\u003e \u003cp\u003eUnderstanding and Installing Reporting Services 432\u003c\/p\u003e \u003cp\u003eImplementing Database Mail 436\u003c\/p\u003e \u003cp\u003eConfiguring Full-Text Indexing 439\u003c\/p\u003e \u003cp\u003eImplementing Transparent Data Encryption 441\u003c\/p\u003e \u003cp\u003eTDE Architecture 441\u003c\/p\u003e \u003cp\u003eTDE Implementation Process 442\u003c\/p\u003e \u003cp\u003eData Compression 443\u003c\/p\u003e \u003cp\u003eSummary 444\u003c\/p\u003e \u003cp\u003eChapter Essentials 444\u003c\/p\u003e \u003cp\u003ePart IV Administering and Maintaining SQL Server 2012 447\u003c\/p\u003e \u003cp\u003eChapter 14 Creating Jobs, Operators, and Alerts 449\u003c\/p\u003e \u003cp\u003eStandardize, Automate, and Update 450\u003c\/p\u003e \u003cp\u003eUnderstanding SQL Server Jobs 452\u003c\/p\u003e \u003cp\u003eJob Steps 452\u003c\/p\u003e \u003cp\u003eJob Configuration Properties 454\u003c\/p\u003e \u003cp\u003eTypical Jobs 462\u003c\/p\u003e \u003cp\u003eCreating T-SQL Jobs 465\u003c\/p\u003e \u003cp\u003eCreating SSIS Jobs 470\u003c\/p\u003e \u003cp\u003eCreating Windows Command Jobs 476\u003c\/p\u003e \u003cp\u003eCreating and Using Operators 480\u003c\/p\u003e \u003cp\u003eCreating and Using Alerts 482\u003c\/p\u003e \u003cp\u003eUsing WSUS for SQL Server 2012 487\u003c\/p\u003e \u003cp\u003eSummary 488\u003c\/p\u003e \u003cp\u003eChapter Essentials 488\u003c\/p\u003e \u003cp\u003eChapter 15 Performance Monitoring and Tuning 491\u003c\/p\u003e \u003cp\u003ePerformance Tuning Principles 492\u003c\/p\u003e \u003cp\u003eWhy Performance Tuning Matters 492\u003c\/p\u003e \u003cp\u003eCommon Performance Tuning Myths 494\u003c\/p\u003e \u003cp\u003ePerformance and Troubleshooting Tools 496\u003c\/p\u003e \u003cp\u003eBlocks, Locks, and Deadlocks 497\u003c\/p\u003e \u003cp\u003eUnderstanding Locks 498\u003c\/p\u003e \u003cp\u003eLock Types 498\u003c\/p\u003e \u003cp\u003eGranularity of Locks 498\u003c\/p\u003e \u003cp\u003eLock Isolation Levels 499\u003c\/p\u003e \u003cp\u003eBlocks and Deadlocks 499\u003c\/p\u003e \u003cp\u003eSQL Server Profiler 503\u003c\/p\u003e \u003cp\u003eDatabase Engine Tuning Advisor 506\u003c\/p\u003e \u003cp\u003eCreating a DTA Workload File 506\u003c\/p\u003e \u003cp\u003eAnalyzing Your Workload File 507\u003c\/p\u003e \u003cp\u003eApplying DTA Recommendations 509\u003c\/p\u003e \u003cp\u003ePerformance Monitoring with System Monitor 511\u003c\/p\u003e \u003cp\u003eInstalling the System Monitor 511\u003c\/p\u003e \u003cp\u003eViewing Live Performance Data 512\u003c\/p\u003e \u003cp\u003eLogging Counters in Windows Server 2003 514\u003c\/p\u003e \u003cp\u003eData Collection in Windows Server 2008 515\u003c\/p\u003e \u003cp\u003eUsing the Resource Governor 519\u003c\/p\u003e \u003cp\u003ePerformance Studio 520\u003c\/p\u003e \u003cp\u003eAdvanced Monitoring Tools 523\u003c\/p\u003e \u003cp\u003eDynamic Management Views 523\u003c\/p\u003e \u003cp\u003eDBCC 525\u003c\/p\u003e \u003cp\u003eResource Monitor 527\u003c\/p\u003e \u003cp\u003eSummary 529\u003c\/p\u003e \u003cp\u003eChapter Essentials 530\u003c\/p\u003e \u003cp\u003eChapter 16 Policy-Based Management 533\u003c\/p\u003e \u003cp\u003ePolicy-Based Management 534\u003c\/p\u003e \u003cp\u003ePBM Components 536\u003c\/p\u003e \u003cp\u003eCreating Conditions 550\u003c\/p\u003e \u003cp\u003eCreating Policies 553\u003c\/p\u003e \u003cp\u003eEvaluating Policies 558\u003c\/p\u003e \u003cp\u003eCentralized Server Management 558\u003c\/p\u003e \u003cp\u003eMajor Benefits and Requirements 558\u003c\/p\u003e \u003cp\u003eCreating a Central Management Server 559\u003c\/p\u003e \u003cp\u003eRegistering Subscriber Servers 559\u003c\/p\u003e \u003cp\u003eStandardizing with PBM and CMS 563\u003c\/p\u003e \u003cp\u003eStandardizing 563\u003c\/p\u003e \u003cp\u003eAutomating 564\u003c\/p\u003e \u003cp\u003eUpdating 566\u003c\/p\u003e \u003cp\u003eSummary 567\u003c\/p\u003e \u003cp\u003eChapter Essentials 567\u003c\/p\u003e \u003cp\u003eChapter 17 Backup and Restoration 569\u003c\/p\u003e \u003cp\u003eBacking Up a Database 570\u003c\/p\u003e \u003cp\u003eCreating a Backup Plan 571\u003c\/p\u003e \u003cp\u003eChoosing a Recovery Model 573\u003c\/p\u003e \u003cp\u003eUsing the Different Backup Types 578\u003c\/p\u003e \u003cp\u003eWorking with Backup Devices and Files 584\u003c\/p\u003e \u003cp\u003eCompressing Backups 587\u003c\/p\u003e \u003cp\u003ePerforming File and Filegroup Backups 588\u003c\/p\u003e \u003cp\u003eBacking Up System Databases 588\u003c\/p\u003e \u003cp\u003eRestoring a Database 589\u003c\/p\u003e \u003cp\u003eChoosing a Restore Method 589\u003c\/p\u003e \u003cp\u003eRestoring to a Point in Time 590\u003c\/p\u003e \u003cp\u003eRestoring to the Point of Failure 591\u003c\/p\u003e \u003cp\u003eRestoring System Databases 592\u003c\/p\u003e \u003cp\u003eBacking Up the Environment 593\u003c\/p\u003e \u003cp\u003eBuilt-in Backup Tools 594\u003c\/p\u003e \u003cp\u003eImaging and Third-Party Tools 595\u003c\/p\u003e \u003cp\u003eSummary 596\u003c\/p\u003e \u003cp\u003eChapter Essentials 596\u003c\/p\u003e \u003cp\u003ePart V SQL Server Security 597\u003c\/p\u003e \u003cp\u003eChapter 18 Security Threats and Principles 599\u003c\/p\u003e \u003cp\u003eSecurity Defined 600\u003c\/p\u003e \u003cp\u003eHow to Classify Data for Security Purposes 603\u003c\/p\u003e \u003cp\u003eSecurity in Theory 603\u003c\/p\u003e \u003cp\u003eSecurity in the Real World 605\u003c\/p\u003e \u003cp\u003eSecurity Threats 605\u003c\/p\u003e \u003cp\u003eThreats, Vulnerabilities, and Exploits Defined 606\u003c\/p\u003e \u003cp\u003eAttack Point 1: Windows Server 608\u003c\/p\u003e \u003cp\u003eAttack Point 2: SQL Server 613\u003c\/p\u003e \u003cp\u003eAttack Point 3: The Network 614\u003c\/p\u003e \u003cp\u003eAttack Point 4: The Client 618\u003c\/p\u003e \u003cp\u003eCracking Examples 621\u003c\/p\u003e \u003cp\u003eSecurity Principles 633\u003c\/p\u003e \u003cp\u003eStart with Good Design 634\u003c\/p\u003e \u003cp\u003eTrust, but Monitor 635\u003c\/p\u003e \u003cp\u003eDefense-in-Depth 637\u003c\/p\u003e \u003cp\u003eLeast Privilege 638\u003c\/p\u003e \u003cp\u003eSummary 638\u003c\/p\u003e \u003cp\u003eChapter Essentials 639\u003c\/p\u003e \u003cp\u003eChapter 19 Authentication and Encryption 641\u003c\/p\u003e \u003cp\u003eUnderstanding Authentication 642\u003c\/p\u003e \u003cp\u003eCredentials 644\u003c\/p\u003e \u003cp\u003eCommon Authentication Methods 646\u003c\/p\u003e \u003cp\u003eRegulatory Compliance 648\u003c\/p\u003e \u003cp\u003eSQL Server Authentication Methods 652\u003c\/p\u003e \u003cp\u003eLogins, Users, and Roles 653\u003c\/p\u003e \u003cp\u003eConfiguring the Authentication Mode 653\u003c\/p\u003e \u003cp\u003eCreating and Managing Principals and Roles 655\u003c\/p\u003e \u003cp\u003eCreating Database Users 668\u003c\/p\u003e \u003cp\u003eUnderstanding Encryption 669\u003c\/p\u003e \u003cp\u003eSQL Server Encryption Solutions 669\u003c\/p\u003e \u003cp\u003eImplementing Application-Level Encryption 671\u003c\/p\u003e \u003cp\u003eImplementing Transparent Encryption 673\u003c\/p\u003e \u003cp\u003eSummary 674\u003c\/p\u003e \u003cp\u003eChapter Essentials 675\u003c\/p\u003e \u003cp\u003eChapter 20 Security Best Practices 677\u003c\/p\u003e \u003cp\u003eEstablishing Baselines 678\u003c\/p\u003e \u003cp\u003eWorking with Security Templates 679\u003c\/p\u003e \u003cp\u003eAnalyzing a Server’s Security Settings 686\u003c\/p\u003e \u003cp\u003eUsing the Security Configuration Wizard 688\u003c\/p\u003e \u003cp\u003eImplementing Least Privilege 691\u003c\/p\u003e \u003cp\u003ePermissions and Authorization 692\u003c\/p\u003e \u003cp\u003eOwnership Chains 698\u003c\/p\u003e \u003cp\u003eCredentials 699\u003c\/p\u003e \u003cp\u003eAuditing SQL Server Activity 701\u003c\/p\u003e \u003cp\u003eUsing Audits 701\u003c\/p\u003e \u003cp\u003eNotifications 705\u003c\/p\u003e \u003cp\u003eDDL Triggers 706\u003c\/p\u003e \u003cp\u003eLogon Triggers 706\u003c\/p\u003e \u003cp\u003eConfiguring the Surface Area 707\u003c\/p\u003e \u003cp\u003eSP_Configure for Surface Area Management 707\u003c\/p\u003e \u003cp\u003ePolicy-Based Management Surface Area Options 709\u003c\/p\u003e \u003cp\u003eUnderstanding Common Criteria and C2 712\u003c\/p\u003e \u003cp\u003eGRC 712\u003c\/p\u003e \u003cp\u003eC2 Compliance 713\u003c\/p\u003e \u003cp\u003eCommon Criteria 716\u003c\/p\u003e \u003cp\u003eSummary 717\u003c\/p\u003e \u003cp\u003eChapter Essentials 718\u003c\/p\u003e \u003cp\u003ePart VI Implementing High Availability and Data Distribution 719\u003c\/p\u003e \u003cp\u003eChapter 21 AlwaysOn and High Availability 721\u003c\/p\u003e \u003cp\u003eIntroducing AlwaysOn Technology 722\u003c\/p\u003e \u003cp\u003eUnderstanding High Availability 722\u003c\/p\u003e \u003cp\u003eAlwaysOn Defined 725\u003c\/p\u003e \u003cp\u003eMirroring and AlwaysOn 727\u003c\/p\u003e \u003cp\u003eReplacing Traditional Mirroring 727\u003c\/p\u003e \u003cp\u003eUsing Traditional Mirroring 728\u003c\/p\u003e \u003cp\u003eFailover Solutions 728\u003c\/p\u003e \u003cp\u003eSynchronous-Commit 728\u003c\/p\u003e \u003cp\u003eAsynchronous-Commit 729\u003c\/p\u003e \u003cp\u003eThe Failover Process 729\u003c\/p\u003e \u003cp\u003eSelecting Hardware for AlwaysOn 730\u003c\/p\u003e \u003cp\u003eHighly Available Servers 730\u003c\/p\u003e \u003cp\u003eHighly Available Storage 731\u003c\/p\u003e \u003cp\u003eHighly Available Networks 731\u003c\/p\u003e \u003cp\u003eSummary 732\u003c\/p\u003e \u003cp\u003eChapter Essentials 732\u003c\/p\u003e \u003cp\u003eChapter 22 SQL Server Failover Clustering 733\u003c\/p\u003e \u003cp\u003eUnderstanding Windows Failover Clustering Service 734\u003c\/p\u003e \u003cp\u003eImplementing a Windows Cluster 735\u003c\/p\u003e \u003cp\u003eFailover Clustering Components 735\u003c\/p\u003e \u003cp\u003eThe Failover Clustering Installation Process 738\u003c\/p\u003e \u003cp\u003eInstalling SQL Server 2012 to a Cluster 747\u003c\/p\u003e \u003cp\u003eMonitoring and Managing a SQL Server Cluster 748\u003c\/p\u003e \u003cp\u003eService Packs and Update Management 748\u003c\/p\u003e \u003cp\u003eFailover Management 749\u003c\/p\u003e \u003cp\u003eCluster Troubleshooting 750\u003c\/p\u003e \u003cp\u003eSummary 750\u003c\/p\u003e \u003cp\u003eChapter Essentials 750\u003c\/p\u003e \u003cp\u003eChapter 23 Database Mirroring and Snapshots 753\u003c\/p\u003e \u003cp\u003eRAID-based Data Redundancy 754\u003c\/p\u003e \u003cp\u003eUsing Database Mirroring 757\u003c\/p\u003e \u003cp\u003eDatabase Mirroring Components 758\u003c\/p\u003e \u003cp\u003eUnderstanding Mirror Operating Modes 759\u003c\/p\u003e \u003cp\u003ePlanning for Role Switching 759\u003c\/p\u003e \u003cp\u003eImplementing Database Mirroring 760\u003c\/p\u003e \u003cp\u003eUnderstanding Log Shipping 764\u003c\/p\u003e \u003cp\u003eInside the Log-Shipping Process 764\u003c\/p\u003e \u003cp\u003eConfiguring Log Shipping and Monitoring 766\u003c\/p\u003e \u003cp\u003eImplementing Database Snapshots 768\u003c\/p\u003e \u003cp\u003eDatabase Snapshot Functionality 768\u003c\/p\u003e \u003cp\u003eImplementing a Snapshot 770\u003c\/p\u003e \u003cp\u003eQuerying a Snapshot 770\u003c\/p\u003e \u003cp\u003eReverting to a Snapshot 770\u003c\/p\u003e \u003cp\u003eSummary 771\u003c\/p\u003e \u003cp\u003eChapter Essentials 771\u003c\/p\u003e \u003cp\u003eChapter 24 Implementing Replication 773\u003c\/p\u003e \u003cp\u003eSQL Server Replication 774\u003c\/p\u003e \u003cp\u003eSQL Server Replication Roles and Concepts 775\u003c\/p\u003e \u003cp\u003eReplication Types 775\u003c\/p\u003e \u003cp\u003eReplication Models 778\u003c\/p\u003e \u003cp\u003eNew Features in SQL Server 2012 778\u003c\/p\u003e \u003cp\u003eConfiguring a Publisher and Distributor 779\u003c\/p\u003e \u003cp\u003eConfiguring a Subscriber 787\u003c\/p\u003e \u003cp\u003eMonitoring Replication 790\u003c\/p\u003e \u003cp\u003eReplication Performance 790\u003c\/p\u003e \u003cp\u003eReplication Recovery 791\u003c\/p\u003e \u003cp\u003eImporting and Exporting Data 791\u003c\/p\u003e \u003cp\u003eUsing BCP 792\u003c\/p\u003e \u003cp\u003eBulk Insert Commands 793\u003c\/p\u003e \u003cp\u003eUsing SQL Server Integration Services 795\u003c\/p\u003e \u003cp\u003eSummary 797\u003c\/p\u003e \u003cp\u003eChapter Essentials 798\u003c\/p\u003e \u003cp\u003ePart VII Implementing Business Intelligence and Reporting 799\u003c\/p\u003e \u003cp\u003eChapter 25 Data Warehousing 801\u003c\/p\u003e \u003cp\u003eUnderstanding Data Warehouses 802\u003c\/p\u003e \u003cp\u003eDefining Terminology 803\u003c\/p\u003e \u003cp\u003eDefining Usage 805\u003c\/p\u003e \u003cp\u003eImplementing Fact Tables 806\u003c\/p\u003e \u003cp\u003eUnderstanding and Planning for Fact Tables 806\u003c\/p\u003e \u003cp\u003eCreating Fact Tables 807\u003c\/p\u003e \u003cp\u003eImplementing Dimensions 808\u003c\/p\u003e \u003cp\u003eUnderstanding and Planning for Dimensions 808\u003c\/p\u003e \u003cp\u003eCreating Dimensions 810\u003c\/p\u003e \u003cp\u003eSummary 811\u003c\/p\u003e \u003cp\u003eChapter Essentials 811\u003c\/p\u003e \u003cp\u003eChapter 26 SQL Server Integration Services 813\u003c\/p\u003e \u003cp\u003eIntegration Issues 814\u003c\/p\u003e \u003cp\u003eExisting Systems 814\u003c\/p\u003e \u003cp\u003eExisting Data 815\u003c\/p\u003e \u003cp\u003eCo-existence 816\u003c\/p\u003e \u003cp\u003eInstalling SSIS 816\u003c\/p\u003e \u003cp\u003eProviding Prerequisites 816\u003c\/p\u003e \u003cp\u003eInstalling the SSIS Components 817\u003c\/p\u003e \u003cp\u003eDevelopment vs. Production Servers 817\u003c\/p\u003e \u003cp\u003eConfiguring SSIS for Operations 818\u003c\/p\u003e \u003cp\u003eConfiguring SSIS Security Settings 819\u003c\/p\u003e \u003cp\u003eSSIS Service 819\u003c\/p\u003e \u003cp\u003eSSIS Roles 820\u003c\/p\u003e \u003cp\u003eAccess Control 821\u003c\/p\u003e \u003cp\u003eDigital Signatures 821\u003c\/p\u003e \u003cp\u003eDeploying Packages 823\u003c\/p\u003e \u003cp\u003eWorking with the SSIS Catalog 823\u003c\/p\u003e \u003cp\u003eUsing the Deployment Utility 824\u003c\/p\u003e \u003cp\u003eDeploying to SQL Server or Files 825\u003c\/p\u003e \u003cp\u003eUsing DTUTIL 826\u003c\/p\u003e \u003cp\u003eSSIS Auditing and Event Handling 826\u003c\/p\u003e \u003cp\u003eAuditing Packages 826\u003c\/p\u003e \u003cp\u003eUsing Log Providers 827\u003c\/p\u003e \u003cp\u003eUsing Event Handlers 828\u003c\/p\u003e \u003cp\u003eExtracting, Transforming, and Loading Data 828\u003c\/p\u003e \u003cp\u003eConnection Managers 829\u003c\/p\u003e \u003cp\u003eData Flow Design 831\u003c\/p\u003e \u003cp\u003eUnderstanding Data Load Options 833\u003c\/p\u003e \u003cp\u003eUsing Script Tasks 835\u003c\/p\u003e \u003cp\u003eSummary 836\u003c\/p\u003e \u003cp\u003eChapter Essentials 836\u003c\/p\u003e \u003cp\u003eChapter 27 Data Quality Solutions 837\u003c\/p\u003e \u003cp\u003eUnderstanding Data Quality Concerns 838\u003c\/p\u003e \u003cp\u003eData Quality Problems 838\u003c\/p\u003e \u003cp\u003eData Quality Dimensions 839\u003c\/p\u003e \u003cp\u003eData Quality Processes 839\u003c\/p\u003e \u003cp\u003eInstalling Data Quality Services 840\u003c\/p\u003e \u003cp\u003ePrerequisites 840\u003c\/p\u003e \u003cp\u003ePerforming the Installation 841\u003c\/p\u003e \u003cp\u003eData Governance 842\u003c\/p\u003e \u003cp\u003eUsing Master Data Services 843\u003c\/p\u003e \u003cp\u003eInstalling and Implementing MDS 843\u003c\/p\u003e \u003cp\u003eCreating MDS Objects 844\u003c\/p\u003e \u003cp\u003eCleaning Data 845\u003c\/p\u003e \u003cp\u003eProfiling Systems 845\u003c\/p\u003e \u003cp\u003eKnowledge Base Management 846\u003c\/p\u003e \u003cp\u003eCreating the Project 847\u003c\/p\u003e \u003cp\u003eSummary 848\u003c\/p\u003e \u003cp\u003eChapter Essentials 848\u003c\/p\u003e \u003cp\u003eAppendices 849\u003c\/p\u003e \u003cp\u003eAppendix A Microsoft’s Certification Program 851\u003c\/p\u003e \u003cp\u003eHow Do You Become Certified on SQL Server 2012? 852\u003c\/p\u003e \u003cp\u003eTips for Taking a Microsoft Exam 853\u003c\/p\u003e \u003cp\u003eExam Registration 853\u003c\/p\u003e \u003cp\u003eCertification Objectives Map 854\u003c\/p\u003e \u003cp\u003eAppendix B About the Additional Study Tools 859\u003c\/p\u003e \u003cp\u003eAdditional Study Tools 860\u003c\/p\u003e \u003cp\u003eVideos 860\u003c\/p\u003e \u003cp\u003eSybex Test Engine 860\u003c\/p\u003e \u003cp\u003eElectronic Flashcards 860\u003c\/p\u003e \u003cp\u003eGlossary of Terms 860\u003c\/p\u003e \u003cp\u003eAdobe Reader 861\u003c\/p\u003e \u003cp\u003eSystem Requirements 861\u003c\/p\u003e \u003cp\u003eUsing the Study Tools 861\u003c\/p\u003e \u003cp\u003eTroubleshooting 861\u003c\/p\u003e \u003cp\u003eCustomer Care 862\u003c\/p\u003e \u003cp\u003eIndex 863\u003c\/p\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"John Wiley \u0026 Sons Inc","offers":[{"title":"Default Title","offer_id":49406878187863,"sku":"9781118487167","price":41.25,"currency_code":"GBP","in_stock":false}],"url":"https:\/\/bookcurl.com\/products\/microsoft-sql-server-2012-administration-9781118487167","provider":"Book Curl","version":"1.0","type":"link"}