Return to home page
Searching: Muskingum library catalog
In response to the COVID-19 outbreak, statewide lending via OhioLINK and SearchOhio has been suspended. OPAL member libraries have closed or are operating at reduced service levels. Please contact your library with specific lending requests or if you need assistance.

LEADER 00000cam  2200649Mi 4500 
001    801987339 
003    OCoLC 
005    20181116042147.6 
006    m     o  d         
007    cr zn||||||||| 
008    120607s2012    inua    o     000 0 eng d 
019    810072337|a1055400076 
020    9781118286845|q(electronic bk.) 
020    1118286847|q(electronic bk.) 
020    9781118282182|q(electronic bk.) 
020    1118282183|q(electronic bk.) 
020    9781118283882|q(electronic bk.) 
020    1118283880|q(electronic bk.) 
020    1118106881 
020    9781118106884 
020    |z9781118106884 
035    (OCoLC)801987339|z(OCoLC)810072337|z(OCoLC)1055400076 
037    CL0500000166|bSafari Books Online 
040    B24X7|beng|epn|erda|cB24X7|dOCLCO|dUMI|dCOO|dC6I|dYDXCP
049    MAIN 
050  4 QA76.9.D3|bP76 2012eb 
072  7 COM|x018000|2bisacsh 
082 04 005.75/85|223 
245 00 Professional Microsoft SQL Server 2012 administration /
       |cAdam Jorgensen [and others] ; technical editors, Jason 
       Strate, Denny Cherry. 
