Microsoft SQL Server 2000 Database Administrator's Guidebook


Book Description

This book will describe the skills needed to be a successful and productive Microsoft SQL database administrator. It will also cover migration of DBA's from Oracle and Sybase to MS/SQL.




Microsoft SQL Server 2000


Book Description

Assuming some familiarity with database concepts and any version of the SQL Server software, database administrator Sharma looks at the features of the 2000 version, common errors and how to rectify them, sample code to explain the features, tips for improving performance, scripts and utilities for routine administration, and interfacing with the .NET environment. The disc contains code for several chapters. Annotation copyrighted by Book News, Inc., Portland, OR




Microsoft SQL Server 2000 DBA Survival Guide


Book Description

Organized into several parts that comprise the various jobs and tasks the DBA performs, each chapter of this book is presented with the goal of providing knowledge and "know-how" to Database Administrators of a SQL Server database. The chapters also offer real-world insight and experience by passing on tips, tricks, and suggestions.




Essential SQL Server 2000


Book Description

This hands-on guide covers the installation, configuration, and administration of SQL Server while providing practical solutions to the daily challenges faced by busy administrators. Filled with real-world examples, this is a succinct survival guide for both experienced professionals as well as those less familiar with the environment.




SQL Server 2000 Stored Procedures Handbook


Book Description

* Shows you how to write more effective stored procedures and functions * Concise, detailed advice from SQL Server experts * Tackles issues barely covered in existing books, such as optimizing and debugging, concurrency and transactions.




Microsoft SQL Server 2000 Administrator's Companion


Book Description

This title is the definitive daily operations guide to planning, deploying, and maintaining Microsoft SQL Server 2000. With it, administrators learn how to use this scalable, high-performance relational database management system to solve complex business challenges, launch Internet-based solutions, and lower the cost and complexity of distributed database solutions. This comprehensive reference introduces new features of both SQL Server 2000 and the Microsoft Windows 2000 operating system. And it includes an expanded section covering installation and setup, an example-rich segment on how to use SQL Server 2000 to create and modify databases, and information about built-in features such as DTC, MTS, and OLAP services. It's the essential daily operations guide for the SQL Server database administrator!




Microsoft SQL Server 2000 Unleashed


Book Description

"Microsoft SQL Server 2000 Unleashed, 2E" offers a variety of topics for system and database administrators to help them learn new features of the product and to solve problems they face on a daily basis. It shows them how to build upon their working knowledge of the product and take their experience and knowledge to a higher level. This new edition of "Microsoft SQL Server 2000 Unleashed" covers the latest updates and service packs to SQL Server 2000, including full support for XML, notification services, and SQL Server CE.




The SQL Server 7.0 Handbook


Book Description

Let the experts help you work smarter with the new SQL Server. The SQL Server 7.0 Handbook concisely and authoritatively explains how to design, implement, administer, and tune Microsoft's powerful new database management system for Windows NT. Readers will learn all major SQL Server 7.0 capabilities, especially its new scalability, decision support, performance, and replication features. The authors, recognized SQL Server authorities, including a former SQL Server product manager, explain how to use the database with other critical Microsoft data management technologies and products, including Microsoft Transaction Server and Active Data Objects (ADO). No other book will enable database administrators, designers, programmers, and IT managers to master SQL Server 7.0 more thoroughly or quickly. Computer professionals studying for Microsoft Certified Professional (MCSE) qualifications will find this book essential reading. Learn major new SQL Server 7.0 scalability and replication features Optimize and secure SQL Server 7.0 Develop data warehouses with SQL Server 7.0 decision support capabilities and OLAP Services




The Handbook for Reluctant Database Administrators


Book Description

Feeling reluctant? The Handbook for Reluctant Database Administrators provides you with a solid grasp of what you'll need to design, build, secure, and maintain a database. Author Josef Finsel writes from an understanding point of view; he also crossed over from programming to database administration. Furthermore, database administration veteran Francis Stanisci comments throughout the book, sharing insight from his own years of experience.




Administrator's Guide to SQL Server 2005


Book Description

The Complete, Practical, 100% Useful Guide for Every SQL Server 2005 DBA! This book has one goal: to help database administrators and their managers run SQL Server 2005 with maximum efficiency, reliability, and performance. Renowned SQL Server expert Buck Woody covers every facet of database administration, from installation and configuration through maintaining enterprise-class business intelligence environments. If you’re a new SQL Server administrator, Buck will help you master core tasks rapidly–and avoid costly mistakes that only show up when it’s too late. If you’re familiar with previous versions of SQL Server, he’ll get you up-to-speed fast on everything new that matters, from high availability improvements and Integration Services to the SQL Server Management Studio. Whatever your background, you’ll find best practices, real-world scenarios, and easy-to-use automation scripts–all grounded in Buck’s unsurpassed SQL Server knowledge.