SEARCHDATABASE.COM | Database Administrator Tips January 22, 2003 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Free database whitepapers http://searchdatabase.techtarget.com/whitepapers3/0,,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - DB2: Create a clustered index on a primary key - SQL Server: Top ten security blunders - Oracle: Browsing OS files from TOAD or SQL*Plus - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Experts: Your tough database questions answered - Featured Topic: Pat's database design tips ___________________________________________________________________ ****************** Free database whitepapers ********************** Download the key papers you need today to make better-informed decisions. Targeted categories include data analysis and business intelligence, data security, data storage, database-Web integration, and more. Click here to access the free SearchDatabase.com white papers section: http://searchdatabase.techtarget.com/whitepapers3/0,,sid13,00.html ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: CREATE A CLUSTERED INDEX ON A PRIMARY KEY | Prashant Dahalkar Here is a way to create a table with clustered index on a composite primary key in DB2 UDB v7.1. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci875345,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= TOP 10 SQL SERVER SECURITY BLUNDERS | Jan Stafford An industry veteran shares the worst SQL Server security mistakes to avoid. Ignore these at your peril! >> CLICK for the part I... http://www.searchDatabase.com/tip/1,289483,sid13_gci874688,00.html >> CLICK for the part II... http://www.searchDatabase.com/tip/1,289483,sid13_gci874690,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= BROWSING OS FILES FROM TOAD OR SQL*PLUS | Jim Leask This tip describes the process required to browse operating system (OS) files from a PC application like TOAD or SQL*PLUS. This process will be useful for browsing the Oracle alert log when access via the OS is restricted. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci874425,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: CHECKING TO SEE IF INDEXES ARE NEEDED | David Quigley http://www.searchDatabase.com/tip/1,289483,sid13_gci870110,00.html If you have SQL that needs an index but you're unsure about the best index to create, DB2 7 has an index advisory. This quick tip helps a DBA figure out the best indexes to create for a specfic SQL query. SQL SERVER BACKUP AND RESTORE, PART II | Greg Robidoux http://www.searchDatabase.com/tip/1,289483,sid13_gci874243,00.html In the second part of a series, the author presents guidelines that can be used for selecting the appropriate backup and recovery model as well as some important considerations and tips. FIND WHAT EACH ORACLE PROCESS IS DOING | M. Indira http://www.searchDatabase.com/tip/1,289483,sid13_gci843413,00.html Here is a handy script that will correlate the operating system process with the Oracle process. You'll also be able to see the most current SQL run by that process. 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 LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= YOUR TOUGH DATABASE QUESTIONS ANSWERED | Ask the Experts DB2: Triggers to UPDATE CASCADE http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid512595_tax285651,00.html SQL: Comparing two tables http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid512588_tax285649,00.html Oracle: Sort order of composite primary keys http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid511846_tax285650,00.html Database design: Is Visual FoxPro a flat database? http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid512231_tax285653,00.html Oracle: Sending queried data from the Web to a CSV or Excel file http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid511837_tax285650,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= PAT'S DATABASE DESIGN TIPS | SearchDatabase.com Featured Topic Taking the time to design stable, fast and secure databases is critical for avoiding future administration headaches. To help you in this endeavor, guru Pat Phelan presents a collection of tips about effective design inside... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci811735,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 2003, 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."