264  1 Indianapolis, Ind. :|bJohn Wiley & amp ;|aSons,|c2012. 
300    1 online resource. 
336    text|btxt|2rdacontent 
337    computer|bc|2rdamedia 
338    online resource|bcr|2rdacarrier 
347    text file|2rdaft|0
490 0  Wrox programmer to programmer 
505 00 |gMachine generated contents note:|gch. 1|tSQL Server 2012
       Architecture --|tSQL Server 2012 Ecosystem --|tNew 
       Important Features in 2012 --|tProduction DBA --
       |tDevelopment DBA --|tBusiness Intelligence DBA and 
       Developer --|tSQL Server Architecture --|tDatabase Files 
       and Transaction Log --|tSQL Native Client --|tStandard 
       System Databases --|tSchemas --|tSynonyms --|tDynamic 
       Management Objects --|tSQL Server 2012 Data Types --
       |tEditions of SQL Server --|tEdition Overview --
       |tLicensing --|tSummary --|gch. 2|tInstalling SQL Server 
       2012 Best Practices --|tPlanning the System --|tHardware 
       Options --|tSoftware and Install Options --|tInstalling 
       SQL Server --|tNew Installs --|tSide-by-Side Installs --
       |tUpgrades --|tUnattended Installs --|tAttended 
       Installations --|tInstalling Analysis Services --
       |tMultidimensional and Data Mining Mode (UDM Mode) --
       |tTabular Mode --|tInstalling Power Pivot for SharePoint -
       -|tBurning in the System --|tPost-Install Configuration --
       |tConfiguring SQL Server Settings for Performance --
       |ttempdb --|tConfiguring SQL Server Setting for Security -
       -|tBest Practices Analyzer (BPA) --|tSQL Server 
       Configuration Manager --|tBack It Up --|tUninstalling SQL 
       Server --|tUninstalling Reporting Services --
       |tUninstalling Analysis Services --|tUninstalling the SQL 
       Server Database Engine --|tTroubleshooting a Failed 
       Install --|tSummary --|gch. 3|tUpgrading SQL Server 2012 
       Best Practices --|tWhy Upgrade to SQL Server 2012? --
       |tRisk Mitigation -- the Microsoft Contribution --
       |tIndependent Software Vendors and SQL Community 
       Contributions --|tUpgrading to SQL Server 2012 --|tIn-
       Place Upgrading --|tSide-by-Side Upgrade --|tIn-Place 
       Upgrade versus Side-By-Side Upgrade Considerations --|tPre
       -Upgrade Steps and Tools --|tPre-Upgrade Steps --|tPre-
       Upgrade Tools --|tBackward Compatibility --|tUnsupported 
       and Discontinued Features in SQL Server 2012 --|tSQL 
       Server 2012 Deprecated Database Features --|tOther SQL 
       Server 2012 Changes Affecting Behavior --|tSQL Server 
       Component Considerations --|tUpgrading Full-Text Catalog -
       -|tUpgrading Reporting Services --|tUpgrading to 64-Bit --
       |tPost-Upgrade Checks --|tPoor Query Performance After 
       Upgrade --|tSummary --|gch. 4|tManaging and 
       Troubleshooting the Database Engine --|tConfiguration and 
       Administration Tools --|tSQL Server Configuration Manager 
       --|tStartup Parameters --|tStartup Stored Procedures --
       |tPartially Contained Databases --|tTroubleshooting Tools 
       --|tDedicated Administrator Connection --|tRebuilding the 
       System Databases --|tManagement Studio --|tReports --
       |tConfiguring SQL Server in Management Studio --
       |tFiltering Objects --|tError Logs --|tActivity Monitor --
       |tMonitoring Processes in T-SQL --|tsp_who and sp_who2 --
       |tsys.dm_exec_connections --|tsys.dm_exec_sql_text --
       |tMultiserver Management --|tCentral Management Servers 
       and Server Groups --|tSQL Server Utility --|tTrace Flags -
       -|tGetting Help from Support --|tSQLDumper.exe --
       |tSQLDiag.exe --|tSummary --|gch. 5|tAutomating SQL Server
       --|tMaintenance Plans --|tMaintenance Plan Wizard --
       |tMaintenance Plan Designer --|tAutomating SQL Server with
       SQL Server Agent --|tJobs --|tSchedules --|tOperators --
       |tAlerts --|tSQL Server Agent Security --|tService Account
       --|tAccess to SQL Agent --|tSQL Server Agent Proxies --
       |tConfiguring SQL Server Agent --|tGeneral Properties --
       |tAdvanced Properties --|tAlert System Properties --|tJob 
       System Properties --|tConnection Properties --|tHistory 
       Properties --|tDatabase Mail --|tArchitecture --|tSecurity
       --|tConfiguration --|tArchiving --|tMultiserver 
       Administration --|tUsing Token Replacement --|tEvent 
       Forwarding --|tUsing WMI --|tMultiserver Administration --
       Using Master and Target Servers --|tSummary --|gch. 6
       |tService Broker in SQL Server 2012 --|tAsynchronous 
       Messaging --|tSQL Service Broker Overview --|tSQL Server 
       Service Broker Versus Other Message Queues --|tConfiguring
       SQL Server Service Broker --|tEnabling --|tMessage Types -
       -|tContracts --|tQueues --|tServices --|tRoutes --
       |tPriorities --|tConversation Groups --|tUsing SQL Server 
       Service Broker --|tSending Messages --|tReceiving Messages
       --|tSending Messages Between Databases --|tSending 
       Messages Between Instances --|tExternal Activation --
       |tSummary --|gch. 7|tSol Server CLR Integration --
       |tIntroduction to the CLR --|tSQL Server as a .NET Runtime
       Host --|tApplication Domains --|tT-SQL versus CLR --
       |tEnabling CLR Integration --|tCreating CLR Assemblies --
       |tNon-Visual Studio Way --|tUsing Microsoft SQL Server 
       Data Tools --|tSecuring CLR --|tPerformance Monitoring --
       |tWindows System Monitor --|tSQL Profiler --|tDynamic 
       Management Views (DMVs) --|tCLR Integration Design Goals -
       -|tSummary --|gch. 8|tSecuring the Database Instance --
       |tAuthentication Types --|tSQL Authentication --|tWindows 
       Authentication --|tSQL Versus Windows Authentication --
       |tAuthorizing Securables --|tServer Securables --
       |tDatabase Securables --|tPermission Chains --|tCross 
       Database Permission Chains --|tRow Level Security --
       |tSummary --|gch. 9|tChange Management --|tCreating 
       Solutions and Projects --|tCreating a Connection --
       |tCreating a Project Query --|tPolicy-Based Management --
       |tPolicy-Based Management Overview --|tPolicy-Based 
       Management Step by Step --|tScripting Policy-Based 
       Management --|tPolicy-Based Management Implementation --
       |tDDL Trigger Syntax --|tDatabase Triggers --|tServer 
       Triggers --|tTrigger Views --|tScripting Overview --
       |tsqlcmd --|tPowerShell --|tCreating Change Scripts --
       |tData-Tier Applications --|tSQL Server Data Tools --
       |tVersion Tables --|tSummary --|gch. 10|tConfiguring the 
       Server for Optimal Performance --|tWhat Every DBA Needs to
       Know About Performance --|tPerformance Tuning Cycle --
       |tDefining Good Performance --|tFocus on What's Most 
       Important --|tWhat the Developer DBA Needs to Know About 
       Performance --|tUsers --|tSQL Statements --|tData Usage 
       Patterns --|tRobust Schema --|tWhat the Production DBA 
       Needs to Know About Performance --|tOptimizing the Server 
       --|tHardware Management --|tCPU --|tx64 --|tCache --
       |tHyper-threading --|tMulticore --|tSystem Architecture --
       |tMemory --|tPhysical Memory --|tPhysical Address Space --
       |tVirtual Memory Manager --|tPage File --|tPage Faults --
       |tI/O --|tNetwork --|tDisks --|tStorage Considerations --
       |tDesigning a Storage System --|tLarge Storage System 
       Considerations: SAN Systems --|tServer Configuration --
       |tFragmentation --|tSummary --|gch. 11|tOptimizing SQL 
       Server 2012 --|tApplication Optimization --|tDefining a 
       Workload --|tSystem Harmony Is the Goal --|tSilent Killer:
       I/O Problems --|tSQL Server I/O Process Model --|tDatabase
       File Placement --|ttempdb Considerations --|tTable and 
       Index Partitioning --|tWhy Consider Partitioning? --
       |tCreating a Partition Function --|tCreating Filegroups --
       |tCreating a Partition Scheme --|tCreating Tables and 
       Indexes --|tData Compression --|tRow Compression --|tPage 
       Compression --|tEstimating Space Savings --|tMonitoring 
       Data Compression --|tData Compression Considerations --
       |tCPU Considerations --|tCache Coherency --|tAffinity Mask
       --|tMax Degree of Parallelism (MAXDOP) --|tAffinity I/O 
       Mask --|tMemory Considerations and Enhancements --|tTuning
       SQL Server Memory --|t64-bit Versions of SQL Server 2012 -
       -|tData Locality --|tMax Server Memory --|tIndex Creation 
       Memory Option --|tMinimum Memory per Query --|tResource 
       Governor --|tBasic Elements of Resource Governor --|tUsing
       Resource Governor from SQL Server 2012 Management Studio -
       -|tMonitoring Resource Governor --|tSummary --|gch. 
