 |
Beginning SQL Server 2000 DBA: From Novice to Pro
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
SQL Server 2000 is the leading relational database in the Windows market. The increased manageability of SQL Server 2000 has "lowered the bar" with regard to the people that can use it -- anyone can use a SQL Server database. However, this book recognizes that aspiring DBAs need more than just a basic knowledge of the available features in order to be considered "a safe pair of hands" for the database and the mission-critical data that is stored in it. They require direction and advice from an expert mentor who not only understands the features available and how they should be used, but also knows what it takes to be a good and effective DBA. In essence, this book is that "mentor", and this is why the book stands apart from the "feature overview" competition.
The book teaches a database novice the core job and roles involved in administering a SQL Server database. It follows the lifecycle of the database, from installation, design and modeling, through development, tuning and securing to growth and migration. It provides practical advice ("How to..."), answers typical questions that they'll encounter from managers and developers ("How do I..."), and offers practical steps to overcome issues with which beginners traditionally struggle. At every stage, it establishes a range of tried-and-tested practices and techniques that will establish and maintain the health of a DB system ("How to be a good DBA").
Author Information
Tony Bain is the founder of Tony Bain & Associates and he has worked with SQL Server for the last 6 years. He is passionate about all database technologies especially when they relate to enterprise availability and scalability. Tony currently has Microsoft Certified System Engineer, Microsoft Certified Solution Developer, and Microsoft Certified Database Administrator certification.
Michael Benkovich is a database technology specialist and founder of the consulting firm of ATG-Imagine! Technologies, based in Minneapolis, Minnesota. Focusing on the effective use of relational technologies for scalable, performant, and mission critical applications, Mike has had the good fortune to have worked in a variety of roles including architect, project manager, developer and technical writer. Since appearing in Microsoft's DevCast in 1994, Mike has been a lecturer and presenter of technical information at conferences and board rooms of corporate America.
Baya Pavliashvili is Senior Database Administrator possessing extensive development experience with the latest client-server and Web technologies as well as Visual Studio .NET. He has in-depth knowledge and demonstrated experience of Microsoft SQL Server database administration and specializes in systems and business analysis, logical and physical database design, database administration, replication, data warehousing and OLAP, query optimization, application performance tuning and database programming. He is also experienced in systems integration, software testing, implementation, support, and training. Pavliashvili is a Microsoft Certified Database Administrator (MCDBA), Microsoft Certified Solution Developer (MCSD), and Microsoft Certified Systems Engineer (MCSE). He is the coauthor of .Net E-Business Architecture , Knowledge Expert for SQL Server (QUEST, available on CD only), and contributor to SQL Server Security Distilled.
Joseph Sack is a database administration and developer consultant based in Minneapolis, Minnesota. Since 1997, he has been developing and supporting SQL Server environments for clients in financial services, IT consulting, manufacturing, and the real estate industry. He is a Microsoft Certified Database Administrator (MCDBA). Sack received his bachelor’s degree in Psychology from the University of Minnesota. He is the author of SQL Server 2000 Fast Answers for DBAs and Developers.
Table of Contents
- Chapter 1: Being a DBA
- Chapter 2: SQL Server Installation
- Chapter 3:Creating a Database
- Chapter 4: DML and Querying
- Chapter 5: Basic Management Tasks
- Chapter 6: Security
- Chapter 7: Networking
- Chapter 8: Backup and Recovery
- Chapter 9: Replication
- Chapter 10: Development with T-SQL
- Chapter 11: Data Warehousing and Analysis
- Chapter 12: Data Transformation Services
- Chapter 13: Monitor, Profile, Tune
- Chapter 14: Keeping the Plates Spinning
|
|
