DBA Tips: Replication vs. clustering, and more...

[SearchDatabase.com]

Title: DBA Tips

May 05, 2004 Published by  SearchDatabase.com DBA Tips Issue Sponsored By: Quest Software IN THIS ISSUE: Hardware clustering vs. replication: A case study DB2: Best practices for tuning DB2 UDB v8.1 Oracle: Identifying fragmented indexes that should be rebuilt SQL Server: The top four ways to secure SQL Server Featured Topic: DBMS performance Maximize DB2 Potential through Space Management Download Quest Software's white paper "Maximize the Potential of DB2 through Effective Space Management" and learn how to manage space structures in DB2 UDB v8.1. Examine benefits of regular maintenance to improve availability and performance. Download the white paper Hardware clustering vs. replication: A case study [SearchDatabase.com] A real-life example showing the superiority of software replication over hardware clustering to maximize data availability. Sybase is used as an example but the argument is universal. MORE INFO: Featured Topic: Spotlight on Sybase Featuerd Topic: Availability DB2: Best practices for tuning DB2 UDB v8.1 [Fraser McArthur] This article takes a practical approach to performance tuning for DB2 UDB. It covers techniques you can implement at various stages of development or on a production system, including database design and layout, database configuration, SQL statement design, maintenance, and monitoring. Oracle: Identifying fragmented indexes that should be rebuilt [Tiffany Linn] This tip will help address performance issues when Oracle stops using indexes on highly volatile tables. It identifies indexes that are fragmented and should be rebuilt. SQL Server: The top four ways to secure SQL Server [Mike Chappel] Here is a brief checklist of the most important actions to take when locking down your SQL Server. ASK THE EXPERTS: Ask the Expert: Counting rows in a subtree Our SQL expert Rudy Limeback discusses the adjacency vs. nested set model. TOPICS: Featured Topic: DBMS performance A slow DBMS is not only annoying to users, it can also affect your bottom line. Our collection of tuning advice will help you achieve maximal speed and reliability for your system. Contact Us Sales For sales inquiries, please contact us at: [EMAIL PROTECTED] Editorial For feedback about any of our articles or to send us your article ideas, please contact us at: [EMAIL PROTECTED] ABOUT THIS E-NEWSLETTER This e-newsletter is published by SearchDatabase.com, a targeted Web site from TechTarget, the most targeted IT media and events company. Copyright 2004 TechTarget. All rights reserved. To unsubscribe from "DBA Tips": Go to unsubscribe: http://searchDatabase.techtarget.com/u?track=NL-94 Please note, unsubscribe requests may take up to 24 hours to process; you may receive additional mailings during that time. A confirmation e-mail will be sent when your request has been successfully processed. Contact Us: SearchDatabase MemberServices 117 Kendrick Street, Suite 800 Needham, MA 02494