Microsoft SQL Server 2012 Administration

Name: Microsoft SQL Server 2012 Administration | Real-World Skills for MCSA Certification and Beyond (Exams 70-461, 70-462, and 70-463)
Brand: Sybex
Price: 44.99 EUR
Availability: OnlineOnly

Real-World Skills for MCSA Certification and Beyond (Exams 70-461, 70-462, and 70-463)

Tom Carpenter(Autor*in)

Sybex (Verlag)

Erschienen am 31. Mai 2013

936 Seiten

E-Book

ePUB mit Adobe-DRM

Systemvoraussetzungen

E-Book

PDF mit Adobe-DRM

Systemvoraussetzungen

978-1-118-65473-6 (ISBN)

44,99 €inkl. 7% MwSt.

Systemvoraussetzungen

für ePUB mit Adobe-DRM und PDF mit Adobe-DRM

(Hinweis: Die Auswahl des von Ihnen gewünschten Dateiformats und des Kopierschutzes erfolgt erst im System des E-Book Anbieters)

E-Book Einzellizenz

Als Download verfügbar

Beschreibung

Weitere Details

Weitere Ausgaben

Person

Inhalt

Cover
Copyright
Acknowledgments
About the Author
Contents at a Glance
Contents
Table of Exercises
Introduction
Who Should Read This Book
What You Will Learn
What You Need
Suggested Home Lab Setup
What Is Covered in This Book
Additional Study Tools
How to Contact the Author
Part I: Introducing SQL Server 2012
Chapter 1: Understanding SQL Server's Role
What Is Information Technology?
The Importance of IT
The Components of IT
Introduction to Databases
Types of Databases
Weighing the Benefits of Using a Local or Server-Based Database
Important Database Terms
Database Servers and Applications
Database Application Types
SQL Server's Role
New Features Introduced in SQL Server 2012
Features Introduced in SQL Server 2008
Features Introduced in SQL Server 2005
Core Features of SQL Server
SQL Server Roles
Summary
Chapter Essentials
Chapter 2: Installing SQL Server 2012
Installation Planning
SQL Server 2012 Architecture
Installation Planning Process
Managing Permissions
Installing a Default Instance
SQL Server Installation Center Tasks
Installation
Installing Named Instances
Installing to a Cluster
Installing Extra Features
Upgrading from Previous Versions
Handling Upgrades
Understanding Migrations
Validating an Installation
Removing an Installation
Summary
Chapter Essentials
Chapter 3: Working with the Administration Tools
SQL Server Configuration Manager
Overview of the SSCM
Performing Common SSCM Tasks
SQL Server Management Studio
Overview of the SSMS
Performing Common SSMS Tasks
SQL Server Data Tools
Overview of SSDT
Performing Common SSDT Tasks
SQL Server Profiler
Books Online
Windows Server Administration for the DBA
User Account Management
File System Management
Network Configuration Administration
Summary
Chapter Essentials
Chapter 4: SQL Server Command-Line Administration
Introducing the Command Prompt
General Command-Prompt Options
Font Settings
Screen Layout
Color Choices
General Commands
Directory and Folder Navigation
Directory and Folder Listing
Screen Management
Displaying Information
Redirecting Output
Administrative Commands
Batch Files
Using Logic (IF and GOTO)
Passing Data
Including Comments
Mastering SQLCMD
Introducing Windows PowerShell
Using SQL Server PowerShell Extensions
Summary
Chapter Essentials
Chapter 5: Querying SQL Server
Understanding the SQL Language
Queries
Short Learning Curve
Varied Query Modes
Standardization
Added Logical Capabilities of T-SQL
SQL Statement Types
Data Manipulation Language
Data Definition Language
Data Control Language
SQL Syntactical Elements
Keywords
Comments
Batch Directives
SQL Statements
Clauses
Identifiers
Variables
Data Types
System Functions
Operators and Expressions
Statement Terminator
Coding Recommendations
Capitalize Keywords
Use Standard SQL
Do Not Use Keywords as Identifiers
Using SELECT Statements
Basic SELECT Statements
Filtered SELECT Statements
Sorted SELECT Statements
Handling NULL Data
Converting Data in Result Sets
Identifying Collation Details
Using Data from Multiple Tables
Advanced Query Techniques
Subqueries
Aggregate Queries
Using DDL Statements
Creating Objects
Altering Objects
Deleting Objects
Using DCL Statements
Granting Access
Denying Access
Revoking Permissions
Modifying Data
The INSERT Statement
The UPDATE Statement
The DELETE Statement
Tuning and Optimizing Queries
Transaction Processing
Error Handling
Summary
Chapter Essentials
Part II: Designing Database Solutions
Chapter 6: Database Concepts and Terminology
Relational Database Theory
Data
Information
Tables
Table Components
Relationship Types
Database Design Processes
Systems Development Life Cycle
Database Life Cycle
Business, Users, Model
Project Management for the DBA
The Define Phase
The Design Phase
The Deliver Phase
The Determine Phase
Summary
Chapter Essentials
Chapter 7: ERD and Capacity Planning
Planning a Database
User Surveys
Evaluating Business Processes
Developing Use Cases
Understanding Entity Relationship Diagramming
Building an ERD
Creating an ERD in Visio
Creating an ERD in OSA
Capacity Planning
Summary
Chapter Essentials
Chapter 8: Normalization and Other Design Issues
Designing for Normalization
Normal Forms
Normalizing a Database
Denormalizing a Database
Designing for Performance
Designing for Availability
Designing for Security
Summary
Chapter Essentials
Part III: Implementing Database Solutions
Chapter 9: Creating SQL Server Databases
SQL Server Databases
System Databases
User Databases
Database Storage
Database Data Files
Database Filegroups
Transaction Logs
Database Options and Properties
Autogrowth
Recovery Model
Compatibility Level
Auto Shrink
Restrict Access
More Database Properties
Creating Databases in the GUI
Creating Databases with T-SQL
Creating Databases with PowerShell
Attaching and Detaching Databases
Database Snapshots
Creating Snapshots
Reverting to Snapshots
Summary
Chapter Essentials
Chapter 10: Creating Tables
Data Types
Data Type Categories
Collations
Configuring Server Instance Collations
Configuring Database Collations
Configuring Column Collations
Table Creation Process
Creating Tables with the Table Designer
Creating Tables with T-SQL
Data Partitioning
Vertical and Horizontal Partitioning
Data Partitioning with Functions and Schemes
Summary
Chapter Essentials
Chapter 11: Indexes and Views
Understanding Indexes
Indexes Defined
Index Types
Creating Basic Indexes
Creating a Clustered Index
Creating a Nonclustered Index
Creating Advanced Indexes
Creating a Covering Index
Creating a Filtered Index
Managing Indexes
Dropping an Index
Disabling and Enabling Indexes
Understanding Index Fragmentation
Understanding Views
Creating Views
Summary
Chapter Essentials
Chapter 12: Triggers and Stored Procedures
Triggers Defined
Types of Triggers
Recursive and Nested Triggers
Using Triggers
Creating Triggers
Understanding Stored Procedures
Creating Stored Procedures
How Triggers Differ from Stored Procedures
Summary
Chapter Essentials
Chapter 13: Implementing Advanced Features
Understanding and Installing Analysis Services
Analysis Services Tools
Analysis Services Optional Components
Installing and Configuring Analysis Services
Understanding Integration Services
Installing and Configuring Integration Services
Creating a Basic Integration Services Package
Troubleshooting and Debugging an SSIS Package
Scheduling Your Package to Run Automatically
Security Protection Levels
Understanding and Installing Reporting Services
Implementing Database Mail
Configuring Full-Text Indexing
Implementing Transparent Data Encryption
TDE Architecture
TDE Implementation Process
Data Compression
Summary
Chapter Essentials
Part IV: Administering and Maintaining SQL Server 2012
Chapter 14: Creating Jobs, Operators, and Alerts
Standardize, Automate, and Update
Understanding SQL Server Jobs
Job Steps
Job Configuration Properties
Typical Jobs
Creating T-SQL Jobs
Creating SSIS Jobs
Creating Windows Command Jobs
Creating and Using Operators
Creating and Using Alerts
Using WSUS for SQL Server 2012
Summary
Chapter Essentials
Chapter 15: Performance Monitoring and Tuning
Performance Tuning Principles
Why Performance Tuning Matters
Common Performance Tuning Myths
Performance and Troubleshooting Tools
Blocks, Locks, and Deadlocks
Understanding Locks
Lock Types
Granularity of Locks
Lock Isolation Levels
Blocks and Deadlocks
SQL Server Profiler
Database Engine Tuning Advisor
Creating a DTA Workload File
Analyzing Your Workload File
Applying DTA Recommendations
Performance Monitoring with System Monitor
Installing the System Monitor
Viewing Live Performance Data
Logging Counters in Windows Server 2003
Data Collection in Windows Server 2008
Using the Resource Governor
Performance Studio
Advanced Monitoring Tools
Dynamic Management Views
DBCC
Resource Monitor
Summary
Chapter Essentials
Chapter 16: Policy-Based Management
Policy-Based Management
PBM Components
Creating Conditions
Creating Policies
Evaluating Policies
Centralized Server Management
Major Benefits and Requirements
Creating a Central Management Server
Registering Subscriber Servers
Standardizing with PBM and CMS
Standardizing
Automating
Updating
Summary
Chapter Essentials
Chapter 17: Backup and Restoration
Backing Up a Database
Creating a Backup Plan
Choosing a Recovery Model
Using the Different Backup Types
Working with Backup Devices and Files
Compressing Backups
Performing File and Filegroup Backups
Backing Up System Databases
Restoring a Database
Choosing a Restore Method
Restoring to a Point in Time
Restoring to the Point of Failure
Restoring System Databases
Backing Up the Environment
Built-in Backup Tools
Imaging and Third-Party Tools
Summary
Chapter Essentials
Part V: SQL Server Security
Chapter 18: Security Threats and Principles
Security Defined
How to Classify Data for Security Purposes
Security in Theory
Security in the Real World
Security Threats
Threats, Vulnerabilities, and Exploits Defined
Attack Point 1: Windows Server
Attack Point 2: SQL Server
Attack Point 3: The Network
Attack Point 4: The Client
Cracking Examples
Security Principles
Start with Good Design
Trust, but Monitor
Defense-in-Depth
Least Privilege
Summary
Chapter Essentials
Chapter 19: Authentication and Encryption
Understanding Authentication
Credentials
Common Authentication Methods
Regulatory Compliance
SQL Server Authentication Methods
Logins, Users, and Roles
Configuring the Authentication Mode
Creating and Managing Principals and Roles
Creating Database Users
Understanding Encryption
SQL Server Encryption Solutions
Implementing Application-Level Encryption
Implementing Transparent Encryption
Summary
Chapter Essentials
Chapter 20: Security Best Practices
Establishing Baselines
Working with Security Templates
Analyzing a Server's Security Settings
Using the Security Configuration Wizard
Implementing Least Privilege
Permissions and Authorization
Ownership Chains
Credentials
Auditing SQL Server Activity
Using Audits
Notifications
DDL Triggers
Logon Triggers
Configuring the Surface Area
SP_Configure for Surface Area Management
Policy-Based Management Surface Area Options
Understanding Common Criteria and C2
GRC
C2 Compliance
Common Criteria
Summary
Chapter Essentials
Part VI: Implementing High Availability and Data Distribution
Chapter 21: AlwaysOn and High Availability
Introducing AlwaysOn Technology
Understanding High Availability
AlwaysOn Defined
Mirroring and AlwaysOn
Replacing Traditional Mirroring
Using Traditional Mirroring
Failover Solutions
Synchronous-Commit
Asynchronous-Commit
The Failover Process
Selecting Hardware for AlwaysOn
Highly Available Servers
Highly Available Storage
Highly Available Networks
Summary
Chapter Essentials
Chapter 22: SQL Server Failover Clustering
Understanding Windows Failover Clustering Service
Implementing a Windows Cluster
Failover Clustering Components
The Failover Clustering Installation Process
Installing SQL Server 2012 to a Cluster
Monitoring and Managing a SQL Server Cluster
Service Packs and Update Management
Failover Management
Cluster Troubleshooting
Summary
Chapter Essentials
Chapter 23: Database Mirroring and Snapshots
RAID-based Data Redundancy
Using Database Mirroring
Database Mirroring Components
Understanding Mirror Operating Modes
Planning for Role Switching
Implementing Database Mirroring
Understanding Log Shipping
Inside the Log-Shipping Process
Configuring Log Shipping and Monitoring
Implementing Database Snapshots
Database Snapshot Functionality
Implementing a Snapshot
Querying a Snapshot
Reverting to a Snapshot
Summary
Chapter Essentials
Chapter 24: Implementing Replication
SQL Server Replication
SQL Server Replication Roles and Concepts
Replication Types
Replication Models
New Features in SQL Server 2012
Configuring a Publisher and Distributor
Configuring a Subscriber
Monitoring Replication
Replication Performance
Replication Recovery
Importing and Exporting Data
Using BCP
Bulk Insert Commands
Using SQL Server Integration Services
Summary
Chapter Essentials
Part VII: Implementing Business Intelligence and Reporting
Chapter 25: Data Warehousing
Understanding Data Warehouses
Defining Terminology
Defining Usage
Implementing Fact Tables
Understanding and Planning for Fact Tables
Creating Fact Tables
Implementing Dimensions
Understanding and Planning for Dimensions
Creating Dimensions
Summary
Chapter Essentials
Chapter 26: SQL Server Integration Services
Integration Issues
Existing Systems
Existing Data
Co-existence
Installing SSIS
Providing Prerequisites
Installing the SSIS Components
Development vs. Production Servers
Configuring SSIS for Operations
Configuring SSIS Security Settings
SSIS Service
SSIS Roles
Access Control
Digital Signatures
Deploying Packages
Working with the SSIS Catalog
Using the Deployment Utility
Deploying to SQL Server or Files
Using DTUTIL
SSIS Auditing and Event Handling
Auditing Packages
Using Log Providers
Using Event Handlers
Extracting, Transforming, and Loading Data
Connection Managers
Data Flow Design
Understanding Data Load Options
Using Script Tasks
Summary
Chapter Essentials
Chapter 27: Data Quality Solutions
Understanding Data Quality Concerns
Data Quality Problems
Data Quality Dimensions
Data Quality Processes
Installing Data Quality Services
Prerequisites
Performing the Installation
Data Governance
Using Master Data Services
Installing and Implementing MDS
Creating MDS Objects
Cleaning Data
Profiling Systems
Knowledge Base Management
Creating the Project
Summary
Chapter Essentials
Appendices
Appendix A: Microsoft's Certification Program
How Do You Become Certified on SQL Server 2012?
Tips for Taking a Microsoft Exam
Exam Registration
Certification Objectives Map
Appendix B: About the Additional Study Tools
Additional Study Tools
Videos
Sybex Test Engine
Electronic Flashcards
Glossary of Terms
Adobe Reader
System Requirements
Using the Study Tools
Troubleshooting
Customer Care
Index