505 00 |t12|tMonitoring Your SQL Server --|tGoal of Monitoring --
       |tDetermining Your Monitoring Objectives --|tEstablishing 
       a Baseline --|tComparing Current Metrics to the Baseline -
       -|tChoosing the Appropriate Monitoring Tools --
       |tPerformance Monitor --|tCPU Resource Counters --|tDisk 
       Activity --|tMemory Usage --|tPerformance Monitoring Tools
       --|tMonitoring Events --|tDefault Trace --|tsystem_health 
       Session --|tSQL Trace --|tEvent Notifications --|tSQL 
       Server Extended Events --|tMonitoring with Dynamic 
       Management Views and Functions --|tWhat's Going on Inside 
       SQL Server? --|tViewing the Locking Information --
       |tViewing Blocking Information --|tIndex Usage in a 
       Database --|tIndexes Not Used in a Database --|tView 
       Queries Waiting for Memory Grants --|tConnected User 
       Information --|tFilegroup Free Space --|tQuery Plan and 
       Query Text for Currently Running Queries --|tMemory Usage 
       --|tBuffer Pool Memory Usage --|tMonitoring Logs --
       |tMonitoring the SQL Server Error Log --|tMonitoring the 
       Windows Event Logs --|tManagement Data Warehouse --
       |tSystem Data Collection Sets --|tViewing Data Collected 
       by the System Data Collection Sets --|tCreating Your Own 
       Data Collection Set --|tExamining the Data You Collected -
       -|tSQL Server Standard Reports --|tSystem Center 
       Management Pack --|tSQL Server Best Practice Analyzer --
       |tSystem Center Advisor --|tSummary --|gch. 13
       |tPerformance Tuning T-SQL --|tPhysical Query Processing 
       Part One: Compilation and Recompilation --|tCompilation --
       |tRecompilation --|tTools and Commands for Recompilation 
       Scenarios --|tParser and Algebrizer --|tOptimization --
       |tPhysical Query Processing Part Two: Execution --
       |tDatabase I/O Information --|tWorking with the Query Plan
       --|tEstimated Execution Plan --|tActual Execution Plan --
       |tIndex Access Methods --|tFragmentation --|tStatistics --
       |tJoin Algorithms --|tData Modification Query Plan --
       |tQuery Processing Enhancements on Partitioned Tables and 
       Indexes --|tGathering Query Plans for Analysis with SQL 
       Trace --|tSummary --|gch. 14|tIndexing Your Database --
       |tNoteworthy Index-Related Features in SQL Server --
       |tWhat's New for Indexes in SQL Server 2012. 
