SQL Server 2000 for Experienced DBAs

SQL Server 2000 for Experienced DBAs, 9780072227888 (0072227885), McGraw-Hill, 2003

Configure and manage SQL Server 2000 for peak performance and high availability using the undocumented administrative and troubleshooting techniques offered inside this focused reference. SQL Server expert Brian Knight gives you details on system and platform architecture, settings, security, file management, replication, automation, backups, clustering, and restoration. The book also explains how to maximize built-in administrative tools, develop maintenance plans to prevent downtime, and optimize overall system performance. Concise and practical, this essential resource will save you hundreds of hours of troubleshooting time.

Manage SQL Server using best practices
Implement security measures and enable C2-level auditing
Automate tasks using T-SQL stored procedures, the Query Analyzer, and Multi Server Administration
Monitor SQL Server by setting trace flags, creating alerts, enabling the black box, and more
Plan for disaster recovery by using full, differential, and transaction log backups
Replicate SQL Server data
Scale SQL Server using linked servers, distributed partition views, and indexed views
Prevent downtime with failover clustering and other high availability solutions
Optimize Windows 2000 networks for SQL Server

Comments

Amazing Books

Pro HTML5 Performance (Professional Apress)

Apress, 2012

This book deals with creating high-performance web sites. Its focus is large and high-volume sites. We met while working for a company whose web site has upwards of 50,000 pages and gets more than 80,000,000 visitors a month (many more during the holiday shopping season). The advice the book gives, however, applies equally to smaller sites,...

Adaptive Learning of Polynomial Networks: Genetic Programming, Backpropagation and Bayesian Methods

Springer, 2006

This book delivers theoretical and practical knowledge for developing algorithms that infer linear and non-linear multivariate models, providing a methodology for inductive learning of polynomial neural network models (PNN) from data. The text emphasizes an organized model identification process by which to discover models that generalize and...

Classical Fourier Analysis (Graduate Texts in Mathematics)

Springer, 2008

The primary goal of this text is to present the theoretical foundation of the field of Fourier analysis. This book is mainly addressed to graduate students in mathematics and is designed to serve for a three-course sequence on the subject. The only prerequisite for understanding the text is satisfactory completion of a course in measure theory,...

ESD : RF Technology and Circuits

John Wiley & Sons, 2006

The phenomenon of electrostatic discharge (ESD) has been known for a long time, but recently a growing interest has been observed in ESD in radio frequency (RF) technology and ESD issues in RF applications.

Why now?

Early telecommunications started with William Cooke and Charles Wheatstone in the development of the electric...

IT Best Practices for Financial Managers

John Wiley & Sons, 2010

Praise for IT Best Practices

"The work of the financial manager revolves around a company's financial systems. Ms. Roehl-Anderson's latest offering addresses the two key aspects of these systems—how to buy and install them. The book covers every conceivable aspect of these systems, including ERP, software...

Designing Educational Video and Multimedia for Open and Distance Learning (Open & Flexible Learning)

Routledge, 2006

In recent years there has been a resurgence in the use of video in teaching and training contexts, due to technological advances that enable good quality moving pictures through CD-Rom, DVD and broadband Internet. This book offers advice and assistance to a growing group of teachers and trainers, technical and support staff in the most effective...