Professional Microsoft SQL Server 2014 Adminstration
Paperback Engels 2014 9781118859131Samenvatting
Best practices for administering SQL Server 2014, from Microsoft MVPs
This comprehensive guide teaches the skills needed to successfully administer SQL Server, including change management, security, performance tuning, monitoring, and backups. Written by the leading authorities on Microsoft SQL Server, this book will help you master the latest features of the 2014 release, including greater integration of cloud and on–premises management using SQL Server Management Studio, enhanced performance optimization, new cardinality estimator, and new features for AlwaysOn availability groups. This comprehensive guide will help you improve the efficiency, scalability, and performance of the SQL Server environment so more can be done in less time.
Professional Microsoft SQL Server 2014 Administration:
- Provides an overview of SQL Azure and new features for AlwaysOn availability groups
- Explains In–Memory OLTP and buffer pool extensions for SSDs and performance optimizations for 2014
- Details the new cardinality estimator (Query Optimizer) in SQL 2014
- Discusses the separation of duties and important regulatory requirements for security roles
- Provides real–world case examples and solutions
- Programmer Forums: Join our Programmer to Programmer forums to ask and answer programming questions about this book, join discussions on the hottest topics in the industry, and connect with fellow programmers from around the world.
- Code Downloads: Take advantage of free code samples from this book, as well as code samples from hundreds of other books, all ready to use.
- Read More: Find articles, e–books, sample chapters, and tables of contents for hundreds of books, and more reference resources on programming topics that matter to you.
Specificaties
Lezersrecensies
Geef uw waardering
Over Ross LoForte
Over Brian Knight
Inhoudsopgave
1. SQL SERVER 2014 ARCHITECTURE
2. INSTALLING SQL SERVER 2014 BEST PRACTICES
3. UPGRADING SQL SERVER 2014 BEST PRACTICES
4. MANAGING AND TROUBLESHOOTING THE DATABASE ENGINE
5. AUTOMATING SQL SERVER
6. SERVICE BROKER IN SQL SERVER 2014
7. SQL SERVER CLR INTEGRATION
8. SECURING THE DATABASE INSTANCE
9. IN-MEMORY OLTP
10. CONFIGURING THE SERVER FOR OPTIMAL PERFORMANCE
11. OPTIMIZING SQL SERVER 2014
12. MONITORING YOUR SQL SERVER
13. PERFORMANCE TUNING T-SQL
14. INDEXING YOUR DATABASE
15. REPLICATION
16. CLUSTERING SQL SERVER 2014
17. BACKUP AND RECOVERY
18. SQL SERVER 2014 LOG SHIPPING
19. DATABASE MIRRORING
20. INTEGRATION SERVICES ADMINISTRATION AND PERFORMANCE TUNING
21. ANALYSIS SERVICES ADMINISTRATION AND PERFORMANCE TUNING
22. SQL SERVER REPORTING SERVICES ADMINISTRATION
23. SQL SERVER 2014 SHAREPOINT 2013 INTEGRATION
24. SQL DATABASE ADMINISTRATION AND CONFIGURATION
25. ALWAYSON AVAILABILITY GROUPS
INDEX
Rubrieken
- Advisering
- Algemeen management
- Coaching en trainen
- Communicatie en media
- Economie
- Financieel management
- Inkoop en logistiek
- Internet en social media
- IT-management / ICT
- Juridisch
- Leiderschap
- Marketing
- Mens en maatschappij
- Non-profit
- Ondernemen
- Organisatiekunde
- Personal finance
- Personeelsmanagement
- Persoonlijke effectiviteit
- Projectmanagement
- Psychologie
- Reclame en verkoop
- Strategisch management
- Verandermanagement
- Werk en loopbaan