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 "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").

About this title

About the Author

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 of and demonstrated experience with Microsoft SQL Server database administration, and he 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 and Knowledge Expert for SQL Server, and he contributed to SQL Server Security Distilled.

Edition details

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