SEARCHDATABASE.COM | Database Administrator Tips June 5, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Master today's most popular database and put yourself in demand! http://searchDatabase.com/r/0,,3586,00.htm?OracleProfLibrary =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: Create daily reports using SQL Mail - Oracle: Two or more different time zones on the same machine - Oracle: Create a link to connect two databases - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Expert: Your toughest database questions answered - Featured Topic: Data quality ___________________________________________________________________ ************** Sponsored by: Computer Books Direct **************** Master today's most popular database and put yourself in demand! The Oracle 9i Professional Library - a 3-volume, 1-CD-ROM set - a $169.97 value - can be yours for $9.99, with membership in Computer Books Direct! This insider's library will give you the most up-to-date security tips for your Oracle database as well as the latest information on the newest Oracle 9i tools! Click for details! http://searchDatabase.com/r/0,,3586,00.htm?OracleProfLibrary ___________________________________________________________________ ___________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= CREATE DAILY REPORTS USING SQL MAIL | Parthasarathy Mandayam At times, SQL Server developers may inadvertently create a database object without prefacing the object name with dbo. The result is that the database object will be owned by the database user, which the developer is using for the connection. To help alleviate this problem, to assist developers, and to orient new database developers to this standard way of development, use SQL Mail to create daily reports for non-dbo-owned database objects. Here's how. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci827376,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= HOW TO RUN TWO OR MORE DATABASES IN DIFFERENT TIME ZONES ON THE SAME MACHINE | Rajeev Nadimpalli Here is an explanation of how to run two or more Oracle databases in different time zones on the same Solaris machine. Hint: the method uses multiple listeners. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci826633,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= CREATING A LINK FOR CONNECTING TWO DATABASES | Shailesh Yagnik This tip shows you how to create a link so that users can get results from two Oracle databases in one SQL query. >> CLICK for the online version of the tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci826602,00.html __________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SENDING MAIL USING CDONTS | Ashish Singal http://www.searchDatabase.com/tip/1,289483,sid13_gci826453,00.html This SQL Server stored procedure can be used to send email through CDONTS. OPTIMAL SIZE OF ROLLBACK SEGMENTS | Marcelo Castanho http://www.searchDatabase.com/tip/1,289483,sid13_gci821261,00.html Here is a simple Oracle script that displays the optimal size of rollback segments created in the database. TUNING THE DATABASE CACHE HIT RATIO | Gatot Rubianto http://www.searchDatabase.com/tip/1,289483,sid13_gci820946,00.html When do you need to tune the Oracle cache hit ratio? Here is a quick list, plus a script that will measure it for you. Hundreds more free tech tips submitted by members: http://searchdatabase.techtarget.com/tips/0,289484,sid13_tax281808,00.html Share your knowledge, submit a tip, win a prize: http://searchdatabase.techtarget.com/tipsSubmit/1,289485,sid13,00.html ___________________________________________________________________ IMPORTANT MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ASK THE EXPERT | This week's tough database questions answered SQL Server: Generating a Word doc containing database info http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid470379_tax285648,00.html Oracle: Clusters explained http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid470480_tax285650,00.html DB2: Altering VARCHAR columns http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid469272_tax285651,00.html DB2: Can a before insert trigger be used to prevent insertion? http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid469275_tax285651,00.html Oracle: Fastest way to generate HTML dynamically http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid470455_tax285650,00.html Database design: Advice for a database design beginner http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid470366_tax285653,00.html Oracle: Wrapped procedures not importing into Oracle 9i http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid470414_tax285650,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DATA QUALITY | SearchDatabase Featured Topic Clean and accurate data translate directly to the bottom line for most companies. Quality data make the life of the DBA easier too. Our collection of news and analysis has all you need to know about data quality and cleansing... >> CLICK for our current Featured Topic... http://www.searchDatabase.com/featuredTopic/0,290042,sid13_gci827300,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html ___________________________________________________________________ *********************SEARCHDATABASE CONTACTS*********************** TIP MAILBOX, (mailto:[EMAIL PROTECTED]) >> Submit your original tip here. TIM DICHIARA, Site Editor (mailto:[EMAIL PROTECTED]) >> Send your feedback and original articles. SARA CUSHMAN, Assistant Editor (mailto:[EMAIL PROTECTED]) >> Send your White Papers and favorite Web sites. ELLEN O'BRIEN, News Editor (mailto:[EMAIL PROTECTED]) >> Send your product announcements and poll ideas. TOM CLICK, Sales (mailto:[EMAIL PROTECTED]) >> Sponsor this or any other TechTarget newsletter. ___________________________________________________________________ **********************ABOUT THIS NEWSLETTER************************ Created by TechTarget (http://www.techtarget.com) TechTarget - The Most Targeted IT Media Copyright 2002, All Rights Reserved. To unsubscribe from 'DBA Tips,' simply reply to this e-mail with REMOVE (all caps) within the Body or Subject or go to http://searchDatabase.techtarget.com/register, log in to edit your profile, click on the link to Edit email subscriptions, and uncheck the box next to the newsletter you wish to unsubscribe from. When finished, click "Save Changes to My Profile."
