Professional Microsoft SQL Server 2008 Administration

Professional Microsoft SQL Server 2008 Administration

1. Aufl.

von: Brian Knight, Ketan Patel, Wayne Snyder, Ross LoForte, Steven Wort

41,99 €

Verlag: Wiley
Format: EPUB
Veröffentl.: 04.01.2011
ISBN/EAN: 9780470440377
Sprache: englisch
Anzahl Seiten: 924

DRM-geschütztes eBook, Sie benötigen z.B. Adobe Digital Editions und eine Adobe ID zum Lesen.


SQL Server 2008 is how-to guide for experienced DBAs. Tutorial-based, this book will get you over the learning curve of how to configure and administer SQL Server 2008. Whether you're an administrator or developer using SQL Server, you can't avoid wearing a DBA hat at some point. The book is loaded with unique tips and workarounds for the most difficult SQL Server admin issues, including managing and monitoring SQL Server, automating administration, security, performance tuning, scaling and replications, clustering, and backup and recovery. A companion website is also available.
Forward. Chapter 1. SQL Server 2005 Architecture. Chapter 2. SQL Server 2005 Installation Best Practices. Chapter 3. Upgrading SQL Server 2008 Best Practices. Chapter 4. Managing and Troubleshooting the Database Engine. Chapter 5. Automating SQL Server. Chapter 6. Integration Services Administration and Performance Tuning. Chapter 7. Analysis Services Administration and Performance Tuning. Chapter 8. Administering the Development Features. Chapter 9. Securing the Database Engine. Chapter 10. Change Management. Chapter 11. Configuring the Server for Optimal Performance. Chapter 12. Optimizing SQL Server 2005. Chapter 13. Monitoring Your SQL Server. Chapter 14. Performance Tuning T-SQL. Chapter 15. Indexing Your Database. Chapter 16. Replication. Chapter 17. Database Mirroring. Chapter 18. Backup and Recovery. Chapter 19. SQL Server 2005 Log Shipping. Chapter 20. Clustering SQL Server 2005.
Brian Knight, SQL Server MVP, MCDBA is a database manager at Fidelity National Financial and a co-founder of He has worked with SQL Server for 10 years and has written several SQL Server books, including Wrox' Professional SQL Server 2005 Integration Services. Ketan Patel is a Development Manager for the Business Intelligence Center of Excellence group at Microsoft. He has worked with SQL Server and other Microsoft technologies for more than 10 years, and has presented at TechEd. Ross LoForte is a SQL technology architect at the Microsoft Technology Center Chicago who specializes in Microsoft SQL Server solutions. He has more than 16 years experience developing, managing, and architecting SQL solutions on large, mission-critical database platforms. Ross presents at TechEd, SQL PASS, Gartner, TDWI, and other conferences.
Professional Microsoft® SQL Server® 2008 Administration SQL Server 2008 represents a significant jump forward in scalability and performance. Database administrators — and developers as well — will need to master new methods for effectively managing increasingly large and complex SQL Server environments. This author team of SQL Server experts arms you with unique tips, tricks, and workarounds, including managing and monitoring SQL Server, automating administration, clustering, performance tuning, handling backup and recovery, and more. You'll learn the various tools that are available to you with the 2008 release, as well as new features such as Performance Studio, Change Data Capture, Policy-based Management, and Query Governor. With a solid understanding of SQL Server 2008, you'll be able to confidently handle even the most difficult SQL Server admin issues. What you will learn from this book Best practices for SQL Server 2008 installation Tips for troubleshooting and securing the database engine How to automate SQL Server Ways to index your database Methods for monitoring your SQL Server instance How to performance tune your SQL Server instance Who this book is for This book is for experienced database administrators who are interested in learning best pratices for administering SQL Server 2008. 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.

Diese Produkte könnten Sie auch interessieren:

Blockchain für Dummies
Blockchain für Dummies
von: Tiana Laurence
EPUB ebook
19,99 €
Data Modeling Fundamentals
Data Modeling Fundamentals
von: Paulraj Ponniah
PDF ebook
124,99 €
Software Specification Methods
Software Specification Methods
von: Henri Habrias, Marc Frappier
PDF ebook
145,99 €