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

Chapter 18

SQL Server 2012 Log Shipping

WHAT’S IN THIS CHAPTER

Overview of Log Shipping
Practical Usage Scenarios
Log Shipping Architecture
Log Shipping Deployment
Role Changing within Log Shipping
Monitoring and Troubleshooting

Log shipping is a low-cost, efficient, and simple SQL Server technique that became available many releases ago and has been vital to organizations for their business continuity. In log shipping, the database transaction log from one SQL Server is backed up and restored onto a secondary SQL Server, where it is often deployed for high-availability, reporting, and disaster-recovery scenarios. Beginning with SQL Server 2005, log shipping delivers business continuity and is one of the high-availability solutions to maintain a warm standby and, with a secondary server, used for failover.

This chapter covers log-shipping architecture and deployment scenarios and discusses how to configure log shipping and the various scenarios for switching roles between the primary and secondary servers. You also learn how to troubleshoot your log-shipping setup and how to integrate log shipping with other high-availability solutions.

SQL Server 2008 Enterprise Edition only supports backup compression. Since SQL Server 2008 R2 both Standard Edition and Enterprise Edition support backup compression.

LOG SHIPPING DEPLOYMENT SCENARIOS

Log shipping takes advantage of the transaction-log ...

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.