505 00 |gNote continued:|tIndex Features from SQL Server 2008R2, 
       SQL Server 2008, and SQL Server 2005 --|tPartitioned 
       Tables and Indexes --|tUnderstanding Indexes --|tCreating 
       Indexes --|tWhy Use Both Partitioned Tables and Indexes? -
       -|tCreating Partitioned Tables --|tIndex Maintenance --
       |tMonitoring Index Fragmentation --|tCleaning Up Indexes -
       -|tImproving Query Performance with Indexes --|tDatabase 
       Tuning Advisor --|tToo Many Indexes? --|tSummary --|gch. 
       15|tReplication --|tReplication Overview --|tReplication 
       Components --|tReplication Types --|tReplication 
       Enhancements in SQL Server 2012 --|tReplication Models --
       |tSingle Publisher, One or More Subscribers --|tMultiple 
       Publishers, Single Subscriber --|tMultiple Publishers Also
       Subscribing --|tUpdating Subscriber --|tPeer-to-Peer --
       |tImplementing Replication --|tSetting Up Snapshot 
       Replication --|tSetting Up Distribution --|tImplementing 
       Snapshot Replication --|tImplementing Transactional and 
       Merge Replication --|tPeer-to-Peer Replication --|tSetting
       Up Peer-to-Peer Replication --|tConfiguring Peer-to-Peer 
       Replication --|tScripting Replication --|tMonitoring 
       Replication --|tReplication Monitor --|tPerformance 
       Monitor --|tReplication DMVs --|tsp_replcounters --
       |tSummary --|gch. 16|tClustering SQL Server 2012 --
       |tClustering and Your Organization --|tWhat Clustering Can
       Do --|tWhat Clustering Cannot Do --|tChoosing SQL Server 
       2012 Clustering for the Right Reasons --|tAlternatives to 
       Clustering --|tClustering: The Big Picture --|tHow 
       Clustering Works --|tClustering Options --|tUpgrading SQL 
       Server Clustering --|tDon't Upgrade --|tUpgrading Your SQL
       Server 2012 Cluster In Place --|tRebuilding Your Cluster -
       -|tBack-Out Plan --|tWhich Upgrade Option Is Best? --
       |tGetting Prepared for Clustering --|tPreparing the 
       Infrastructure --|tPreparing the Hardware --|tClustering 
       Windows Server 2008 --|tBefore Installing Windows 2011 
       Clustering --|tInstalling Windows Server 2008 Failover 
       Clustering --|tPreparing Windows Server 2008 for 
       Clustering --|tClustering Microsoft Distributed 
       Transaction Coordinator --|tClustering SQL Server 2012 --
       |tStep by Step to Cluster SQL Server --|tInstalling the 
       Service Pack and Cumulative Updates --|tTest, Test, and 
       Test Again --|tManaging and Monitoring the Cluster --
       |tTroubleshooting Cluster Problems --|tHow to Approach 
       Windows Failover Clustering Troubleshooting --|tDoing It 
       Right the First Time --|tGathering Information --
       |tResolving Problems --|tWorking with Microsoft --
       |tSummary --|gch. 17|tBackup and Recovery --|tTypes of 
       Failure --|tHardware Failure --|tData Modification Failure
       --|tSoftware Failure --|tLocal Disasters --|tMaking Plans 
       --|tBackup/Recovery Plan --|tDisaster Recovery Planning --
       |tCreating the Disaster Recovery Plan --|tMaintaining the 
       Plan --|tOverview of Backup and Restore --|tHow Backup 
       Works --|tCopying Databases --|tBackup Compression --
       |tComparing Recovery Models --|tChoosing a Model --
       |tSwitching Recovery Models --|tBacking Up History Tables 
       --|tPermissions Required for Backup and Restore --
       |tBacking Up System Databases --|tFull-Text Backup --
       |tVerifying the Backup Images --|tHow Restore Works --
       |tPreparing for Recovery --|tRecoverability Requirements -
       -|tData Usage Patterns --|tMaintenance Time Window --
       |tOther High-Availability Solutions --|tDeveloping and 
       Executing a Backup Plan --|tUsing SQL Server Management 
       Studio --|tDatabase Maintenance Plans --|tUsing Transact-
       SQL Backup Commands --|tManaging Backups --|tBackup and 
       Restore Performance --|tPerforming Recovery --|tRestore 
       Process --|tSQL Server Management Studio Restore --|tT-SQL
       Restore Command --|tRestoring System Databases --
       |tArchiving Data --|tSQL Server Table Partitioning --
       |tPartitioned View --|tSummary --|gch. 18|tSQL Server 2012
       Log Shipping --|tLog Shipping Deployment Scenarios --|tLog
       Shipping to Create a Warm Standby Server --|tLog Shipping 
       as a Disaster Recovery Solution --|tLog Shipping as a 
       Report Database Solution --|tLog-Shipping Architecture --
       |tPrimary Server --|tSecondary Server --|tMonitor Server -
       -|tLog Shipping Process --|tSystem Requirements --
       |tNetwork --|tIdentical Capacity Servers --|tStorage --
       |tSoftware --|tDeploying Log Shipping --|tInitial 
       Configuration --|tDeploying with Management Studio --
       |tDeploying with T-SQL Commands --|tMonitoring and 
       Troubleshooting --|tMonitoring with Management Studio --
       |tMonitoring with Stored Procedures --|tTroubleshooting 
       Approach --|tManaging Changing Roles --|tSynchronizing 
       Dependencies --|tSwitching Roles from the Primary to 
       Secondary Servers --|tSwitching Between Primary and 
       Secondary Servers --|tRedirecting Clients to Connect to 
       the Secondary Server --|tDatabase Backup Plan --
       |tIntegrating Log Shipping with Other High-Availability 
       Solutions --|tSQL Server 2012 Data Mirroring --|tWindows 
       Failover Clustering --|tSQL Server 2012 Replication --
       |tRemoving Log Shipping --|tRemoving Log Shipping with 
       Management Studio --|tRemoving Log Shipping with T-SQL 
       Commands --|tLog-Shipping Performance --|tUpgrading to SQL
       Server 2012 Log Shipping --|tMinimum Downtime Approach --
       |tWith Downtime Approach --|tDeploy Log Shipping Approach 
       --|tSummary --|gch. 19|tDatabase Mirroring --|tOverview of
       Database Mirroring --|tOperating Modes of Database 
       Mirroring --|tDatabase Mirroring In Action --|tPreparing 
       the Endpoints --|tPreparing the Database for Mirroring --
       |tInitial Synchronization Between Principal and Mirror --
       |tEstablishing the Mirroring Session --|tHigh-Safety 
       Operating Mode Without Automatic Failover --|tHigh-Safety 
       Operating Mode with Automatic Failover --|tHigh-
       Performance Operating Mode --|tDatabase Mirroring and SQL 
       Server 2012 Editions --|tDatabase Mirroring Catalog Views 
       --|tsys.database_mirroring --
       |tsys.database_mirroring_witnesses --
       |tsys.database_mirroring_endpoints --|tDatabase Mirroring 
       Role Change --|tAutomatic Failover --|tManual Failover --
       |tForced Failover --|tDatabase Availability Scenarios --
       |tPrincipal Is Lost --|tMirror Is Lost --|tWitness Is Lost
       --|tMirror and Witness Are Lost --|tMonitoring Database 
       Mirroring --|tMonitoring Using System Monitor --
       |tMonitoring Using Database Mirroring Monitor --|tSetting 
       Thresholds on Counters and Sending Alerts --
       |tTroubleshooting Database Mirroring --|tTroubleshooting 
       Setup Errors --|tTroubleshooting Runtime Errors --
       |tAutomatic Page Repair --|tPreparing the Mirror Server 
       for Failover --|tHardware, Software, and Server 
       Configuration --|tDatabase Availability During Planned 
       Downtime --|tSQL Job Configuration on the Mirror --
       |tDatabase Trustworthy Bit on the Mirror --|tClient 
       Redirection to the Mirror --|tMirroring Multiple Databases
       --|tDatabase Mirroring and Other High-Availability 
       Solutions --|tDatabase Mirroring versus Clustering --
       |tDatabase Mirroring versus Transactional Replication --
       |tDatabase Mirroring versus Log Shipping --|tDatabase 
       Mirroring Versus Availability Groups --|tMirroring Event 
       Listener Setup --|tDatabase Snapshots --|tSummary --|gch. 
