Professional Microsoft SQL Server 2014 Administration
Lýsing:
Learn to take advantage of the opportunities offered by SQL Server 2014 Microsoft's SQL Server 2014 update means big changes for database administrators, and you need to get up to speed quickly because your methods, workflow, and favorite techniques will be different from here on out. The update's enhanced support of large-scale enterprise databases and significant price advantage mean that SQL Server 2014 will become even more widely adopted across the industry.
The update includes new backup and recovery tools, new AlwaysOn features, and enhanced cloud capabilities. In-memory OLTP, Buffer Pool Extensions for SSDs, and a new Cardinality Estimator can improve functionality and smooth out the workflow, but only if you understand their full capabilities. Professional Microsoft SQL Server 2014 is your comprehensive guide to working with the new environment.
Authors Adam Jorgensen, Bradley Ball, Ross LoForte, Steven Wort, and Brian Knight are the dream team of the SQL Server community, and they put their expertise to work guiding you through the changes. Improve oversight with better management and monitoring Protect your work with enhanced security features Upgrade performance tuning, scaling, replication, and clustering Learn new options for backup and recovery Professional Microsoft SQL Server 2014 includes a companion website with sample code and efficient automation utilities, plus a host of tips, tricks, and workarounds that will make your job as a DBA or database architect much easier.
Annað
- Höfundar: Adam Jorgensen, Bradley Ball, Steven Wort, Ross LoForte, Brian Knight
- Útgáfa:1
- Útgáfudagur: 2014-09-08
- Hægt að prenta út 10 bls.
- Hægt að afrita 2 bls.
- Format:ePub
- ISBN 13: 9781118859193
- Print ISBN: 9781118859131
- ISBN 10: 1118859197
Efnisyfirlit
- Cover
- Chapter 1: SQL Server 2014 Architecture
- SQL SERVER 2014 ECOSYSTEM
- NEW IMPORTANT FEATURES IN 2014
- SQL SERVER ARCHITECTURE
- EDITIONS OF SQL SERVER
- SUMMARY
- Chapter 2: Installing SQL Server 2014 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 2014 Best Practices
- WHY UPGRADE TO SQL SERVER 2014?
- UPGRADING TO SQL SERVER 2014
- 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
- SQL SERVER 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
- MULTISERVER ADMINISTRATION
- SUMMARY
- Chapter 6: Service Broker in SQL Server 2014
- ASYNCHRONOUS MESSAGING
- CONFIGURING SQL SERVER SERVICE BROKER
- USING SQL SERVER SERVICE BROKER
- SUMMARY
- Chapter 7: SQL Server CLR Integration
- INTRODUCTION TO CLR
- CREATING CLR ASSEMBLIES
- CLR INTEGRATION SECURITY
- PERFORMANCE MONITORING
- SUMMARY
- Chapter 8: Securing the Database Instance
- AUTHENTICATION TYPES
- LOGINS AND USERS
- AUTHORIZING SECURABLES
- ROW-LEVEL SECURITY
- SUMMARY
- Chapter 9: In-Memory OLTP
- USING AND IMPLEMENTING IN-MEMORY OLTP
- CREATING NATIVELY COMPILED STORED PROCEDURES
- OVERVIEW OF THE ANALYZE, MIGRATE, AND REPORT (ARM) TOOL
- SUMMARY
- Chapter 10: Configuring the Server for Optimal Performance
- WHAT EVERY DBA NEEDS TO KNOW ABOUT PERFORMANCE
- WHAT THE DEVELOPER DBA NEEDS TO KNOW ABOUT PERFORMANCE
- WHAT THE PRODUCTION DBA NEEDS TO KNOW ABOUT PERFORMANCE
- CPU
- MEMORY
- I/O
- SUMMARY
- Chapter 11: Optimizing SQL Server 2014
- APPLICATION OPTIMIZATION
- THE SILENT KILLER: I/O PROBLEMS
- SQL SERVER INTERNALS AND FILE ALLOCATIONS
- TABLE AND INDEX PARTITIONING
- DATA COMPRESSION
- UNDERSTANDING SQL SERVER AND CPUs
- MEMORY CONSIDERATIONS AND ENHANCEMENTS
- RESOURCE GOVERNOR
- SUMMARY
- Chapter 12: Monitoring Your SQL Server
- THE GOAL OF MONITORING
- CHOOSING THE APPROPRIATE MONITORING TOOLS
- PERFORMANCE MONITOR
- MONITORING EVENTS
- MONITORING WITH DYNAMIC MANAGEMENT VIEWS AND FUNCTIONS
- MONITORING LOGS
- SQL SERVER STANDARD REPORTS
- SYSTEM CENTER ADVISOR
- SUMMARY
- Chapter 13: Performance Tuning T-SQL
- OVERVIEW OF QUERY PROCESSING
- IDENTIFYING SQL QUERY PERFORMANCE TUNING ISSUES
- DATA ACCESS OPERATORS IN QUERY PLANS
- JOIN OPERATORS
- DATA MODIFICATION QUERY PLAN
- ANALYZING QUERY PERFORMANCE IN A PRODUCTION ENVIRONMENT
- PUTTING IT ALL TOGETHER
- SUMMARY
- Chapter 14: Indexing Your Database
- WHAT'S NEW FOR INDEXES IN SQL SERVER 2014
- ABOUT INDEXES AND PARTITIONED TABLES
- INDEX MAINTENANCE
- IMPROVING QUERY PERFORMANCE WITH INDEXES
- DATABASE TUNING ADVISOR
- SUMMARY
- Chapter 15: Replication
- REPLICATION OVERVIEW
- REPLICATION MODELS
- IMPLEMENTING REPLICATION
- PEER-TO-PEER REPLICATION
- SCRIPTING REPLICATION
- MONITORING REPLICATION
- SUMMARY
- Chapter 16: Clustering SQL Server 2014
- CLUSTERING AND YOUR ORGANIZATION
- CLUSTERING: THE BIG PICTURE
- UPGRADING SQL SERVER CLUSTERING
- GETTING PREPARED FOR CLUSTERING
- CLUSTERING WINDOWS SERVER 2012 R2
- CLUSTERING MICROSOFT DISTRIBUTED TRANSACTION COORDINATOR
- CLUSTERING SQL SERVER 2014
- MANAGING AND MONITORING THE CLUSTER
- TROUBLESHOOTING CLUSTER PROBLEMS
- SUMMARY
- Chapter 17: Backup and Recovery
- BACKUP AND RESTORE ENHANCEMENTS
- OVERVIEW OF BACKUP AND RESTORE
- PREPARING FOR RECOVERY
- DEVELOPING AND EXECUTING A BACKUP PLAN
- MANAGING BACKUPS
- BACKUP AND RESTORE PERFORMANCE
- PERFORMING RECOVERY
- ARCHIVING DATA
- SUMMARY
- Chapter 18: SQL Server 2014 Log Shipping
- LOG-SHIPPING DEPLOYMENT SCENARIOS
- LOG-SHIPPING ARCHITECTURE
- LOG-SHIPPING PROCESS
- SYSTEM REQUIREMENTS
- DEPLOYING LOG SHIPPING
- MONITORING AND TROUBLESHOOTING
- MANAGING CHANGING ROLES
- DATABASE BACKUP PLAN
- INTEGRATING LOG SHIPPING WITH OTHER HIGH-AVAILABILITY SOLUTIONS
- REMOVING LOG SHIPPING
- LOG-SHIPPING PERFORMANCE
- UPGRADING TO SQL SERVER 2014 LOG SHIPPING
- SUMMARY
- Chapter 19: Database Mirroring
- OVERVIEW OF DATABASE MIRRORING
- OPERATING MODES OF DATABASE MIRRORING
- DATABASE MIRRORING IN ACTION
- DATABASE MIRRORING AND SQL SERVER 2014 EDITIONS
- DATABASE MIRRORING ROLE CHANGE
- MONITORING USING DATABASE MIRRORING MONITOR
- PREPARING THE MIRROR SERVER FOR FAILOVER
- DATABASE MIRRORING AND OTHER HIGH-AVAILABILITY SOLUTIONS
- DATABASE SNAPSHOTS
- SUMMARY
- Chapter 20: Integration Services Administration and Performance Tuning
- A TOUR OF INTEGRATION SERVICES
- ADMINISTRATION OF THE INTEGRATION SERVICES SERVICE
- ADMINISTRATION OF INTEGRATION SERVICES PACKAGES IN PACKAGE DEPLOYMENT MODEL
- ADMINISTRATION OF INTEGRATION SERVICES PACKAGES IN PROJECT DEPLOYMENT MODEL
- EXECUTION AND SCHEDULING
- APPLYING SECURITY TO INTEGRATION SERVICES
- SUMMARY
- Chapter 21: Analysis Services Administration and Performance Tuning
- TOUR OF ANALYSIS SERVICES
- ADMINISTERING ANALYSIS SERVICES SERVER
- ADMINISTERING ANALYSIS SERVICES DATABASES
- ANALYSIS SERVICES PERFORMANCE MONITORING AND TUNING
- SUMMARY
- Chapter 22: SQL Server Reporting Services Administration
- SQL SERVER REPORTING SERVICES CONFIGURATION MANAGER
- THE REPORT EXECUTION LOG
- REPORT MANAGER
- SUMMARY
- Chapter 23: SQL Server 2014 SharePoint 2013 Integration
- COMPONENTS OF INTEGRATION
- DATA REFRESH
- SUMMARY
- Chapter 24: SQL Database Administration and Configuration
- GETTING TO KNOW WINDOWS AZURE SQL DATABASE
- SQL DATABASE ARCHITECTURE
- CONFIGURING SQL DATABASE
- ADMINISTERING SQL DATABASE
- WORKING WITH SQL DATABASE
- WHAT'S MISSING IN SQL DATABASE
- SUMMARY
- Chapter 25: AlwaysOn Availability Groups
- ARCHITECTURE
- AVAILABILITY GROUP EXAMPLE
- ACTIVE SECONDARY FOR SECONDARY READ-ONLY
- BACKUP ON THE SECONDARY REPLICA
- ALWAYSON GROUP DASHBOARD
- MONITORING AND TROUBLESHOOTING
- SUMMARY
- Introduction
- Who This Book Is For
- How This Book Is Structured
- What You Need to Use This Book
- Conventions
- Source Code
- Errata
- p2p.wrox.com
- Advertisement
- End User License Agreement
UM RAFBÆKUR Á HEIMKAUP.IS
Bókahillan þín er þitt svæði og þar eru bækurnar þínar geymdar. Þú kemst í bókahilluna þína hvar og hvenær sem er í tölvu eða snjalltæki. Einfalt og þægilegt!Rafbók til eignar
Rafbók til eignar þarf að hlaða niður á þau tæki sem þú vilt nota innan eins árs frá því bókin er keypt.
Þú kemst í bækurnar hvar sem er
Þú getur nálgast allar raf(skóla)bækurnar þínar á einu augabragði, hvar og hvenær sem er í bókahillunni þinni. Engin taska, enginn kyndill og ekkert vesen (hvað þá yfirvigt).
Auðvelt að fletta og leita
Þú getur flakkað milli síðna og kafla eins og þér hentar best og farið beint í ákveðna kafla úr efnisyfirlitinu. Í leitinni finnur þú orð, kafla eða síður í einum smelli.
Glósur og yfirstrikanir
Þú getur auðkennt textabrot með mismunandi litum og skrifað glósur að vild í rafbókina. Þú getur jafnvel séð glósur og yfirstrikanir hjá bekkjarsystkinum og kennara ef þeir leyfa það. Allt á einum stað.
Hvað viltu sjá? / Þú ræður hvernig síðan lítur út
Þú lagar síðuna að þínum þörfum. Stækkaðu eða minnkaðu myndir og texta með multi-level zoom til að sjá síðuna eins og þér hentar best í þínu námi.
Fleiri góðir kostir
- Þú getur prentað síður úr bókinni (innan þeirra marka sem útgefandinn setur)
- Möguleiki á tengingu við annað stafrænt og gagnvirkt efni, svo sem myndbönd eða spurningar úr efninu
- Auðvelt að afrita og líma efni/texta fyrir t.d. heimaverkefni eða ritgerðir
- Styður tækni sem hjálpar nemendum með sjón- eða heyrnarskerðingu
- Gerð : 208
- Höfundur : 12727
- Útgáfuár : 2014
- Leyfi : 379