=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEARCHDATABASE.COM | Database Administrator Tip November 19, 2001
Essential tools and advice for the enterprise DBA More tips: http://searchDatabase.techtarget.com/tips/ =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - DBA Tip: XML support in SQL Server 2000 - DBA Tip: Indian money to character conversion - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Featured Topic: Finding value in your data - New newsletter: Oracle tips - Book: Database design for mere mortals ___________________________________________________________________ ************ SPONSORED BY: Expand Beyond Corporation ************** Tired of hauling around laptops and pagers? PocketDBA lets database administrators control their Oracle databases from wireless handheld devices - at any time, from any place. With the PocketDBA software, DBAs can monitor, manage and troubleshoot mission-critical systems in real-time, live in the database. New Oracle OpenWorld pricing is $500 per database and $50 per user! Try the live demo at http://ad.doubleclick.net/clk;3600838;5058249;m?http://www.pocketdba.com/demo.asp You'll be automatically entered into a drawing for FREE Compaq iPAQ 3760. ___________________________________________________________________ =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= XML SUPPORT IN SQL SERVER 2000 | by Baya Pavliashvili XML can be used with SQL Server 2000 in three different ways: extensions to Transact-SQL, integration of SQL Server and Internet Information Server (IIS), and using XML Updategrams. This article is a detailed introduction to the first method. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci782319,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= INDIAN MONEY TO CHARACTER CONVERSION | by Puneet Vats Here is an Oracle script that converts numbers in the form of Indian money (rupees, paises, etc) into characters. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci782320,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS WHO OR WHAT IS HOGGING THE DATABASE? | by Scott Taylor http://www.searchDatabase.com/tip/1,289483,sid13_gci780359,00.html By using UNIX tools such as "top," it is normally easy to determine which Oracle process is hogging CPU cycles and/or disk space. But what is that process doing and who is running it? Running the code in this tip will prompt for a process ID (PID) and will return details of that process. HOT BACKUP UNIX SCRIPT | by Alan Copeland http://www.searchDatabase.com/tip/1,289483,sid13_gci780366,00.html This large script performs a hot backup of an Oracle database with no interaction. The user of the script must have write privileges to the backup drives or devices. The script writes to a disk but can be modified to write to a tape device. AVOID JOINING TABLES ON A RANGE IN SQL SERVER | by Michael Milligan http://www.searchDatabase.com/tip/1,289483,sid13_gci780367,00.html Even when columns are indexed and the result set returned is only one row, SQL Server can choke. This tip includes a query that was attempting to scan the entire table for both the ">" selection and the "<" selection. Converting these to sub-selects did nothing to prevent the full table scans. Watch out for this! Hundreds more free DBA tips submitted by members: http://searchdatabase.techtarget.com/tipsIndex/0,289482,sid13_tax286329,00.html Share your knowledge: Submit your own tip and win a DIGITAL CAMERA http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz773507_cts773500,00.html ___________________________________________________________________ IMPORTANT MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FINDING VALUE IN YOUR DATA | SearchDatabase Featured Topic What potentially profitable secrets lie hidden in your data? Check out our collection of data analysis resources and join Bill Inmon TODAY at 2 pm EST (19:00 GMT) for a discussion of the infrastructure needed to find patterns in your corporate data. >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci756639,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FREE NEWSLETTER | Oracle Tips A brand-new, free monthly newsletter for Oracle DBA's and developers, chock full of advice and scripts from the experts and the Oracle community. To subscribe, just log in to your account and check off 'Oracle Tips' in the Tips & Columns section. >> SUBSCRIBE: http://searchdatabase.techtarget.com/register/1,,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= BOOK OF THE WEEK | Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design Relational databases are powerful tools for organizing data, but learning to use them effectively can be painful. "Relational Database Design for Mere Mortals" explains the concepts of relational-database design in an easy-to-digest fashion that covers both the theoretical underpinnings and their practical implications. Michael J. Hernandez covers all the basics--table and field structure, keys, relationships, business rules, and more--but always keeps his feet on the ground with advice for real-world implementations and a particularly strong section on analyzing your current database infrastructure. >> CLICK: http://www.digitalguru.com/DigitalGuru/product_detail.asp?catalog%5Fname=Books&product%5Fid=0201694719&partner_id=77 ___________________________________________________________________ *********************SEARCHDATABASE CONTACTS*********************** TIP MAILBOX, ([EMAIL PROTECTED]) >> Send us feedback on tips and ideas for new tip content. TIM DICHIARA, Site Editor ([EMAIL PROTECTED]) >> Send us your original articles and tips. ED PARRY, News Editor ([EMAIL PROTECTED]) >> Send in your product announcements and poll ideas. TOM CLICK ([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 2001, All Rights Reserved. If you no longer wish to receive this newsletter simply reply to this message with "REMOVE" in the subject line. Or, visit http://searchDatabase.techtarget.com/register and adjust your subscriptions accordingly. If you choose to unsubscribe using our automated processing, you must send the "REMOVE" request from the email account to which this newsletter was delivered. Please allow 24 hours for your "REMOVE" request to be processed.