505 00 |t20|tIntegration Services Administration and Performance 
       Tuning --|tTour of Integration Services --|tIntegration 
       Services Uses --|tMain Parts of Integration Services --
       |tProject Management and Change Control --|tAdministration
       of the Integration Services Service --|tOverview of the 
       Integration Services Service --|tConfiguration --|tEvent 
       Logs --|tMonitoring Activity --|tAdministration of 
       Integration Services Packages in Package Deployment Model 
       --|tUsing Management Studio for Package Management --
       |tDeployment --|tAdministration of Integration Services 
       Packages in Project Deployment Model --|tConfiguring the 
       SSIS Catalog --|tDeploying Packages --|tConfiguring 
       Packages --|tExecution and Scheduling --|tRunning Packages
       in SQL Server Data Tools --|tRunning Packages with the SQL
       Server Import and Export Wizard --|tRunning Packages with 
       DTExec --|tRunning Packages with DTExecUI (Package 
       Deployment Model) --|tRunning Packages with the Execute 
       Package Tool (Project Deployment Model) --|tScheduling 
       Execution with SQL Server Agent --|tRunning Packages with 
       T-SQL --|tApplying Security to Integration Services --
       |tOverview of Integration Services Security --|tSecuring 
       Packages in Package Deployment Model --|tSummary --|gch. 
       21|tAnalysis Services Administration and Performance 
       Tuning --|tTour of Analysis Services --|tMOLAP Components 
       --|tTabular Model Components --|tAnalysis Services 
       Architectural Components --|tAdministering Analysis 
       Services Server --|tServer Properties --|tRequired 
       Services --|tAnalysis Services Scripting Language --
       |tAdministering Analysis Services Databases --|tDeploying 
       Analysis Services Databases --|tProcessing Analysis 
       Services Objects --|tBacking Up and Restoring Analysis 
       Services Databases --|tSynchronizing Analysis Services 
       Databases --|tAnalysis Services Performance Monitoring and
       Tuning --|tMonitoring Analysis Services Events --
       |tCreating Traces for Replay --|tUsing Flight Recorder for
       After-the-Fact Analysis --|tManagement of Analysis 
       Services MOLAP Model Storage --|tStorage Modes --
       |tPartition Configuration --|tDesigning Aggregations in 
       the MOLAP Model --|tApplying Security to Analysis Services
       in the MOLAP Model --|tServer Role --|tDatabase Role --
       |tDatabase Role Permissions --|tApplying Security to 
       Analysis Services in the Tabular Model --|tSummary --|gch.
       22|tSQL Server Reporting Services Administration --|tSQL 
       Server Reporting Services Configuration Manager --
       |tService Account --|tWeb Service URL --|tReporting 
       Services Databases --|tReport Manager URL --|tE-mail 
       Settings --|tExecution Account --|tEncryption Keys --
       |tScale-out Deployment --|tReport Server Properties --
       |tGeneral Properties Page --|tExecution Properties Page --
       |tHistory Properties Page --|tLogging Properties Page. 
