Professional Microsoft SQL Server 2014 Administration (eBook)

eBook Download: PDF
2014 | 1. Auflage
936 Seiten
John Wiley & Sons (Verlag)
978-1-118-85926-1 (ISBN)

Lese- und Medienproben

Professional Microsoft SQL Server 2014 Administration - Adam Jorgensen, Bradley Ball, Steven Wort, Ross Loforte, Brian Knight
Systemvoraussetzungen
35,99 inkl. MwSt
  • Download sofort lieferbar
  • Zahlungsarten anzeigen
Learn to take advantage of the opportunities offered by SQL
Server 2014

Microsoft's SQL Server 2014 update means big changes for
database administrators, and you need to get up to speed quickly
because your methods, workflow, and favorite techniques will be
different from here on out. The update's enhanced support of
large-scale enterprise databases and significant price advantage
mean that SQL Server 2014 will become even more widely adopted
across the industry. The update includes new backup and recovery
tools, new AlwaysOn features, and enhanced cloud capabilities.
In-memory OLTP, Buffer Pool Extensions for SSDs, and a new
Cardinality Estimator can improve functionality and smooth out the
workflow, but only if you understand their full capabilities.
Professional Microsoft SQL Server 2014 is your comprehensive
guide to working with the new environment. Authors Adam Jorgensen,
Bradley Ball, Ross LoForte, Steven Wort, and Brian Knight are the
dream team of the SQL Server community, and they put their
expertise 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, and
clustering

* Learn new options for backup and recovery

Professional Microsoft SQL Server 2014 includes a
companion website with sample code and efficient automation
utilities, plus a host of tips, tricks, and workarounds that will
make your job as a DBA or database architect much easier. Stop
getting frustrated with administrative issues and start taking
control. Professional Microsoft SQL Server 2014 is your
roadmap to mastering the update and creating solutions that
work.

Adam Jorgensen is the President of Pragmatic Works and the Executive Vice President of PASS with more than 15 years experience. Bradley Ball is a MCITP 2005, 2008, and 2012 MCSE DBA with more than a decade of experience who is currently the Data Platform Management Lead with Pragmatic Works specializing in Data Platform solutions. Steven Wort has been working with SQL Server since 1993, who joined Microsoft in 2000, and now works as an Architect in the CRM Service Engineering team. Ross LoForte is a Technology Architect at the Microsoft Technology Center Chicago focused on Microsoft SQL Server solutions, with more than 20 years of business development, project management, and SQL experience. Brian Knight is the founder of Pragmatic Works and co-founder of SQLServerCentral.com and JumpStartTV.com Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

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

Erscheint lt. Verlag 27.8.2014
Sprache englisch
Themenwelt Informatik Datenbanken SQL Server
Mathematik / Informatik Informatik Netzwerke
Schlagworte Computer Science • Database & Data Warehousing Technologies • Datenbanken u. Data Warehousing • Informatik • SQL Server 2014
ISBN-10 1-118-85926-X / 111885926X
ISBN-13 978-1-118-85926-1 / 9781118859261
Haben Sie eine Frage zum Produkt?
PDFPDF (Adobe DRM)
Größe: 31,7 MB

Kopierschutz: Adobe-DRM
Adobe-DRM ist ein Kopierschutz, der das eBook vor Mißbrauch schützen soll. Dabei wird das eBook bereits beim Download auf Ihre persönliche Adobe-ID autorisiert. Lesen können Sie das eBook dann nur auf den Geräten, welche ebenfalls auf Ihre Adobe-ID registriert sind.
Details zum Adobe-DRM

Dateiformat: PDF (Portable Document Format)
Mit einem festen Seiten­layout eignet sich die PDF besonders für Fach­bücher mit Spalten, Tabellen und Abbild­ungen. Eine PDF kann auf fast allen Geräten ange­zeigt werden, ist aber für kleine Displays (Smart­phone, eReader) nur einge­schränkt geeignet.

Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen eine Adobe-ID und die Software Adobe Digital Editions (kostenlos). Von der Benutzung der OverDrive Media Console raten wir Ihnen ab. Erfahrungsgemäß treten hier gehäuft Probleme mit dem Adobe DRM auf.
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 eine Adobe-ID sowie eine kostenlose App.
Geräteliste und zusätzliche Hinweise

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.

Mehr entdecken
aus dem Bereich
A Practical Guide to Analyzing Performance in SQL Server and Azure …

von Thomas LaRock; Enrico van de Laar

eBook Download (2023)
Apress (Verlag)
62,99