Details

Pro SQL Server Administration


Pro SQL Server Administration



von: Peter Carter

CHF 77.00

Verlag: Apress
Format: PDF
Veröffentl.: 16.11.2015
ISBN/EAN: 9781484207109
Sprache: englisch

Dieses eBook enthält ein Wasserzeichen.

Beschreibungen

<p><em></em></p><p><em>Pro SQL Server Administration</em> 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.</p><p>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. <em>Pro SQL Server Administration </em>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.</p><ul><li>Extensive coverage of hybrid cloud environments involving Azure SQL Database&nbsp;<p></p></li><li>Detailed discussions on all new, key features, including AlwaysOn and in-memory support<p></p></li><li>Comprehensive coverage of key skills, such as monitoring, maintenance and indexing<p></p></li></ul><p></p><p></p>
<p><strong>Part I: Installing and Configuring SQL Server</strong></p><p>Chapter 1: Planning the Deployment</p><p>Chapter 2: GUI Installation</p><p>Chapter 3: Server Core Installation</p><p>Chapter 4: Configuring the Instance</p><p><strong>Part II: Database Administration</strong></p><p>Chapter 5: Files and Filegroups</p><p>Chapter 6: Configuring Tables</p><p>Chapter 7: Indexes and Statistics</p><p>Chapter 8: Database Consistency</p><p><strong>Part III: Security, Resilience, and Scaling</strong></p><p>Chapter 9: SQL Server Security Model</p><p>Chapter 10: Encryption</p><p>Chapter 11: HA and DR Concepts</p><p>Chapter 12: Implementing Clustering</p><p>Chapter 13: Implementing AlwaysOn Availability Groups</p><p>Chapter 14: Implementing Log Shipping</p><p>Chapter 15: Backups and Restore</p><p>Chapter 16: Scaling Workloads</p><p><strong>Part IV: Monitoring and Maintenance</strong></p><p>Chapter 17: SQL Server Metadata </p><p>Chapter 18: Locking and Blocking</p><p>Chapter 19: Extended Events<p>Chapter 20: Distributed Replay</p><p>Chapter 21: Automating Routine Maintenance</p><p>Chapter 22: Policy-Based Management</p><p>Chapter 23: Resource Governor</p><p>Chapter 24: Triggers</p><p><strong>Part V: Managing a Hybrid Cloud Environment</strong></p><p>Chapter 25: Cloud Backups and Restores</p><p>Chapter 26: Storing Data Files in Windows Azure</p><p>Chapter 27: Migrating to the Cloud<br></p><p></p><p></p><p></p>
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.
<p>Pro SQL Server Administration brings SQL Server administration into the modern era with strong coverage of hybrid cloud environments, in-memory support, and Server Core installs suitable for virtualization.</p>

Diese Produkte könnten Sie auch interessieren:

Quantifiers in Action
Quantifiers in Action
von: Antonio Badia
PDF ebook
CHF 118.00
Managing and Mining Uncertain Data
Managing and Mining Uncertain Data
von: Charu C. Aggarwal
PDF ebook
CHF 118.00