505 00 |gNote continued:|tSecurity Properties Page --|tAdvanced 
       Properties Page --|tReport Execution Log --|tReport 
       Builder --|tReport Manager --|tManaging Report Manager --
       |tManaging Reports --|tSummary --|gch. 23|tSQL Server 2012
       Sharepoint 2010 Integration --|tComponents of Integration 
       --|tPowerPivot --|tReporting Services --|tPower View --
       |tService Application Architecture --|tData Refresh --
       |tUsing Data Connections in Excel --|tPerformancePoint 
       Data Refresh --|tVisio Services Data Refresh --
       |tPowerPivot Data Refresh --|tSummary --|gch. 24|tSQL 
       Azure Administration and Configuration --|tIntroduction to
       SQL Azure --|tSQL Azure Architecture --|tClient Layer --
       |tServices Layer --|tPlatform Layer --|tInfrastructure 
       Layer --|tConfiguring SQL Azure --|tServer and Database 
       Provisioning --|tThrottling and Load Balancing --
       |tConfiguring SQL Azure Firewalls --|tConnecting to SQL 
       Azure --|tAdministering SQL Azure --|tCreating Logins and 
       Users --|tAssigning Access Rights --|tWorking with SQL 
       Azure --|tBackups with SQL Azure --|tObject Explorer for 
       SQL Azure --|tWhat's Missing in SQL Azure --|tSummary --
       |gch. 25|tAlwayson Availability Groups --|tArchitecture --
       |tAvailability Group Replicas and Roles --|tAvailability 
       Modes --|tTypes of Failover Supported --|tAllowing Read-
       Only Access to Secondary Replicas --|tAvailability Group 
       Example --|tConfigures New Availability Group --
       |tConfigure an Existing Availability Group --
       |tAvailability Group Failover Operation --|tSuspend an 
       Availability Database --|tResume an Availability Database 
       --|tClient Application Connections --|tActive Secondary 
       for Secondary Read-Only --|tRead-Only Access Behavior --
       |tSecondary Replica Client Connectivity --|tPerformance --
       |tBackup on the Secondary Replica --|tEvaluate Backup 
       Replicas Metadata --|tAlwaysOn Group Dashboard --
       |tMonitoring and Troubleshooting --|tSummary. 
