SearchDatabase.com: DBA Tips April 14, 2004 ___________________________________
ISSUE SPONSORED BY: SQLtool. FREE 30-DAY TRIAL OF IDERA'S WEB-BASED SQL SERVER MANAGEMENT TOOL ___________________________________________________________________ IN THIS ISSUE: -- DB2: How to create Web database apps with WDSC and VDM -- DB2: Generating XML from SQL data -- Oracle: Using Oracle flashback querying for DDL audits -- SQL Server: Guidelines for creating indexes -- DB2 v8 certification: Everything you need to know -- Ask the Expert: Vertical partitioning of large databases -- Featured Topic: Newbie tips and advice ::::::::::::::::::::::::: SPONSOR ::::::::::::::::::::::::: FREE 30-DAY TRIAL OF IDERA'S WEB-BASED SQL SERVER MANAGEMENT TOOL - SQLtool Powerful, with over 350 functions, SQLtool allows you to manage and administer any SQL Server anywhere in the world from your browser. Highly scalable, with battle-proven performance on large SQL Server installations, SQLtool is easy-to-use and deploys in minutes. Download now! http://ttarget.adbureau.net/adclick/CID=000043250000000000000000/acc_random=89318165/site=searchdatabase/area=em.41/aamsz=1x1/position=1/keyword=C480551 :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: ___________________________________________________________________ THIS WEEK'S TIPS: 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=480551 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. ORACLE: USING ORACLE FLASHBACK QUERYING FOR DDL AUDITS | P. Sangdara http://www.searchoracle.com/tip/1,289483,sid41_gci939610,00.html?track=NL-94&ad=480551 In this tip, the author extends Oracle's useful flashback querying feature to auditing data dictionary changes issued on the entire database. SQL SERVER: VERTICAL PARTITIONING OF LARGE DATABASES | B. Sosinsky http://www.searchDatabase.com/tip/1,289483,sid13_gci959754,00.html?track=NL-94&ad=480551 To increase performance, you can partition your tables using either vertical or horizontal partitioning depending upon the nature of your data. Here is an overview of the former. ___________________________________________________________________ PREVIOUS TIPS: DB2: GENERATING XML FROM SQL DATA | SearchDatabase.com http://www.searchDatabase.com/tip/1,289483,sid13_gci958684,00.html?track=NL-94&ad=480551 You are an RPG programmer. You could use the XML parser APIs on the iSeries to learn how to do DOM or SAX parsing to generate XML documents. Good idea? No! Learn how to easily generate XML from SQL without coding using WDSC in DB2/400. SQL SERVER: GUIDELINES FOR CREATING INDEXES | Barrie Sosinsky http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci958678,00.html?track=NL-94&ad=480551 A well-performing database minimizes index creation while emphasizing the creation of the "right" mix of indexing. Here are some rules to guide you in your table designs when you are trying to decide what to index. DB2 V8 CERTIFICATION: EVERYTHING YOU NEED TO KNOW | Howard Fosdick http://www.searchDatabase.com/tip/1,289483,sid13_gci947041,00.html?track=NL-94&ad=480551 The whats, whys, and hows of DB2 certification are presented in this detailed article. ___________________________________________________________________ ALSO ON SEARCHDATABASE.COM: SQL SERVER: TRIGGER TO UPDATE TABLE WITH NO FOREIGN KEYS TO ORIGINAL | ASK THE EXPERTS http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid581827_tax285648,00.html?track=NL-94&ad=480551 Our SQL Server expert Mike Hotek answers a question about creating a trigger on a table that has no primary key that is a foreign key in the position table. NEWBIE TIPS AND ADVICE | FEATURED TOPIC http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci817960,00.html?track=NL-94&ad=480551 To newbies, the modern DBMS seems impossibly complex. They're right, of course! Inside is a wealth of resources for those just starting out: tips, webcasts, advice, and much more. ___________________________________________________________________ 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=480551&lid=430854&track=NL-94&ad=480551 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