Pro SQL Server 2008 Administration by Ken Simmons, Sylvester Carstarphen

Pro SQL Server 2008 Administration



Download Pro SQL Server 2008 Administration




Pro SQL Server 2008 Administration Ken Simmons, Sylvester Carstarphen
Language: English
Page: 594
Format: pdf
ISBN: 1430223731, 9781430223733
Publisher: Apress

Pro SQL Server 2008 Administration is critical for database administrators seeking in-depth knowledge on administering SQL Server 2008. This book covers the impact of the new features available in SQL Server 2008 specifically targeted for database administrators, along with the tried-and-true advanced techniques required to support and maintain Microsoft SQL Server.

Introduces new administration features of SQL Server 2008 Shows how to manage a SQL Server 2008 database at professional level Provides guidance on performance optimization What you’ll learn Take advantage of the new administrative features in SQL Server 2008 Make intelligent decisions when choosing an installation or upgrade path Define and implement database policies to create a consistent, predictable environment throughout the organization Automate repetitive Tasks for increased productivity Create baseline monitors using Performance Monitor, Profiler, and System Dynamic Management views Identify and resolve long-running, I/O, and CPU-intensive queries Who this book is for

This book is for junior and seasoned database administrators who are looking to develop their knowledge and skill set in Microsoft SQL Server 2008.

Table of Contents New Feature Overview Pre:Installation Considerations Choosing a High Availability Solution Installing Microsoft SQL Server 2008 Upgrading to Microsoft SQL Server 2008 Post Installation Multi-Server Administration Managing Security within the Database Engine Administering Database Objects Indexing for Performance Managing Backups Restore and Recovery Strategies Automating Routine Maintenance Monitoring Your Server Auditing SQL Server Managing Query Performance Secrets to Excelling as a Professional DBA What's Next?

About the Author

Ken Simmons is a database administrator/developer specializing in MSSQL Server and .NET. He is currently working with a global electronic payment service provider in Columbus, Georgia. He has been working in the IT industry since 2000 and currently holds certifications for MCP, MCAD, MCSD, MCDBA, and MCTS for SQL 2005.

Ken is highly active in the online community and often participates in the SQL forums on MSDN and SQLServerCentral. He enjoys sharing tips that he discovers by writing articles for SQLServerCentral and MSSQLTips.com. He has also formed a SQL Server Users Group in Columbus, Georgia, for SQL Server professionals to come together to share knowledge and resources. When he is not working, Ken enjoys traveling with his wife, Susan, and 3-year-old son, Nathan, and can often be found on a cruise ship, at a Disney resort, or at the beach in his hometown of Pensacola, FL.

Sylvester Carstarphen is a senior database administrator for a CRM company where he is heavily involved in the performance monitoring and tuning of the company's very large databases. Sylvester started his database administration career almost 6 years ago at a Fortune 500 financial corporation where he rapidly progressed from DBA I, to DBA II, SR DBA, and finally working manager of database support in 4 years. His role consisted of managing six SQL Server DBAs and an environment of 100+ SQL Servers with 150+ application databases. In search of opportunities to increase his performance tuning skills, Sylvester took on a new role with the CRM company to help solve their major performance issues.

Sylvester possesses a bachelor's degree in computer science from Wofford College and a master's degree in applied computer science with a concentration in software development from Columbus State University. Sylvester enjoys playing video games and spending time with his wife and two American Staffordshire Terrier dogs

MORE EBOOKS:
Die Chronik der Unsterblichen 9: Das Damonenschiff download pdf







Tags: Pro SQL Server 2008 Administration ebook pdf djvu epub
Pro SQL Server 2008 Administration download pdf epub djvu
Download Pro SQL Server 2008 Administration free ebook pdf
Read Pro SQL Server 2008 Administration online book
Pro SQL Server 2008 Administration cheap ebook for kindle and nook
Pro SQL Server 2008 Administration download book
Ken Simmons, Sylvester Carstarphen ebooks
Pro SQL Server 2008 Administration download pdf rapidshare mediafire fileserve 4shared torrent