book

Microsoft SQL Server 2012 Administration: Real-World Skills for MCSA Certification and Beyond (Exams 70-461, 70-462, and 70-463)

by Tom Carpenter

June 2013

Intermediate to advanced

936 pages

23h 54m

English

Sybex

Read now

Unlock full access

What Is Information Technology?Introduction to DatabasesDatabase Servers and ApplicationsSQL Server’s RoleSummaryChapter Essentials
Installation PlanningInstalling a Default InstanceInstalling Named InstancesInstalling to a ClusterInstalling Extra FeaturesUpgrading from Previous VersionsValidating an InstallationRemoving an InstallationSummaryChapter Essentials
SQL Server Configuration ManagerSQL Server Management StudioSQL Server Data ToolsSQL Server ProfilerBooks OnlineWindows Server Administration for the DBASummaryChapter Essentials
Introducing the Command PromptGeneral CommandsBatch FilesMastering SQLCMDIntroducing Windows PowerShellUsing SQL Server PowerShell ExtensionsSummaryChapter Essentials
Understanding the SQL LanguageSQL Statement TypesSQL Syntactical ElementsCoding RecommendationsUsing SELECT StatementsAdvanced Query TechniquesUsing DDL StatementsUsing DCL StatementsModifying DataTuning and Optimizing QueriesSummaryChapter Essentials
Relational Database TheoryDatabase Design ProcessesProject Management for the DBASummaryChapter Essentials
Planning a DatabaseUnderstanding Entity Relationship DiagrammingBuilding an ERDCapacity PlanningSummaryChapter Essentials
Designing for NormalizationDesigning for PerformanceDesigning for AvailabilityDesigning for SecuritySummaryChapter Essentials
SQL Server DatabasesDatabase StorageDatabase Options and PropertiesCreating Databases in the GUICreating Databases with T-SQLCreating Databases with PowerShellAttaching and Detaching DatabasesDatabase SnapshotsSummaryChapter Essentials
Data TypesCollationsTable Creation ProcessData PartitioningSummaryChapter Essentials
Understanding IndexesCreating Basic IndexesCreating Advanced IndexesManaging IndexesUnderstanding ViewsCreating ViewsSummaryChapter Essentials
Triggers DefinedUsing TriggersCreating TriggersUnderstanding Stored ProceduresCreating Stored ProceduresSummaryChapter Essentials
Understanding and Installing Analysis ServicesUnderstanding Integration ServicesUnderstanding and Installing Reporting ServicesImplementing Database MailConfiguring Full-Text IndexingImplementing Transparent Data EncryptionData CompressionSummaryChapter Essentials
Standardize, Automate, and UpdateUnderstanding SQL Server JobsCreating T-SQL JobsCreating SSIS JobsCreating Windows Command JobsCreating and Using OperatorsCreating and Using AlertsUsing WSUS for SQL Server 2012SummaryChapter Essentials
Performance Tuning PrinciplesPerformance and Troubleshooting ToolsBlocks, Locks, and DeadlocksSQL Server ProfilerDatabase Engine Tuning AdvisorPerformance Monitoring with System MonitorUsing the Resource GovernorPerformance StudioAdvanced Monitoring ToolsSummaryChapter Essentials
Policy-Based ManagementCentralized Server ManagementStandardizing with PBM and CMSSummaryChapter Essentials
Backing Up a DatabaseBacking Up System DatabasesRestoring a DatabaseBacking Up the EnvironmentSummaryChapter Essentials
Security DefinedSecurity ThreatsSecurity PrinciplesSummaryChapter Essentials
Understanding AuthenticationSQL Server Authentication MethodsLogins, Users, and RolesUnderstanding EncryptionSummaryChapter Essentials
Establishing BaselinesImplementing Least PrivilegeAuditing SQL Server ActivityConfiguring the Surface AreaUnderstanding Common Criteria and C2SummaryChapter Essentials
Introducing AlwaysOn TechnologyMirroring and AlwaysOnFailover SolutionsSelecting Hardware for AlwaysOnSummaryChapter Essentials
Understanding Windows Failover Clustering ServiceImplementing a Windows ClusterInstalling SQL Server 2012 to a ClusterMonitoring and Managing a SQL Server ClusterSummaryChapter Essentials
RAID-based Data RedundancyUsing Database MirroringUnderstanding Log ShippingImplementing Database SnapshotsSummaryChapter Essentials
SQL Server ReplicationImporting and Exporting DataSummaryChapter Essentials
Understanding Data WarehousesImplementing Fact TablesImplementing DimensionsSummaryChapter Essentials
Integration IssuesInstalling SSISConfiguring SSIS Security SettingsDeploying PackagesSSIS Auditing and Event HandlingExtracting, Transforming, and Loading DataSummaryChapter Essentials
Understanding Data Quality ConcernsInstalling Data Quality ServicesUsing Master Data ServicesCleaning DataSummaryChapter Essentials