Beginning SQL Server 2000 DBA

From Novice to Professional
Softcover Nachdruck of the Original 1. Auflage 2004
ISBN: 978-1-59059-293-9
Verlag: Apress

Buch, Englisch, 696 Seiten, Format (B × H): 191 mm x 234 mm, Gewicht: 1225 g

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.

Zielgruppe

Popular/general

Autoren/Hrsg.

Pavliashvili, Baya

Bain, Tony

Benkovich, Michael

Sack, Joseph

Freeman, Brian

Fachgebiete

• Mathematik | Informatik EDV | Informatik Business Application Tabellenkalkulation
• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Datenbankprogrammierung
• Mathematik | Informatik EDV | Informatik Daten / Datenbanken Zeichen- und Zahlendarstellungen

Inhaltsverzeichnis

1: Being a DBA.- 2: SQL Server Installation.- 3: Creating a Database.- 4: DML and Querying.- 5: Basic Management Tasks.- 6: Security.- 7: Connectivity.- 8: Backup and Recovery.- 9: Replication.- 10: Development with Transact-SQL.- 11: Data Warehousing and Analysis.- 12: Data Transformation Services.- 13: Monitor, Profile, and Tune.- 14: Keeping the Plates Spinning.

Über Autor(innen)

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.