SEARCHDATABASE.COM | Database Administrator Tips
March 12, 2003
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
IN THIS ISSUE | Table of Contents
1. DATABASE ADMINISTRATOR TIPS
- DB2: Use trigger programs to track record changes
- SQL Server: Upgrading SQL Server, part I
- Oracle: An example of dynamic SQL in PL/SQL redux
- Data warehousing: Getting value out of your data
- More recent tips from members
2. IMPORTANT ANNOUNCEMENTS AND LINKS
- Free webcast: Business intelligence with SQL Server, and more
- Ask the experts: Your database questions answered
- Featured Topic: PL/SQL tips and scripts
___________________________________________________________________
THIS WEEK'S TIPS:
USE TRIGGER PROGRAMS TO TRACK RECORD CHANGES | John Kohan
One of the issues programmers have to deal with is recording when a
record was changed. Trigger programs are one way for you to track
these changes on DB2 for AS/400.
>> CLICK for the full tip...
http://www.searchDatabase.com/tip/1,289483,sid13_gci868256,00.html
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
UPGRADING SQL SERVER, PART I: OVERVIEW AND PROJECT PLANNING
First of a series by Jeremy Kadlec detailing the SQL Server upgrade
process from the technical, logistical and business perspective.
>> CLICK for the full tip...
http://www.searchDatabase.com/tip/1,289483,sid13_gci883965,00.html
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
AN EXAMPLE OF DYNAMIC SQL IN PL/SQL | Lucy Lynch
This rebuttal to a recent tip is a tip itself. The author argues that
the problem presented can be solved much more compactly and
efficiently with straight SQL than dynamic SQL and provided this
replacement script to prove it. (Do you agree or disagree? Email the
editor at [EMAIL PROTECTED] and let him know!)
>> CLICK for the full tip...
http://www.searchDatabase.com/tip/1,289483,sid13_gci809890,00.html
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
BEYOND REPORTING: GETTING VALUE OUT OF YOUR DATA | John Wallace
OLAP and business intelligence (BI) are key elements of reporting and
can offer significant value to businesses. This article is an
introdction to advanced analytics, including predictive modeling,
clustering, optimization, and more.
>> CLICK for the full tip...
http://www.searchDatabase.com/tip/1,289483,sid13_gci884576,00.html
___________________________________________________________________
MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS:
DROPPING A COLUMN IN DB2 7.2 | Prashant Dahalkar
http://www.searchDatabase.com/tip/1,289483,sid13_gci881687,00.html
Here is a simple way to drop a column to update your DB2 7.2
databases if you do not use third-party software.
COMPARING TIMESTAMPS | Baya Pavliashvili
http://www.searchDatabase.com/tip/1,289483,sid13_gci876848,00.html
If you're unfamiliar with the TIMESTAMP data type in SQL Server, be
forewarned: its name is rather misleading. The truth is that
TIMESTAMP has absolutely nothing to do with date or time. The whys
and hows of using TIMESTAMP are outlined in this article.
AUTOMATIC COALESCE OF ALL TABLESPACES | Max Mangoni
http://www.searchDatabase.com/tip/1,289483,sid13_gci883724,00.html
Coalescing tablespace extents is fundamental when the database
contains a lot of fragmentated tablespaces. This simple korn shell
script helps to automate cleaning of tablespaces. Using this script,
the Oracle DBA can schedule a regular tablespace coalesce (always
advisable) without any manual intervention.
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:
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
FREE WEBCASTS | SearchDatabase.com
>> Business intelligence with SQL Server
http://searchDatabase.com/r/0,,10507,00.htm
Microsoft's Bill Baker discusses best practices for implementing
a SQL Server business intelligence solution on heterogeneous
database systems.
>> Impossible data warehouse situations
http://searchdatabase.com/r/0,,10092,00.htm
Experts Chuck Kelley and Sid Adelman discuss their personal
experiences about the realities of data warehousing not covered
in basic texts.
>> Business intelligence: From inception to implementation
http://searchDatabase.com/r/0,,10861,00.htm
Listen and learn as author Shaku Atre discusses the different the
major components of BI application development, the vendor landscape,
and the six steps of a BI implementation.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
YOUR TOUGH DATABASE QUESTIONS ANSWERED | Ask the Experts
Oracle: Duplicating a database without using rcp
http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid520875_tax289342,00.html
Oracle: Getting Database Configuration Assistant to work
http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid520890_tax289342,00.html
Oracle: Getting the MAX over a partition
http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid520900_tax285650,00.html
Oracle: Refreshing one 8.0.5 instance's data with another
http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid520892_tax285650,00.html
Oracle: Running a recurring job at another specific time
http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid520873_tax289342,00.html
More expert answers here:
http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
PL/SQL TIPS AND SCRIPTS | SearchDatabase.com Featured Topic
PL/SQL is Oracle's powerful procedural language extension to the
Structured Query Language. The free tips, tutorials, scripts and
expert advice inside will help DBAs and developers master PL/SQL
scripting.
>> CLICK for our current Featured Topic...
http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci884334,00.html
>> CLICK for previous Featured Topics...
http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html
___________________________________________________________________
*********************SEARCHDATABASE CONTACTS***********************
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.
___________________________________________________________________
:::::::::::::::::::: ABOUT THIS NEWSLETTER :::::::::::::::::::::
Published 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."
