Pro SQL Server Administration (eBook)
XXV, 1004 Seiten
Apress (Verlag)
978-1-4842-0710-9 (ISBN)
Pro SQL Server Administration brings SQL Server administration into the modern era with strong coverage of hybrid cloud environments, In-Memory OLTP, and installation on Server Core. This comprehensive guide to SQL Server Administration for today's DBA helps you to administer the new and key areas of SQL Server, including Columnstore indexes and the In-Memory OLTP feature set introduced in 2014.
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.
Pro SQL Server Administration brings SQL Server administration into the modern era with strong coverage of hybrid cloud environments, In-Memory OLTP, and installation on Server Core. This comprehensive guide to SQL Server Administration for today's DBA helps you to administer the new and key areas of SQL Server, including Columnstore indexes and the In-Memory OLTP feature set introduced in 2014.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 supportComprehensive 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 ServerChapter 1: Planning the DeploymentChapter 2: GUI InstallationChapter 3: Server Core InstallationChapter 4: Configuring the InstancePart II: Database AdministrationChapter 5: Files and FilegroupsChapter 6: Configuring TablesChapter 7: Indexes and StatisticsChapter 8: Database ConsistencyPart III: Security, Resilience, and ScalingChapter 9: SQL Server Security ModelChapter 10: EncryptionChapter 11: HA and DR ConceptsChapter 12: Implementing ClusteringChapter 13: Implementing AlwaysOn Availability GroupsChapter 14: Implementing Log ShippingChapter 15: Backups and RestoreChapter 16: Scaling WorkloadsPart IV: Monitoring and MaintenanceChapter 17: SQL Server Metadata Chapter 18: Locking and BlockingChapter 19: Extended EventsChapter 20: Distributed ReplayChapter 21: Automating Routine MaintenanceChapter 22: Policy-Based ManagementChapter 23: Resource GovernorChapter 24: TriggersPart V: Managing a Hybrid Cloud EnvironmentChapter 25: Cloud Backups and RestoresChapter 26: Storing Data Files in Windows AzureChapter 27: Migrating to the Cloud
| Erscheint lt. Verlag | 16.11.2015 |
|---|---|
| Zusatzinfo | XXV, 1004 p. 525 illus. |
| Verlagsort | Berkeley |
| Sprache | englisch |
| Themenwelt | Informatik ► Datenbanken ► SQL Server |
| ISBN-10 | 1-4842-0710-6 / 1484207106 |
| ISBN-13 | 978-1-4842-0710-9 / 9781484207109 |
| Haben Sie eine Frage zum Produkt? |
PDF (Wasserzeichen)Größe: 37,5 MB
DRM: Digitales Wasserzeichen
Dieses eBook enthält ein digitales Wasserzeichen und ist damit für Sie personalisiert. Bei einer missbräuchlichen Weitergabe des eBooks an Dritte ist eine Rückverfolgung an die Quelle möglich.
Dateiformat: PDF (Portable Document Format)
Mit einem festen Seitenlayout eignet sich die PDF besonders für Fachbücher mit Spalten, Tabellen und Abbildungen. Eine PDF kann auf fast allen Geräten angezeigt werden, ist aber für kleine Displays (Smartphone, eReader) nur eingeschränkt geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen dafür einen PDF-Viewer - z.B. den Adobe Reader oder Adobe Digital Editions.
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen dafür einen PDF-Viewer - z.B. die kostenlose Adobe Digital Editions-App.
Zusätzliches Feature: Online Lesen
Dieses eBook können Sie zusätzlich zum Download auch online im Webbrowser lesen.
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich
