SEARCHDATABASE.COM | Database Administrator Tips January 21, 2004 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
FREE WHITE PAPER ON DATA RECOVERY BEST PRACTICES http://searchDatabase.com/r/0,,23490,00.htm?track=NL-94&lumigenttechnologies =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: Drop user databases without using normal syntax - DB2: Leveraging your Oracle 9i skills to learn DB2 UDB v8 - Oracle: Working with Oracle10g's global temporary tables - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Experts: Your tough DBMS questions answered - Featured Topic: Ask the SQL expert ___________________________________________________________________ ************* SPONSORED BY: Lumigent Technologies ***************** Planning for data recovery is about more than just making sure your database is backed up. There are many things to consider. In his paper, Stephen Wynkoop, MVP and Founder SSWUG, discusses the best approaches to a solid data recovery solution. Download it today, compliments of Lumigent Technologies: http://searchDatabase.com/r/0,,23490,00.htm?track=NL-94&lumigenttechnologies ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DROP USER DATABASES WITHOUT USING NORMAL SYNTAX | Rudy Setiadi When you restore a SQL Server database to another server or PC, sometimes the sysusers table is not consistent and users can't be dropped from the database. Here's how to drop user databases if they can't be dropped using normal syntax like sp_dropuser. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci931561,00.html?track=NL-94 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= LEVERAGING YOUR ORACLE 9I SKILLS TO LEARN DB2 UDB V8 | Suita Gupta If you're a database specialist interested in growing your DB2 Universal Database skills, there's a good chance that you've already developed database skills with another relational database product somewhere along the way. This detailed article shows you how to use your current knowledge of Oracle 9i to quickly gain skills in DB2 UDB for Linux, UNIX, and Windows Version 8. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci945589,00.html?track=NL-94 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= WORKING WITH ORACLE10G'S NEW GLOBAL TEMPORARY TABLE FEATURES Oracle Database 10g extends the features of global temporary tables to permit VARRAY and nested table columns. This tip will explain how to use these new features. Contributed by author Kevin Owens. >> CLICK for the full tip... http://www.searchOracle.com/tip/1,289483,sid41_gci944420,00.html?track=NL-94 ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: SQL SERVER SIZE MAINTENANCE | Baya Pavliashvili http://www.searchDatabase.com/tip/1,289483,sid13_gci944134,00.html?track=NL-94 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. CREATE PROCEDURES AND COMPILE DDL SCRIPTS ON THE FLY | M. Huffine http://www.searchOracle.com/tip/1,289483,sid41_gci940477,00.html?track=NL-94 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. WHY OLAP DESERVES MORE ATTENTION | Alexey Reznichenko http://www.searchDatabase.com/tip/1,289483,sid13_gci940713,00.html?track=NL-94 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. 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. 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: "With all simplicity, what are clustered and unique indexes in DB2?" >> CLICK for Craig Mullins's answer... http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid568135_tax285651,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 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ASK THE SQL EXPERT | Featured Topic Our expert Rudy Limeback has been in the database field for 25 years and he knows his SQL. Browse his 250+ answers to your tough SQL questions inside... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci867561,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.
