SEARCHDATABASE.COM | Database Administrator Tips March 10, 2004 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Optimize Oracle 9i Instance Memory http://searchDatabase.com/r/0,,25995,00.htm?track=NL-94&ad=478048&questsoftware =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - Face-off: Oracle vs. SQL Server - New DB2 vulnerability discovered - The business case for SOA - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Experts: Your tough DBMS questions answered - Featured Topic: Spotlight on Sybase ___________________________________________________________________ **************** SPONSORED BY: Quest Software ********************* Memory is a critical system resource. Effective utilization of memory is necessary for optimal system performance because memory access is faster than accessing data directly from disk. Download Quest Software?s new white paper, "Optimizing Oracle 9i Instance Memory," and learn how the concepts of dynamic SGA, automatic SQL execution management and Oracle advisories and their use in resizing can help optimize instance memory management in your environment. Download the white paper at http://searchDatabase.com/r/0,,25995,00.htm?track=NL-94&ad=478048&questsoftware ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIP: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FACE-OFF: ORACLE VS. SQL SERVER | Tim DiChiara & Robyn Lorusso Our crash course in the lingua franca of the database world, the structured query language, including tips, advice, and scripts from the gurus... >> CLICK for the full tip... http://searchdatabase.techtarget.com/originalContent/0,289142,sid13_gci953120,00.html?track=NL-94&ad=478048 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= NEW DB2 VULNERABILITY DISCOVERED | Rob Westervelt IBM yesterday released a fix for a DB2 vulnerability that could allow attackers to gain administrative privileges on systems running version 8.1 Enterprise Edition. >> CLICK for the full tip... http://searchdatabase.techtarget.com/originalContent/0,289142,sid13_gci954341,00.html?track=NL-94&ad=478048 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= THE BUSINESS CASE FOR SERVICE-ORIENTED ARCHITECTURE | John Hogan SOA allows enterprises to reuse components of an application for multiple purposes. These become "services" that can be shared by other applications on a network -- hence the term "Web services." This article briefly introduces SOA and describes how it can benefit your business. >> CLICK for the full tip... http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci952759,00.html?track=NL-94&ad=478048 ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: LEARNING GUIDE TO SQL http://searchdatabase.techtarget.com/originalContent/0,289142,sid13_gci950920,00.html?track=NL-94&ad=478048 Our crash course in the lingua franca of the database world, the structured query language, including tips, advice, and scripts from the gurus... FREEWARE PROFILER FOR SQL SERVER | Barrie Sosinsky http://www.searchDatabase.com/tip/1,289483,sid13_gci952237,00.html?track=NL-94&ad=478048 SQLcheck is a cool freeware goodie that you can use to monitor a wide range of parameters in your SQL Server databases. INSTALLING AND CONFIGURING DB2 V8 | Peter Buxbaum http://www.searchDatabase.com/tip/1,289483,sid13_gci931151,00.html?track=NL-94&ad=478048 Although the DB2 UDB V8 documentation covers the installation and configuration of DB2 servers and clients, this book chapter provides more detailed instructions on installing the server. FIND AND RELEASE LOCKED OBJECTS | Vijay Kaushik http://www.searchOracle.com/tip/1,289483,sid41_gci930268,00.html?track=NL-94&ad=478048 This Oracle script will find which tables in a schema are locked and which session has locked it. UDF FOR GETTING A COLUMN LIST FOR INSERT STATEMENTS | Baya Pavliashvili http://www.searchDatabase.com/tip/1,289483,sid13_gci951169,00.html?track=NL-94&ad=478048 If you've ever been in a SQL Server environment where you're unfamiliar with the database schema, you know how tedious it is to write stored procedures that populate tables using the INSERT statement. Here's a solution to make your life easier. TRACING AN ORACLE SESSION BY SID | Adinath Kamode http://www.searchOracle.com/tip/1,289483,sid41_gci935720,00.html?track=NL-94&ad=478048 This quick script accepts the Oracle session ID as a parameter and will show you what SQL statement is running and what the session is waiting for. A QUICK 'UNION ALL' TRICK | Dipak Padhy http://www.searchDatabase.com/tip/1,289483,sid13_gci827176,00.html?track=NL-94&ad=478048 Let's say that you have two SQL Server tables that have columns of the datatype TEXT and you need all DISTINCT records that are linked or not linked to child tables. What do you do? USING SEQUENCE OBJECTS | Craig Mulllins http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid569117_tax285651,00.html?track=NL-94&ad=478048 A great new feature of DB2 V8 is sequence objects, a separate structure that generates sequential numbers. Here's how to use it to prevent an online program from updating a serial number table to the same value that a batch program is going to use. FIRST IMPRESSIONS OF 10G | Rob Westervelt http://searchdatabase.techtarget.com/originalContent/0,289142,sid13_gci949726,00.html?track=NL-94&ad=478048 After getting their hands on the latest Oracle database, DBAs and IT managers are raving about its newest features. LEVERAGE YOUR SQL SERVER 2000 SKILLS TO LEARN DB2 UDB V8 | R. Chong http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci947038,00.html?track=NL-94&ad=478048 In the IT world today, we are constantly bombarded with new information -- new software products, new versions, new features. Leveraging your current knowledge is one way to keep up with this constant change. The author shows you how you can use your current knowledge of SQL Server 2000 to quickly gain skills in DB2 UDB for Linux, UNIX, and Windows Version 8. TERMINATING 11I CONCURRENT REQUESTS | Bob Schreiber http://searchoracle.techtarget.com/tip/1,289483,sid41_gci945160,00.html?track=NL-94&ad=478048 This script is useful for finding the SID and serial number for a specific Oracle 11i concurrent request that has been terminated in the applications, but has not been cleaned up by PMON. Hundreds more free tech tips submitted by members: http://searchdatabase.techtarget.com/tips/0,289484,sid13_tax281808,00.html?track=NL-94&ad=478048 Share your knowledge, submit a tip, win a prize: http://searchdatabase.techtarget.com/tipsSubmit/1,289485,sid13,00.html?track=NL-94&ad=478048 ___________________________________________________________________ IMPORTANT LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= YOUR TOUGH DATABASE QUESTIONS ANSWERED | Ask the Experts SQL: Why "select star" is bad http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid576581_tax285649,00.html?track=NL-94&ad=478048 SQL: Gaps in autonumber sequences http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid576584_tax285649,00.html?track=NL-94&ad=478048 SQL Server: Formatting dates, part 1 http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid575447_tax294863,00.html?track=NL-94&ad=478048 SQL Server: Automated script to restore database and transaction logs http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid575449_tax294863,00.html?track=NL-94&ad=478048 Data warehousing: Year values in time dimension contains zeros http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid574879_tax288372,00.html?track=NL-94&ad=478048 Data warehousing: The relationship between dimensions http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid572666_tax288372,00.html?track=NL-94&ad=478048 >> CLICK for other database expert answers... http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html?track=NL-94&ad=478048 >> CLICK for Oracle-related expert answers... http://searchoracle.techtarget.com/ateExperts/0,289622,sid41,00.html?track=NL-94&ad=478048 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SPOTLIGHT ON SYBASE | Featured Topic Sybase administrators and developers will benefit from the collection of technical tips, expert advice, news and market analysis, white papers, and webcasts inside... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci797407,00.html?track=NL-94&ad=478048 ___________________________________________________________________ *********************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 e-newsletter is published by SearchDatabase.com, a targeted Web site from TechTarget, the most targeted IT media and events company. TechTarget offers magazines, Web sites, e-newsletters, Webcasts and conferences for enterprise IT professionals. Copyright 2004 TechTarget. All rights reserved. _____________________________________________________________________ To unsubscribe from "Database Administrator Tips": Go to unsubscribe: http://SearchDatabase.com/u?cid=478048&lid=430854&track=NL-94&ad=478048 Please note, unsubscribe requests may take up to 24 hours to process; you may receive additional mailings during that time. A confirmation e-mail will be sent when your request has been successfully processed. Contact us: SearchDatabase Member Services 117 Kendrick Street, Suite 800 Needham, MA 02494
