Professional Microsoft SQL Server 2012 Administration (eBook)

eBook Download: EPUB
2012
Wiley (Verlag)
978-1-118-28218-2 (ISBN)

Lese- und Medienproben

Professional Microsoft SQL Server 2012 Administration -  Adam Jorgensen,  Brian Knight,  Ross LoForte,  Steven Wort
Systemvoraussetzungen
38,99 inkl. MwSt
  • Download sofort lieferbar
  • Zahlungsarten anzeigen
An essential how-to guide for experienced DBAs on the most significant product release since 2005! Microsoft SQL Server 2012 will have major changes throughout the SQL Server and will impact how DBAs administer the database. With this book, a team of well-known SQL Server experts introduces the many new features of the most recent version of SQL Server and deciphers how these changes will affect the methods that administrators have been using for years. Loaded with unique tips, tricks, and workarounds for handling the most difficult SQL Server admin issues, this how-to guide deciphers topics such as performance tuning, backup and recovery, scaling and replication, clustering, and security. Serves as a must-have how-to guide on the new features of the 2012 release of Microsoft SQL Server Walks you through ways to manage and monitor SQL Server and automate administration Guides you through SQL Azure for cloud computing, data replication, and data warehouse performance improvements Addresses client-connectivity enhancements, new features that ensure high availability of mission-critical applications, and tighter integration with Excel and SharePoint for data analysis and reporting Highlights major changes to the suite of SQL Server BI tools, including integration, reporting, and analysis services Includes real-world case examples and best practices from Microsoft insiders If you're a database administrator eager to get started with the newest version of SQL Server, then this book is essential reading.

Adam Jorgensen is the President of Pragmatic Works Consulting, a Director for the Professional Association of SQL Server (PASS), SQL Server MVP, and a well-known speaker, author, and executive mentor. Steven Wort has been working with SQL Server since 1993. He joined Microsoft in 2000, and now works in the SQL Server Appliance Engineering Team leading the engineering work for the Microsoft Database Consolidation Appliance. Ross LoForte is a Microsoft SQL technology expert with 20+ years of experience developing and implementing solutions for Microsoft's largest customers. He works for the Microsoft Technology Center in Chicago and is active with the Professional Association for SQL Server. Brian Knight is the founder of Pragmatic Works and co-founder of SQLServerCentral.com and JumpstartTV.com.

INTRODUCTION xxxvii

CHAPTER 1: SQL SERVER 2012 ARCHITECTURE 1

CHAPTER 2: INSTALLING SQL SERVER 2012 BEST PRACTICES 21

CHAPTER 3: UPGRADING SQL SERVER 2012 BEST PRACTICES 53

CHAPTER 4: MANAGING AND TROUBLESHOOTING THE DATABASE ENGINE
71

CHAPTER 5: AUTOMATING SQL SERVER 105

CHAPTER 6: SERVICE BROKER IN SQL SERVER 2012 147

CHAPTER 7: SQL SERVER CLR INTEGRATION 167

CHAPTER 8: SECURING THE DATABASE INSTANCE 181

CHAPTER 9: CHANGE MANAGEMENT 197

CHAPTER 10: CONFIGURING THE SERVER FOR OPTIMAL PERFORMANCE
233

CHAPTER 11: OPTIMIZING SQL SERVER 2012 273

CHAPTER 12: MONITORING YOUR SQL SERVER 317

CHAPTER 13: PERFORMANCE TUNING T-SQL 399

CHAPTER 14: INDEXING YOUR DATABASE 449

CHAPTER 15: REPLICATION 473

CHAPTER 16: CLUSTERING SQL SERVER 2012 509

CHAPTER 17: BACKUP AND RECOVERY 547

CHAPTER 18: SQL SERVER 2012 LOG SHIPPING 607

CHAPTER 19: DATABASE MIRRORING 641

CHAPTER 20: INTEGRATION SERVICES ADMINISTRATION AND PERFORMANCE
TUNING 695

CHAPTER 21: ANALYSIS SERVICES ADMINISTRATION AND PERFORMANCE
TUNING 729

CHAPTER 22: SQL SERVER REPORTING SERVICES ADMINISTRATION 765

CHAPTER 23: SQL SERVER 2012 SHAREPOINT 2010 INTEGRATION 815

CHAPTER 24: SQL AZURE ADMINISTRATION AND CONFIGURATION 837

CHAPTER 25: ALWAYSON AVAILABILITY GROUPS 857

INDEX 885

Erscheint lt. Verlag 28.3.2012
Sprache englisch
Themenwelt Informatik Datenbanken SQL Server
Mathematik / Informatik Informatik Netzwerke
Schlagworte book on Microsoft SQL Server • book on Microsoft SQL Server 2011 • book on SQL Server 2011 • Computer Science • concepts of Microsoft SQL Server • concepts of Microsoft SQL Server 2011 • Database & Data Warehousing Technologies • Datenbanken u. Data Warehousing • features of Microsoft SQL Server • features of Microsoft SQL Server 2011 • Informatik • introduction to Microsoft SQL Server • introduction to Microsoft SQL Server 2011 • introduction to SQL Server 2011 • introduction to SQL Server 2012 • Microsoft SQL Server • Microsoft SQL Server 2011 • Microsoft SQL Server 2011 introduction • Microsoft SQL Server 2011 overview • Microsoft SQL Server introduction • Microsoft SQL Server overview • new version of Microsoft SQL Server • new version of Microsoft SQL Server 2011 • overview of Microsoft SQL Server • overview of Microsoft SQL Server 2011 • SQL Server • SQL Server 2011
ISBN-10 1-118-28218-3 / 1118282183
ISBN-13 978-1-118-28218-2 / 9781118282182
Haben Sie eine Frage zum Produkt?
EPUBEPUB (Adobe DRM)
Größe: 69,2 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: EPUB (Electronic Publication)
EPUB ist ein offener Standard für eBooks und eignet sich besonders zur Darstellung von Belle­tristik und Sach­büchern. Der Fließ­text wird dynamisch an die Display- und Schrift­größe ange­passt. Auch für mobile Lese­geräte ist EPUB daher gut 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

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