Beginning SQL Server 2000 DBA: From Novice to Professional - Softcover

Pavliashvili, Baya; Benkovich, Michael; Bain, Tony; Freeman, Brian; Sack, Joseph

Softcover

ISBN 10: 159059293X ISBN 13: 9781590592939

Publisher: Apress, 2004

Synopsis

SQL Server 2000 is the leading relational database in the Windows market. The increased manageability of SQL Server 2000 has also increased its popularity--anyone, not just database administrators, can use a SQL Server database. This book recognizes that aspiring database administrators 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. Aspiring database administrators can benefit from the direction and advice of 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 database administrators. In essence this book is that "mentor which is what sets it apart from the other books on the market that only present feature overviews. Database novices will learn the core job and roles involved in administering a SQL Server database. You'll follow the life cycle of the database from installation, design, and modeling through to development, tuning, and securing, and onto growth and migration. This comprehensive guide provides practical advice, answers typical questions that you'll encounter from managers and developers, and offers practical steps to overcome issues with which new database administrators traditionally struggle. At every stage of the life cycle, this book supplies a range of tried-and-tested practices and techniques that will help you to establish and maintain a healthy database system.

About this title

About the Author

Tony Bain: 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. He is the coauthor of VB.NET & SQL Server 2000: Building an Effective Data Layer, SQL Server 2000 Stored Procedure Handbook, and Beginning SQL Server 2000 Programming, Professional SQL Server 2000 Data Warehousing with Analysis Services. Baya Pavliashvili: 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: 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.

Synopsis

SQL Server 2000 is the leading relational database in the Windows market. The increased manageability of SQL Server 2000 has also increased its popularity--anyone, not just database administrators, can use a SQL Server database. 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. Aspiring DBAs can benefit from the direction and advice of 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," which is what sets it apart from the other books on the market that only present feature overviews. Database novices will learn the core job and roles involved in administering a SQL Server database. You'll follow the life cycle of the database from installation, design, and modeling; through to development, tuning, and securing; and on to growth and migration.This comprehensive guide provides practical advice, answers typical questions that you'll encounter from managers and developers, and offers practical steps to overcome issues with which new DBAs traditionally struggle.

At every stage of the life cycle, this book supplies a range of tried-and-tested practices and techniques that will help you to establish and maintain a healthy database system.

Edition details

• Publisher: Apress
• Publication date: 2004
• ISBN 10: 159059293X
• ISBN 13: 9781590592939
• Binding: Paperback
• Language: English
• Number of pages: 709