SEARCHDATABASE.COM | Database Administrator Tips March 24, 2004 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Database Professionals Library - 3 Books for only $9.99 http://searchDatabase.com/r/0,,26814,00.htm?track=NL-94&ad=479021&databaseprofessional =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: Introduction to SQLXML - DB2: Linux on the mainframe -- is it right for you? - Oracle: Merging datasets with NULL values - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Experts: Answers to your tough database questions - Featured Topic: DBMS security ___________________________________________________________________ ********** Sponsor: Database Professionals Library **************** Buy the Database Professionals Library (a $119.97 value) for only $9.99 (with membership). These hands-on references look at theoretical and practical information for all database administrators. Learn about database tools and techniques for using SQL and PHP and for developing scalable database applications in the .NET environment. Save over $109 and receive a FREE gift. Order now. http://searchDatabase.com/r/0,,26814,00.htm?track=NL-94&ad=479021&databaseprofessional ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIP: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= INTRODUCTION TO SQLXML | Ken Henderson This chapter from a new book by Ken Henderson describes how SQLXML technologies are designed and how they fit together from an architectural standpoint. As with the rest of the book, the author's intent here is to get beyond the "how to" and into the "why" behind how SQL Server's technologies work. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci939474,00.html?track=NL-94&ad=479021 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= LINUX ON THE MAINFRAME -- IS IT RIGHT FOR YOU? | Johanna Ambrosio Running Linux on a mainframe isn't the right move for everyone, but an increasing number of customers are choosing this route. >> CLICK for the full tip... http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci947002,00.html?track=NL-94&ad=479021 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= MERGING DATASETS WITH NULL VALUES | Carmen Beitzer The MERGE functionality introduced in Oracle9i offers a simplified, yet powerful enhancement to the commonly known UPSERT approach of earlier editions. >> CLICK for the full tip... http://www.searchOracle.com/tip/1,289483,sid41_gci955161,00.html?track=NL-94&ad=479021 ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: PLANNING FOR WINDOWS SERVER 2003 | Johanna Ambrosio http://www.searchDatabase.com/tip/1,289483,sid13_gci955254,00.html?track=NL-94&ad=479021 Large companies with numerous remote nodes will benefit the most from a rapid upgrade to Windows Server 2003. DB2 V8 CERTIFICATION: EVERYTHING YOU NEED TO KNOW | H. Fosdick http://www.searchDatabase.com/tip/1,289483,sid13_gci947041,00.html?track=NL-94&ad=479021 The whats, whys, and hows of DB2 certification are presented in this detailed article. FIND UNNECESSARY DUPLICATE INDEXES ON A TABLE | Cassio Ferrari http://www.searchOracle.com/tip/1,289483,sid41_gci938740,00.html?track=NL-94&ad=479021 This Oracle script will generate a drop index script which can be used to drop redundant indexes on all tables except those owned by user SYS and SYSTEM. FACE-OFF: ORACLE VS. SQL SERVER | Tim DiChiara & Robyn Lorusso http://searchdatabase.techtarget.com/originalContent/0,289142,sid13_gci953120,00.html?track=NL-94&ad=479021 Our crash course in the lingua franca of the database world, the structured query language, including tips, advice, and scripts from the gurus... LEARNING GUIDE TO SQL http://searchdatabase.techtarget.com/originalContent/0,289142,sid13_gci950920,00.html?track=NL-94&ad=479021 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=479021 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=479021 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=479021 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=479021 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=479021 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=479021 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? Hundreds more free tech tips submitted by members: http://searchdatabase.techtarget.com/tips/0,289484,sid13_tax281808,00.html?track=NL-94&ad=479021 Share your knowledge, submit a tip, win a prize: http://searchdatabase.techtarget.com/tipsSubmit/1,289485,sid13,00.html?track=NL-94&ad=479021 ___________________________________________________________________ IMPORTANT LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= YOUR TOUGH DATABASE QUESTIONS ANSWERED | Ask the Experts SQL: A scalar subquery http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid578476_tax285649,00.html?track=NL-94&ad=479021 SQL Server: Formatting dates, part 1 http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid575447_tax294863,00.html?track=NL-94&ad=479021 SQL Server: Does script continue to work after failover? http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid576420_tax285648,00.html?track=NL-94&ad=479021 SQL Server: Memory problems with SQLServerAgent http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid576423_tax285648,00.html?track=NL-94&ad=479021 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=479021 DB2: Extracting hours from a timestamp http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid578568_tax285651,00.html?track=NL-94&ad=479021 DB2: Updating part of a foreign key http://searchdatabase.techtarget.com/ateQuestionNResponse/0,289625,sid13_cid578569_tax285651,00.html?track=NL-94&ad=479021 >> CLICK for other database expert answers... http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html?track=NL-94&ad=479021 >> CLICK for Oracle-related expert answers... http://searchoracle.techtarget.com/ateExperts/0,289622,sid41,00.html?track=NL-94&ad=479021 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DBMS SECURITY | Featured Topic The need for data security may be obvious, but the path getting there certainly isn't. Our collection of tips & advice will help you lock down your Oracle, DB2, or SQL Server DBMS. http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci863539,00.html?track=NL-94&ad=479021 ___________________________________________________________________ *********************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=479021&lid=430854&track=NL-94&ad=479021 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