Systemvoraussetzungen

Dateiformat: ePUB
Kopierschutz: Adobe-DRM (Digital Rights Management)

Systemvoraussetzungen:

Computer (Windows; MacOS X; Linux): Installieren Sie bereits vor dem Download die kostenlose Software Adobe Digital Editions (siehe E-Book Hilfe).
Tablet/Smartphone (Android; iOS): Installieren Sie bereits vor dem Download die kostenlose App Adobe Digital Editions oder die App PocketBook (siehe E-Book Hilfe).
E-Book-Reader: Bookeen, Kobo, Pocketbook, Sony, Tolino u.v.a.m. (nicht Kindle)

Das Dateiformat ePUB ist sehr gut für Romane und Sachbücher geeignet – also für „fließenden” Text ohne komplexes Layout. Bei E-Readern oder Smartphones passt sich der Zeilen- und Seitenumbruch automatisch den kleinen Displays an.
Mit Adobe-DRM wird hier ein „harter” Kopierschutz verwendet. Wenn die notwendigen Voraussetzungen nicht vorliegen, können Sie das E-Book leider nicht öffnen. Daher müssen Sie bereits vor dem Download Ihre Lese-Hardware vorbereiten.

Bitte beachten Sie: Wir empfehlen Ihnen unbedingt nach Installation der Lese-Software diese mit Ihrer persönlichen Adobe-ID zu autorisieren!

