SearchDatabase.com: DBA Tips April 29, 2004 ___________________________________
ISSUE SPONSORED BY: - SearchDatabase.com Career Center __________________________________________________________________ IN THIS ISSUE: -- SQL Server: When to use data replication -- DB2: Best practices for tuning DB2 UDB v8.1 -- Oracle: Analyzing tables in a schema, part II -- DB2: How to create Web database apps with WDSC and VDM -- Featured Topic: T-SQL tips and scripts __________________________________________________________________ THIS WEEK'S TIPS: SQL SERVER: WHEN TO USE DATA REPLICATION | Baya Pavliashvilli http://www.searchDatabase.com/tip/1,289483,sid13_gci961888,00.html?track=NL-94&ad=481742 SQL Server replication can be used effectively for many different purposes, as discussed in this brief introduction. ::::::::::::::::::::::::: SPONSOR ::::::::::::::::::::::::: How does your salary compare to those of your peers? Visit SearchDatabase.com's Career Center powered by Dice and take our salary survey. Find training, certification, resume resources and over 27,000 IT job openings to search through. Register now and access a host of career resources! http://ttarget.adbureau.net/adclick/CID=000047cc0000000000000000/acc_random=2572110119/site=searchdatabase/area=em.41/aamsz=1x1/position=2/keyword=C481742 :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: DB2: BEST PRACTICES FOR TUNING DB2 UDB V8.1 | Fraser McArthur http://www.searchdatabase.com/tip/1,289483,sid13_gci962104,00.html?track=NL-94&ad=481742 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: ANALYZING TABLES IN A SCHEMA, PART II | Stuart Hunter http://www.searchoracle.com/tip/1,289483,sid41_gci961666,00.html?track=NL-94&ad=481742 An improvement in a previously posted tip regarding analysis of objects in a specific schema. This script is more streamlined and allows analysis of any tables within a user-specified schema. DB2: HOW TO CREATE WEB DATABASE APPS WITH WDSC AND VDM | Jim Mason http://www.searchDatabase.com/tip/1,289483,sid13_gci959751,00.html?track=NL-94&ad=481742 An overview of the author's "Visual development method" that seeks to raise productivity and shorten the learning curve for DB2 iSeries/RPG developers who want to build Java Web applications. __________________________________________________________________ ALSO ON SEARCHDATABASE.COM: ASK THE EXPERT: PREVENTING APPS FROM CONNECTING TO SYBASE http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid583582_tax294910,00.html?track=NL-94&ad=481742 Our Sybase expert Mich Talebzadeh responds to a member's question about securing Sybase to prevent unauthorized programs from accessing the database. FEATURED TOPIC: T-SQL TIPS AND SCRIPTS | TOPICS http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci886017,00.html?track=NL-94&ad=481742 Transact-SQL is a set of programming extensions to the Structured Query Language developed by Sybase and Microsoft. The free tips, scripts, and expert advice inside will help DBAs ... __________________________________________________________________ CONTACT US: For sales inquiries, please contact us at: mailto:[EMAIL PROTECTED] For feedback about any of our articles or to send us your article ideas, please contact us at: mailto:[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. TechTarget offers magazines, Web sites, e-newsletters, Webcasts and conferences for enterprise IT professionals. Copyright 2004 TechTarget. All rights reserved. _____________________________________________________________________ To unsubscribe from "DBA Tips": Go to unsubscribe: http://SearchDatabase.com/u?cid=481742&lid=430854&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 Member Services 117 Kendrick Street, Suite 800 Needham, MA 02494
