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.
Auflage
Sprache
Verlagsort
Zielgruppe
Produkt-Hinweis
Broschur/Paperback
Klebebindung
Illustrationen
Maße
Höhe: 234 mm
Breite: 191 mm
Dicke: 41 mm
Gewicht
ISBN-13
978-1-59059-293-9 (9781590592939)
DOI
10.1007/978-1-4302-0703-0
Schweitzer Klassifikation
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.
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.