book

Professional Microsoft SQL Server 2012 Administration

Name: Professional Microsoft SQL Server 2012 Administration
ISBN: 9781118106884

by Brian Knight, Adam Jorgensen, Steven Wort, Ross LoForte

April 2012

Beginner

960 pages

28h 33m

English

Wrox

Read now

Unlock full access

Cover
Contents
Chapter 1: SQL Server 2012 Architecture
SQL Server 2012 EcosystemNew Important Features in 2012SQL Server ArchitectureEditions of SQL ServerSummary
Chapter 2: Installing SQL Server 2012 Best Practices
Planning the SystemInstalling SQL ServerInstalling Analysis ServicesInstalling PowerPivot for SharePointBurning in the SystemPost-Install ConfigurationUninstalling SQL ServerTroubleshooting a Failed InstallSummary
Chapter 3: Upgrading SQL Server 2012 Best Practices
Why Upgrade to SQL Server 2012?Upgrading to SQL Server 2012Pre-Upgrade Steps and ToolsBackward CompatibilitySQL Server Component ConsiderationsPost-Upgrade ChecksSummary
Chapter 4: Managing and Troubleshooting the Database Engine
Configuration and Administration ToolsTroubleshooting ToolsManagement StudioMonitoring Processes in T-SQLMultiserver ManagementTrace FlagsGetting Help from SupportSummary
Chapter 5: Automating SQL Server
Maintenance PlansAutomating SQL Server with SQL Server AgentSQL Server Agent SecurityConfiguring SQL Server AgentDatabase MailMultiserver AdministrationSummary
Chapter 6: Service Broker in SQL Server 2012
Asynchronous MessagingConfiguring SQL Server Service BrokerUsing SQL Server Service BrokerSummary
Chapter 7: SQL Server CLR Integration
Introduction to the CLRCreating CLR AssembliesSecuring CLRPerformance MonitoringSummary
Chapter 8: Securing the Database Instance
Authentication TypesAuthorizing SecurablesRow Level SecuritySummary

Chapter 9: Change Management
Creating Solutions and ProjectsPolicy-Based ManagementDDL Trigger SyntaxTrigger ViewsScripting OverviewCreating Change ScriptsData-Tier ApplicationsSummary
Chapter 10: Configuring the Server for Optimal Performance
What Every DBA Needs to Know About PerformanceWhat the Developer DBA Needs to Know About PerformanceWhat the Production DBA Needs to Know About PerformanceCPUMemoryI/OSummary
Chapter 11: Optimizing SQL Server 2012
Application OptimizationThe Silent Killer: I/O ProblemsTable and Index PartitioningData CompressionCPU ConsiderationsMemory Considerations and EnhancementsResource GovernorSummary
Chapter 12: Monitoring Your SQL Server
The Goal of MonitoringChoosing the Appropriate Monitoring ToolsPerformance MonitorMonitoring EventsMonitoring with Dynamic Management Views and FunctionsMonitoring LogsManagement Data WarehouseSQL Server Standard ReportsSystem Center Management PackSQL Server Best Practice AnalyzerSystem Center AdvisorSummary
Chapter 13: Performance Tuning T-SQL
Physical Query Processing Part One: Compilation and RecompilationPhysical Query Processing Part Two: ExecutionSummary
Chapter 14: Indexing Your Database
Noteworthy Index-Related Features in SQL ServerPartitioned Tables and IndexesIndex MaintenanceImproving Query Performance with IndexesDatabase Tuning AdvisorToo Many Indexes?Summary
Chapter 15: Replication
Replication OverviewReplication ModelsImplementing ReplicationPeer-to-Peer ReplicationScripting ReplicationMonitoring ReplicationSummary
Chapter 16: Clustering SQL Server 2012
Clustering and Your OrganizationClustering: The Big PictureUpgrading SQL Server ClusteringGetting Prepared for ClusteringClustering Windows Server 2008Clustering Microsoft Distributed Transaction CoordinatorClustering SQL Server 2012Managing and Monitoring the ClusterTroubleshooting Cluster ProblemsSummary
Chapter 17: Backup and Recovery
Types of FailureMaking PlansOverview of Backup and RestorePreparing for RecoveryDeveloping and Executing a Backup PlanManaging BackupsBackup and Restore PerformancePerforming RecoveryArchiving DataSummary
Chapter 18: SQL Server 2012 LOG Shipping
Log Shipping Deployment ScenariosLog-Shipping ArchitectureLog Shipping ProcessSystem RequirementsDeploying Log ShippingMonitoring and TroubleshootingManaging Changing RolesDatabase Backup PlanIntegrating Log Shipping with Other High-Availability SolutionsRemoving Log ShippingLog-Shipping PerformanceUpgrading to SQL Server 2012 Log ShippingSummary
Chapter 19: Database Mirroring
Overview of Database MirroringOperating Modes of Database MirroringDatabase Mirroring In ActionDatabase Mirroring and SQL Server 2012 EditionsDatabase Mirroring Catalog ViewsDatabase Mirroring Role ChangeDatabase Availability ScenariosMonitoring Database MirroringTroubleshooting Database MirroringPreparing the Mirror Server for FailoverMirroring Multiple DatabasesDatabase Mirroring and Other High-Availability SolutionsMirroring Event Listener SetupDatabase SnapshotsSummary
Chapter 20: Integration Services Administration and Performance Tuning
A Tour of Integration ServicesAdministration of the Integration Services ServiceAdministration of Integration Services Packages in Package Deployment ModelAdministration of Integration Services Packages in Project Deployment ModelExecution and SchedulingApplying Security to Integration ServicesSummary
Chapter 21: Analysis Services Administration and Performance Tuning
Tour of Analysis ServicesAdministering Analysis Services ServerAdministering Analysis Services DatabasesAnalysis Services Performance Monitoring and TuningManagement of Analysis Services MOLAP Model StorageApplying Security to Analysis Services in the MOLAP ModelSummary
Chapter 22: SQL Server Reporting Services Administration
SQL Server Reporting Services Configuration ManagerReport Server PropertiesThe Report Execution LogReport BuilderReport ManagerSummary
Chapter 23: SQL Server 2012 Sharepoint 2010 Integration
Components of IntegrationData Refresh
Chapter 24: SQL Azure Administration and Configuration
Introduction to SQL AzureSQL Azure ArchitectureConfiguring SQL AzureAdministering SQL AzureWorking with SQL AzureWhat’s Missing in SQL AzureSummary
Chapter 25: Alwayson Availability Groups
ArchitectureAvailability Group ExampleActive Secondary for Secondary Read-OnlyBackup on the Secondary ReplicaAlwaysOn Group DashboardMonitoring and TroubleshootingSummary
Introduction
Advertisement

