SEARCHDATABASE.COM | Database Administrator Tips January 14, 2004 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
ORACLE-ONLY TECHNICAL ADVICE http://searchoracle.com/r/0,,18966,00.htm?track=NL-94 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: Database size maintenance - Oracle: Create procedures and compile DDL scripts on the fly - Why OLAP deserves more attention - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Experts: Your tough DBMS questions answered - Featured Topic: DBMS monitoring ___________________________________________________________________ **************** ORACLE-ONLY TECHNICAL ADVICE ********************* SearchOracle.com features unbiased Oracle news and analysis, technical tips, informative webcasts, white papers and more -- all designed to help IT pros tackle their toughest database issues with ease. Newsletters are available on a range of topics, including Oracle administration and E-Business Suite. http://searchoracle.com/r/0,,18966,00.htm?track=NL-94 ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SQL SERVER SIZE MAINTENANCE | Baya Pavliashvili Database size maintenance is among the "boring" tasks that DBAs have to perform. However, if you allow your databases to grow without ever managing their size you're very likely to get in trouble. Here's a quick introduction to the topic. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci944134,00.html?track=NL-94 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= CREATE PROCEDURES AND COMPILE DDL SCRIPTS ON THE FLY | M. Huffine This Oracle procedure creates views, procedures, functions, and packages, and update, delete, and insert statements and compiles them. This provides developers with a means to call a procedure to create and compile all DDL scripts on the fly and see the output errors when executing stored DDL. >> CLICK for the full tip... http://www.searchOracle.com/tip/1,289483,sid41_gci940477,00.html?track=NL-94 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= WHY OLAP DESERVES MORE ATTENTION | Alexey Reznichenko According to one survey, only thirty percent of companies use OLAP technology. Why? The author makes the case for OLAP and describes the various types and implementations. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci940713,00.html?track=NL-94 ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: ALTERNATE WAY TO FIND DATABASE SIZE | Robert Oliver http://www.searchDatabase.com/tip/1,289483,sid13_gci935717,00.html?track=NL-94 Here's a quick SQL Server script that finds the size of the database and separates the log and data file sizes. USING 'INSTEAD OF' TRIGGERS | Alexander Kuznetsov http://www.searchDatabase.com/tip/1,289483,sid13_gci941941,00.html?track=NL-94 First introduced in DB2 UDB V8.1, INSTEAD OF triggers are very useful when you need to modify the database structure without changing the applications running against the changed database. Here's an introduction. GET USEFUL DETAILS ABOUT A TABLE WITH ONE QUERY | Ajay Garg http://www.searchOracle.com/tip/1,289483,sid41_gci940473,00.html?track=NL-94 This Oracle script gives a half dozen details about a table structure and dependencies at one go, including comments, keys, constraints, and more. SQL INJECTION: WHEN FIREWALLS OFFER NO PROTECTION | D. Litchfield http://www.searchDatabase.com/tip/1,289483,sid13_gci940262,00.html?track=NL-94 A detailed introduction to the basics of SQL injection, including best practices for defending SQL Server against such attacks. JDBC: AN INTRODUCTION | Alexander Kuznetsov http://www.searchDatabase.com/tip/1,289483,sid13_gci940272,00.html?track=NL-94 A detailed introduction to the JDBC API and how to use it for accessing virtually any kind of tabular data. 30 ORACLE TIPS IN 30 MINUTES | Kenny Smith http://searchoracle.techtarget.com/tip/0,289483,sid41_gci940637,00.html?track=NL-94 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! 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. 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. 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. 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 A SearchDatabase.com member writes: "This has got to be a simple problem, but I'm a beginner in SQL. I need to generate a list of users that are not members of a specific group. I can easily get a list of users who are part of a group, but I can't seem to figure out the inverse..." >> CLICK for Rudy Limeback's answer... http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid567187_tax285649,00.html?track=NL-94 >> CLICK for other database expert answers... http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html?track=NL-94 >> CLICK for Oracle-related expert answers... http://searchoracle.techtarget.com/ateExperts/0,289622,sid41,00.html?track=NL-94 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DBMS MONITORING | Featured Topic It may not be the sexiest topic, but monitoring is an essential and time-consuming task for all DBAs. Learn more with our collection of tips, expert advice, and news inside. http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci943909,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]) ::::::::::::::::::::: ABOUT THIS NEWSLETTER :::::::::::::::::::::: This newsletter is published by TechTarget, the most targeted IT media. http://www.techtarget.com?track=NL-94 Copyright 2004 TechTarget. 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?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." Changes may take 24 hours.
