================================================ SEARCHDATABASE.COM'S Database Administrator Tip August 8, 2001 ================================================ Welcome to the searchDatabase.com Database Administrator Tips newsletter! Today's tip, "Renaming foreign keys" can also be viewed online at: http://www.searchDatabase.com/tip/1,289483,sid13_gci759997,00.html Check out our collection of over 200 DBA, developer, Oracle, DB2, and SQL Server tips FREE to searchDatabase members: http://searchdatabase.techtarget.com/tips/0,289484,sid13_tax281808,00.html ******** Sponsored by Syncsort *********** Protect your NAS and get a FREE T-SHIRT! You've invested in Network Attached Storage (NAS) to store the terabytes of data on your network. Now, how do you protect it if the system fails? With Backup Express, a multi-platform, system-wide, easy-to-use backup/restore solution. Its distributed architecture speeds backup and restore, reduces network congestion, ensures scalability, allows backup of all NAS devices on a network from any TCP/IP node, yet creates one central catalog. Get a free trial, free white paper and free director's T-shirt! http://www.syncsort.com/tgb810 ************************************************* "Renaming foreign keys" By Terry Plantz Here is a script that renames foreign keys from system-assigned constraint names to more intelligible names. The names use the current table name and the referenced table name. This greatly improves readability, especially for error messages. The complete script is too long to list here, so click the link below to view it online: http://www.searchDatabase.com/tip/1,289483,sid13_gci759997,00.html SUBMIT YOUR OWN TIP AND WIN A PRIZE: http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz520733_cts520732,00.html ======================================= MORE GREAT STUFF ON SEARCHDATABASE.COM! ======================================= Featured Topic this week: MySQL vs. itself http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci758930,00.html Verbal sparring. Lawsuits. What has the cozy little open-source database community become? The NuSphere-MySQL AB dispute raises important issues about the definition and future of the open-source movement itself. Click the link for more... Over 200 DBA, developer, Oracle, DB2, and SQL Server tips FREE to searchDatabase members: http://searchdatabase.techtarget.com/tips/0,289484,sid13_tax281808,00.html NEW: Industry gadfly Fabian Pascal's latest column about XML (part III in a series): http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci759453,00.html Pascal writes: "If XML is just a physical format for data exchange, why does it incorporate logical constructs such as data model components?" Our huge collection of hand-picked and reviewed resources about XML & databases: http://searchdatabase.techtarget.com/bestWebLinks/0,289521,sid13_tax281608,00.html Ask the Expert category of the day: "SQL" http://searchdatabase.techtarget.com/ateAnswers/0,289620,sid13_cid376817_tax285649,00.html SQL guru extraordinaire Rudy Limeback is waiting to tackle your toughest SQL scripting problems. Three archived audio presentations with leading experts are now available: "Data mining for fun and profit," by Shaku Atre http://searchdatabase.techtarget.com/onlineEventsTranscriptSecurity/1,289693,sid13_gci754454,00.html "Database replication," by Mike Hotek http://searchdatabase.techtarget.com/onlineEventsTranscriptSecurity/1,289693,sid13_gci749642,00.html "SQL for Smarties," by Joe Celko http://searchdatabase.techtarget.com/onlineEventsTranscriptSecurity/1,289693,sid13_gci558024,00.html ======================================= LEARNING ZONE FEATURED BOOK OF THE WEEK ======================================= "Oracle 9i SQLJ Programming" By Nirva Morisseau-Leroy Take advantage of greater programming capabilities with SQLJ--a standard language specification that embeds SQL statements in Java--in the Oracle 9i environment. Officially authorized by Oracle Corporation, this authoritative resource explains how to develop hosted applications, achieve remarkable scalability, implement real-time business intelligence features, and reach a new level of programming functionality. Get comprehensive coverage of SQLJ programming techniques, including SQL programming and development, SQLJ stored programs, triggers, and object-relational processing. Oracle9i SQLJ Programming will help you control each piece of the development process. Discover the benefits of Oracle's highly developed SQL-embedded Java programming standard. http://www.digitalguru.com/dgstore/product.asp?isbn=0072190930&ac_id=58 ================================================ SUBMIT A TECHNICAL TIP AND WIN A PRIZE! ================================================ Do you have a time-saving shortcut, trick, or script that you want to share with other database pros? The first fifty individuals who submit a tip will receive a free searchDatabase.com hat. The highest rated tips each month will win our "Tip of the Month" contest and receive a high-quality searchDatabase.com denim shirt AND a free book of your choice from Wrox Press. We're accepting short, focused tips or code snippets on topics of interest to DBA's and database developers, such as Oracle, DB2, SQL Server, database design, SQL, performance tuning, etc. Click here for more info and to submit your tip: http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz520733_cts520732,00.html This will be a great way to share your knowledge, cement your status as an industry expert, and maybe win a prize. Send us your tip today! ================================================ If you would like to sponsor this or any TechTarget newsletter, please contact Gabrielle DeRussy at [EMAIL PROTECTED] ================================================ 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.