Beginning SQL server 2000 DBA: from novice to professional

Front Cover
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.

From inside the book

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Being a DBA
1
SQL Server Installation
21
Creating a Database
93
Copyright

13 other sections not shown

Other editions - View all

Common terms and phrases

About the author (2004)

Tony Bain is the founder of Tony Bain & Associates. He has worked with SQL Server for the last 6 years, and he is passionate about all database technologies, especially when they relate to enterprise availability and scalability. Tony currently holds the Microsoft Certified System Engineer, Microsoft Certified Solution Developer, and Microsoft Certified Database Administrator certifications.

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.

Primarily a database technology specialist, Mike Benkovich is a founder of the consulting firm ATG-Imagine! Technologies, a company that focuses on integrating relational technologies withing the client/server framework. Mike has had the good fortune to have worked in a variety of fields including architecture, project management, software development, and technical writing. Mike appeared in Microsoft's DevCast in 1994, and has since been a lecturer and presenter of technical information at corporate conferences and board meetings.

Joseph Sack works for Microsoft as a SQL Server dedicated support engineer on the Premier Field Engineering team. For more than 10 years, he has been developing and supporting SQL Server environments for clients in financial services, IT consulting, manufacturing, retail and the real estate industry. He is the author of SQL Server 2005 T-SQL Recipes and SQL Server 2000 Fast Answers for DBAs and Developers. He is the co-author of Pro SQL Server 2005 and Beginning SQL Server 2000 DBA: From Novice to Professional.

Brian Freeman is a software engineer with Carnegie Technologies and Bluewave Computing (http://www.bluewave-computing.com) in Atlanta, Georgia. His primary role is designing and implementing custom software in Visual Basic with different back-end storage platforms. His current project is an insurance program suite using SQL Server and VB 6.

Bibliographic information