Pro SQL Server Administration
Apress (Verlag)
978-1-4842-0711-6 (ISBN)
- Titel erscheint in neuer Auflage
- Artikel merken
You will also be guided through the administration of traditional areas of SQL Server, including how to secure your instance, monitor and maintain your instance, and to use features such as AlwaysOn to make your instance highly available. Also covered is the use of SQL Server features to scale out read-only workloads. Pro SQL Server Administration is an all-new book taking up-to-date and modern approach that you'll want and need to further your career as a SQL Server database administrator.
Extensive coverage of hybrid cloud environments involving Azure SQL Database
Detailed discussions on all new, key features, including AlwaysOn and in-memory support
Comprehensive coverage of key skills, such as monitoring, maintenance and indexing
Peter Carter is a SQL Server expert with over a decade of experience in developing, administering, and architecting SQL Server platforms and data-tier applications. Peter was awarded an MCC by Microsoft in 2011, to sit alongside his array of MCTS, MCITP, MCSA and MCSE certifications in SQL Server from version 2005, onward. His passion for SQL Server shows through in everything he does, and his goal is that his passion for the technology will inspire others.
Part I: Installing and Configuring SQL Server
Chapter 1: Planning the Deployment
Chapter 2: GUI Installation
Chapter 3: Server Core Installation
Chapter 4: Configuring the Instance
Part II: Database Administration
Chapter 5: Files and Filegroups
Chapter 6: Configuring Tables
Chapter 7: Indexes and Statistics
Chapter 8: Database Consistency
Part III: Security, Resilience, and Scaling
Chapter 9: SQL Server Security Model
Chapter 10: Encryption
Chapter 11: HA and DR Concepts
Chapter 12: Implementing Clustering
Chapter 13: Implementing AlwaysOn Availability Groups
Chapter 14: Implementing Log Shipping
Chapter 15: Backups and Restore
Chapter 16: Scaling Workloads
Part IV: Monitoring and Maintenance
Chapter 17: SQL Server Metadata
Chapter 18: Locking and Blocking
Chapter 19: Extended Events
Chapter 20: Distributed Replay
Chapter 21: Automating Routine Maintenance
Chapter 22: Policy-Based Management
Chapter 23: Resource Governor
Chapter 24: Triggers
Part V: Managing a Hybrid Cloud Environment
Chapter 25: Cloud Backups and Restores
Chapter 26: Storing Data Files in Windows Azure
Chapter 27: Migrating to the Cloud
| Zusatzinfo | 525 Illustrations, black and white; XXV, 1004 p. 525 illus. |
|---|---|
| Verlagsort | Berkley |
| Sprache | englisch |
| Maße | 178 x 254 mm |
| Themenwelt | Informatik ► Datenbanken ► SQL Server |
| Mathematik / Informatik ► Informatik ► Netzwerke | |
| Mathematik / Informatik ► Informatik ► Software Entwicklung | |
| Schlagworte | Microsoft SQL Server 2012; Systemadministration |
| ISBN-10 | 1-4842-0711-4 / 1484207114 |
| ISBN-13 | 978-1-4842-0711-6 / 9781484207116 |
| Zustand | Neuware |
| Haben Sie eine Frage zum Produkt? |
aus dem Bereich