Weitere Informationen finden Sie in unserer E-Book Hilfe.

Dateiformat: PDF
Kopierschutz: Adobe-DRM (Digital Rights Management)

Systemvoraussetzungen:

Computer (Windows; MacOS X; Linux): Installieren Sie bereits vor dem Download die kostenlose Software Adobe Digital Editions (siehe E-Book Hilfe).
Tablet/Smartphone (Android; iOS): Installieren Sie bereits vor dem Download die kostenlose App Adobe Digital Editions oder die App PocketBook (siehe E-Book Hilfe).
E-Book-Reader: Bookeen, Kobo, Pocketbook, Sony, Tolino u.v.a.m. (nicht Kindle)

Das Dateiformat PDF zeigt auf jeder Hardware eine Buchseite stets identisch an. Daher ist eine PDF auch für ein komplexes Layout geeignet, wie es bei Lehr- und Fachbüchern verwendet wird (Bilder, Tabellen, Spalten, Fußnoten). Bei kleinen Displays von E-Readern oder Smartphones sind PDF leider eher nervig, weil zu viel Scrollen notwendig ist.
Mit Adobe-DRM wird hier ein „harter” Kopierschutz verwendet. Wenn die notwendigen Voraussetzungen nicht vorliegen, können Sie das E-Book leider nicht öffnen. Daher müssen Sie bereits vor dem Download Ihre Lese-Hardware vorbereiten.

Bitte beachten Sie: Wir empfehlen Ihnen unbedingt nach Installation der Lese-Software diese mit Ihrer persönlichen Adobe-ID zu autorisieren!

Weitere Informationen finden Sie in unserer E-Book Hilfe.

Als PDF speichern Als Link merken