Content preview from Professional Microsoft SQL Server 2012 Administration

CONTENTS

Chapter 1: SQL Server 2012 Architecture

SQL Server 2012 Ecosystem

New Important Features in 2012

SQL Server Architecture

Editions of SQL Server

Summary

Chapter 2: Installing SQL Server 2012 Best Practices

Planning the System

Installing SQL Server

Installing Analysis Services

Installing PowerPivot for SharePoint

Burning in the System

Post-Install Configuration

Uninstalling SQL Server

Troubleshooting a Failed Install

Summary

Chapter 3: Upgrading SQL Server 2012 Best Practices

Why Upgrade to SQL Server 2012?

Upgrading to SQL Server 2012

Pre-Upgrade Steps and Tools

Backward Compatibility

SQL Server Component Considerations

Post-Upgrade Checks

Summary

Chapter 4: Managing and Troubleshooting the Database Engine

Configuration and Administration Tools

Troubleshooting Tools

Management Studio

Monitoring Processes in T-SQL

Multiserver Management

Trace Flags

Getting Help from Support

Summary

Chapter 5: Automating SQL Server

Maintenance Plans

Automating SQL Server with SQL Server Agent

SQL Server Agent Security

Configuring SQL Server Agent

Database Mail

Multiserver Administration

Summary

Chapter 6: Service Broker in SQL Server 2012

Asynchronous Messaging

Configuring SQL Server Service Broker

Using SQL Server Service Broker

Summary

Chapter 7: SQL Server CLR Integration

Introduction to the CLR

Creating CLR Assemblies

Securing CLR

Performance Monitoring

Summary

Chapter 8: Securing the Database Instance

Authentication Types

Authorizing Securables

Row Level Security

Summary

Chapter 9: ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Professional Microsoft SQL Server 2012 Integration Services

Publisher Resources

ISBN: 9781118106884Purchase book Downloads

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Professional Microsoft SQL Server 2012 Administration

by Brian Knight, Adam Jorgensen, Steven Wort, Ross LoForte

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.