Beginning SQL Server 2000 DBA: From Novice to Professional

Overview

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

See more details below
Paperback (New Edition)
$44.63
BN.com price
(Save 10%)$49.99 List Price
Other sellers (Paperback)
  • All (17) from $1.99   
  • New (5) from $31.87   
  • Used (12) from $1.99   
Sending request ...

Overview

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.

Read More Show Less

Product Details

  • ISBN-13: 9781590592939
  • Publisher: Apress
  • Publication date: 1/8/2004
  • Edition description: New Edition
  • Edition number: 1
  • Pages: 696
  • Product dimensions: 1.46 (w) x 7.50 (h) x 9.25 (d)

Meet 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.

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.

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.

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.

Joseph Sack is a Principal Consultant with SQLskills. He has worked as a SQL Server professional since 1997 and has supported and developed for SQL Server environments in financial services, IT consulting, manufacturing, retail, and the real estate industry. Prior to joining SQLskills, he worked at Microsoft as a Premier Field Engineer supporting very large enterprise customer environments. He was responsible for providing deep SQL Server advisory services, training, troubleshooting, and ongoing solutions guidance. His areas of expertise include performance tuning, scalability, T-SQL development, and high-availability. In 2006 Joe earned the Microsoft Certified Master: SQL Server 2005 certification; and in 2008, he earned the Microsoft Certified Master: SQL Server 2008 certification. In 2009 he took over responsibility for the SQL Server Microsoft Certified Master program and held that post until 2011. He is the author of a few books and white papers, including most recently, "SQL Server 2008 Transact-SQL Recipes" (Apress, 2008). Joe's blog is at www.SQLskills.com/blogs/joe, and he can be reached at joe@SQLskills.com.

Read More Show Less

Table of Contents

Introduction
Ch. 1 Being a DBA 1
Ch. 2 SQL Server Installation 21
Ch. 3 Creating a Database 93
Ch. 4 DML and Querying 147
Ch. 5 Basic Management Tasks 191
Ch. 6 Security 231
Ch. 7 Connectivity 291
Ch. 8 Backup and Recovery 331
Ch. 9 Replication 401
Ch. 10 Development with Transact-SQL 469
Ch. 11 Data Warehousing and Analysis 533
Ch. 12 Data Transformation Services 569
Ch. 13 Monitor, Profile, and Tune 601
Ch. 14 Keeping the Plates Spinning 625
Index 653
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted March 2, 2004

    excellent for starters

    this title stands out because it goes into enough depth to make a pro out of a beginner; it doesn't just stop at 'SELECT * FROM authors' and point you to books online. This book discusses all aspects of working as a SQL Server 2000 DBA, including configuring, tuning, replication, data warehousing and more. Highly recommended for people new to the DBA role as well as intermediate level (up to 5 years of experience).

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)