520 8  Annotation|bAn essential how-to guide for experienced DBAs
       on the most significant product release since 
       2005!Microsoft SQL Server 2012 will have major changes 
       throughout the SQL Server and will impact how DBAs 
       administer the database. With this book, a team of well-
       known SQL Server experts introduces the many new features 
       of the most recent version of SQL Server and deciphers how
       these changes will affect the methods that administrators 
       have been using for years. Loaded with unique tips, tricks,
       and workarounds for handling the most difficult SQL Server
       admin issues, this how-to guide deciphers topics such as 
       performance tuning, backup and recovery, scaling and 
       replication, clustering, and security. Serves as a must-
       have how-to guide on the new features of the 2012 release 
       of Microsoft SQL ServerWalks you through ways to manage 
       and monitor SQL Server and automate administrationGuides 
       you through SQL Azure for cloud computing, data 
       replication, and data warehouse performance 
       improvementsAddresses client-connectivity enhancements, 
       new features that ensure high availability of mission-
       critical applications, and tighter integration with Excel 
       and SharePoint for data analysis and reportingHighlights 
       major changes to the suite of SQL Server BI tools, 
       including integration, reporting, and analysis 
       servicesIncludes real-world case examples and best 
       practices from Microsoft insidersIf you're a database 
       administrator eager to get started with the newest version
       of SQL Server, then this book is essential reading. 
630 00 SQL server.|0
650  0 Database management.|0
655  4 Electronic books. 
700 1  Jorgensen, Adam,|0
700 1  Strate, Jason,|eeditor. 
700 1  Cherry, Denny,|0
776 08 |iPrint version:|tProfessional Microsoft SQL server 2012 
       administration.|b1st ed.|dIndianapolis, IN : Wiley Pub., 
       Inc., 2012|z9781118106884|w(DLC)  2012933629
990    ProQuest Safari|bO'Reilly Safari Learning Platform: 
       Academic edition|c2018-11-16|yMaster record variable 
       field(s) change: 505|5OH1 
990    ProQuest Safari|bO'Reilly Safari Learning Platform: 
       Academic edition|c2018-10-22|yNew collection 
990    ProQuest ebrary|bebrary Academic Complete|c2017-08-11
       |yRemoved from collection ebrary.ebooks|5MTU 
990    ProQuest ebrary|bebrary Academic Complete|c2017-04-20|5MTU
View online

If you experience difficulty accessing or navigating this content, please contact the OPAL Support Team