SEARCHDATABASE.COM | Database Administrator Tips December 17, 2003 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
How much will you spend on data management in 2004? http://www.insightexpress.com/s/spen64219 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: When firewalls offer no protection - DB2: An introduction to JDBC - Oracle: 30 tips in 30 minutes - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Experts: Your tough DBMS questions answered - Featured Topic: Java ___________________________________________________________________ ***************** SearchDatabase.com 2004 survey ****************** How will you approach your database strategy in 2004? Are you planning on investing in upgrades? Take a few minutes to share your thoughts with this brief survey. http://www.insightexpress.com/s/spen64219 ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SQL INJECTION: WHEN FIREWALLS OFFER NO PROTECTION | D. Litchfield A detailed introduction to the basics of SQL injection, including best practices for defending SQL Server against such attacks. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci940262,00.html?track=NL-94 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= JDBC: AN INTRODUCTION | Alexander Kuznetsov A detailed introduction to the JDBC API and how to use it for accessing virtually any kind of tabular data. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci940272,00.html?track=NL-94 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 30 ORACLE TIPS IN 30 MINUTES | Kenny Smith Brought to you by the IOUG, these quick tips and tricks are designed to make your DBA or developer job easier. Get help with database administration, development, RMAN and more! >> CLICK for the full tip... http://searchoracle.techtarget.com/tip/0,289483,sid41_gci940637,00.html?track=NL-94 ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: LEVERAGING USER-DEFINED DISTINCT TYPES | Alexander Kuznetsov http://www.searchDatabase.com/tip/1,289483,sid13_gci940590,00.html?track=NL-94 Did you know that you can protect your SQL from developer mistakes in DB2? You need to use UDDTs -- here's how. TROUBLESHOOTING REPLICATIONS | Barrie Sosinsky http://www.searchDatabase.com/tip/1,289483,sid13_gci911714,00.html?track=NL-94 Here is a quick overview of replication in SQL Server and how to solve common problems. DON BURLESON'S FAVORITE ORACLE10G NEW FEATURES | Don Burleson http://www.searchOracle.com/tip/1,289483,sid41_gci939890,00.html?track=NL-94 With all of the hoopla surrounding the impending release of Oracle 10g, it is sometimes difficult to differentiate between the truly valuable features and the marginal new features. Guru Don Burleson discusses his favorites in this exclusive article. FIND THE PRODUCT OF A FIELD | Vadivel Mohanakrishnan http://www.searchDatabase.com/tip/1,289483,sid13_gci937838,00.html?track=NL-94 There isn't a prebuild function for finding the product of field or set of values in SQL Server. Here is a workaround using a combination of the SUM(), POWER() and LOG10() functions. INDEX COVERING AND QUERY PERFORMANCE | Alexander Kuznetsov http://www.searchDatabase.com/tip/1,289483,sid13_gci939445,00.html?track=NL-94 The DB2 rule of thumb "put the most selective column first in the index definition" is usually sound, but not always. Here is a situation when putting the most selective column last speeds up a query. COMPILE ALL INVALID OBJECTS INCLUDING THOSE WITH SYNTAX ERRORS | by Rastislav Ciganek http://www.searchOracle.com/tip/1,289483,sid41_gci938288,00.html?track=NL-94 Here's how to compile all invalid objects in Oracle, including these with syntax errors. It can by used for specific schemas or for whole databases and has more features than utlrp.sql. MAINTAIN RUNNING NUMBERS | Vadivel Mohanakrishnan http://www.searchDatabase.com/tip/1,289483,sid13_gci937840,00.html?track=NL-94 Here is how to maintain a running number if you need to combine fields from different tables in SQL Server 7 and 2000. DEFINING BUSINESS INTELLIGENCE USERS | Mike Beire http://www.searchDatabase.com/tip/1,289483,sid13_gci938533,00.html?track=NL-94 Users of BI systems can be delineated by application requirements and by skill. Here is how to define who is using your BI systems -- a critical step in enuring the success of your implementation. Hundreds more free tech tips submitted by members: http://searchdatabase.techtarget.com/tips/0,289484,sid13_tax281808,00.html?track=NL-94 Share your knowledge, submit a tip, win a prize: http://searchdatabase.techtarget.com/tipsSubmit/1,289485,sid13,00.html?track=NL-94 ___________________________________________________________________ IMPORTANT LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= YOUR TOUGH DATABASE QUESTIONS ANSWERED | Ask the Experts "I have three tables: Item (A), Item Transaction Current (B), and Item Transaction History (C). I need to pull information from both tables B and C for a specific item number. Table A is used to get the description of the item. What would the SQL look like to achieve this result?" >> Read expert Rudy Limeback's response... http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html?track=NL-94 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= JAVA | Featured Topic Oracle and DB2 coders are leading the way in using Java for enterprise database development. Want to learn more? We have scads of Java, J2EE, JDBC, and SQLJ resources inside... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci790305,00.html?track=NL-94 ___________________________________________________________________ *********************SEARCHDATABASE CONTACTS*********************** TIM DICHIARA, Senior Site Editor (mailto:[EMAIL PROTECTED]) ROBYN LORUSSO, Site Editor (mailto:[EMAIL PROTECTED]) SARA CUSHMAN, Assistant Editor (mailto:[EMAIL PROTECTED]) ELLEN O'BRIEN, News Editor (mailto:[EMAIL PROTECTED]) ROB WESTERVELT, News Writer (mailto:[EMAIL PROTECTED]) GABRIELLE DERUSSY, Sales (mailto:[EMAIL PROTECTED]) 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?track=NL-94 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."
