-18%
35,99 €
Statt 43,99 €**
35,99 €
inkl. MwSt.
**Preis der gedruckten Ausgabe (Broschiertes Buch)
Sofort per Download lieferbar
0 °P sammeln
-18%
35,99 €
Statt 43,99 €**
35,99 €
inkl. MwSt.
**Preis der gedruckten Ausgabe (Broschiertes Buch)
Sofort per Download lieferbar

Alle Infos zum eBook verschenken
0 °P sammeln
Als Download kaufen
Statt 43,99 €**
-18%
35,99 €
inkl. MwSt.
**Preis der gedruckten Ausgabe (Broschiertes Buch)
Sofort per Download lieferbar
0 °P sammeln
Jetzt verschenken
Statt 43,99 €**
-18%
35,99 €
inkl. MwSt.
**Preis der gedruckten Ausgabe (Broschiertes Buch)
Sofort per Download lieferbar

Alle Infos zum eBook verschenken
0 °P sammeln
  • Format: PDF


Learn to take advantage of the opportunities offered by SQLServer 2014 Microsoft's SQL Server 2014 update means big changes fordatabase administrators, and you need to get up to speed quicklybecause your methods, workflow, and favorite techniques will bedifferent from here on out. The update's enhanced support oflarge-scale enterprise databases and significant price advantagemean that SQL Server 2014 will become even more widely adoptedacross the industry. The update includes new backup and recoverytools, new AlwaysOn features, and enhanced cloud capabilities.In-memory OLTP, Buffer Pool…mehr

Produktbeschreibung
Learn to take advantage of the opportunities offered by SQLServer 2014 Microsoft's SQL Server 2014 update means big changes fordatabase administrators, and you need to get up to speed quicklybecause your methods, workflow, and favorite techniques will bedifferent from here on out. The update's enhanced support oflarge-scale enterprise databases and significant price advantagemean that SQL Server 2014 will become even more widely adoptedacross the industry. The update includes new backup and recoverytools, new AlwaysOn features, and enhanced cloud capabilities.In-memory OLTP, Buffer Pool Extensions for SSDs, and a newCardinality Estimator can improve functionality and smooth out theworkflow, but only if you understand their full capabilities.Professional Microsoft SQL Server 2014 is your comprehensiveguide to working with the new environment. Authors Adam Jorgensen,Bradley Ball, Ross LoForte, Steven Wort, and Brian Knight are thedream team of the SQL Server community, and they put theirexpertise 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, andclustering * Learn new options for backup and recovery Professional Microsoft SQL Server 2014 includes acompanion website with sample code and efficient automationutilities, plus a host of tips, tricks, and workarounds that willmake your job as a DBA or database architect much easier. Stopgetting frustrated with administrative issues and start takingcontrol. Professional Microsoft SQL Server 2014 is yourroadmap to mastering the update and creating solutions thatwork.

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, D ausgeliefert werden.

  • Produktdetails
  • Verlag: John Wiley & Sons
  • Seitenzahl: 936
  • Erscheinungstermin: 27. August 2014
  • Englisch
  • ISBN-13: 9781118859261
  • Artikelnr.: 41495241
Autorenporträt
Adam Jorgensen is the President of Pragmatic Works andthe Executive Vice President of PASS with more than 15 yearsexperience. Bradley Ball is a MCITP 2005, 2008, and 2012 MCSE DBAwith more than a decade of experience who is currently the DataPlatform Management Lead with Pragmatic Works specializing in DataPlatform solutions. Steven Wort has been working with SQL Server since 1993,who joined Microsoft in 2000, and now works as an Architect in theCRM Service Engineering team. Ross LoForte is a Technology Architect at the MicrosoftTechnology Center Chicago focused on Microsoft SQL Serversolutions, with more than 20 years of business development, projectmanagement, and SQL experience. Brian Knight is the founder of Pragmatic Works andco-founder of SQLServerCentral.com and JumpStartTV.com Wrox Professional guides are planned and written byworking programmers to meet the real-world needs of programmers,developers, and IT professionals. Focused and relevant, theyaddress the issues technology professionals face every day. Theyprovide examples, practical solutions, and expert education in newtechnologies, all designed to help programmers do a better job.
Inhaltsangabe
INTRODUCTION xxxvii

CHAPTER 1: SQL SERVER 2014 ARCHITECTURE 1

CHAPTER 2: INSTALLING SQL SERVER 2014 BEST PRACTICES 23

CHAPTER 3: UPGRADING SQL SERVER 2014 BEST PRACTICES 57

CHAPTER 4: MANAGING AND TROUBLESHOOTING THE DATABASE ENGINE 79

CHAPTER 5: AUTOMATING SQL SERVER 113

CHAPTER 6: SERVICE BROKER IN SQL SERVER 2014 155

CHAPTER 7: SQL SERVER CLR INTEGRATION 185

CHAPTER 8: SECURING THE DATABASE INSTANCE 199

CHAPTER 9: IN-MEMORY OLTP 215

CHAPTER 10: CONFIGURING THE SERVER FOR OPTIMAL PERFORMANCE 247

CHAPTER 11: OPTIMIZING SQL SERVER 2014 281

CHAPTER 12: MONITORING YOUR SQL SERVER 325

CHAPTER 13: PERFORMANCE TUNING T-SQL 391

CHAPTER 14: INDEXING YOUR DATABASE 425

CHAPTER 15: REPLICATION 449

CHAPTER 16: CLUSTERING SQL SERVER 2014 491

CHAPTER 17: BACKUP AND RECOVERY 535

CHAPTER 18: SQL SERVER 2014 LOG SHIPPING 593

CHAPTER 19: DATABASE MIRRORING 629

CHAPTER 20: INTEGRATION SERVICES ADMINISTRATION AND PERFORMANCE TUNING 667

CHAPTER 21: ANALYSIS SERVICES ADMINISTRATION AND PERFORMANCE TUNING 701

CHAPTER 22: SQL SERVER REPORTING SERVICES ADMINISTRATION 725

CHAPTER 23: SQL SERVER 2014 SHAREPOINT 2013 INTEGRATION 763

CHAPTER 24: SQL DATABASE ADMINISTRATION AND CONFIGURATION 789

CHAPTER 25: ALWAYSON AVAILABILITY GROUPS 813

INDEX 849