from:"searchDatabase.com"

Database Developer Tip: VBA class modules

2001-08-01 Thread searchDatabase.com


 
SEARCHDATABASE.COM'S Database Developer Tips
August 1, 2001 
 

Welcome to the searchDatabase.com Database Developer Tips newsletter!
Today's tip, VBA database class modules can also be viewed online
at: 
http://www.searchDatabase.com/tip/1,289483,sid13_gci758640,00.html

Don't forget about our collection of over 200 DBA, developer, Oracle,
DB2, and SQL Server tips FREE to searchDatabase members:
http://searchdatabase.techtarget.com/tips/0,289484,sid13_tax281808,00.html

 Storage Decisions 2001 ***

Storage Decisions 2001 (SD2001), an exclusive conference focused on
storage, is brought to you by our sister site searchStorage.com. The
event takes place in Chicago from September 26 through 28. Unlike any
other storage conference, this event is FREE to searchDatabase.com
members who manage storage in enterprise environments and face
storage decisions in the upcoming months and year. Other events
merely identify the issues you face, SD2001 tackles them head on with
specific how-to-advice to set strategy, make key decisions and manage
storage effectively. Benefit from the expertise of top storage
analysts like Gartner Group's Nick Allen, seasoned experts like Steve
Duplessie of ESG and storage technologists independent expert and
best selling author John William Toigo.

*

VBA database class modules 

By Barrie Sosinsky

A Class module contains the definition for a new object. Procedures
to represent the properties and methods of the object can be defined
in the module. Class modules were available to Access developers
first in the Access 97 database. The addition of standalone class
modules in Visual Basic for Applications or VBA is a welcome site to
users and would be developers. A class is the definition of an
object. The module allows you to define the class or object. Once a
class is defined, you can then create a new object simply by creating
a new instance of the class. 

While you may not be aware of it, you have probably used classes and
associated objects already. As a brief example, the forms or reports
modules you use are class modules, while the form or report itself is
actually the instantiated object. Instantiated is when you create a
new instance of a class, you create a new object, usually by using
the set keyword, which assigns a variable to represent the new
object. That is also a new occurrence of a class. Another good
example of object definition and its instantiated result is the
ComboBox class and a ComboBox object on your generated form.

Many times the same set of processes must be applied repeatedly
whenever certain types of data are needed by your application. You
can encapsulate your data combined with the rules and regulations
that apply, and let less experienced developers have access to it
without destroying or corrupting it. Since they are allowed only to
reference the properties and methods, they do not go through entire
pages of your code. Encapsulation preserves the integrity of your
program. 

Some of the best reasons for working with class modules are:

 *  If you use the same types of forms, you can view multiple forms
in separate windows.
 
  *  If you have a multiuser environment and want to speed it up, you
can create class modules that represent your records as reusable
objects.
 
 *  You can ensure that business rules are enforced, by encapsulating
them and associated data into a single class.

More information about creating class modules is available at
http://www.microsoft.com/officedev/articles/movs109.htm.

ABOUT THE AUTHOR
Barrie Sosinsky ([EMAIL PROTECTED]) is president of consulting
company Sosinsky and Associates (Medfield MA). He has written
extensively on a variety of computer topics. His company specializes
in custom software (database and Web related), training and technical
documentation.

SUBMIT YOUR OWN TIP AND WIN A PRIZE
http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz520733_cts520732,00.html
 

===
MORE GREAT STUFF ON SEARCHDATABASE!
===

Featured Topic this week: Storage tips  tricks
The most important function of a DBA is storage management: the
backup and recovery of business-critical data. But how do you keep up
with emerging technologies such as DAS, SAN and NAS? SearchDatabase
has compiled the best online advice, news stories, Web links and
vendor listings to help you learn more about storage.
http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci757776,00.html

NEW: Three archived audio presentations with leading experts are now
available:

   Data mining for fun and profit, by Shaku Atre
  
http://searchdatabase.techtarget.com/onlineEventsTranscriptSecurity/1,289693,sid13_gci754454,00.html

   Database replication, by Mike Hotek
  
http://searchdatabase.techtarget.com

DBA Tip: Renaming foreign keys

2001-08-08 Thread searchDatabase.com

SEARCHDATABASE.COM'S Database Administrator Tip
August 8, 2001

Welcome to the searchDatabase.com Database Administrator Tips
newsletter! Today's tip, Renaming foreign keys can also be viewed
online at:
http://www.searchDatabase.com/tip/1,289483,sid13_gci759997,00.html

Check out our collection of over 200 DBA, developer, Oracle, DB2, and
SQL Server tips FREE to searchDatabase members:
http://searchdatabase.techtarget.com/tips/0,289484,sid13_tax281808,00.html

Discussion Today: The Pros and Cons of XML

2001-08-22 Thread searchDatabase.com


TODAY'S DISCUSSION
XML began as a simple markup language for defining and sharing
documents containing structured information. Recently, initiatives
such as XML Query and XML Schemas have been designed to incorporate
database-like features. Is this the direction XML should be headed?
Do you have an experience to share that either supports or challenges
the wisdom of this direction? Join in today's DBA Water Cooler Forum
Discussion and let us know what you think:
http://searchdatabase.techtarget.com/forums/0,289802,sid13_fid1,00.html

TODAY'S EXPERT PANEL
On hand in the DBA Water Cooler Forum today is an impressive panel of
database technology experts to answer your questions and comment on
your opinions: Bianca Blount, Mike Hotek, Craig Mullins, Fabian
Pascal, Brian Peasland and Pat Phelan. Challenge them, and take
advantage of the shared knowledge of this impressive list of experts
-- as well as your fellow searchDatabase members -- in today's
discussion:
http://searchdatabase.techtarget.com/forums/0,289802,sid13_fid1,00.html



If you no longer wish to receive this newsletter simply reply to 
this message with REMOVE in the subject line.  Or, visit 
http://searchDatabase.techtarget.com/register 
and adjust your subscriptions accordingly. 

If you choose to unsubscribe using our automated processing, you 
must send the REMOVE request from the email account to which 
this newsletter was delivered.  Please allow 24 hours for your 
REMOVE request to be processed.

DBA Tip: Improve performance with histograms

2001-08-22 Thread searchDatabase.com


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
SEARCHDATABASE.COM  |  Database Administrator Tip
August 22, 2001 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Welcome to the searchDatabase.com Database Administrator Tips
newsletter! Today's tip, Improving performance with histograms can
also be viewed online at: 
http://www.searchDatabase.com/tip/1,289483,sid13_gci758792,00.html

Check out collection of over 200 DBA, developer, Oracle, DB2, and SQL
Server tips FREE to searchDatabase members:
http://searchdatabase.techtarget.com/tips/0,289484,sid13_tax281808,00.html


SPONSORED BY: **Storage Decisions 2001**

If you're going to spend $5+ million on storage hardware and software
next year, don't miss a must-attend FREE conference developed just
for you. Attend Storage Decisions 2001 in Chicago September 26-28.
Learn to set strategy/make the smartest decisions to most effectively
manage your storage initiatives for 2002. Pre-qualified audience of
your peers and NO vendor sales pitches. Visit: 

http://ad.doubleclick.net/clk;3230220;5058249;w?http://www.StorageDecisions2001.com



Improving performance with histograms

By James Giordano


When dealing with a table that has highly skewed data distribution,
histograms are an excellent way to improve performance by getting the
optimizer to choose your index.

Recently I was tuning some SQL that used a column to flag whether a
row should be processed or not. For example the table had a column
called JOB_ID, 99% of the million rows in the table had a value of 0,
and the other 1% of the rows had a JOB_ID of the PID of the job
processing the data. There was an index built on JOB_ID, but the
optimizer wouldn't use the index, because the cardinality of the
index was so poor. In this case a histogram helped to get the
optimizer to use the index. Histograms are created using the FOR
COLUMNS option of the analyze command. For example, I used:

  ANALYZE TABLE INVENTORY_COST ESTIMATE STATISTICS SAMPLE 20 PERCENT
  FOR COLUMNS JOB_ID SIZE 10;

Determining where histograms are used in your database is a little
tricky because Oracle considers all cost-based statistics as
histograms, so if you look in DBA_HISTOGRAMS, you will find 2 rows
for every table in the database. I have been using the following
query to determine what table have histograms:

  select 
distinct TABLE_NAME, COLUMN_NAME 
  from 
dba_histograms 
  where 
endpoint_number not in (1,0) 
  order by table_name, column_name ;


ABOUT THE AUTHOR:
James Giordano is an Oracle database administrator. He has been
working with Oracle for about seven years, and also has experience
with UNIX and PeopleSoft/Oracle financials.

SUBMIT YOUR OWN TIP AND WIN A PRIZE:
http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz520733_cts520732,00.html
 

===
MORE GREAT STUFF ON SEARCHDATABASE!
===

Featured Topic this week: XML: Hit or hype?
http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci761146,00.html
XML began as a simple markup language for defining and sharing
documents containing structured data. Then came database-like
initiatives such as XML Query and XML Schemas. Where is XML headed?
Where should it be headed? Check out our XML resources and join the
debate in our discussion forums.

If XML is just a physical format for data exchange, why does it
incorporate logical constructs such as data model components?  More:
http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci759453,00.html

Mark your calendars: Bill Inmon, the father of data warehousing, will
be presenting Ten critical data warehousing success factors LIVE on
searchDatabase.com September 6 at 1 pm Eastern (18:00 GMT). He will
also be available to take your questions. Don't miss this opportunity
to chat with the premier data warehousing guru in the world!
http://searchdatabase.techtarget.com/onlineEvents/0,289675,sid13,00.html

Over 200 DBA, developer, Oracle, DB2, and SQL Server tips FREE to
searchDatabase members:
http://searchdatabase.techtarget.com/tips/0,289484,sid13_tax281808,00.html

Hundreds of hand-picked and reviewed resources about every aspect of
database administration, including backup, performance tuning,
database design, normalization, and much more:
http://searchdatabase.techtarget.com/bestWebLinks/0,289521,sid13_tax281570,00.html

Ask the Expert category of the day: SQL
http://searchdatabase.techtarget.com/ateAnswers/0,289620,sid13_cid376817_tax285649,00.html
SQL guru extraordinaire Rudy Limeback is waiting to tackle your
toughest SQL scripting problems.

===
LEARNING ZONE FEATURED BOOK OF THE WEEK 
===
Oracle 9i SQLJ Programming 

By Nirva Morisseau-Leroy  

Take

Developer tip: Creating a SQL Server database

2001-08-29 Thread searchDatabase.com

SEARCHDATABASE.COM'S Database Developer Tip
August 29, 2001

Welcome to the searchDatabase.com Database Developer Tip newsletter!
Today's tip, Creating a SQL Server database can also be viewed
online at:
http://www.searchDatabase.com/tip/1,289483,sid13_gci764004,00.html

Don't forget about our collection of over 200 DBA, developer, Oracle,
DB2, and SQL Server tips FREE to searchDatabase members:
http://searchdatabase.techtarget.com/tips/0,289484,sid13_tax281808,00.html

This Week: Bill Inmon's Top 10

2001-09-04 Thread searchDatabase.com


September 4, 2001

SearchDatabase Member,

This is a big week on searchDatabase. You are invited to participate
in a Live QA Thursday with Bill Inmon -- the man who coined the term
data warehouse. Be sure to pre-register for the event today and
check out the rest of the new resources we've gathered for you in
this week's update.

* Live Thursday: Bill Inmon's Top 10 DW Success Factors
* Featured Topic: Data Warehousing Success (or, Avoiding Failure)
* September Contest: Submit a Tip, Win a DVD Player
* PASS 2001 NORTH AMERICA: Unparalleled SQL Education
* Live Event Transcript Library: Over 40 Topics and Speakers
* Informix Product Line Lives on Inside IBM
* Security Product Reviews: Concise, Informative  Timesaving
* Quick Takes: Securing Unprotected Data
* Java is Living Up to its Promises
* More: Java Best Web Links

LIVE THURSDAY: BILL INMON'S TOP 10
Get problem-solving advice from the guy who started it all. Join the
father of the data warehouse in this discussion about the most
critical guidelines to follow -- and the common pitfalls to avoid -
in running a data warehouse. Join us for a Live Expert QA this
Thursday, September 6th at 1:00 PM EDT (17:00 GMT). This exclusive
event is sponsored by Syncsort -- pre-register now and make plans to
join in the discussion:
http://www.italkservices.com/iTalkSlides/CustomerDocs/tcht01/viewLogin.asp?prov=15742pres=1
 

FEATURED TOPIC: DATA WAREHOUSING SUCCESS (OR, AVOIDING FAILURE)
You've seen the stats and heard the stories on the large number of
failed data warehousing projects. Learn from other's mistakes by
reading (and using) this week's Featured Topic report:
http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci764575,00.html 

SEPTEMBER CONTEST: SUBMIT A TIP, WIN A DVD PLAYER
A new month means a new prize -- the winner of September's tip
contest will walk away with a DVD Player! If you've recently solved a
problem with your database or found a particularly useful snippet of
code, then we want to hear from you. Share the information, help your
peers, and possibly win a DVD player.
http://searchdatabase.techtarget.com/tipsSubmit/1,289485,sid13,00.html 

PASS 2001 NORTH AMERICA: Unparalleled SQL Education
The premier SQL Server event, PASS 2001 North America, gives you
instant access to the latest SQL trends and solutions from users,
Microsoft developers, MVPs, and SQL experts. Plus, take advantage of
more than 100 technical sessions, pre-conference seminars, and access
to more than fifty leading vendors. 
Conference Details: http://www.sqlpass.org/events/orlando/index.cfm  
Hotel Discounts -- Up to 40% off at: http://www.swandolphin.com/ 

LIVE EVENT TRANSCRIPT LIBRARY: OVER 40 TOPICS AND SPEAKERS
The list of speakers that have hosted searchDatabase Live Expert QAs
over the past year reads like a who's who in the database community.
Stop by our Live Event Transcript Library containing over 40 topics
and speakers, archived by event date for your convenience. Click
here: 
http://searchdatabase.techtarget.com/onlineEventsTranscripts/0,289709,sid13,00.html 

INFORMIX PRODUCT LINE LIVES ON INSIDE IBM
IBM has sent strong signals that the Informix product line will not
suffer a quick death now that Big Blue has completed its $1 billion
acquisition of the software maker's database business. Read on:
http://searchdatabase.techtarget.com/originalContent/0,289142,sid13_gci763216,00.html 

SECURITY PRODUCT REVIEWS: CONCISE, INFORMATIVE  TIMESAVING
Imagine -- only 5 minutes a month and you gain:
* Explanation of important security product categories
* Summary of the leading vendors  tools in those categories
* Insights on the performance of the top security products 
* Insights into shortcomings and needed improvements 
* Key trends in the security products market
Get it all once a month with Scheier's Security Products Roundup
Exclusively for searchSecurity members. Sign up now:
http://www.searchsecurity.com/register

QUICK TAKES: SECURING UNPROTECTED DATA
Data Junction and ERUCES form a partnership to help users transfer
unprotected data to secure databases, and DBMiner releases new
analytical software for business intelligence in this edition of
Quick Takes. Read on:
http://searchdatabase.techtarget.com/originalContent/0,289142,sid13_gci763495,00.html

JAVA IS LIVING UP TO ITS PROMISES
In the six years since Java was introduced, the programming language
has made a name for itself by enabling portable applications. In this
multi-platform world, most new software applications that are written
use a mixture of technologies, but one expert says, Java is here to
stay. It has rapidly settled in. Get the whole story here:
http://searchdatabase.techtarget.com/originalContent/0,289142,sid13_gci764387,00.html

MORE: JAVA BEST WEB LINKS
Find the Best Web Links gathered by our editorial team from all
across the Internet on Java here:
http://searchdatabase.techtarget.com/bestWebLinks/0,289521,sid13_tax281601,00.html


Please forward this email to colleagues who

Bill Inmon Live: Data Warehousing Success

2001-09-05 Thread searchDatabase.com


Join us TOMORROW, Thursday September 6th at 1:00 PM EDT (17:00 GMT)
for the Live Expert QA: The Top 10 Data Warehousing Success Factors
with database technology pioneer Bill Inmon. For event details and
free pre-registration, click here:
http://searchdatabase.techtarget.com/onlineEvents/0,289675,sid13,00.html

THE EVENT SPONSOR: SYNCSORT
**Mine Web Data Fast!-FREE Flashlight-FREE Trial**
An active web site can easily generate a billion web records a day.
How can you mine all that information fast to better understand
customer behavior and increase profits? Web data mining pioneers like
Microsoft are using SyncSort, a lightning-fast data manipulation
product, to sort, select, reformat, clean, standardize and aggregate
web data.  For a FREE product trial, and a FREE flashlight to remind
you that SyncSort can shine a light on buried nuggets of information
fast, click here:
http://www.syncsort.com/tgz910

FOR MORE: DATA WAREHOUSING SUCCESS!
You've read the grim statistics. You've heard the horror stories.
Many data warehousing projects are doomed to fail. This week's
searchDatabase Featured Topic targets resources gathered to help you
avoid common pitfalls and learn from others' mistakes. This Featured
Topic culminates with Thursday's Live Expert QA with Bill Inmon.
Check it out:
http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci764575,00.html






If you no longer wish to receive this newsletter simply reply to 
this message with REMOVE in the subject line.  Or, visit 
http://searchDatabase.techtarget.com/register 
and adjust your subscriptions accordingly. 

If you choose to unsubscribe using our automated processing, you 
must send the REMOVE request from the email account to which 
this newsletter was delivered.  Please allow 24 hours for your 
REMOVE request to be processed.

TODAY: Live Expert QA with Bill Inmon

2001-09-06 Thread searchDatabase.com


Log on now and register for today's exclusive Live Expert QA with
`the father of the data warehouse', Bill Inmon. The topic of today's
multimedia presentation and real-time discussion is The Top 10
Factors in Data Warehousing Success. This one-hour event happens
TODAY, Thursday, September 6th at 1:00 PM EDT (17:00 GMT) on
searchDatabase. Click here to participate:
http://searchdatabase.techtarget.com/onlineEvents/0,289675,sid13,00.html

THE EVENT SPONSOR: SYNCSORT
**Mine Web Data Fast!-FREE Flashlight-FREE Trial**
An active web site can easily generate a billion web records a day.
How can you mine all that information fast to better understand
customer behavior and increase profits? Web data mining pioneers like
Microsoft are using SyncSort, a lightning-fast data manipulation
product, to sort, select, reformat, clean, standardize and aggregate
web data.  For a FREE product trial, and a FREE flashlight to remind
you that SyncSort can shine a light on buried nuggets of information
fast, click here:
http://www.syncsort.com/tgz910




If you no longer wish to receive this newsletter simply reply to 
this message with REMOVE in the subject line.  Or, visit 
http://searchDatabase.techtarget.com/register 
and adjust your subscriptions accordingly. 

If you choose to unsubscribe using our automated processing, you 
must send the REMOVE request from the email account to which 
this newsletter was delivered.  Please allow 24 hours for your 
REMOVE request to be processed.

This Week: Whither Informix?

2001-09-10 Thread searchDatabase.com


September 10, 2001

SearchDatabase Member,

Among the items in this week's update, you'll find a Featured Topic
report discussing how the marriage between IBM and Informix is
shaping up and the affect this is having on the database industry.

* Featured Topic: Whither Informix?
* SearchDatabase: 100,000 and Growing
* Introducing new TargetSearch Powered by Google
* Audio Archive: Bill Inmon's Top 10
* Plan Now: TDWI Fall Conference
* New and Improved Data Warehousing Resources
* Ask the DB2 Expert: Craig Mullins
* Online Quiz: Database Basics
* Understanding SQL and Java Together
* Win a Blackberry and Read the Latest IDC White Paper
* 2 New White Papers Free to our members
* Final Notice to members

FEATURED TOPIC: Whither Informix?
Although IBM's acquisition of Informix is now a month old, questions
remain. Will IBM really continue to support Informix products? How
will the development of DB2 be affected? Why did IBM buy Informix
anyway? Read on: 
http://www.searchDatabase.com/featuredTopic/0,290042,sid13_gci768593,00.html 

SEARCHDATABASE: 100,000 AND GROWING
In a little over a year, searchDatabase membership has grown to over
100,000 database professionals. We are proud of this accomplishment
and we plan to continue our commitment to bring you the targeted
resources you want, when you want them. Please take a minute today
and update your member profile to make sure you are taking full
advantage of all searchDatabase has to offer you -- especially the
free, targeted newsletters created just for you:
http://searchdatabase.techtarget.com/register/1,,sid13,00.html 

INTRODUCING NEW TARGETSEARCH POWERED BY GOOGLE
We are excited to introduce the launch of our NEW TargetSearch
powered by Google. We have combined the most powerful search
technology on the Web, Google, with the most targeted sites on the
Web to create the Web's most powerful and targeted search engine.
TargetSearch crawls the thousands of database-specific sites that
have been hand picked by our editorial team to ensure only relevant
results. Try the new Database TargetSearch today at:
http://searchdatabase.techtarget.com/integratedSearchAdvanced/0,289518,sid13,00.html 

AUDIO ARCHIVE: BILL INMON'S TOP 10
Thanks to all who joined us last week for our Live Expert QA with
data warehousing guru Bill Inmon as he discussed The Top 10 Data
Warehousing Success Factors. If you missed the event or would like to
give it a second visit -- click on the following link to hear the
full audio archive and view the presentation:
http://www.italkservices.com/iTalkSlides/CustomerDocs/tcht01/viewLogin.asp?prov=15742pres=1U=a2c1b7cc-a2f2-11d5-a8ce-00d0b79d91f0SA=1
 

This exclusive event was sponsored by Syncsort.
For a FREE product trial, and a FREE flashlight, click here:
http://www.syncsort.com/tgz910 

NOT YOUR ORDINARY DATA WAREHOUSING AND BUSINESS INTELLIGENCE
CONFERENCE
TDWI World Conference-Fall 2001, 11/4 - 11/9, Orlando, FL
A unique program of intensive training --including cutting-edge
topics, direct access to industry experts, and plenty of
opportunities to network with your peers.
For more information, please visit: 
http://www.dw-institute.com/orlando2001/ 
REGISTER BEFORE THE 28TH OF SEPTEMBER AND RECEIVE THE EARLY
REGISTRATION DISCOUNT AND BONUS GIFT!

NEW AND IMPROVED DATA WAREHOUSING RESOURCES
Attention searchDataWarehousing members: Take a look at our newly
enhanced Data Warehousing and Business Intelligence Best Web Links
section. Go to:
http://searchdatabase.techtarget.com/bestWebLinks/0,289521,sid13_tax281567,00.html

ASK THE DB2 EXPERT: CRAIG MULLINS
Get free advice from the searchDatabase DB2 expert, Craig Mullins.
Craig is the Director of DB2 Technology Planning at BMC Software and
is available to answer your inquiries in our Ask the Expert section:
http://searchdatabase.techtarget.com/ateQuestion/0,289624,sid13_tax285651,00.html 

ONLINE QUIZ: DATABASE BASICS
Show off your knowledge of database technology by trying to ace our
quiz:
http://searchdatabase.techtarget.com/sDefinition/0,,sid13_gci750695,00.html 

UNDERSTANDING SQL AND JAVA TOGETHER
A guide to SQLJ, JDBC, and Related Technologies by Jim Melton and
Andrew Eisenberg. For fast shipping and a great price, click here:
http://www.digitalguru.com/DigitalGuru/product_detail.asp?catalog%5Fname=Booksproduct%5Fid=1558605622partner_id=77
  

WIN A BLACKBERRY AND READ THE LATEST IDC WHITE PAPER
Sign up for the free Information Architect Newsletter that examines
innovative companies that are leading the market in the development
and deployment of next-generation information architectures. When you
sign up you will be automatically entered to win a Wireless
Blackberry.
Sign up today at
http://ad.doubleclick.net/clk;3301864;5058249;j?http://www.searchstorage.com/EMCjump

2 NEW WHITE PAPERS FREE TO OUR MEMBERS
Service providers claim to offer IT organizations a viable option to
cut costs, free-up internal resources, and quickly implement
business-critical solutions. Update your member profile

DBA Tip: Is your database accessible?

2001-09-12 Thread searchDatabase.com


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
SEARCHDATABASE.COM  |  Database Administrator Tip
September 12, 2001 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Welcome to the searchDatabase.com Database Administrator Tips
newsletter! Today's tip, Is your database accessible? can also be
viewed online at: 
http://www.searchDatabase.com/tip/1,289483,sid13_gci769447,00.html

Help your fellow database geeks and perhaps win a Toshiba DVD player!
Submit your own technical tip here:
http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz764692_cts764388,00.html

 Sponsored by SyncSort ***

**Mine Web Data Fast!-FREE Flashlight-FREE Trial**
An active web site can easily generate a billion web records a day.
How can you mine all that information fast to better understand
customer behavior and increase profits? Web data mining pioneers like
Microsoft are using SyncSort, a lightning-fast data manipulation
product, to sort, select, reformat, clean, standardize and aggregate
web data.  For a FREE product trial, and a FREE flashlight to remind
you that SyncSort can shine a light on buried nuggets of information
fast, click here: 

http://www.syncsort.com/tgb910

*

Is your database accessible?

By Kirtikumar Deshpande


As a DBA, there will be situations when you would like to know if a
particular Oracle database is up and running, and if it is accessible
to end users. Most solutions involve checking for the presence of a
background process such as PMON or SMON (or in older versions, the
file sgadef.dbf). However, these solutions do not tell the DBA if the
database is accessible or not. The following simple code does two
things. It positively verifies that the listener process is working
properly and the database is accessible by trying to connect to it.
You do not need to set up any special user account to try to make a
connection! 

Here's the code:


#!/usr/bin/ksh 
# 
# dbcheck : Script to check if datbase is up 
# and accessible 
#--- 
  
echo Enter Name of the Database SID to check 
  if it is accessible 
read DB 

# Let us try to connect to the DB using a 
# dummy userid/password. 
sqlplus -s  EOF  /tmp/$$.1 
whenever sqlerror exit 
aaa/aaa@$DB 
exit; 
EOF 
## Please be sure EOF start in column 1 

egrep 'ORA-121|ORA-01034' /tmp/$$.1  /dev/null 
if [[ $? = 0 ]] 
then 
   echo - '$DB' is _NOT_ Accessiblen 
else 
   grep 'ORA-01017' /tmp/$$.1  /dev/null 
   if [[ $? = 0 ]] 
   then 
 echo - '$DB' is UP and Accessiblen 
   else 
 echo - '$DB' is _NOT_ Accessiblen 
   fi 
fi 
rm /tmp/$$.1 

# --- End of File 


FOR MORE INFORMATION:

The Best Oracle Web Links: tips, tutorials, and more
http://searchdatabase.techtarget.com/bestWebLinks/0,289521,sid13_tax282873,00.html

Ask your technical Oracle questions--or help out your peers by
answering them--in our live discussion forums:
http://searchdatabase.techtarget.com/forums/0,289802,sid13_fid1,00.html

Help your peers: Submit your own tip and win a Toshiba DVD player!
http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz520733_cts520732,00.html
 


SPONSORED BY: **Storage Decisions 2001**


TIME IS RUNNING OUT to qualify to attend the FREE Storage Decisions
2001 conference in Chicago September 26-28. Learn to set
strategy/make the smartest decisions to most effectively manage your
storage initiatives for 2002. Pre-qualified audience of your peers
and NO vendor sales pitches. Don't get shut out at this critical
event. Visit: 

http://ad.doubleclick.net/clk;3230220;5058249;w?http://www.StorageDecisions2001.com 

===
MORE GREAT STUFF ON SEARCHDATABASE!
===

This week's Featured Topic: Whither Informix?
Although IBM's acquisition of Informix is now a month old, questions
remain. Will IBM really continue to support Informix products? How
will the development of DB2 be affected? Why did IBM buy Informix
anyway? Click the link below for more...
http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci768593,00.html

Did you miss Bill Inmon's excellent presentation about the Top ten
data warehousing success factors? Check out this archived version,
complete with audio and PowerPoint presentation:
http://searchdatabase.techtarget.com/onlineEventsTranscriptSecurity/1,289693,sid13_gci760304,00.html

WIN A TOSHIBA DVD PLAYER: Share your knowledge, help your peers, and
compete to win a $200 DVD player. Submit your technical tip today:
http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz764692_cts764388,00.html

Sonal and Sonix are still waiting for your help! Check out the DBA
Water Cooler for their questions about Oracle drivers and storing
BLOBs:
http

THIS WEEK: XML: Hit or hype?

2002-09-03 Thread SearchDatabase.com

Title: TechTarget

September 03, 2002

>>Receive this email as text >>About this email

In this Issue

>>
From the editor:
Data administration bloopers

>>
Featured Topic:
XML: Hit or hype?

>>
Expert Technical Advice:
New expert advice, forum posts, and tips

>>
Site Highlights:

* Live Webcast: Database health check
* Take our user survey
* Get the results of our Oracle Report Card

From the Editor:

by Tim DiChiara, Site Editor

Admit it. You're not perfect.

Sure, we all make mistakes, but the mistakes of DBAs are writ large, amplified due the mission-critical nature of the job. It's one thing to spill coffee on your home PC; it's quite another to do the same on your bank's main production server.

I'm happy to announce a fun new feature on SearchDatabase: True DBA Bloopers. Submit your backup/recovery snafus, tuning disasters, and ugly upgrades. Stories of good intentions gone bad, over-ambitious and under-trained newbies, clueless consultants, and even more clueless managers will all be accepted. If you've accidentally turned off the power to your company's data center, then this contest is for you. (Yes, that has happened!) The more horrifying, amusing, and wince-inducing the tale, the better. For obvious reasons, you can remain anonymous if you wish.

The submitter of the "best" (worst?) blooper of the month will receive a free copy of Craig Mullins' new book Database administration: The complete guide to practices and procedures.

Let's learn from each other's mistakes. Or at least laugh at each other's expense. Email me at [EMAIL PROTECTED] with your true DBA blooper.

Have a good week, Tim

Featured Topic:

XML: Hit or hype?
by Tim DiChiara, Site Editor
XML began as a simple markup language for defining and sharing documents containing structured data. Then came query features and database integration. The resources inside will help you understand and use XML with your DBMS...

Read more about this topic

Expert Technical Advice:

Featured Expert Jason Law
Senior Database Architect, PowerQuest Corp.

Category: SQL
Jason is an Oracle Certified Professional and a seasoned Systems Architect with more than twelve years experience in information technology. He has experience in data design, web applications, data warehousing, system integration, and project management. Ask him your tough SQL questions!

View all Jason's answers

This Week: In the forums

Ingres connection to Asp.NET

Here's a tough one. Member "shashi" is trying to connect an Asp.NET application to an Ingres database. Does anybody have any tutorials about how to do this? Go to our "Database-Web Connectivity" forum if you can offer any advice.

ASP 0177 (0x8007007E) Error

Member "yonelay" had an app that was working on PWS but all heck broke loose when he switched to IIS on Windows 2000: he gets an ASP 0177 (0x8007007E) error. Go to our "Database-Web Connectivity" forum if you can help "yonelay" figure out the problem.

Tip of the Week:
On August 16, data management expert and author Craig Mullins gave an excellent Webcast titled "Database Administration 101." Here are answers to audience questions that Craig
didn't have time to address.
>>
Craig Mullins answers your database administration questions

Site Highlights

Database health check on September 19
Find out if your Oracle database is fit in this Webcast with Quest Software
Your database may not be at peak performance. Don't be held back by your database; discover hidden issues in this Webcast.

Take our user survey
Help us improve the look, navigation and usability of SearchDatabase.com
We want your feedback. Tell us what you think about our site features in this user survey.

Get the results of our Oracle Report Card
Subscribe to the Daily News today for the survey results
You know what the media is saying about Oracle. Find out what Oracle users think. After asking 500 Oracle users for their opinions, the responses are now in and tallied. The results and analysis of

Webcast Series: Why smart companies are so bullish on Web services

2002-09-06 Thread SearchDatabase.com


Be sure to attend our two-part Vendor Connection Webcast series with
IONA entitled Standards-Based Enterprise Integration: Why Smart
Companies are so Bullish on Web Services. Join us to see how you can
enhance and extend your existing systems with Web services. 

Pre-register for both SearchDatabase.com Webcasts today, and you'll
receive e-mails each day to remind you of the events.

PART 1:
*
TOPIC:   Web Services for the financial industry
WHEN:Thursday, September 12 at 11:00 a.m. EDT (15:00 GMT) 
SPEAKER: Gary Maier, Managing Director of Financial Services, IONA
SPONSOR: IONA
PRE-REGISTER FOR THIS WEBCAST:
http://searchWebServices.com/r/0,,5467,00.htm
*


-- About this Webcast -- 

Small-to-medium sized organizations are likely to benefit the most
from the proliferation of best-of-breed application services. For
example, a Web service model in the financial industry can be used to
deliver fully integrated T+1 settlement capabilities to small hedge
funds. 

With limited technical proficiency and budget, this class of Web
service consumer is unlikely to value development tools and expensive
EAI frameworks. Instead the availability of a ubiquitous service
browser enabling just-in-time, mission-critical integration is
required. 

Attend this Webcast to learn how this vision changes current EAI
thinking, products and business models. Click here to register:
http://searchWebServices.com/r/0,,5467,00.htm

 
PART 2: 
*
TOPIC:   Life beyond CORBA: Extending network operations with Web 
 services
WHEN:Tuesday, September 17 at 11:00 a.m. EDT (15:00 GMT) 
SPEAKER: Jody Hunt, Senior Product Marketing Manager, IONA
SPONSOR: IONA
PRE-REGISTER FOR THIS WEBCAST:
http://searchWebServices.com/r/0,,5468,00.htm
*
 

-- About this Webcast -- 

There is no more widely adopted integration standard on the
network-facing side of telecommunications than CORBA. Today's dynamic
business climate demands integration of disparate network operations
as quickly and efficiently as possible. 

Attend this Webcast for a case-study approach showing how Web
Services can extend CORBA infrastructure to support CLECs and
resellers. Also discover how Web Services are used to realize
immediate ROI from acquired network facilities.

Register today for part two of this exclusive IONA Webcast series:
http://searchWebServices.com/r/0,,5468,00.htm

*
'Best Software White Paper' -- Maximize your Web Services Investment
*
Do you find it necessary to protect your Web services investment as
underlying technologies change? Using the Model Driven Architecture
(tm) approach, you can develop Web services in a way that improves
programmer productivity and avoids rapid obsolescence of services.
Download IONA's award-winning white paper: Using Model-Driven
Architecture to Develop Web Services to learn how. Click here:
http://www.searchwebservices.com/survey?s=483074track=WB_Promo_MDAWP
*


-- Invite a colleague --

If you think this topic would be interesting to a colleague, invite
them to this Vendor Connection Webcast. All you need to do is forward
this e-mail.



Unsubscribe from 'Updates on upcoming online events'
 - Simply Reply to this Email with REMOVE 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.
 - Uncheck the box next to the newsletter you wish 
   to unsubscribe from.
 - When finished, click Save Changes to My Profile.

THIS WEEK: DBMS reviews comparisons

2002-09-09 Thread SearchDatabase.com

Title: TechTarget

September 09, 2002

>>Receive this email as text >>About this email

In this Issue

>>
From the Editor:
Tip winners

>>
Featured Topic:
DBMS reviews & comparisons

>>
Expert Technical Advice:
New expert advice, forum posts, and tips

>>
Site Highlights:
* Do a health check on your Oracle database
* E-business standards Webcast on September 26
* The importance of database design

From the Editor:

by Tim DiChiara, Site Editor

As our faithful members know, the highest-rated Oracle, DB2, or
SQL Server tip submitted to SearchDatabase.com each month is
awarded a cool prize. Drum roll, please! Congratulations this month
goes out to somebody going by the mysterious pseudonym "Database
Person," who is the winner of August's contest. He or she will
receive a SONICblue Rio 600 MP3 Player and will be inducted into
our "Hall of Fame" for the Oracle tip,
Last
DDL time by tablespace. Congrats also to our runner-up
Rich Graff for his DB2 tip Extract data from DB2 on MVS
from within DB2 UDB on
AIX.

For the insatiably curious, here is a selection of some
previous winners:

July 2002: Metadata API in Oracle
9i
June 2002: Replacing non-alphanumeric characters in
strings using
T-SQL
May 2002: Copy the structure of a
table
April 2002: How to find carriage returns in
data
Hundreds more free tech tips submitted by our
members

Thanks again to all those who have submitted their
hard-won practical knowledge. If you haven't participated
yet, why not give it a try? Our mailbox is always packed
with great Oracle tips, but you DB2 and SQL Server pros out
there are a bit bashful. So come on -- share your
knowledge and help out your fellow database
geeks!
Thanks and have a great week, Tim

Featured Topic:

DBMS reviews & comparisons
by Tim DiChiara, Site Editor
One of the most common requests we at SearchDatabase.com
receive is for independent product reviews. We aim to
please, so here is a collection of 100+ Oracle, SQL Server,
Sybase, MySQL, and DB2 reviews, comparisons, and analyses.

Read more about this topic

Expert Technical Advice:

Featured Expert Eli Leiba, Senior Application DBA, Israel
Electric Co.

Category: Oracle
Eli holds a B.S. in Computer Science and has 11
years of experience working with both Oracle and SQL Server
systems. He also teaches SQL Server DBA and development
courses at Microsoft CTEC and also serves as a senior
database consultant for several Israeli start-up companies.
Ask Eli your toughest Oracle questions!

View Eli's answers

This Week: In the forums

SQL many-to-many relationship
Member "Ed" is having query trouble. Go to our
"DBA Water Cooler" forum, check out his schema, and offer
any advice if you can.

ODBC query in SQL Server 2000
Member "Ryland" needs to connect SQL Server to
DB2 via ODBC, but can't seem to direct the MSSQL system to
execute a query. Go to our "DBA Water Cooler" forum if you
can help "Ryland" figure out the problem.

Tip of the Week:
Generate flat files from a data warehouse
This Oracle procedure takes in the schema name and directory path name, grabs all the tables owned by that schema, and
generates a tab-delimited flat file.

>>
Read full tip

Site Highlights

Do a health check on your Oracle database
Pre-register for this Webcast with Guy Harrison of Quest Software on September 19
Find out how fit your database is and discover if there's room for improvement. Learn key metrics and data analyzing methods.

E-business standards Webcast on September 26
Pre-register for "Making e-business standards work with Web services"
Author and cofounder of the XML/edi Group covers Web services integration with information services, legacy systems and standards.

The importance of database design
Get some insight from Michael Hernandez, author of "Database Design for Mere Mortals"
A solid database design is the key to future success -- don't overlook its importance. Join best-selling author Michael Hernandez on September 30 for this Webcast about

Webcasts: Database design plus Oracle and XML

2002-09-27 Thread SearchDatabase.com


Check out these two Webcasts on SearchDatabase.com next week. On
Monday, Michael J. Hernandez discusses the database development
process, emphasizing its design aspects. Then join us again on
Wednesday to learn how to extract data and manipulate it into a
variety of output formats with XML.

Monday's Webcast:
-
TOPIC:   The importance of database design
WHEN:Monday, September 30 at 1:00 p.m. EDT (17:00 GMT)
SPEAKER: Michael J. Hernandez, author of Database Design for Mere
Mortals
SPONSOR: SoftTree Technologies

ABOUT THIS WEBCAST: Based on the author's years of experience
teaching this material, this Webcast will be a straightforward,
platform-independent tutorial on the basic principles of relational
database design. It will introduce the core concepts of design theory
and method without the technical jargon and provide developers and
DBAs with a common-sense design methodology for developing databases
that work. 
PRE-REGISTER FOR THIS WEBCAST:
http://searchDatabase.com/r/0,,6005,00.htm
-

*
 SPONSORED BY: SOFTTREE TECHNOLOGIES 
*
SoftTree Technologies develops advanced software, solutions and
technologies for business computing. SoftTree's suite of powerful
database tools addresses a broad range of needs of database
professionals including database management, monitoring, auditing,
tuning, benchmarking, and coding. SoftTree Technologies also provides
enterprise strength job scheduling and automation tools. Visit:
http://www.softtreetech.com
*

Wednesday's Webcast:
-
TOPIC:   Oracle and XML
WHEN:Wednesday, October 2 at 1:00 p.m. EDT (17:00 GMT)
SPEAKER: Bradley D. Brown, Chairman of the Board, Chief Architect and
Co-founder of TUSC
SPONSOR: eXcelon Corp

ABOUT THIS WEBCAST: Oracle9iAS provides a powerful utility to help
you generate XML straight from data in your Oracle database -- the
XSQL processor. XML style sheets (a.k.a. XSLT with a file extension
of XSL) allow you to manipulate XML into various usable forms. In
this Webcast, Bradley D. Brown will share tips and advice on how this
functionality can help you harness the power of XML.
PRE-REGISTER FOR THIS WEBCAST:
http://searchDatabase.com/r/0,,6155,00.htm 
-

*
--- Sponsored by: eXcelon ---
*
Are your Web Services handling large volumes of XML? Do you get your
XML from many Web Services? Do you handle a variety of schemas,
and/or DTDs? Do you have long running business processes? If so, keep
your XML 100% extensible... and 100% queryable! Manage XML 100%
without limits using eXcelon's award winning native XML database
eXtensible Information Server(tm). Download a FREE copy today!
http://www.xmlquickstart.com/default.asp?pcode=tt_oct2_eb 
*


-- Invite a colleague --

If you think this event topic would be interesting to a colleague,
invite them to this Live Expert QA Webcast. All you need to do is
forward this e-mail.



Unsubscribe from 'Updates on upcoming online events'
 - Simply Reply to this Email with REMOVE 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.
 - Uncheck the box next to the newsletter you wish 
   to unsubscribe from.
 - When finished, click Save Changes to My Profile.

Webcast today: The importance of database design

2002-09-30 Thread SearchDatabase.com


Best-selling author Michael J. Hernandez will discuss the database
development process, particularly the aspects of database design.
He'll teach you a structured set of procedures that will ensure
success for your next database project.

-
TOPIC:   The importance of database design
WHEN:TODAY - Monday, September 30 at 1:00 p.m. EDT (17:00 GMT)
SPEAKER: Michael J. Hernandez, author of Database Design for Mere
Mortals
SPONSOR: SoftTree Technologies
JOIN THIS WEBCAST: http://searchDatabase.com/r/0,,6160,00.htm 
-

*
 SPONSORED BY: SOFTTREE TECHNOLOGIES 
*
SoftTree Technologies develops advanced software, solutions and
technologies for business computing. SoftTree's suite of powerful
database tools addresses a broad range of needs of database
professionals including database management, monitoring, auditing,
tuning, benchmarking, and coding. SoftTree Technologies also provides
enterprise strength job scheduling and automation tools. Visit:
http://www.softtreetech.com
*

---
-- About today's Webcast --
---
Sound design can save you hours of development time before you write
a single line of code. 

Based on the author's years of experience teaching this material,
this Webcast will be a straightforward, platform-independent tutorial
on the basic principles of relational database design. It will
introduce the core concepts of design theory and method without the
technical jargon and will provide developers and DBAs with a
common-sense design methodology for developing databases that work. 

Mike Hernandez will also touch upon topics such as avoiding bad
design and bending the rules set forth in design process.

Attend today's Webcast by clicking here:
http://searchDatabase.com/r/0,,6160,00.htm


-- Invite a colleague --

If you think this event topic would be interesting to a colleague,
invite them to today's live expert QA Webcast. All you need to do is
forward this e-mail.



Unsubscribe from 'Updates on upcoming online events'
 - Simply Reply to this Email with REMOVE 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.
 - Uncheck the box next to the newsletter you wish 
   to unsubscribe from.
 - When finished, click Save Changes to My Profile.

Webcast today: Oracle and XML

2002-10-02 Thread SearchDatabase.com


XML can change the way you manage your data. Discover how to simplify
your work in today's presentation -- Bradley D. Brown will show you
how to extract data and manipulate it into a variety of output
formats using Oracle and XML.

-
TOPIC:   Oracle and XML
WHEN:TODAY - Wednesday, October 2 at 1:00 p.m. EDT (17:00 GMT)
SPEAKER: Bradley D. Brown, Chairman of the Board, Chief Architect 
 and Co-founder of TUSC
SPONSOR: eXcelon Corp
ENTER THIS WEBCAST HERE: http://searchDatabase.com/r/0,,6242,00.htm 
-

*
--- Sponsored by: eXcelon ---
*
Are your Web Services handling large volumes of XML? Do you get your
XML from many Web Services? Do you handle a variety of schemas,
and/or DTDs? Do you have long running business processes? If so, keep
your XML 100% extensible... and 100% queryable! Manage XML 100%
without limits using eXcelon's award winning native XML database
eXtensible Information Server(tm). Download a FREE copy today!
http://www.xmlquickstart.com/default.asp?pcode=tt_oct2_eb 
*

---
-- About today's webcast --
---
Oracle9iAS provides a powerful utility to help you generate XML
straight from data in your Oracle database -- the XSQL processor. XML
style sheets (a.k.a. XSLT with a file extension of XSL) allow you to
manipulate XML into various usable forms. 

In this Webcast, Bradley D. Brown will share tips and advice on how
this functionality can help you harness the power of XML. Click here
to attend: http://searchDatabase.com/r/0,,6242,00.htm

His presentation will include:

* The definition of XML
* Reasons it's gaining popularity
* Oracle and Java XML components
* The XSQL application

Join us today at: http://searchDatabase.com/r/0,,6242,00.htm

--
-- Additional resources --
--
** Check out our collection of Oracle resources in our Best Web 
   Links: http://searchDatabase.com/r/0,,6267,00.htm 

** Find out more from these answered questions in our Oracle Ask 
   the Experts section:
   - Brian Peasland, Database Administrator, Raytheon, Inc.
 http://searchDatabase.com/r/0,,6268,00.htm 

   - Eli Leiba, Senior Application DBA, Israel Electric Co.
 http://searchDatabase.com/r/0,,6270,00.htm 

   - Karen Morton, Owner, Morton Consulting, Inc.
 http://searchDatabase.com/r/0,,6271,00.htm 


-- Invite a colleague --

If you think this event topic would be interesting to a colleague,
invite them to today's webcast. All you need to do is forward this
e-mail.



Unsubscribe from 'Updates on upcoming online events'
 - Simply Reply to this Email with REMOVE 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.
 - Uncheck the box next to the newsletter you wish 
   to unsubscribe from.
 - When finished, click Save Changes to My Profile.

Webcast today: Tom Kyte on Oracle 9i

2002-10-23 Thread SearchDatabase.com

Take advantage of this exclusive opportunity to interact with one of
the premier Oracle gurus on the planet. During today's webcast, Tom
Kyte will answer your burning questions about Oracle 9i.

-
TOPIC:   Tom Kyte answers your Oracle9i questions 
WHEN:TODAY - Wednesday, October 23 at 1:00 p.m. EDT (17:00 GMT)
SPEAKER: Tom Kyte, author of Expert one-on-one: Oracle
SPONSOR: Maverick Solutions, Inc.
CLICK HERE TO ATTEND: http://searchDatabase.com/r/0,,6763,00.htm 
-

*
-- Sponsored by: Maverick Solutions, Inc. ---
*
Maverick Solutions, Inc. offers comprehensive training in Oracle,
Java, and related technologies. We offer this solution to corporate
clients across the United States. Our primary focus has been and will
continue to be offering the best value in onsite training. If your
group is working with Oracle or Java, come find out why so many
companies and organizations are choosing Maverick as their onsite
training Solution.   
http://www.mavericksolutions.net  
*

---
-- About today's Webcast --
---
Oracle DBAs and developers flock to the Ask Tom Web site for
answers to their most daunting technical challenges. In this webcast,
Tom Kyte zeroes in on Oracle 9i and answers user questions on
everything from RAID levels to backup techniques and purging data
correctly. 

Whether you've already upgraded to Oracle 9i or are deciding if and
when to upgrade, attend this webcast to find out:
-- About Real Application Clusters (RAC) in 9i: compatible platforms,
   storage partition options and scalability potential.
-- How to resolve character set differences.
-- Is there a substantial difference in the speed of RAID levels?
-- How and when to prioritize users with Oracle Userid.
-- The difference between caching and pinning.
-- Plus much more. 

Use this webcast to get your questions answered -- and learn from the
questions of your peers. Attend this exclusive webcast today:
http://searchDatabase.com/r/0,,6763,00.htm


-- About Tom Kyte --

Tom Kyte's recently released book, Oracle One-on-One, has been called
perhaps the best book about Oracle products ever put out...and a
model of all aspects of technical publishing. He is the Vice
President of Core Technologies at Oracle Corporation with more than
15 years of experience designing and developing large-scale database
and Internet applications. Tom specializes in core database
technologies, application design and architecture, and performance
tuning. He is also a columnist with Oracle magazine and runs the Ask
Tom Oracle forum Web site.


-- Invite a colleague --

If you think this topic would be interesting to a colleague, invite
them to today's webcast. All you need to do is forward this e-mail.



Unsubscribe from 'Updates on upcoming online events'
 - Simply Reply to this Email with REMOVE 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.
 - Uncheck the box next to the newsletter you wish 
   to unsubscribe from.
 - When finished, click Save Changes to My Profile.

Webcast today: Calculating your ROI in a SAP BI initiative

2002-10-24 Thread SearchDatabase.com

Calculating ROI in your data warehouse has always been elusive and
complex, and even then promised little or no value. Join expert Hari
Guleria today to learn a measurable ROI methodology for your BI
initiatives.

-
TOPIC:   Calculating your ROI in a SAP-BI initiative
WHEN:TODAY - Thursday, October 24 at 2:00 p.m. EDT (18:00 GMT)
SPEAKER: Hari Guleria, BW Practice Manager, icm AMERICA
SPONSOR: Unisys
CLICK HERE TO ATTEND: http://searchSAP.com/r/0,,6811,00.htm 
-

*
-DOWNLOAD 3 FREE GIGA GROUP ARTICLES THAT HELP YOU IMPLEMENT PORTALS-
*
Thinking about implementing SAP Portals? Simplify your SAP
environment with the Unisys ES7000 enterprise server. The ES7000
reduces server management complexity and optimizes the performance of
large Windows-based SAP operations. These free Giga analyst articles
could help you avoid common portals mistakes, accelerate deployment
times, and more! Click here: 
http://jumpbi.techtarget.com/es7000.asp?s=SAP_Promo_Email_Giga3WP  
*

---
-- About today's Webcast --
---
Hari Guleria will illustrate how to simplify your BI ROI calculations
by using business processes and end-user deliverables as basic
drivers, showing actual examples to graphically map the ROI for BI
analysis.

This webcast includes a case study on a major manufacturer that
achieved a simpler ROI methodology that accomplished the following: 
1. Used business processes and end user satisfaction as criteria
2. Viewed BI from tactical and strategic integration factors
3. Mapped, measured and delivered quantifiable business metrics 
4. Demonstrated actual business process improvements 

If you're a manager looking to add more MEASURABLE value to your BI
initiatives, this webcast is for you. Click here to join:
http://searchSAP.com/r/0,,6811,00.htm


-- About Hari Guleria --

Hari Guleria has more than 10 years of sales, marketing and strategic
planning with multinationals, with a strong SD and MM configuration
background. Hari is currently assisting with a global BW HR
implementation from multiple legacy and non-SAP source systems and is
the co-author of a new BW book titled The 7 steps to BW Excellence.


-- Invite a colleague --

If you think this topic would be interesting to a colleague, invite
them to today's webcast. All you need to do is forward this e-mail.



Unsubscribe from 'Updates on upcoming online events'
 - Simply Reply to this Email with REMOVE 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.
 - Uncheck the box next to the newsletter you wish 
   to unsubscribe from.
 - When finished, click Save Changes to My Profile.

DBA Tips: Finding nulls in any table, and more...

2002-10-30 Thread SearchDatabase.com

SEARCHDATABASE.COM | Database Administrator Tips
October 30, 2002

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
FROM OUR SPONSOR:

Performance Tuning White Paper - Quest Software 
http://searchDatabase.com/r/0,,7047,00.htm?whitepaper 

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

IN THIS ISSUE | Table of Contents

1. DATABASE ADMINISTRATOR TIPS 
  - Optimizing database performance, part 2
  - DB2: Converting a DB2 date to SQL Server
  - Oracle: Finding nulls in any table
  - More recent tips from members

2. IMPORTANT ANNOUNCEMENTS AND LINKS
  - Free webcast: Enterprise integration
  - Ask the Experts: Your tough database questions answered
  - Featured Topic: The challenge of integration

___
** Sponsored by Quest Software 

Do you check metrics such as IO rates, CPU usage, memory usage and
network utilization when tuning your database for performance?
Metrics collected from SQL*Net, background processes, the SGA and
logs can unlock the secrets to better database performance, yet many
of us focus on SQL tuning alone. Quest Software provides a free white
paper that will help you learn a new tuning methodology. Download
your white paper, A Successful Performance Tuning Methodology,
today! 
http://searchDatabase.com/r/0,,7047,00.htm?whitepaper 

*** 

___
THIS WEEK'S TIPS:

OPTIMIZING DATABASE PERFORMANCE, PART 2: DENORMALIZATION AND
CLUSTERING

Craig Mullins continues his series about techniques for optimizing
the performance of any database. In part two, he discusses
denormalization, clustering, page splitting, and interleaving data.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci857336,00.html


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
CONVERTING A DB2 DATE TO SQL SERVER | Douglas Seward 

SQL Server 7 crashes when trying to process a view of DB2 tables
where some of the date fields are initialized with the value
'0001-01-01'. Here's a work around...

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci857672,00.html

 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
FINDING NULLS IN ANY TABLE | Saritha Rani

These SQL scripts quickly show the number of rows with NULLs in each
column. 

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci857662,00.html


___
MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS:

OPTIMIZING DATABASE PERFORMANCE, PART 1: PARTITIONING AND INDEXING
http://www.searchDatabase.com/tip/1,289483,sid13_gci850679,00.html
In this first part of a new series, author Craig Mullins introduces
the techniques for optimizing the performance of any database.

GETTING INFO ABOUT LOCKED OBJECTS IN ORACLE | Ranjit Kumar
http://www.searchDatabase.com/tip/1,289483,sid13_gci854780,00.html
This short script takes the object name and gives the session ID and
serial number for the session that has a lock.
 
REPLICATING DATA FROM SQL SERVER 2000 TO ORACLE | Sravan Kasarla
http://www.searchDatabase.com/tip/1,289483,sid13_gci854771,00.html
This tip is useful for understanding the replication options between
SQL Server 2000 and Oracle 8i databases. It will help DBAs to enable
sharing of data in a heterogeneous environment, which is a common
challenge in most IT departments.

INSERTING CLOB DATA INTO DB2 | Sujit Mishra
http://www.searchDatabase.com/tip/1,289483,sid13_gci854776,00.html
These days, the CLOB data type is extensively used in many
applications. However, our problem was inserting DB2 CLOB data from a
Java application into a OS/390 database because the codepage settings
are different for both client and server. This tip helps solve the
problem of inserting the data into DB2 on OS/390.

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 MESSAGES AND LINKS:

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
ASK THE EXPERT | This week's tough database questions answered

DB2: Is a cluster index necessary?
http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid498949_tax285651,00.html

Oracle: Problem installing Oracle on Red Hat Linux
http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid498955_tax289342,00.html

SQL: Paging through a result set without TOP or LIMIT
http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid498398_tax285649,00.html

DB2: Illegal keyword in FETCH FIRST n ROW ONLY
http

Webcast: Web services -- A business revolution

2002-11-06 Thread SearchDatabase.com

The Web services revolution overthrows the long-time theme of
technology as the dictator. Join us on November 12 to learn why Web
services are creating this change and how businesses will prosper
from this maturity.

-
TOPIC:   Web services -- An evolution in technology; a revolution for
 business
WHEN:Tuesday, November 12 at 2:00 p.m. EST (19:00 GMT)
SPEAKER: Suhayl Masud, President, DifferentThinking.com
SPONSOR: IONA
PRE-REGISTER TODAY: http://searchWebServices.com/r/0,,7268,00.htm 
-

*
-- FREE White Paper - Extend CORBA Applications with Web Services ---
*
Learn how to maximize your CORBA investment by quickly and easily:
- INTEGRATING CORBA applications with J2EE, Mainframe and Microsoft 
  .NET technologies.  
- EXPOSING CORBA functionality to other parts of the organization
- EXTENDING CORBA applications to customers partners over the
Internet Download the FREE IONA White Paper: Extending, Enhancing and
Optimizing CORBA Systems with Web Services. Click here!
http://searchWebServices.com/r/0,,7267,00.htm 
*


-- About this webcast --

Web services have all the ingredients to act as a catalyst for
e-business. Web services re-use existing infrastructure, like
transfer protocols over the Web, and description languages built upon
XML. They remove costly negotiations of what technology to use when
establishing online business relationships, and they utilize concepts
that are understood by both business and technical people. 

Whether Web services bring about the massive change themselves, or
simply act as a catalyst to inspire and evolve future technologies,
the revolution has begun and it promises to change the e-business
landscape forever.

Attend this webcast and you'll have the opportunity to ask your
questions to Suhayl Masud -- the president of Different Thinking, a
consulting company. Click here to pre-register:
http://searchWebServices.com/r/0,,7268,00.htm

---
-- About the speaker --
---
Suhayl Masud is the president of Different Thinking, a consulting
company that provides Architecture, Training and Visualization
services. He is the former lead technical architect for RosettaNet,
an e-business standard where he led the efforts in developing the new
generation architecture for eBusiness. At RosettaNet, he was a leader
in the development of the next generation Partner Interface Process
(PIP) architecture and in re-engineering key components of the PIP
creation process.


-- Additional information --

Read this article from Suhayl Masud entitled Web services: An
elephant in the dark. Find out why Web services are the catalyst for
technology to mature and businesses to prosper in this article:
http://searchWebServices.com/r/0,,7279,00.htm 


-- Invite a colleague --

If you think this event topic would be interesting to a colleague,
invite them to this webcast. All you need to do is forward this
e-mail.



Unsubscribe from 'Updates on upcoming online events'
 - Simply Reply to this Email with REMOVE 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.
 - Uncheck the box next to the newsletter you wish 
   to unsubscribe from.
 - When finished, click Save Changes to My Profile.

THIS WEEK: OracleWorld 2002

2002-11-11 Thread SearchDatabase.com

Title: TechTarget

November 11, 2002

Receive this email as text About this email

In this Issue

From the editor:
OracleWorld 2002 coverage

Featured Topic:

OracleWorld 2002
by Tim DiChiara, Site Editor
Travel budget cut? San Francisco too far away? Just plain forgot? If you aren't going to OracleWorld this week, we have the latest news, exclusive analysis, expert advice, and product announcements from the show inside...

Read more about this topic

Expert Technical Advice:

Featured Expert Brian Peasland
Database Administrator, Raytheon, Inc.

Categories:Oracle
Brian is an OCP and has been in the IT field for 14 years working as a Computer Operator, Operations Analyst, Systems Administrator, Application Developer, and finally a Database Administrator. Ask him your tough Oracle questions!

View all Brian's answers

This Week: In the forums

DB2 doesn't see new RAID drive
Member "RSC" just added an additional RAID array to his NT 4 test server but when trying to perform a backup to this drive, he gets a 'drive not valid' error. Anybody out there know how to solve this problem? Go to our "DBA Water Cooler" forum if you can offer any advice.

Installation of Informatica
Member "mukies" has Oracle 8.1.6. on his system and now wants to install Informatica. If you have any tips, go to our "Data warehousing" forum.

Tip of the Week:
Craig Mullins concludes his series about the techniques for optimizing the performance of any database. In part three, he discusses techniques such as fill factor management, compression, file placement, page/block size, and more.

Optimizing database performance, part 3: Compression and page size

Site Highlights

Tomorrow: Web services and business
Web Services: An Evolution in Technology; a Revolution for Business
Learn why the Web services revolution is changing the theme of technology as the dictator and how businesses will prosper.

SQL Server security best practices
Join two members of the Microsoft SQL Server team in this Wednesday's webcast
In this webcast, James Hamilton and Girish Chander discuss creating security plans that are manageable, flexible and verifiable.

IT career webcast Thursday at 3:00 p.m. EST
Join us for "Key skills for an IT career in data warehousing"
If you're already in the data warehousing industry, then you know the importance of refining your skills. And if you're hoping to break into the industry, now is the time to learn more. Join William McKnight in this informative webcast discussing essential DW skills and ways to excel at a data-warehousing caree

Performance Event

Join Oracle performance experts Tom Kyte, Steven Feuerstein, J

Webcast today: Web services -- A business revolution

2002-11-12 Thread SearchDatabase.com

If you're a business-minded person, then don't miss tomorrow's
webcast with Suhayl Masud, president of Different Thinking. You'll
hear why Web services are expected to overthrow the long-time theme
of technology as the dictator.

-
TOPIC:   Web services -- An evolution in technology; a revolution for
 business
WHEN:TODAY - Tuesday, November 12 at 2:00 p.m. EST (19:00 GMT)
SPEAKER: Suhayl Masud, President, DifferentThinking.com
SPONSOR: IONA
CLICK HERE TO ATTEND: http://searchWebServices.com/r/0,,7411,00.htm 
-

*
-- FREE White Paper - Extend CORBA Applications with Web Services ---
*
Learn how to maximize your CORBA investment by quickly and easily:
- INTEGRATING CORBA applications with J2EE, Mainframe and Microsoft 
  .NET technologies.  
- EXPOSING CORBA functionality to other parts of the organization
- EXTENDING CORBA applications to customers partners over the
Internet Download the FREE IONA White Paper: Extending, Enhancing and
Optimizing CORBA Systems with Web Services. Click here!
http://searchWebServices.com/r/0,,7267,00.htm 
*

---
-- About today's webcast --
---
Hear the unique perspective of a technologist helping business folks
find solutions to problems without being overwhelmed by the
technology behind it. Attend today's webcast with Suhayl Masud to
discover why he believes Web services will overthrow the long-time
dictatorship of technology.

Web services remove costly negotiations and utilize concepts that
both business and technical people understand. Whether Web services
bring about the massive change themselves, or simply act as a
catalyst to inspire and evolve future technologies, the revolution
has begun and it promises to change the e-business landscape forever.

Learn about the role of Web services in creating this change and how
businesses will prosper by attending today's webcast with Suhayl
Masud. View this webcast and pose your own questions to the speaker:
http://searchWebServices.com/r/0,,7411,00.htm

---
-- About the speaker --
---
Suhayl Masud is the president of Different Thinking, a consulting
company that provides Architecture, Training and Visualization
services. He is the former lead technical architect for RosettaNet,
an e-business standard where he led the efforts in developing the new
generation architecture for eBusiness. At RosettaNet, he was a leader
in the development of the next generation Partner Interface Process
(PIP) architecture and in re-engineering key components of the PIP
creation process.


-- Additional information --

Read this article from Suhayl Masud entitled Web services: An
elephant in the dark. Find out why Web services are the catalyst for
technology to mature and businesses to prosper in this article:
http://searchWebServices.com/r/0,,7279,00.htm 


-- Invite a colleague --

If you think this event topic would be interesting to a colleague,
invite them to today's webcast. All you need to do is forward this
e-mail.



Unsubscribe from 'Updates on upcoming online events'
 - Simply Reply to this Email with REMOVE 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.
 - Uncheck the box next to the newsletter you wish 
   to unsubscribe from.
 - When finished, click Save Changes to My Profile.

DBA Tips: Using the English Query tool, and more...

2002-11-14 Thread SearchDatabase.com

SEARCHDATABASE.COM | Database Administrator Tips
November 13, 2002

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
FROM OUR SPONSOR:

Lumigent Entegra for Data Access Accountability 
http://searchDatabase.com/r/0,,7452,00.htm?lumigent 

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

IN THIS ISSUE | Table of Contents

1. DATABASE ADMINISTRATOR TIPS 
  - DB2: Finding the connection port in DB2
  - SQL Server: Use the Microsoft English Query tool
  - Oracle: Space check before data LOAD
  - More recent tips from members

2. IMPORTANT ANNOUNCEMENTS AND LINKS
  - Ask the Experts: Your tough database questions answered
  - Featured Topic: OracleWorld 2002

___
** Sponsored by Lumigent Technologies  

Announcing Lumigent(R) Entegra(TM) - meet your data privacy and
security requirements with a complete audit of database activity.
Know who's doing what to which data when.  Entegra provides an
audit trail of changes to data and to database structure and
permissions, including data views (i.e. who viewed data). Entegra
monitors and alerts on database activity for a complete record of
data access, and data and database changes. FREE whitepaper - Data
Access Accountability: 
http://searchDatabase.com/r/0,,7452,00.htm?lumigent

*** 

___
THIS WEEK'S TIPS:

FINDING THE CONNECTION PORT IN DB2 | Ranjit Kumar

This short tip tells you how to find the client connection port for
multiple DB2 instances.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci857650,00.html


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
SPACE CHECK BEFORE DATA LOAD | Sudhakar Parsi  

Here's a script to check table space before loading millions of
records, which is especially useful in data warehousing situations.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci821247,00.html

 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
USE THE MICROSOFT ENGLISH QUERY TOOL | Barrie Sosinsky 

If you are a developer, no doubt you have learned to think in SQL,
and perhaps to employ a tool to help you compose the more complex SQL
statements that arise. Your clients, however, don't think in SQL. For
this Microsoft has introduced their Microsoft English Query tool.
Here's a quick introduction.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci859891,00.html

___
MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS:

OPTIMIZING DATABASE PERFORMANCE, PART 3: COMPRESSION  PAGE SIZE
http://www.searchDatabase.com/tip/1,289483,sid13_gci861319,00.html
Craig Mullins concludes his series about the techniques for
optimizing the performance of any database. In part 3, he discusses
techniques such as fill factor management, compression, file
placement, page/block size, and more.

EXTRACTING COMPLETE DDL FROM DB2 6 DATABASES | Sudhakar Parsi  
http://www.searchDatabase.com/tip/1,289483,sid13_gci857622,00.html
You may often need to get DDL statements for various DB2 database
objects in order to recreate them on another server. For example,
while setting up test systems, DBAs usually try to create a copy of
the production database on test servers. Here's how to do it on DB2
v6.

UPGRADING FROM SQL SERVER 7.0 TO 2000 | Rhys Kerrigan 
http://www.searchDatabase.com/tip/1,289483,sid13_gci861379,00.html
Here's how to address the following error while upgrading to SQL
Server 2000: The Ordinal 105 could not be located in the dll
Opens60.dll 

HOT BACKUP AND RECOVERY WITH PERL | Frank Pantaleo
http://www.searchDatabase.com/tip/1,289483,sid13_gci857677,00.html
This extensive script is useful for DBAs who want to use Perl for
doing hot backups.

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 MESSAGES AND LINKS:

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
ASK THE EXPERT | This week's tough database questions answered

SQL: Why WHERE cannot be used after GROUP BY
http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid501484_tax285649,00.html

Database design: Design for sales database
http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid501498_tax285649,00.html

SQL Server: Passing an array to a stored procedure
http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid501463_tax285648,00.html

Data warehousing: Merging customer lists
http://www.searchDatabase.com/ateQuestionNResponse/0,289625

Webcast: Contemplating J2EE Web services?

2002-11-15 Thread SearchDatabase.com

If you haven't yet decided if J2EE Web services are the best solution
for your operations, then pre-register for this webcast today. Gain
valuable insight into J2EE Web services that will help you make the
right decision.

-
TOPIC:   Developing Web services applications using J2EE 1.4
WHEN:Thursday, November 21 at 2:00 p.m. EST (19:00 GMT)
SPEAKER: Jim Keogh, Author of J2EE: The Complete Reference
SPONSOR: Oracle
PRE-REGISTER TODAY: http://searchWebServices.com/r/0,,7530,00.htm 
-

*
--- Sponsored by: Oracle 
*
Oracle9iAS: Faster Software Means Less Hardware. Oracle9i Application
Server keeps your business applications up and running with increased
performance and reliability on low-cost Linux clusters. Plus, it's #1
for price/performance on the ECperf Java benchmark-click for a full
ECperf report. 
http://ad.doubleclick.net/clk;4841836;7625403;m?http://www.oracle.com/go/?Src=1380990Act=65
 
*


-- About this webcast --

Is your IT department among those considering a move to a Web
services infrastructure using J2EE? Why wait until the competition
beats you to it -- pre-register for this webcast to decide whether
you should be using J2EE Web services:
http://searchWebServices.com/r/0,,7530,00.htm

If you're an IT manager, architecture pro or developer, then you'll
want to hear Jim Keogh cover:
* The explanation of J2EE Web services
* The benefits of J2EE Web services 
* Implementation of a J2EE Web services solution 
* Drawbacks of J2EE Web services 

Join us after Jim's presentation and get your questions answered.
We'll select attendees who submit relevant questions during the
webcast to win one of five free copies of J2EE: The Complete
Reference. Click here to pre-register for this webcast:
http://searchWebServices.com/r/0,,7530,00.htm

---
-- About the speaker --
---
Jim Keogh introduced PC programming nationally in his Popular
Electronics Magazine column in 1982. He was a team member involved
with one of the first Windows applications and has since spent more
than a decade developing computer systems for Wall Street firms such
as Salomon, Inc. and Bear Stearns, Inc. Jim is the author of J2EE:
The Complete Reference, J2ME, The Complete Reference and more than
50 other titles including five in the popular ...For Dummies series. 


-- Additional information --

Learn more about J2EE in our Best Web Links:
http://searchWebServices.com/r/0,,7538,00.htm 

Download an excerpt from Chapter 2 of J2EE: The Complete Reference:
http://searchWebServices.com/r/0,,7539,00.htm 


-- Invite a colleague --

If you think this event topic would be interesting to a colleague,
invite them to this webcast. All you need to do is forward this
e-mail.



Unsubscribe from 'Updates on upcoming online events'
 - Simply Reply to this Email with REMOVE 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.
 - Uncheck the box next to the newsletter you wish 
   to unsubscribe from.
 - When finished, click Save Changes to My Profile.

THIS WEEK: Database security

2002-11-18 Thread SearchDatabase.com

Title: TechTarget





 
   
   
  
 



 

  



 
 
  
   November 18, 2002  
  
  Receive this email as text About this email
 
 


 
 
  
   

 
   

 
  
  
 
 
   
   

 
 

   
  
  In this Issue
 
 



 
 
  From the editor:
   Overload 
 
   
 
  Featured Topic:
   Database security 
 
  
 
  Expert Technical Advice:
   New expert advice, forum posts, and tips 
 
  
 
  Site Highlights:
   
* Webcast Archive: SQL Server security best practices 
* Become a SearchDatabase.com partner
* Catch up on our OracleWorld 2002 coverage 
 
 

 


 
   


 
 


   
   

 
 

   
  
  From the Editor:
 



 
  
   
   
 by Tim DiChiara, Site Editor 
  
  Last week, I predicted information and sensory overload for my week at OracleWorld in San Francisco. I was right, fortunately or unfortunately.

The hundreds of technical sessions were useful and educational, of course, and every guru worth his or her salt was there and available to answer questions. The keynotes ranged from relatively sober (Michael Dell and Larry Ellison, for example) to over-the-top ("Infrastructure Jeopardy" and Senior VP Sohaib Abbasi's "BI-onic man") Meanwhile in the vendor exhibit hall, the gimmicks seem to be getting sillier every year: Besides the usual laser lights, throbbing techno music, and free trinkets, there were jugglers, race cars, planes, talking robots, marketing staff dressed like convicts from Alcatraz, and even one presentation involving somebody wearing a strait jacket while riding a unicycle, the point of which eluded me. It all smacked of desperation -- not too surprising given the horrible IT economy.

Thankfully, I missed the sight of 23,000 database geeks rocking out to Cheap Trick's "I want you to want me" on Wednesday. My nervous system does have its limits. If anybody was there, I'd love to hear your opinion (email me at [EMAIL PROTECTED]). 

In case you missed it, here is our original coverage of the show:

Grid computing leaves Oracle exec speechless -- almost
Oracle gets theatrical in play for BI market share
DBAs warm to Oracle's vision for application clusters
BMC competes with Oracle to reduce DBA 'think time'
Oracle-related product announcements
More OracleWorld news and analysis

 
Thanks, and have a great week, Tim

 
  
 


 


 
   


 
 


   
   

 
 

   
  
  Featured Topic:
 



 

   Database security
   by Tim DiChiara, Site Editor 
   The need for data security may be obvious, but the path to get there certainly isn't. The collection of technical tips, expert advice, webcasts and analysis inside will help you lock down your Oracle, DB2, or SQL Server databases.
   
   
   
Read more about this topic

 


 


 
   


 
 


   
   

 
 

   
  
  Expert Technical Advice:
 
 



 
   


  Featured Expert Ian Abramson,
CTO, IAS Inc.

Categories: Data warehousing
Ian is the founder of IAS, Inc, which has built a fourteen year reputation for delivering high quality Data Warehouse and Oracle systems to clients around the world. Ian is also the co-author of several Oracle books, is currently the Director of Education Programming for the International Oracle User Group, and is well-known for his seminars and technical training classes. Ask Ian your tough data warehousing questions! 
 
   
   View all Ian's answers  
  
 







 
   This Week: In the forums
  
 
 
  
  
   
   CLOB from Perl

Member "Mery G" is wondering how to execute a procedure from a Perl script. Anybody out there with experience? Go to our "Database-Web connectivity" forum if you can offer any advice. 
  
   
  
  
   
   Oracle to SQL Server data transfer

Member "ynoel" is trying to transfer data from Oracle 8 on Solaris to SQL Server. One person recommended DTS or Perl and BCP. Go to our "Data warehousing" forum if you have any other ideas for "ynoel." 
  
   




 Tip of the Week:
 This script is useful for understanding the replication options between SQL Server 2000 and Oracle 8i databases. It will help DBAs enable the sharing of data in a heterogeneous environment, which is a common challenge in most IT departments these days.  
 
  Replicating data from SQL Server 2000 to Oracle
 


 


 
   


 
 


   
   

 
 

   
  
  Site Highlights
 
 



 
  
   
   
Webcast archive: SQL Server security
Best practices and tips for locking down your SQL Server database 
Learn about the SQL Server security model, integration, implementation tips, security plans and enhancements to the model.
 

Become a SearchDatabase.com partner
Do you have a database user group, conference or Web site to promote?
If you value no-cost promotion opportunities, then send me an e-mail about your group, event o

Webcast today: Implementing J2EE Web services

2002-11-21 Thread SearchDatabase.com

Attend today's webcast to find out what you need to know about using
J2EE Web services for your operations. Gain valuable insight from Jim
Keogh as he discusses J2EE Web services. Five lucky attendees who
submit a question will win a copy of the speaker's book, J2EE: The
Complete Reference.

-
TOPIC:   Developing Web services applications using J2EE 1.4
WHEN:TODAY - Thursday, November 21 at 2:00 p.m. EST (19:00 GMT)
SPEAKER: Jim Keogh, Author of J2EE: The Complete Reference
SPONSOR: Oracle
ATTEND TODAY'S WEBCAST: http://searchWebServices.com/r/0,,7785,00.htm
-

*
--- Sponsored by: Oracle 
*
Oracle9iAS: Faster Software Means Less Hardware. Oracle9i Application
Server keeps your business applications up and running with increased
performance and reliability on low-cost Linux clusters. Plus, it's #1
for price/performance on the ECperf Java benchmark-click for a full
ECperf report. 
http://ad.doubleclick.net/clk;4841836;7625403;m?http://www.oracle.com/go/?Src=1380990Act=65
 
*

---
-- About today's webcast --
---
Are you an IT manager, architecture pro or developer considering a
transition to a Web services infrastructure using J2EE? You'll want
to attend today's webcast to hear Jim Keogh discuss:
* The explanation of J2EE Web services
* The benefits of J2EE Web services 
* Implementation of a J2EE Web services solution 
* Drawbacks of J2EE Web services 

Find out whether your organization can benefit from J2EE Web
services. Join us today for this informative webcast:
http://searchWebServices.com/r/0,,7785,00.htm

--
-- Win a copy of J2EE: The Complete Reference --
--
Ask Jim a J2EE question following his presentation. We'll select
attendees who submit relevant questions during the webcast to win one
of five free copies of J2EE: The Complete Reference. Click here to
attend today's webcast: http://searchWebServices.com/r/0,,7785,00.htm

---
-- About the speaker --
---
Jim Keogh introduced PC programming nationally in his Popular
Electronics Magazine column in 1982. He was a team member involved
with one of the first Windows applications and has since spent more
than a decade developing computer systems for Wall Street firms such
as Salomon, Inc. and Bear Stearns, Inc. Jim is the author of J2EE:
The Complete Reference, J2ME, The Complete Reference and more than
50 other titles including five in the popular ...For Dummies series. 


-- Additional information --

Download an excerpt from Chapter 2 of J2EE: The Complete Reference:
http://searchWebServices.com/r/0,,7539,00.htm

Learn more about J2EE in our Best Web Links:
http://searchWebServices.com/r/0,,7538,00.htm 


-- Invite a colleague --

If you think this event topic would be interesting to a colleague,
invite them to today's webcast. All you need to do is forward this
e-mail.



Unsubscribe from 'Updates on upcoming online events'
 - Simply Reply to this Email with REMOVE 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.
 - Uncheck the box next to the newsletter you wish 
   to unsubscribe from.
 - When finished, click Save Changes to My Profile.

THIS WEEK: Stored procedure development

2002-11-25 Thread SearchDatabase.com

Title: TechTarget

November 25, 2002

Receive this email as text About this email

In this Issue

From the editor:
Your two cents

Featured Topic:
Stored procedure development

Expert Technical Advice:
New expert advice, forum posts, and tips

Site Highlights:

* OracleWorld Coverage
*Webcast Archive: Developing Web services applications using J2EE 1.4
* Member survey: What are your 2003 goals?

From the Editor:

by Tim DiChiara, Site Editor

I know you appreciate the free benefits SearchDatabase.com has to
offer -- now is your chance to make our site even better. We are
currently seeking database professionals to help with our year-end
survey. The results of this survey will guide the editorial team
toward the topics, tips and news that interest you the most. Don't pass on this opportunity to
play a key role in influencing SearchDatabase.com content.

We would like to know:

What database-related projects will you be involved in next year?
Is your data management budget going to be cut next year?
Where do you plan to spend your database budget in 2003?

These important questions will help us focus on the topics you need
to know about the most. Next year is predicted to be a recovery year for database management and the IT industry, and we want to make sure you
are prepared. Click here to take this very short survey
It will only take a
couple minutes to complete. The information you provide will help
influence the site for next year and beyond.

On behalf of the SearchDatabase.com team, I would like to thank you
for your assistance with this. Thanks, and have a great week, Tim

Featured Topic:

Stored procedure development
by Tim DiChiara, Site Editor
Stored procedures increase the performance, flexibility, and security of your DBMS. Here is a selection of our best tips and expert advice about coding effective Oracle, SQL Server, and DB2 stored procedures and triggers.

Read more about this topic

Expert Technical Advice:

Featured Expert Ian Abramson,
CTO, IAS Inc.

Category: Data warehousing
Ian is the founder of IAS, Inc, which has built a fourteen year reputation for delivering high quality Data Warehouse and Oracle systems to clients around the world. Ian is also the co-author of several Oracle books, is currently the Director of Education Programming for the International Oracle User Group, and is well-known for his seminars and technical training classes. Ask Ian your tough data warehousing questions!

View all Ian's answers

This Week: In the forums

CLOB from Perl

Member "Mery G" is still wondering how to execute a procedure from a Perl script. Anybody out there with experience? Go to our "Database-Web connectivity" forum if you can offer any advice.

Lookup tables

Member "Badone" is looking for a good reference about lookup tables in order to create a faster way to search through 1000 character descriptions in a database. Go to our "DBA Water Cooler" forum if you have any other ideas for "Badone."

Tip of the Week:
The main usage of this tip is to help clarify by example the use of Oracle's virtual private database by an application server account. Most examples and documentation by Oracle show how VPDs can restrict access to data based on your user account when you login to the Oracle database. The problem with app servers is that you login to the app server with your login but the app server accesses the database as the app server account so all users would appear to login to the database as the app server account and the VPD cannot differentiate individual app users. The tip shows how to pass a session ID from the App to the database allowing the use of VPD.

Using Oracle virtual private databases with application servers

Site Highlights

OracleWorld Coverage
Read news stories such as "Oracle gets theatrical in play for BI market share"
Discover the latest news and announcements that are stimulating the interest of Oracle professionals everywhere.

Web services and J2EE 1.4 webcast
View this recent webcast to learn what you need to know about J2EE Web services
In this webcast, Jim Keogh explains J2EE and then discusses benefits, implementation and drawba

DBA Tips: DB2 reorgs, trimming Oracle strings, and more...

2002-12-04 Thread SearchDatabase.com

SEARCHDATABASE.COM | Database Administrator Tips
December 4, 2002

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
FROM OUR SPONSOR:

Lumigent Entegra for Data Access Accountability 
http://searchDatabase.com/r/0,,8071,00.htm?lumigent 

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

IN THIS ISSUE | Table of Contents

1. DATABASE ADMINISTRATOR TIPS 
  - DB2: Generating reorg statements for all tables
  - SQL Server: Removing duplicate records from a table
  - Oracle: Use the name of current database in queries
  - Oracle: Trimming a string in versions before 8i
  - More recent tips from members

2. IMPORTANT ANNOUNCEMENTS AND LINKS
  - Ask the Experts: Your tough database questions answered
  - Featured Topic: Stored procedure development

___
*** Sponsored by Lumigent Technologies ***

Announcing Lumigent(R) Entegra(TM) - meet your data privacy and
security requirements with a complete audit of database activity.
Know who's doing what to which data when.  Entegra provides an
audit trail of changes to data and to database structure and
permissions, including data views (i.e. who viewed data). Entegra
monitors and alerts on database activity for a complete record of
data access, and data and database changes. FREE whitepaper -- Data
Access Accountability 
http://searchDatabase.com/r/0,,8071,00.htm?lumigent

*** 

___
THIS WEEK'S TIPS:

GENERATING REORG STATEMENTS FOR ALL TABLES | Prashant Dahalkar

The author's production tables often need to be reorganized because
they have been modified so many times that the data is fragmented and
access performance is slow. In order to generate the reorg statements
for all the tables at once -- as a batch process that will execute at
night -- this command for DB2 UDB 7.1 is very useful.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci860001,00.html


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
REMOVING DUPLICATE RECORDS FROM A TABLE THAT HAS NO PRIMARY KEY

By Prashant Dahalkar. Here is a SQL Server SELECT query that fetches
only those records where the combination of two composite keys is
unique.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci862833,00.html

 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
USE THE NAME OF CURRENT DATABASE IN QUERIES | Sushil Srivastava 

Sometimes its quite essential to know and use the Oracle database
name on which your SQL is being executed. You can do it simply by
querying the GLOBAL_NAMES view in Oracle, like this: SELECT * FROM
GLOBAL_NAMES. Simple!

 CLICK for the online version of the tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci858631,00.html


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
TRIMMING A STRING IN VERSIONS BEFORE 8I | Keshav Chennakeshav  

To trim a string in Oracle, LTRIM and RTRIM are available. Here is a
utility function that combines the two. Note: this function is a
standard feature of Oracle 8i and higher so it will be of use for
those who use Oracle versions less than 8i.

 CLICK for the online version of the tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci859899,00.html

___
MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS:

IDENTIFY REDUNDANT INDEXES | Sreedhar Bobbadi
http://www.searchDatabase.com/tip/1,289483,sid13_gci859891,00.html
Indexes are created to enhance performance, but often they are
created with the same attributes, resulting in redundant indexes.
Over a period of time the number of such indexes can grow, increasing
the size of the DB2 catalog. The following SQL can help you to
indentify all such indexes.  It has been tested on DB2 UDB OS/390
version 7.0.

USE A QUERY TO DOCUMENT YOUR DATABASE | Parthasarathy Mandayam
http://www.searchDatabase.com/tip/1,289483,sid13_gci839384,00.html
Did you know that you can use a query to document your SQL Server
database? This simple query on the system tables will do just that.
You can easily cut and paste the results into a Word document and
improve the look and feel. Here's how.

ACCESSING NON-ORACLE DATABASES WITH JDBC | Vishal Shah
http://www.searchDatabase.com/tip/1,289483,sid13_gci865321,00.html
The author needed to access data in a Progress database from within
an Oracle stored procedure. To do so, he utilized Oracle's Java
Stored Procedure functionality to make this possible. Here are the
steps that can work with any DBMS.

KEEPING OPTIMIZER STATISTICS UP TO DATE | David Gibbs
http://www.searchDatabase.com/tip/1,289483,sid13_gci865222,00.html
This Oracle script can be scheduled to run regularly to monitor table
usage and keep statistics on schema objects current.

Hundreds more

Webcast premiere: Don Burleson reveals his Oracle tuning secrets

2002-12-10 Thread SearchDatabase.com

Optimal performance of your Oracle database is essential. Get Oracle
tuning tips from the expert who literally wrote the book on Oracle
tuning. Don Burleson reveals several important secrets and techniques
for tuning your Oracle database today. 

-
TOPIC:   Oracle expert tuning secrets
SPEAKER: Don Burleson, author and owner of BEI Oracle Consulting
SPONSOR: Unisys
CLICK HERE: http://searchDatabase.com/r/0,,8272,00.htm 
-

*
--- FREE WHITE PAPERS from Unisys ---
*
Low TCO and High reliability of Windows 2000 servers

Discover what the Aberdeen Group has determined after comparing the
total cost of ownership of Windows 2000 servers compared to Unix. In
their Windows Server Cost-of-Ownership Study, find out how ease of
use issues can add up to big savings.  Then, learn why the Gartner
Group considers the Unisys ES7000 the most reliable enterprise server
with the highest availability of any server in the Windows and
marketplace by downloading  Business Continuance Through the
Deployment of Geographically Dispersed Clusters.  Click here for
your FREE White Papers: 
http://jumpbi.techtarget.com/dbserver.asp?s=invite  
*


-- About this webcast --

Oracle tuning is a phenomenal challenge for any database
professional. With more than 250 parameters and thousands of causes,
identifying and correcting a performance problem can be extremely
complex no matter how much or little experience you have.

This presentation shares tuning secrets that Oracle guru Don Burleson
has accumulated over 20+ years as a database administrator
consultant, including:
* Silver bullets
* Minimizing disk I/O
* SQL optimization
* SGA tuning
* Trend-based Oracle tuning

This webcast is indispensable for anyone who must ensure that a
database is optimally configured. Click here to view Don's
presentation and learn some of his time-saving secrets: 
http://searchDatabase.com/r/0,,8272,00.htm

---
-- About the speaker --
---
Don has more than 20 years of full-time DBA experience, and has
written 14 books, including Oracle high-performance SQL tuning and
most recently the Oracle9i UNIX Administration Handbook. He has
also published more than 60 articles in national magazines, serves as
Editor-in-Chief of Oracle Internals magazine, and is owner of BEI
Oracle Consulting. 


-- Additional information --

Check out our Best Web Links for Oracle Performance and Tuning Tips:
http://searchdatabase.com/bestWebLinks/0,289521,sid13_tax286162,00.html 


-- Invite a colleague --

If you think this event topic would be interesting to a colleague,
invite them to this webcast. All you need to do is forward this
e-mail.



___
  ABOUT THIS NEWSLETTER   :

Published by TechTarget (http://www.techtarget.com)
 TechTarget - The Most Targeted IT Media
 Copyright 2002, All Rights Reserved.

Unsubscribe from 'Updates on upcoming online events'
 - Simply Reply to this Email with REMOVE 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.
 - Uncheck the box next to the newsletter you wish 
   to unsubscribe from.
 - When finished, click Save Changes to My Profile.

DBA Tips: Connecting SQL Server and DB2, object access in Oracle, and more...

2002-12-11 Thread SearchDatabase.com

SEARCHDATABASE.COM | Database Administrator Tips
December 11, 2002

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
CHECK IT OUT:

FREE WEBCAST: Oracle expert tuning secrets
http://searchDatabase.com/r/0,,8272,00.htm 
 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

IN THIS ISSUE | Table of Contents

1. DATABASE ADMINISTRATOR TIPS 
  - DB2: Connect to an SQL Server from the iSeries 
  - SQL Server: Tablespace usage view
  - Oracle: Control users' access to Oracle objects from SQL*Plus
  - More recent tips from members

2. IMPORTANT ANNOUNCEMENTS AND LINKS
  - Featured Topic: Rudy Limeback's SQL tips

___
** CLICKWORTHY 

FREE WEBCAST: Oracle expert tuning secrets with author and guru Don
Burleson. Oracle tuning is a phenomenal challenge for any
professional. This presentation shares tuning secrets that Don has
accumulated over his 20+ years as a database administrator
consultant.  He explores some of the most common causes of poor
performance, looks at silver bullets and shows techniques for
reducing disk I/O, tuning the SGA, and tuning SQL statements. Fun,
informative and entertaining, this presentation is indispensable for
anyone who must ensure that their Oracle database is optimally
configured.
http://searchDatabase.com/r/0,,8272,00.htm 

*** 

___
THIS WEEK'S TIPS:

CONNECT TO AN SQL SERVER FROM THE ISERIES | Santosh Prasad

A quick tip about how to connect to a SQL Server database from DB2 on
AS400/iSeries using Java Tool Box. 

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci868252,00.html


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
TABLESPACE USAGE VIEW | Andrew Barringer 

This SQL Server view allows you to easily see the top 10% by Row
Count, Space Used, etc. This is useful for answering the question
what's taking up all the space in my database?

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci867509,00.html

 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
CONTROL ACCESS TO ORACLE OBJECTS FROM SQL*PLUS | Murali Krishna

The PRODUCT_USER_PROFILE table can be used to control users' access
to various Oracle objects from SQL*Plus. Here is how to implement it.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci867728,00.html

___
MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS:

GENERATING REORG STATEMENTS FOR ALL TABLES | Prashant Dahalkar
http://www.searchDatabase.com/tip/1,289483,sid13_gci860001,00.html
The author's production tables often need to be reorganized because
they have been modified so many times that the data is fragmented and
access performance is slow. In order to generate the reorg statements
for all the tables at once -- as a batch process that will execute at
night -- this command for DB2 UDB 7.1 is very useful.

REMOVING DUPLICATE RECORDS FROM A TABLE THAT HAS NO PRIMARY KEY
http://www.searchDatabase.com/tip/1,289483,sid13_gci862833,00.html
By Prashant Dahalkar. Here is a SQL Server SELECT query that fetches
only those records where the combination of two composite keys is
unique.

EMBEDDED SQL AND DB2 V5R1 FOR ISERIES | Sudhakar Kunji 
http://www.searchDatabase.com/tip/1,289483,sid13_gci838014,00.html
In V5R1, a change was made to DB2 UDB for iSeries so that it returns
the proper SQLCODE warning on certain types of FETCH and SELECT INTO
statements. If an application wasn't coded properly to check the
SQLCODE value, then it will start failing on V5R1 systems. Click
below for more details...

USE THE NAME OF CURRENT DATABASE IN QUERIES | Sushil Srivastava 
http://www.searchDatabase.com/tip/1,289483,sid13_gci858631,00.html
Sometimes its quite essential to know and use the Oracle database
name on which your SQL is being executed. You can do it simply by
querying the GLOBAL_NAMES view in Oracle, like this: SELECT * FROM
GLOBAL_NAMES. Simple!

TABLESPACE MONITOR FOR AUTOEXTEND | Perry White 
http://www.searchDatabase.com/tip/1,289483,sid13_gci850776,00.html
This Oracle code provides a way to proactively indicate how much
total logical disk space is available for tablespaces using the
autoextend feature of Oracle on its datafiles.

SECURE IMPORT/EXPORT USER | Ed Schalk 
http://www.searchDatabase.com/tip/1,289483,sid13_gci841580,00.html
Avoid the security problem of putting Oracle passwords in script
files for privileged users.

TRIMMING A STRING IN VERSIONS BEFORE 8I | Keshav Chennakeshav  
http://www.searchDatabase.com/tip/1,289483,sid13_gci859899,00.html
To trim a string in Oracle, LTRIM and RTRIM are available. Here is a
utility function that combines the two. Note: this function is a
standard

THIS WEEK: The 2002 database top ten

2003-01-02 Thread SearchDatabase.com

Title: TechTarget

January 02, 2003

Receive this email as text About this email

In this Issue

From the editor:
Happy new year!

Featured Topic:
The 2002 database top ten

Expert Technical Advice:
New expert advice, forum posts, and tips

Site Highlights:

* White Paper Library
* Webcast: The state of the Web services union
* Webcast: Oracle expert tuning secrets

From the Editor:

by Tim DiChiara, Site Editor

Happy New Year to all! Seems like we made New Year's resolutions just yesterday, yet here we are again. Have you followed through with yours? Do I still have your attention?

This year we plan to offer you everything you need to get to the next level of enterprise DBMS development and administration with focused news, tips, advice, webcasts and forums. What's so different about that, you ask? Sure, that's always been our goal at SearchDatabase.com, but this year we'll be trying a few new features and sources, including new experts, webcast speakers, featured tips, special reports and more.

As always, we can't do this without your input. Begin your new year by sending me your feedback about what you'd llike to see us cover in 2003.

We read and consider every e-mail that comes in and your input is what has helped make SearchDatabase.com one of the best data management resources on the Web. Here's to a great New Year!

Cheers, Tim

Featured Topic:

The 2002 database top ten
by Tim DiChiara, Site Editor
We analyzed traffic stats, ratings, and feedback and came up with a list of your favorite SearchDatabase content in 2002. Inside you'll find the best of the best tech tips, news analysis, and Ask the Expert advice...

Read more about this topic

Expert Technical Advice:

Featured Expert Pat Phelan,
Data modeler

Category: Database design
Pat has an eclectic background that dates back to when the field was still called Data Processing and used punched cards. He has worked on systems ranging from IBM mainframes, through mini-computers (DEC, HP, PR1ME, etc), to microcomputers, to process control machines. Ask him your questions about database design!

View all Pat's answers

This Week: In the forums

Oracle shared SQL areas

Member "oraclekautilya" is wondering about the diference between a private SQL area created by a PRO*C application and a SQL*PLUS application? Go to our "DBA Water Cooler" forum if you can offer any advice.

DB2 vs. IMS Fast Path performance
Member "Wambui" is looking for help making a comparison between DB2 and IMS, in terms of performance, web services, and more. Go to our "DBA Water Cooler" forum if you can offer any advice.

Tip of the Week:
This SQL Server view allows you to easily see the top 10% by Row
Count, Space Used, etc. This is useful for answering the question
"what's taking up all the space in my database?"

Tablespace usage view

Site Highlights

White Paper Library
Hundreds of papers on database-technology topics
New papers are added weekly for free download. Visit and bookmark this page today.

The state of the Web services union
View this webcast with Eric Newcomer, CTO, IONA, today
Where do Web services stand as we start 2003 and what does it mean to your enterprise? Find out in this webcast.

Don Burleson's Oracle Tuning Secrets
Get Oracle tuning "silver bullets" from this leading Oracle guru and author
Oracle tuning is a phenomenal challenge for any database professional. With more than 250 parameters and thousands of causes, identifying and correcting a performance problem can be extremely complex no matter how much experience you have. View this webcast today for tips on optimal configuration.

FREE EMAIL SERVICES!

Select newsletters you would like to receive from the list below.

Ask the Database Experts

DB2 Tips

SQL Server Tips

DBA Tips: Backup and restore basics, truncate tables with PL/SQL, and more...

2003-01-08 Thread SearchDatabase.com

SEARCHDATABASE.COM | Database Administrator Tips
January 8, 2003

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
FROM OUR SPONSOR:

Free database whitepapers
http://searchdatabase.techtarget.com/whitepapers3/0,,sid13,00.html
 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

IN THIS ISSUE | Table of Contents

1. DATABASE ADMINISTRATOR TIPS 
  - DB2: Reorg and runstats in a ksh script
  - SQL Server: SQL Server backup and restore, part 1: The basics 
  - Oracle: Truncate tables using PL/SQL
  - More recent tips from members
 
2. IMPORTANT ANNOUNCEMENTS AND LINKS
  - Ask the Experts: Your tough database questions answered
  - Featured Topic: Craig Mullins: DB2 guru

___
** Free database whitepapers **

Download the key papers you need today to make better-informed
decisions. Targeted categories include data analysis and business
intelligence, data security, data storage, database-Web integration,
and more. Click here to access the free SearchDatabase.com white 
papers section:

http://searchdatabase.techtarget.com/whitepapers3/0,,sid13,00.html

*** 

___
THIS WEEK'S TIPS:

REORG AND RUNSTATS IN A KSH SCRIPT | Venkat Arikatla

You can reorg and runstats for DB2 with this single ksh script.
Install it as a crontab to run every day during off-peak hours. 

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci869564,00.html


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
SQL SERVER BACKUP AND RESTORE, PART 1 | Greg Robidoux

One of the most important aspects for a SQL Server environment is
ensuring that reliable backups are being executed and a dependable
recovery plan is established in the event of a system failure or data
corruption. The first part of this two-part article analyzes the
various options available for your backup and recovery process with
SQL Server 2000.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci872342,00.html

 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
TRUNCATE TABLES USING PL/SQL | Kevin Shidler

This script truncates data from tables using PL/SQL for Oracle8i. It
first disables all foreign key constraints that would cause the
ORA-02266 error, truncates the tables, and then re-enables all the
foreign keys. 

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci842566,00.html

___
MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS:

FAST ACCESS TO DB2 ON THE ISERIES WITH PHP | Alex Corretge i Bergua
http://www.searchDatabase.com/tip/1,289483,sid13_gci868255,00.html
The author had a dream: Access DB2 on the iSeries with an Web-based
application written in PHP. He used the simple steps in this tip to
make that dream a reality.

WORD WRAPPING WITH T-SQL | Andrew Novick 
http://www.searchDatabase.com/tip/1,289483,sid13_gci869491,00.html
There are times when there isn't a suitable front-end that can
perform a word wrapping task and so it has to be done by SQL Server
itself. Here is a UDF, called udf_TxtN_Wrap, that wraps a nvarchar
string at a given line length.

REFRESH VALUE OF A GLOBAL VARIABLE ONLY AFTER COMMIT | Murali Krishna
http://www.searchDatabase.com/tip/1,289483,sid13_gci854788,00.html
Through any front-end applications it's easy to control the value of
any variable via re-initialization at any point. But what happens if
you want to reinitialize the value at the SQL prompt or at the
database level? Here's how to do it in Oracle.

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:

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 
YOUR TOUGH DATABASE QUESTIONS ANSWERED | Ask the Experts 

DB2: RECOVER versus LOAD utilities
http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid508544_tax285651,00.html

Oracle: Steps to copy an 8i database to another PC
http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid508949_tax289342,00.html

SQL Server:  Executing Oracle stored porcedures in SQL Server
http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid509320_tax285648,00.html

Database design: Avoiding overhead of insert/delete with indexes
http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid508676_tax285653,00.html

Oracle: VARCHAR2 versus VARCHAR
http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid508992_tax285650,00.html

More expert answers here: 
http

DBA Tips: SQL Server backup best practices, DB2 indexes, and more...

2003-01-15 Thread SearchDatabase.com

SEARCHDATABASE.COM | Database Administrator Tips
January 15, 2003

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
FROM OUR SPONSOR:

Free database whitepapers
http://searchdatabase.techtarget.com/whitepapers3/0,,sid13,00.html
 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

IN THIS ISSUE | Table of Contents

1. DATABASE ADMINISTRATOR TIPS 
  - DB2: Checking to see if indexes are needed
  - SQL Server: Backup and restore, part II: Best practices 
  - Oracle: Find what each Oracle process is doing
  - More recent tips from members
 
2. IMPORTANT ANNOUNCEMENTS AND LINKS
  - Ask the Experts: Your tough database questions answered
  - Featured Topic: Backup and recovery

___
** Free database whitepapers **

Download the key papers you need today to make better-informed
decisions. Targeted categories include data analysis and business
intelligence, data security, data storage, database-Web integration,
and more. Click here to access the free SearchDatabase.com white 
papers section:

http://searchdatabase.techtarget.com/whitepapers3/0,,sid13,00.html

*** 

___
THIS WEEK'S TIPS:

CHECKING TO SEE IF INDEXES ARE NEEDED | David Quigley

If you have SQL that needs an index but you're unsure about the best
index to create, DB2 7 has an index advisory. This quick tip helps a
DBA figure out the best indexes to create for a specfic SQL query.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci870110,00.html


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
SQL SERVER BACKUP AND RESTORE, PART II | Greg Robidoux

In the second part of a series, the author presents guidelines that
can be used for selecting the appropriate backup and recovery model
as well as some important considerations and tips.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci874243,00.html

 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
FIND WHAT EACH ORACLE PROCESS IS DOING | M. Indira

Here is a handy script that will correlate the operating system
process with the Oracle process. You'll also be able to see the most
current SQL run by that process.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci843413,00.html

___
MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS:

REORG AND RUNSTATS IN A KSH SCRIPT | Venkat Arikatla
http://www.searchDatabase.com/tip/1,289483,sid13_gci869564,00.html
You can reorg and runstats for DB2 with this single ksh script.
Install it as a crontab to run every day during off-peak hours. 

SQL SERVER BACKUP AND RESTORE, PART I | Greg Robidoux
http://www.searchDatabase.com/tip/1,289483,sid13_gci872342,00.html
One of the most important aspects for a SQL Server environment is
ensuring that reliable backups are being executed and a dependable
recovery plan is established in the event of a system failure or data
corruption. The first part of this two-part article analyzes the
various options available for your backup and recovery process with
SQL Server 2000.

TRUNCATE TABLES USING PL/SQL | Kevin Shidler
http://www.searchDatabase.com/tip/1,289483,sid13_gci842566,00.html
This script truncates data from tables using PL/SQL for Oracle8i. It
first disables all foreign key constraints that would cause the
ORA-02266 error, truncates the tables, and then re-enables all the
foreign keys. 

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:

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 
YOUR TOUGH DATABASE QUESTIONS ANSWERED | Ask the Experts 

DB2: Finding the 10 greatest numbers in a column
http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid511553_tax285651,00.html

DB2: QMF versus SPUFI
http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid511544_tax285651,00.html

Oracle: Loading data from Oracle into flat files
http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid508988_tax285650,00.html

SQL Server: Improving the search performance though text fields
http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid511092_tax292506,00.html

SQL Server: Increasing speed of MS Data Engine/SQL Server environment
http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid511081_tax292506,00.html

More expert answers here: 
http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html

THIS WEEK: Pat's database design tips

2003-01-20 Thread SearchDatabase.com

Title: TechTarget

January 20, 2003

Receive this email as text About this email

In this Issue

From the editor:
Jim's Oracle tips

Featured Topic:
Pat's database design tips

Expert Technical Advice:
New expert advice, forum posts, and tips

Site Highlights:

* Webcast: Server consolidation
* Free offers at our new partner page
* Download a new white paper

From the Editor:

by Tim DiChiara, Site Editor

I am happy to announce that Jim Giordano's Oracle tips and advice will now be featured on SearchDatabase.com. Our sister site SearchHP.com is merging with us this week, so now there will be even more great Oracle expertise available on SearchDatabase.com.

Jim is a senior Oracle DBA with over 10 years of Oracle experience on UNIX. He works for Symmetry Consulting where he is is a Senior Principal Consultant. Based out of Albany, NY, Jim travels around the U.S. providing DBA support to ERP implementations. On our site, he will specialize in questions about Oracle implementations on HP platforms.
Here is a sampling of his "Ask the Expert" work:

How do I copy a database from one server to another? View Jim's eight-step process here.

Pop quiz: What is the command for finding the size of a shared pool? Jim answers that question and nine others here.

What are the kernel parameters that should be modified for Oracle on
HP-UX?

Jim answers dozens more Oracle and HP questions here.

Thanks, and have a great week, Tim

Featured Topic:

Pat's database design tips
by Tim DiChiara, Site Editor
Taking the time to design stable, fast and secure databases is critical for avoiding future administration headaches. To help you in this endeavor, guru Pat Phelan presents a collection of tips about effective design inside...

Read more about this topic

Expert Technical Advice:

Featured Expert Mike Hotek,
Director of Database Operations, AdOutlet

Categories: SQL Server
Mike has extensive experience with replication going back to Sybase System 11 and SQL Server 6.5 through SQL Server 2000 with over 50 replication installations currently in production with some being the largest in existence in the world. Mr. Hotek also has extensive disaster recovery experience in performing over 150 recoveries of live, production environments. Mr. Hotek became a SQL Server MVP in 2000 for all of the work he does in newsgroups, mailing lists and discussion forums. He's co-author of "SQL Server System Administration," contributing author of "Special Edition Using Microsoft SQL Server 7.0," and creator of mssqlserver.com and certfaq.com.

View all Mike's answers

This Week: In the forums

How to save a new record in an Access subform?
Member "orpheus" has a form that should save a record in a subform when undergoing an ONINSERT action but is having problems. Go to our "DBA Water Cooler" forum if you can offer any advice.

Oracle - Toad connection problems
Member "Dee" is still waiting for an answer! He is having trouble connecting 9i to Toad, getting an "ORA-12154" error. Go to our "Database-web connectivity" forum if you can offer any advice.

Tip of the Week:
In the second part of a series, Greg Robidoux presents guidelines that can be used for selecting the appropriate backup and recovery model as well as some important considerations and tips.

SQL Server backup and restore, part II: Best practices

Site Highlights

Server consolidation webcast
A key component of a network upgrade is server consolidation
View this webcast with Laura DiDio of the Yankee Group to learn about total cost of ownership, ROI, challenges and more!

Free offers at our new partner page
Take a look at this new page -- featuring special offers for SearchDatabase.com members
Check it out for relevant information... or contact us if you have a valuable offer to share with other members.

Download this new white paper
Are your centralized business applications stuck in a time warp?
Read "Distributing Business Applications & Databases; an Analysis of Enterprise Replication Options" to:
* Explore the limitations of business application architectures
* Learn about new distribution, replicat

DBA Tips: SQL Server security blunders, Oracle and TOAD, and more...

2003-01-22 Thread SearchDatabase.com

SEARCHDATABASE.COM | Database Administrator Tips
January 22, 2003

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
FROM OUR SPONSOR:

Free database whitepapers
http://searchdatabase.techtarget.com/whitepapers3/0,,sid13,00.html
 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

IN THIS ISSUE | Table of Contents

1. DATABASE ADMINISTRATOR TIPS 
  - DB2: Create a clustered index on a primary key
  - SQL Server: Top ten security blunders
  - Oracle: Browsing OS files from TOAD or SQL*Plus
  - More recent tips from members
 
2. IMPORTANT ANNOUNCEMENTS AND LINKS
  - Ask the Experts: Your tough database questions answered
  - Featured Topic: Pat's database design tips

___
** Free database whitepapers **

Download the key papers you need today to make better-informed
decisions. Targeted categories include data analysis and business
intelligence, data security, data storage, database-Web integration,
and more. Click here to access the free SearchDatabase.com white 
papers section:

http://searchdatabase.techtarget.com/whitepapers3/0,,sid13,00.html

*** 

___
THIS WEEK'S TIPS:

CREATE A CLUSTERED INDEX ON A PRIMARY KEY | Prashant Dahalkar

Here is a way to create a table with clustered index on a composite
primary key in DB2 UDB v7.1.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci875345,00.html


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
TOP 10 SQL SERVER SECURITY BLUNDERS | Jan Stafford

An industry veteran shares the worst SQL Server security mistakes to
avoid. Ignore these at your peril!

 CLICK for the part I... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci874688,00.html

 CLICK for the part II... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci874690,00.html 

 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
BROWSING OS FILES FROM TOAD OR SQL*PLUS |  Jim Leask

This tip describes the process required to browse operating system
(OS) files from a PC application like TOAD or SQL*PLUS. This process
will be useful for browsing the Oracle alert log when access via the
OS is restricted.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci874425,00.html

___
MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS:

CHECKING TO SEE IF INDEXES ARE NEEDED | David Quigley
http://www.searchDatabase.com/tip/1,289483,sid13_gci870110,00.html
If you have SQL that needs an index but you're unsure about the best
index to create, DB2 7 has an index advisory. This quick tip helps a
DBA figure out the best indexes to create for a specfic SQL query.

SQL SERVER BACKUP AND RESTORE, PART II | Greg Robidoux
http://www.searchDatabase.com/tip/1,289483,sid13_gci874243,00.html
In the second part of a series, the author presents guidelines that
can be used for selecting the appropriate backup and recovery model
as well as some important considerations and tips.
 
FIND WHAT EACH ORACLE PROCESS IS DOING | M. Indira
http://www.searchDatabase.com/tip/1,289483,sid13_gci843413,00.html
Here is a handy script that will correlate the operating system
process with the Oracle process. You'll also be able to see the most
current SQL run by that process.

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:

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 
YOUR TOUGH DATABASE QUESTIONS ANSWERED | Ask the Experts 

DB2: Triggers to UPDATE CASCADE
http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid512595_tax285651,00.html

SQL: Comparing two tables 
http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid512588_tax285649,00.html

Oracle: Sort order of composite primary keys 
http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid511846_tax285650,00.html

Database design: Is Visual FoxPro a flat database?
http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid512231_tax285653,00.html

Oracle: Sending queried data from the Web to a CSV or Excel file
http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid511837_tax285650,00.html

More expert answers here: 
http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html 


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
PAT'S DATABASE DESIGN TIPS | SearchDatabase.com Featured Topic

Taking the time to design stable, fast and secure databases is
critical for avoiding future

DBA Tips: Automate documentation tasks, and more...

2003-02-05 Thread SearchDatabase.com

SEARCHDATABASE.COM | Database Administrator Tips
February 5, 2003

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
FROM OUR SPONSOR:

FREE WHITE PAPER: Oracle data access from .NET 
http://searchDatabase.com/r/0,,9924,00.htm?compuware 
 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

IN THIS ISSUE | Table of Contents

1. DATABASE ADMINISTRATOR TIPS 
  - DB2: Find out what dynamic SQL is running
  - SQL Server: Automate documentation tasks
  - Oracle: Determining the hit ratio of Oracle databases
  - More recent tips from members
 
2. IMPORTANT ANNOUNCEMENTS AND LINKS
  - Ask the experts: Your database questions answered
  - Featured Topic: Web services: What? Why? How?

___
* Sponsored by Compuware **

FREE WHITE PAPER: Oracle data access from .NET. LEARN how you can
analyze and debug PL/SQL completely within the Visual Studio 
environment to save time in development. Get expert advice on
accessing and manipulating database objects, without switching back
and forth between two separate environments. Now that's a technique
you'll want to learn. Read on.  REGISTER FOR FREE WHITE PAPER
DOWNLOAD HERE:

http://searchDatabase.com/r/0,,9924,00.htm?compuware 

*** 

___
THIS WEEK'S TIPS:

FIND OUT WHAT DYNAMIC SQL IS RUNNING | David Quigley 

Have you wondered what SQL is being executed against your database as
well as its frequency? Here's a quick command that will retrieve that
info for you.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci870147,00.html


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
AUTOMATE DOCUMENTATION TASKS | Garet Griffin

Documentation is sorely lacking in many commercial development
projects today. By automating some of the documentation tasks for
your databases, you are doing yourself a big favor.  Here are several
simple documentation routines that can be stored in SQL Server's
MODEL database and therefore propagated to all new databases.

 CLICK for the full tip...
http://www.searchDatabase.com/tip/1,289483,sid13_gci878331,00.html

 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
DETERMINING THE HIT RATIO OF ORACLE DATABASES | Peter Choi 

The hit ratio determines if Oracle is performing more physical reads
to retrieve the data. A general rule of thumb for OLTP systems is
that if the hit ratio falls below 70%-80%, the DBA should investigate
the cause. Here's a quick script that will calculate the hit ratio.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci878332,00.html

___
MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS:

DB2'S DATE DATA TYPE | Peter Gulutzan and Trudy Pelzer
http://www.searchDatabase.com/tip/1,289483,sid13_gci876846,00.html
This article describes how IBM implements the DATE data type for DB2
and discusses what calendar is used, what the JULIAN_DAY function
really does, why date arithmetic is random, how to calculate
birthdays, and how to find month ends using DB2.

DETERMINE THE NUMBER OF ROWS IN A TABLE | Andrew Novick
http://www.searchDatabase.com/tip/1,289483,sid13_gci876060,00.html
If you don't require an exact answer, it isn't necessary use a SELECT
count(*) query on the rows in a table to get the row count. SQL
Server keeps the row count in sysindexes and it can be retrieved
there. Here's how.

UPDATED: HOT BACKUP AND RECOVERY WITH PERL | Frank Pantaleo
http://www.searchDatabase.com/tip/1,289483,sid13_gci857677,00.html
This extensive script is useful for Oracle DBAs who want to use Perl
for doing hot backups. Now updated with bug fixes, code cleanup and
add more verbose messages.

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:

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 
YOUR TOUGH DATABASE QUESTIONS ANSWERED | Ask the Experts 

Oracle: Storing video clips
http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid514884_tax289342,00.html

Object-oriented DBs: How does data mining work in ODBMSs?
http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid513952_tax288550,00.html

SQL Server: Equivalent of Oracle's DESC function
http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid513982_tax285648,00.html

DB2: Tool for SAP DB2 backups
http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid514620_tax285651,00.html

Oracle: Inserting the '' symbol in a string
http

THIs WEEK: Normalization

2003-02-10 Thread SearchDatabase.com

SEARCHDATABASE.COM: This Week
February 10, 2003
___
IN THIS ISSUE
__

From the editor: Pointing fingers for Slammer 
Featured Topic: Normalization
Expert Technical Advice: New expert advice, forum posts, and tips
Site Highlights: 
* Webcast: Unraveling the complexities of DB2 stored procedures
* Data Center Futures | June 4-6 |Chicago
* Webcast: Impossible data warehouse situations



From the Editor:
__
by Tim DiChiara, Site Editor

Last week, we posed the question: Who's to blame for the SQL Slammer
worm? Over 500 of you responded, but this passion didn't translate
into a clear winner. Here are the results: 
Both - 34% 
Microsoft - 30% 
SQL Server administrators - 20% 
Neither - 17% 

It seems you were quite fair in assigning blame: the results
demonstrate that everybody had a role in the outbreak. At least
that's what you database geeks believe. Our sister site
SearchSecurity.com, which has fewer DBAs in its audience, ran the
same poll and received 600 votes. The results were similar, with one
glaring exception: significantly more people blamed SQL Server
admins. It seems that the blame is distributed according to who is
doing the blaming! Sound familiar? A Chinese proverb comes to mind:
If one's face is ugly, one cannot blame the mirror.

After you've taken the responsibility for your role in security,
check out SearchDatabase.com's plethora of resources to help you
secure your SQL Server, Oracle, and DB2 databases:

* Webcast: SQL Server security best practices
http://searchdatabase.techtarget.com/newsItem/0,289139,sid13_gci863947,00.html

* Ask our database gurus your security questions.
http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html

* Top 10 SQL Server security blunders
http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci874688,00.html

* All our database security tips, scripts, and advice.
http://searchDatabase.com/r/0,,10101,00.htm


Till next week, Tim


Featured Topic:
__
Normalization

Optimal normalization is the key to good database design. And good
design is the key to optimal database performance, efficiency, and
integrity. The tips and expert advice inside will help you master
this important skill.
http://www.searchDatabase.com/featuredTopic/0,290042,sid13_gci879196,00.html



Expert Technical Advice:
__
Featured Expert  Karen Morton, Owner, Morton Consulting, Inc
http://searchdatabase.techtarget.com/ateExpertBio/0,289623,sid13_cid404542,00.html

Category: Oracle
Karen has over 15 years IT experience and 10 years Oracle experience.
She has co-authored several Oracle training coursebooks and taught
hundreds of individuals in skills ranging from introductory Oracle to
advanced DBA topics. She holds a B.S. in Computer Science and
additionally holds OCP DBA credentials for Oracle 8i. Ask her your
tough Oracle questions! 

View all Karen's answers 
http://searchdatabase.techtarget.com/ateAnswers/0,289620,sid13_tax289342,00.html

This Week: In the forums
Upgrade Oracle from 32- to 64-bit

Member oracleperl is about to upgrade his Oracle 9i system to
64-bit. Has anybody done this? Any tips or caveats? Go to our  DBA
Water Cooler if you can offer any suggestions.
http://searchdatabase.techtarget.com/forums/0,289802,sid13_fid1,00.html  

GUI administration tool for Sybase
Member Sybase Novice is looking for a freeware or shareware GUI
administration tool for Sybase v11.0.3 on Linux. Go to our  DBA
Water Cooler if you can help.
http://searchdatabase.techtarget.com/forums/0,289802,sid13_fid1,00.html  

TIP OF THE WEEK
DB2's DATE data type
This article describes how IBM implements the DATE data type for DB2
and discusses what calendar is used, what the JULIAN_DAY function
really does, why date arithmetic is random, how to calculate
birthdays, and how to find month ends using DB2.
http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci876846,00.html



SITE HIGHLIGHTS
__
 Learn more about DB2 stored procedures
View this webcast: Unraveling the complexities of DB2 stored
procedures
David Cohn provides an overview of DB2 stored procedures on OS/390,
the mechanisms for using them and the SQL/PSM language.
http://searchDatabase.com/r/0,,10091,00.htm


Data Center Futures | June 4-6 |Chicago
Free conference -- confirm your registration by April 15 for your
free attendance
Attend this independent conference that will help you set your
strategy today for the most scalable, reliable data center.
http://datacenterfutures.com


Webcast: Impossible data warehouse situations
Attend this webcast with experts Chuck Kelley and Sid Adelman today
Get advice from experts who know how to plan and implement data
warehouses. You'll hear about the solutions to common crises that
companies face when building complex data warehouses. Listen as these
experts discuss their personal experiences about

Webcast premiere: Impossible data warehouse situations

2003-02-13 Thread SearchDatabase.com

Dear SearchDatabase.com Member,

You are invited to attend an expert webcast, Impossible data
warehouse situations. Our experts will share personal advice on how
to make impossible data warehousing projects possible. You don't
want to miss this educational opportunity.

Attend today:
http://searchDatabase.com/r/0,,10351,00.htm

~~
TITLE:Impossible data warehouse situations
SPEAKER: Chuck Kelley, author and founder of the consultancy
Excellence in Data, Inc.
SPEAKER: Sid Adelman author, founder of the Business Intelligence
Alliance, principal of Sid Adelman Associates

SPONSOR: Data Junction
http://www.datajunction.com

ATTEND THIS WEBCAST:
http://searchDatabase.com/r/0,,10351,00.htm
~

** SPONSORED BY: DATA JUNCTION ***
Data Junction offers flexible, cost-effective solutions and
integration processes executed on demand, regularly scheduled or
performing in totally lights-out operations. Data Junction
frees you from time-consuming custom code writing for improving and
extending existing systems, deploying new applications, and enhancing
the distribution of mission-critical information
inside and outside your organization. Visit
http://www.datajunction.com
**

**
ABOUT THIS WEBCAST
**

Effective data warehousing can be tricky without adequate planning
and project management. Don't begin a project without first learning
about the seemingly impossible situations all data warehousing
projects run into, such as:

* Management issues
* Changing requirements
* User and team issues
* Project planning
* Security
* Data quality
* Integration
* Performance

These situations aren't really impossible. Chuck Kelley and Sid
Adelman present this webcast that promises to be enlightening.

Join us today for a learning experience you don't want to miss!
http://searchDatabase.com/r/0,,10351,00.htm

===
To subscribe to Data Warehouse Design and Implementation go to:
http://searchDatabase.techtarget.com/OptIn/1,290894,sid13,00.html?cid=458974em=tid=255FE=1

Not a searchDatabase member? We'll activate your membership with your
subscription.
===

-- Invite a colleague --

If you think this event topic would be interesting to a colleague,
invite them to this webcast. All you need to do is forward this
e-mail.

Unsubscribe from 'Updates on upcoming online events'
- Simply Reply to this Email with REMOVE 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.
- Uncheck the box next to the newsletter you wish
to unsubscribe from.
- When finished, click Save Changes to My Profile.

THIS WEEK: Database career tips

2003-02-24 Thread SearchDatabase.com

Title: TechTarget





 
   
   
  
 



 

  



 
 
  
   February 24, 2003  
  
  Receive this email as text About this email
 
 


 
 
  
   

 
   

 
  
  
 
 
   
   

 
 

   
  
  In this Issue
 
 



 
 
  From the editor:
   Database glossary debuts 
 
   
 
  Featured Topic:
   Database career tips 
 
  
 
  Expert Technical Advice:
   New expert advice, forum posts, and tips 
 
  
 
  Site Highlights:
   
* Searching for SQL Server resources?
* SearchDatabase.com White Paper Library
* Webcast: Business intelligence with SQL Server 
 
 

 


 
   


 
 


   
   

 
 

   
  
  From the Editor:
 



 
  
   
   
 by Tim DiChiara, Site Editor 
  
  Choking on the alphabet soup of database industry acronyms? Or perhaps you just need to know more about a particular term? We're happy to announce the debut of our database-specific glossary that will help you understand the latest industry lingo. 

The glossary is powered by our famous sister site WhatIs.com so you know it is detailed and accurate. Here is a sampling (are you sure you know the meaning of all these?):


ACID
HOLAP
Splay tree
TMQL
X#


If you are puzzled by a term not seen in the glossary, please drop me an email at [EMAIL PROTECTED] and we'll add the definition to our list.

Till next week, Tim 
  
 


 


 
   


 
 


   
   

 
 

   
  
  Featured Topic:
 



 

   Database career tips
   by Tim DiChiara, Site Editor 
   Even in this dour economy, database administrators and developers continue to be in high demand -- and continue to be highly paid. The collection of tips and advice inside will guide you along the path to becoming a database guru.
   
   
   
Read more about this topic

 


 


 
   


 
 


   
   

 
 

   
  
  Expert Technical Advice:
 
 



 
   


  Featured Expert Craig Mullins,
Director of DB2 Technology Planning, BMC Software

Categories: DB2

Craig has extensive experience in the field of
database management, having worked as an application
developer, a DBA, and an instructor with multiple database
management systems, including DB2, Oracle and SQL Server.
Additionally, Craig worked as a Research Director with the
Gartner Group covering the field of database administration.
He is the author of the DB2 Developer's Guide, the
industry-leading book on DB2 for OS/390, and has published
over 100 articles on database technology. Ask Craig your
tough DB2 questions! 
   
   View all of Craig's answers 
  
 







 
   This Week: In the forums
  
 
 
  
  
   
   Oracle table reorg hangs during import
Member "Virgin DBA" is having trouble doing a reorg on a single table with 1+ million records. Go to our "Oracle Tech Forum" to offer your two cents. 
  
   
  
  
   
   Converting dates to a DB2 varchar format
Member "CyberCircus" is trying to convert a DB2 date value into a char with the following format: 'DD/MM/YY'. Go to our "Oracle Tech Forum" if you can help. 
  
   




 Tip of the Week:
 This SQL script for DB2 UDB 7.2 will create a script for running full
statistics on databases and provides an output file for updating
statistics as needed. 
 
  Generating DB2 update statistics
 


 


 
   


 
 


   
   

 
 

   
  
  Site Highlights
 
 



 
  
   
   
Searching for SQL Server resources?
SearchDatabase.com the information SQL Server users need
Check out our SQL Server-specific information throughout our site -- Ask the Experts, webcasts, white papers, tips and more.
 

SearchDatabase.com White Paper Library
Access our library of more than 300 free database-specific white papers
our SearchDatabase.com membership entitles you to free white papers from some of the industry's top sources and vendors.
  
  
  
  
  
  
   
Business intelligence with SQL Server
Don't let the amount of data in your enterprise overwhelm you
In this webcast, SQL Server expert Bill Baker shares tips and best practices for implementing a Microsoft SQL Server business intelligence solution on heterogeneous database systems. Bill will discuss: 
* SQL Server 2000 data transformation services (DTS)
* Office XP as a BI platform
* SharePoint Portal Server
* And more 
Sponsored By: Proclarity
  
  
  
 


 
  
  
   
   

 
 
 
  
  
  
   
  
  
   

 
  

 
  FREE EMAIL SERVICES!
 


 


   
 
  Select newsletters you would like to receive from the list below.
 
 
  
 
 
  
   Ask the Database Experts
  
 
  
   Database Administrator Tips

Webcast premiere: Business intelligence: From inception to implementation

2003-02-27 Thread SearchDatabase.com

Dear SearchDatabase.com member,

Please join us for an insightful expert webcast that will educate
you on how to develop an effective business intelligence (BI)
application. Expert Shaku Atre will walk you through every step
of the process--from strategic planning to the selection of new
technologies and the evaluation of application releases.

Attend today!
http://searchDatabase.com/r/0,,10861,00.htm
--
TOPIC: Business intelligence: From inception to implementation
SPEAKER: Shaku Atre, author of Business Intelligence Roadmap
SPONSOR: MicroStrategy
http://www.microstrategy.com?CID=1938a

ATTEND TODAY:
http://searchDatabase.com/r/0,,10861,00.htm
---

* SPONSORED BY: MICROSTRATEGY *
**FREE** Vision in Business Intelligence White Paper **

MicroStrategy 7i is the only Business Intelligence platform that
can scale to thousands of users and analyze multi-terabyte data
warehouses. Business Objects can't. Cognos can't. Download
our FREE white paper to learn how Fortune 500 companies
like Best Buy are relying on MicroStrategy 7i as their enterprise
standard for business intelligence:
http://searchDatabase.com/r/0,,10848,00.htm?microstrategy

--
ABOUT THIS EXPERT WEBCAST:
--
Listen and learn as BI expert, Shaku Atre, discusses the different
facets of business intelligence and how they can ultimately help you
increase your bottom line. She will explain how to take your BI
project from implementation to fruition. Learn about:

* The major components of BI application development
* The vendors' landscape
* The six stages of BI implementation: An engineering project

Attend this valuable expert webcast and learn how you can increase
your bottom line. Join us today!
http://searchDatabase.com/r/0,,10861,00.htm

--
ABOUT THE SPEAKER:
--

Shaku Atre is President of Atre Associates, Inc., a data warehousing
and systems integration consultancy, Chairperson of the Atre Group,
a research and analysis firm and author of six books and hundreds of
articles on database and client-server technology. Before heading her
present company, she was a partner with PriceWaterhouse Coopers and a
faculty member at the prestigious IBM Systems Research Institute.

===
To subscribe to Daily News go to:
http://searchDatabase.techtarget.com/OptIn/1,290894,sid13,00.html?cid=459493em=tid=242FE=1

Not a searchDatabase member? We'll activate your membership with your
subscription.
===

-- Invite a colleague --

If you think today's webcast topic would interest your
colleagues, simply forward them this invitation.

This week: The future of data management

2003-03-03 Thread SearchDatabase.com

Select newsletters you would like to receive from the list below.

Database Administrator Tips

Daily News

Ask the Database Experts

Email:

Not a member? We'll activate your membership with your subscription.

Free white paper

Read "A Vision for Business Intelligence" for an overview on BI software and the impact it could have on your organization.

Download it now

802.11 Alphabet Soup

How well do you understand 802.11 standards? Visit the new SearchNetworking.com Wireless LAN Info Center and keep up on the latest developments in the booming WLAN industry.

Check it out

Browse our glossary

ETL, OLTP, BLOB... What do they all mean? Stay informed of the latest industry lingo with the SearchDatabase.com Glossary. Visit today to find meanings for acronyms and terms.

Find a meaning

ABOUTTHISNEWSLETTER

Created by TechTarget
TechTarget - The Most Targeted IT Media
Copyright 2003, All Rights Reserved.

To unsubscribe from Updates on new site content:

>> Simply Reply to this Email with REMOVE 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.

- Uncheck the box next to the newsletter you wish to unsubscribe from.

- When finished, click "Save Changes to My Profile".

DBA Tips: Comparing timestamps in SQL Server, Automatic coalesce in Oracle, and more...

2003-03-05 Thread SearchDatabase.com

SEARCHDATABASE.COM | Database Administrator Tips
March 5, 2003

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
FROM OUR SPONSOR:

FREE WHITE PAPER: Oracle data access from .NET 
http://searchDatabase.com/r/0,,10994,00.htm?compuware 
 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

IN THIS ISSUE | Table of Contents

1. DATABASE ADMINISTRATOR TIPS 
  - DB2: Dropping a column in DB2 7.2
  - SQL Server: Comparing timestamps
  - Oracle: Automatic coalesce of all tablespaces
  - More recent tips from members
 
2. IMPORTANT ANNOUNCEMENTS AND LINKS
  - Free webcast: Business intelligence
  - Ask the experts: Your database questions answered
  - Featured Topic: The challenge of integration

___
 Sponsored by: Compuware **

LEARN how you can analyze and debug PL/SQL completely within the
Visual Studio environment to save time in development. Get expert
advice on accessing and manipulating database objects, without
switching back and forth between two separate environments. Now
that's a technique you'll want to learn. Read on. REGISTER FOR FREE
DOWNLOAD HERE: 

http://searchDatabase.com/r/0,,10994,00.htm?compuware 

*** 

___
THIS WEEK'S TIPS:

DROPPING A COLUMN IN DB2 7.2 | Prashant Dahalkar

Here is a simple way to drop a column to update your DB2 7.2
databases if you do not use third-party software.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci881687,00.html


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
COMPARING TIMESTAMPS | Baya Pavliashvili

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.

 CLICK for the full tip...
http://www.searchDatabase.com/tip/1,289483,sid13_gci876848,00.html

 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
AUTOMATIC COALESCE OF ALL TABLESPACES | Max Mangoni

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.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci883724,00.html

___
MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS:

GETTING STARTED WITH DB2 APPLICATION TUNING | John Irwin 
http://www.searchDatabase.com/tip/1,289483,sid13_gci881905,00.html
This article looks into some of the steps necessary to locate and
tune DB2 application performance problems.

SQL SERVER ADMINISTRATION DOS AND DON'TS | Meredith Derby 
http://www.searchDatabase.com/tip/1,289483,sid13_gci880458,00.html
Ignore these simple SQL Server admin tips at your peril!

USE AUTONOMOUS TRANSACTIONS TO RECORD TO LOGS | Jagadeesh Nooli 
http://www.searchDatabase.com/tip/1,289483,sid13_gci879431,00.html
Here's a quick script that shows you how to write to logs for
transactions irrespective of whether the transaction commits or rolls
back.

SQUEEZE THE SIZE OF FILES IN A TABLESPACE | Sergey Solodilov  
http://www.searchDatabase.com/tip/1,289483,sid13_gci879433,00.html
This tip decreases the size of files of a tablespace to the bare
minimum. It's useful when you have many files in a tablespace and
you've moved some tables or indexes into another tablespace, and then
you want to decrease the size of the first tablespace.

GETTING THE LAST ROW FROM A TABLE | Sunil Bhola
http://www.searchDatabase.com/tip/1,289483,sid13_gci840260,00.html
Everyone knows that how to get first row from a table but what if you
want to get the last row and don't know how many rows are in the
table? This query will solve it!

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 WEBCAST | SearchDatabase.com

TOPIC: Business intelligence: From inception to implementation  
SPEAKER: Shaku Atre, author of Business Intelligence Roadmap

Listen and learn as BI expert, Shaku Atre, discusses the different 
facets of business intelligence and how they can ultimately help you 
increase your bottom line. She will explain how to take your BI
project from implementation to fruition. Learn about:

 * The major

This week: PL/SQL tips and scripts

2003-03-10 Thread SearchDatabase.com

Title: TechTarget

March 10, 2003

Receive this email as text About this email

In this Issue

From the editor:
Profiles in data management

Featured Topic:

PL/SQL tips and scripts
by Tim DiChiara, Site Editor
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.

Read more about this topic

Expert Technical Advice:

Featured Expert: Craig Mullins,
Director of DB2 Technology Planning, BMC Software

Categories:DB2
Craig has extensive experience in the field of
database management, having worked as an application
developer, a DBA and an instructor with multiple database
management systems, including DB2, Oracle and SQL Server.
Additionally, Craig worked as a Research Director with the
Gartner Group covering the field of database administration.
He is the author of the DB2 Developer's Guide, the
industry-leading book on DB2 for OS/390, and has published
more than 100 articles on database technology. Ask Craig your
tough DB2 questions!

View all of Craig's answers

This Week: In the forums

Connect DB2 to Oracle

Description: Member "odir" is wondering if there is a way to connect his DB2 to Oracle DB from an iSeries AS/400 script?. Go to our "DB2 Tech Forum" to offer your two cents.

Installing Oracle 8i client using IIS Server

Member "irishstudent" is trying to connect Oracle 8i through Dreamweaver Ultradev using an IIS server on Windows XP but is having problems with installing the Oracle client. Go to our "Database-to-Web Connectivity" forum if you can help.

Tip of the Week:
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 tutorial.

Comparing timestamps in SQL Server

Site Highlights

Free business application white paper
Discover how you can leverage the power of the desktop
Improve the productivity of remote workers with new distribution, replication, and synchronization technologies.

Best Web Links: Database Basics
If you are a new DBA or just looking to refresh your memory, then bookmark this page today
Visit this popular category for some resources to help make your life easier -- including case studies, FAQs and more.

Business intelligence with SQL Server
Hear

This week: PL/SQL tips and scripts

2003-03-10 Thread SearchDatabase.com

Title: TechTarget

March 10, 2003

Receive this email as text About this email

In this Issue

From the editor:
Profiles in data management

Featured Topic:

Read more about this topic

Expert Technical Advice:

Featured Expert: Craig Mullins,
Director of DB2 Technology Planning, BMC Software

View all of Craig's answers

This Week: In the forums

Connect DB2 to Oracle

Description: Member "odir" is wondering if there is a way to connect his DB2 to Oracle DB from an iSeries AS/400 script?. Go to our "DB2 Tech Forum" to offer your two cents.

Installing Oracle 8i client using IIS Server

Comparing timestamps in SQL Server

Site Highlights

Business intelligence with SQL Server
Hear

Webcast premiere: Reducing the total cost of wide area data access

2003-03-11 Thread SearchDatabase.com

Dear SearchDatabase.com member,

Please join us for an informational vendor webcast, Reducing the
total cost of wide area data access. Listen to 20 year industry
veteran, Tim Yeaton, as he explains how you can dramatically
reduce the complexity and cost of wide area data access.
Join us for this educational webcast today.
http://searchDatabase.com/r/0,,10659,00.htm?avaki
--
TITLE: Reducing the total cost of wide area data access
with Avaki

SPEAKER: Tim Yeaton, president, Avaki
SPONSOR: Avaki
http://www.avaki.com

ATTEND TODAY:
http://searchDatabase.com/r/0,,10659,00.htm?avaki
---

--
ABOUT THIS VENDOR WEBCAST:
--
Delivering consistent and current data to knowledge workers at
multiple sites is a challenge. For sites with diverse infrastructures
and security requirements, it can be hard to provide secure and
efficient access. In this informative webcast, Avaki President Tim
Yeaton will discuss:

* The factors that contribute to the cost of wide-area data access.
* The pros and cons of approaches - such as FTP, data replication,
VPNs and DMZs.
* How companies can achieve breakthrough reductions in
infrastructure complexity and cost.

Join us today for this insightful vendor webcast you don't want to
miss.
http://searchDatabase.com/r/0,,10659,00.htm?avaki

* SPONSORED BY: AVAKI **
** FREE WHITE PAPER on Wide Area Data Access.**
When critical data spans locations, departments, and companies,
wide area access can help control costs and improve productivity
across the organization. Learn how you can tie together IT
infrastructure, so users and applications can access distributed
data as if it were local.

Get your FREE copy now at: http://www.avaki.com/rd?101

--
ABOUT THE SPEAKER:
--

As Avaki's President, Tim Yeaton oversees the company's overall
strategic direction and business operations. With more than 20
years experience in the technology industry, Tim joined Avaki
from Macromedia, where he served as Senior Vice President and
General Manager of the company's Server Products. He joined
Macromedia in March of 2001, as a result of the merger with
Allaire Corporation, where he served as Senior Vice President
of Products, with overall responsibility for the company's
complete line of products and services.

Prior to Allaire, Tim held the position of Vice President
and General Manager of Compaq's UNIX/Linux Software Division
where he led the company's UNIX and Linux business strategies,
including product planning and development, business management
and marketing.

===
To subscribe to Daily News go to:
http://searchDatabase.techtarget.com/OptIn/1,290894,sid13,00.html?cid=459911em=tid=242FE=1

Not a searchDatabase member? We'll activate your membership with your
subscription.
===

-- Invite a colleague --

If you think today's webcast topic would interest your
colleagues, simply forward them this invitation.

___
ABOUT THIS NEWSLETTER :

Published by TechTarget (http://www.techtarget.com)
TechTarget - The Most Targeted IT Media
Copyright 2003, All Rights Reserved.

DBA tips: Upgrading SQL Server, Dynamic SQL, and more...

2003-03-12 Thread SearchDatabase.com

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

New white paper: A Vision for Business Intelligence

2003-03-12 Thread SearchDatabase.com

Dear SearchDatabase.com member,

Take a minute today to read this free white paper, A Vision for
Business Intelligence: Engendering a Quiet Revolution in the Business
Place. Click here to read it today:
http://searchDatabase.com/r/0,,11337,00.htm?Microstrategy 

==
ABOUT THIS FEATURED WHITE PAPER SPONSORED BY MICROSTRATEGY
==
Implementing an effective business intelligence strategy can help
your organization realize maximum profitability throughout its
database initiatives. A Vision for Business Intelligence presents
an overview of increasingly critical BI technology and emphasizes the
impact BI can have on your end-users. 

This white paper highlights: 
** Business intelligence software capabilities
** The technology behind BI, delivered in a clear
   and concise format
** A new perspective on BI and its role in your organization
** And more! 

Don't miss your chance to learn more about BI software and the impact
it could have on your organization. Download this white paper now:
http://searchDatabase.com/r/0,,11337,00.htm?Microstrategy 

~
ACCESS MORE INFORMATION ABOUT THIS TOPIC:
Check out these resources from SearchDatabase.com for more on
business intelligence:

** WHITE PAPERS: For more white papers on data analysis and business
intelligence, click here: http://searchDatabase.com/r/0,,11325,00.htm

** BEST WEB LINKS: For resources on data warehousing and business
intelligence, click here: http://searchDatabase.com/r/0,,11326,00.htm

** ASK THE EXPERTS: Ask your BI questions to our data warehousing
experts, click here: http://searchDatabase.com/r/0,,11327,00.htm 

~

===
To subscribe to Daily News go to:
http://searchDatabase.techtarget.com/OptIn/1,290894,sid13,00.html?cid=460031em=tid=242FE=1

Not a searchDatabase member? We'll activate your membership with your
subscription.
===

===
ABOUT MICROSTRATEGY
===
MicroStrategy is a worldwide leader in the increasingly critical
business intelligence software market. MicroStrategy's 7i business
intelligence platform gives leading Fortune 500 organizations across
all industries solutions to all of their query, reporting and
advanced analytical needs, and distributes insight to users via web,
wireless and voice. 

~
Tell a colleague about the SearchDatabase.com White Paper Library -
Simply forward this e-mail. 
http://searchDatabase.com/r/0,,11328,00.htm 
~


___
  ABOUT THIS NEWSLETTER   :

Published by TechTarget (http://www.techtarget.com)
 TechTarget - The Most Targeted IT Media
 Copyright 2003, All Rights Reserved.

If you no longer wish to receive this newsletter simply reply to this
message with REMOVE in the subject line.  Or, visit
http://searchDatabase.techtarget.com/register and adjust your
subscriptions accordingly.If you choose to unsubscribe using our
automated processing, you must send the REMOVE request from the
email account to which this newsletter was delivered.  Please allow
24 hours for your REMOVE request to be processed.

Hundreds of database terms defined

2003-03-18 Thread SearchDatabase.com

Dear SearchDatabase.com member,

ACID, BLOB, DAO, SDLC, MOLAP, UML... And the list of terms goes on.
If you don't know the meaning of an acronym or term you come across,
don't worry! Now you can look up definitions for hundreds of
technical terms in our new SearchDatabase.com Glossary. Browse our
glossary today -- click here:
http://searchDatabase.com/r/0,,11494,00.htm

Terms are listed in alphabetical subcategories -- making it easy for
you to find what you want quickly and easily. Or you can do a quick
search with our search box for the term that has you stumped.

VISIT THE SEARCHDATABASE.COM GLOSSARY TODAY
Our editorial team constantly updates the glossary with the latest
terms to help you keep current on new developments. Don't wait!
Bookmark this page today for easy reference when you come across
unfamiliar terms -- you can't afford not to:
http://searchDatabase.com/r/0,,11494,00.htm

Don't see the term or acronym you're looking for? Let us know! E-mail
to our editor at: mailto:[EMAIL PROTECTED]

===
To subscribe to Daily News go to:
http://searchDatabase.techtarget.com/OptIn/1,290894,sid13,00.html?cid=460287em=tid=242FE=1

Not a searchDatabase member? We'll activate your membership with your
subscription.
===

Don't keep this information-packed glossary a secret! Tell your peers
about the new SearchDatabase.com Glossary. Simply forward this
e-mail.
http://searchDatabase.com/r/0,,11494,00.htm

___
ABOUT THIS NEWSLETTER :

Published by TechTarget (http://www.techtarget.com)
TechTarget - The Most Targeted IT Media
Copyright 2003, All Rights Reserved.

Unsubscribe from 'Updates on new site content'
- Simply Reply to this Email with REMOVE 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.
- Uncheck the box next to the newsletter you wish
to unsubscribe from.
- When finished, click Save Changes to My Profile.

DBA Tips: Upgrading to DB2 7.1, automate backups, and more...

2003-03-19 Thread SearchDatabase.com

SEARCHDATABASE.COM | Database Administrator Tips
March 19, 2003

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
FROM OUR SPONSOR:

Data Center Futures: Apply for free admission
http://datacenterfutures.techtarget.com/?Offer=DCFnewsdb

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

IN THIS ISSUE | Table of Contents

1. DATABASE ADMINISTRATOR TIPS 
  - DB2: Planning your upgrade to DB2 v7.1
  - SQL Server: Automate scheduled backups for all databases
  - Oracle: Random number between two integers
  - More recent tips from members
 
2. IMPORTANT ANNOUNCEMENTS AND LINKS
  - Free webcasts: Business intelligence with SQL Server, and more
  - Ask the experts: Your database questions answered
  - Featured Topic: T-SQL

___
 Sponsored by Data Center Futures * 

DATA CENTER FUTURES - HILTON CHICAGO HOTEL - JUNE 4-6. Gain FREE
admission to the only independent conference available today that
helps you build the most scalable and reliable data center for
tomorrow. Plan now to achieve a core technology foundation with a
full understanding of networking, security, storage, systems
management and more. Discover full benefits on our conference Web
site and apply for FREE admission today:

http://datacenterfutures.techtarget.com/?Offer=DCFnewsdb
___  
___
THIS WEEK'S TIPS:

PLANNING YOUR UPGRADE TO DB2 V7.1 | Jim Schesvold and John Irwin

In simple outline form, here are some tips and guidelines if you're
considering upgrading to DB2 v.7.1 from versions 4, 5, or 6.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci881912,00.html


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
AUTOMATE SCHEDULED BACKUPS FOR ALL DATABASES | Mike Weaver 

This script will 1) go through all SQL Server databases on a single
server and create a device for each database and 2) schedule a single
job with a task for each database to be backed up to a local
directory of your choice. It is very useful if want to do complete
scheduled backups of all your databases on a single server and you
need to know that the devices and scheduled tasks have been created
correctly and uniformly.

 CLICK for the full tip...
http://www.searchDatabase.com/tip/1,289483,sid13_gci867516,00.html

 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
RANDOM NUMBER BETWEEN TWO INTEGERS | Siva Val

Though Oracle provides an internal function to generate random
numbers, there is no function that gives a random number between any
two given integers. This quick script solves that problem.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci886755,00.html

___
MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS:

LIMIT ACCESS TO DATA BY TIME | Karen Mann  
http://www.searchDatabase.com/tip/1,289483,sid13_gci883234,00.html
Here is a way to grant access to a DB2 table for a specific period of
time so that users can see the data only during a specific time of
day. While a grant won't provide the solution, a view will. The
author created this view using DDL...

SCRIPT TO RUN LARGE DAILY SCHEMA EXPORTS | Robert Dow   
http://www.searchDatabase.com/tip/1,289483,sid13_gci821260,00.html
This is a script the author uses on AIX servers to run very large
daily Oracle schema exports. He uses the mknode method to trick the
export utility to generate a dump file  2 GB. 

ENABLE THE REFERENTIAL INTEGRITY CONSTRAINT | Ravi Gulati
http://www.searchDatabase.com/tip/1,289483,sid13_gci834318,00.html
Enable the foreign key constraints when you enable the primary key
constraints with this quick Oracle script.

USE TRIGGER PROGRAMS TO TRACK DB2 RECORD CHANGES | John Kohan
http://www.searchDatabase.com/tip/1,289483,sid13_gci868256,00.html
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.

UPGRADING SQL SERVER, PART I: OVERVIEW AND PROJECT PLANNING
http://www.searchDatabase.com/tip/1,289483,sid13_gci883965,00.html
First of a series by Jeremy Kadlec detailing the SQL Server upgrade
process from the technical, logistical and business perspective. 

AN EXAMPLE OF DYNAMIC SQL IN PL/SQL...OR NOT | Lucy Lynch
http://www.searchDatabase.com/tip/1,289483,sid13_gci809890,00.html
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.

BEYOND REPORTING: GETTING VALUE OUT OF YOUR DATA | John Wallace 
http://www.searchDatabase.com/tip/1,289483,sid13_gci884576,00.html
OLAP and business intelligence (BI) are key elements

This Week: Open source databases

2003-03-24 Thread SearchDatabase.com

Title: TechTarget

March 24, 2003

Receive this email as text About this email

In this Issue

From the Editor:
DBA profiles

Featured Topic:

Open source databases
by Tim DiChiara, Site Editor
Free, open source DBMSs such as MySQL and PostgreSQL have found significant niches in enterprise IT. Learn more with the collection of news, expert advice, and tech tips inside...

Read more about this topic

Expert Technical Advice:

Featured Expert
Tony Bain,
Senior Database Consultant, SQLServices.com

Categories: SQL Server
Description: Tony is a MCSE, MCSD, MCDBA and author of "VB.NET & SQL Server 2000: Building an Effective Data Layer." Ask him your tough SQL Server questions!

View all of Tony's answers

This Week: In the forums

Migrating from SQL Server 6.5 to 2000

Member "Jeg" is still wondering what the best method is to do the upgrade: use scripts and BCP or use the upgrade wizard? Go to our "DBA Water Cooler" forum to offer your two cents.

DTS workflow precedence problem

Member "Gilligan" is having some SQL Server scripting problems, specifically in some if/then logic. Go to our "SQL Server Tech Forum" if you can help.

Tip of the Week:
This Oracle query will answer the following questions: 1) Is there enough
space in my tablespaces to allocate the next N extents related to the
tables that have less than M % of free space left? and 2) What
percentage and amount of space will I be left with in case such
allocations occur?

Predicting the future of space usage

Site Highlights

Todd Barbera on the Job
Did you miss our first Profiles in Data Management?
Read our first installment featuring a sr. systems administrator & Oracle DBA for a Boston-based broadcasting company.

Database glossary
Can't find an industry acronym in Webster's? Need the "long" definition of a technical term?
Our glossary is here for you! If don't find a term in our dictionary, let us know. Our editors will find it and add it to the list!

Check out our database tips section
You'll find hints and tricks from other DBAs here.
Share the knowledge! Read the tips and then submit your own! Recently submitted tips include:
* Planning your upgrade to DB2 v7.1
* Limit access to date and time
* Export all the tables in a given schema
* Return all values in a comma-delimited string
* Upgrading from SQL server 7.0 to 2000

Update your subscriptions

Select newsletters you would like to receive from the list below.

Database Administrator Tips

Ask the Database Experts

Daily News

Email:

Not a member? We'll activate your membership with your subscription.

IOUG Live! 2003
April

DBA Tips: DB2 triggers, Oracle on Windows, and more...

2003-04-02 Thread SearchDatabase.com

SEARCHDATABASE.COM | Database Administrator Tips
April 2, 2003

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
FROM OUR SPONSOR:

Free Avaya white paper on business continuity
http://searchnetworking.techtarget.com/whitepaperPage/0,293857,sid7_gci883603,00.html 

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

IN THIS ISSUE | Table of Contents

1. DATABASE ADMINISTRATOR TIPS 
  - DB2: Working with triggers
  - SQL Server: ZIP files with a stored procedure
  - Oracle: Our experts on Windows problems
  - More recent tips from members
 
2. IMPORTANT ANNOUNCEMENTS AND LINKS
  - Ask the experts: Your database questions answered
  - Featured Topic: DBMS ROI and TCO

___
* Sponsored by: Avaya *

Free Avaya white paper: How the Seattle Times newspaper ensures
business continuity. Understand the benefits from IP Telephony
Without Reinventing Your Network. Avaya helped the Seattle Times
newspaper migrate to IP for the cost of a PBX upgrade -- and the
paper saved $180,000 in the first year. Find out how, sign up for the
free Avaya white paper now:

http://searchnetworking.techtarget.com/whitepaperPage/0,293857,sid7_gci883603,00.html 
  
*** 

___
THIS WEEK'S TIPS:

WORKING WITH TRIGGERS | Susan Lawson 

A trigger in DB2 is a set of actions that will be executed when a
defined event occurs. Here is a brief introduction.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci891630,00.html


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
ZIP FILES WITH A STORED PROCEDURE | Matt Harper 

A SQL Server stored procedure that zips files from a source and
destination directory you pass when calling the procedure.

 CLICK for the full tip...
http://www.searchDatabase.com/tip/1,289483,sid13_gci884575,00.html

 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
ASK THE EXPERTS: ORACLE ON WINDOWS

Running Oracle on Windows is a common enterprise setup, and
predictably, database administrators run into common problems with
it. To clear up the confusion, SearchDatabase.com's resident Oracle
experts Eli Leiba, Karen Morton and Brian Peasland offer their advice
for overcoming some frequent Windows frustrations.

 CLICK for the full tip... 
http://www.searchDatabase.com/originalContent/0,289142,sid13_gci887118,00.html

___
MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS:

SIMPLE ORACLE OBJECTS | Eli Leiba
http://www.searchDatabase.com/tip/1,289483,sid13_gci888174,00.html
Version 8i introduced simple objects in Oracle and so made the Oracle
database a true object-oriented environment. This article presents
short scripts that demonstrate how to build, use and maintain Oracle
simple objects. 

ASK THE EXPERTS: ORACLE BACKUP AND RECOVERY   
http://www.searchDatabase.com/originalContent/0,289142,sid13_gci885453,00.html
Designing and maintaining a solid backup and recovery process is the
most important task a DBA can do. SearchDatabase.com's resident
Oracle experts have answered many user-submitted questions over the
last year about the best ways to backup and recover mission-crtical
data. Here is a compilation of some recent Oracle backup and recovery
advice from gurus Brian Peasland and Karen Morton.

IS YOUR SQL OPTIMIZED? | David Quigley
http://www.searchDatabase.com/tip/1,289483,sid13_gci870113,00.html
This is a useful tip to help DBAs figure out if certain DB2 SQL has
been optimized. It gives information in text and graphic form that
shows how it's accessing tables and indexes. It also shows all the
objects used in the plan and information about those objects such as
tablesize, number of records, and more.

FINDING THE NTH MAXIMAL VALUE | Eli Leiba 
http://www.searchDatabase.com/tip/1,289483,sid13_gci880140,00.html
This extension to the MAX T-SQL function gets a tablename, column and
integer (N) as parameters and finds the Nth largest value of a column
in a specific table.

DETERMINE USED AND FREE SPACE IN A TABLESPACE | S. Sunitha
http://www.searchDatabase.com/tip/1,289483,sid13_gci887383,00.html
This small Oracle script can be executed as a script file from the
SQL*Plus prompt and reports the total size, used space, free space
and percentage of used and free space in all the tablespaces in a
database. Very useful for DBAs!

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:

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
YOUR TOUGH

DBA Tips: Oracle full table scans, upgrading SQL Server, and more...

2003-06-11 Thread SearchDatabase.com

SEARCHDATABASE.COM | Database Administrator Tips
June 11, 2003

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
FROM OUR SPONSOR:

Attention Oracle DBAs - Free Data Dictionary from Quest Software
http://searchDatabase.com/r/0,,14903,00.htm?questsoftware

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

IN THIS ISSUE | Table of Contents

1. DATABASE ADMINISTRATOR TIPS 
  - Upgrading SQL Server, part II: Critical upgrade decisions
  - Oracle: Find full table scans
  - DB2: Multiple sorts without using dynamic SQL
  - More recent tips from members
 
2. IMPORTANT ANNOUNCEMENTS AND LINKS
  - Ask the experts: Your database questions answered
  - Featured Topic: Data center futures

___
* Sponsored by Quest Software *

Is your Oracle database running at full speed? Can you identify
bottlenecks and code that needs tuning? Find out how Quest Software
can help with a Database Health Check. Learn more by attending a free
live demo of Quest Central(tm) for Oracle. Register today and get a
free online Oracle data dictionary:  

http://searchDatabase.com/r/0,,14903,00.htm?questsoftware  
  
*** 

___
THIS WEEK'S TIPS:

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
UPGRADING SQL SERVER, PART II: CRITICAL UPGRADE DECISIONS

Jeremy Kadlec continues his series detailing the SQL Server upgrade
process from the technical, logistical and business perspective. This
time, he discusses SQL Server 6.5 to 2000 critical upgrade decisions
and redundant upgrade architecture.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci904447,00.html


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
FIND FULL TABLE SCANS | Sanjay Gupta

This tip is useful for identifying all full table scans (FTS)
occuring in your Oracle database. Doing a FTS on big tables often
causes performance problems. There are many tools available that
allow you to select a SQL statement and then present you with the SQL
plan; however, when you have thousands of SQL statements and you want
to find out only those statements that are going through a FTS, this
is a better script.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci893666,00.html


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
MULTIPLE SORTS WITHOUT USING DYNAMIC SQL | Jim Haire  

Have you ever wanted the order of your data sorted differently based
on some condition?  You could do it by coding multiple cursors or
creating dynamic SQL.  Here is a way to do it with static SQL and
only one cursor.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci903834,00.html


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
PL/SQL CONTROL STRUCTURES: BEST PRACTICES | Steven Feuerstein

**Note corrected link!** Here are several best practices you should
take into account when you work with IF, FOR, WHILE, and GOTO
statements in PL/SQL.  

 CLICK for the full tip... 
http://searchdatabase.techtarget.com/tip/1,289483,sid13_gci904096,00.html

___
MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS:

ORACLE SEGMENT STATISTICS | Brian Peasland
http://www.searchDatabase.com/tip/1,289483,sid13_gci903793,00.html
The V$SEGMENT_STATISTICS dynamic performance view gives many
statistics about each and every segment that is used by the Oracle
database. Here's how to use it.

SCRIPT TO GRANT PERMISSIONS | Parthasarathy Mandayam
http://www.searchDatabase.com/tip/1,289483,sid13_gci901507,00.html
Here's a simple SQL Server script that can be customized to quickly
grant permissions to various users on all tables or stored
procedures. Using this script, the author was able to reduce the time
taken to grant permissions during installation from 30 minutes to 1
second!

DENORMALIZATION OF DB2 TABLES | Craig Mullins  
http://www.searchDatabase.com/tip/1,289483,sid13_gci903045,00.html
Speeding the retrieval of data from DB2 tables is a frequent
requirement for DBAs and performance analysts. One way to accomplish
this is to denormalize DB2 tables. However, it should be undertaken
only when a completely normalized design will not perform optimally.
Consider these issues before denormalizing... 

INTRODUCTION TO ORACLE DESIGN | Dave Ensor  Ian Stevenson
http://www.searchDatabase.com/tip/1,289483,sid13_gci903329,00.html
Covers what database design is, the various alternative methods and
approaches, planning the design phase, and much more. 

PL/SQL: WHAT, WHEN, AND WHERE | Bill Pribyl  Steven Feuerstein
http://www.searchDatabase.com/tip/1,289483,sid13_gci902939,00.html
What the Procedural Language/Structured Query Language (PL/SQL)
really is, what it is good

This Week: Achieving high availability

2003-06-23 Thread SearchDatabase.com

Title: TechTarget

June 23, 2003

Receive this email as text About this email

In this Issue

From the editor:
ERP shake-up recap

Featured Topic:

Achieving high availability
by Tim DiChiara, Site Editor

If you DBAs haven't yet reached the 'five nines' (99.999% uptime) for your mission-critical databases, you'll need the tips, tutorials, webcasts, and news analyses inside...

Read more about this topic

Expert Technical Advice:

Featured Expert: Pat Phelan,
Data modeler

View all of Pat's answers

This Week: In the forums

Write as one statement using CASE Member "Groovy" is wondering how to merge his three UPDATE statements into one so it reads through the table only once. Check out his code and go to our "SQL Server Tech Forum" if you can help.

Unable to install DB2 UDB v8 Member "Okonita" is having a difficult time installing DB2 UDB v8 Personal Edition for Linux, Unix, and Windows on his home PC. Check out what he's done so far and offer your two cents in our "DB2 Tech Forum".

Tip of the Week:
Rajendra Gutta's definitive cold backup and recovery scripts for
Oracle running under Sun Solaris, HP-UX and AIX. The first in a series of Oracle backup and recovery scripts for Oracle on Unix and Windows.

Oracle backup and recovery scripts, part I: Cold backup under Unix

Site Highlights

SearchDatabase.com delivered!
Have the information you want delivered to your desktop.
SearchDatabase.com delivers news, tips, upcoming whitepapers and webcasts right to you! Sign up today for one of our great newsletters!

Help for your purchasing decisions
Only you can determine the best data management solution for your company.
But you don't have to do it alone. Our Product and Vendor guide provides you with the research you need to make the most informed decision. Visit today!

Everything Oracle!
This Oracle page includes links and resources you need all in one place.
Find information in over 15 different categories including:
* Installation tips
* Free tools and scripts
* Security tips
* FAQs
* Performance and tuning tips
* Oracle reviews and comparisons

FREE EMAIL SERVICES!

Select newsletters you would like to receive from the list below.

Daily News

This week: Introducing SearchOracle.com

2003-07-07 Thread SearchDatabase.com

Title: TechTarget





 
   
   
   A weekly  newsletter from TechTarget
  
 



 

  



 
 
  
   July 07, 2003  
  
  Receive this email as text About this email
 
 


 
 
  
   

 
   

 
  
  
 
 
   
   

 
 

   
  
  In this Issue
 
 



 
 
  From the editor:
   SearchOracle.com debuts 
 
   
 
  Featured Topic:
   Introducing SearchOracle.com 
 
  
 
  Expert Technical Advice:
   New expert advice, forum posts, and tips 
 
  
 
  Site Highlights:
   * SQL Server Tips
* SearchDatabase.com's White Paper Library
* The E-Business Suite Update 
 
 

 


 
   


 
 


   
   

 
 

   
  
  From the Editor:
 



 
 
   


  by Tim DiChiara, Senior Site Editor 
   
 From the team that brings you SearchDatabase.com -- we're happy to announce the debut of SearchOracle.com. The mission of SearchOracle.com is to be the leading independent voice for you, the Oracle community. 
 
SearchOracle.com was created to arm enterprise DBAs, developers, and managers with the knowledge they need to implement and administer a successful Oracle shop. SearchOracle.com will cover the latest news and trends in both the Oracle and the data management industry, and provide a one-stop resource for technical advice about Oracle products, including the database management system, application server, application suite, development tools, and other technologies.
 
Check out all these quality (and free!) site features:
 

Oracle news and analysis
Oracle DBA tips and scripts
Advice from our panel of Oracle administration and PL/SQL experts
Webcasts with leading Oracle gurus such as Tom Kyte, Don Burleson, Mike Ault, and more
A huge Oracle link directory
Oracle and third-part vendor white papers
Oracle database and E-Business Suite discussion forums

 
SearchOracle.com is meant to be an advocate for you, so if you'd like to see coverage of a topic important to you, feel free to drop us a line at [EMAIL PROTECTED]. Thanks for supporting us!
 
Till next time, Tim DiChiara, Editor 
  
 


 


 
   


 
 


   
   

 
 

   
  
  Featured Topic:
 



 

   Introducing SearchOracle.com
   by Tim DiChiara, Senior Site Editor 
   
 We're very happy to introduce the independent voice for the Oracle user, our new sister site SearchOracle.com! Read more about who we are, what our mission is, and what you can expect to find on SearchOracle.com. 
   
   
   
Read more about this topic

 


 


 
   


 
 


   
   

 
 

   
  
  Expert Technical Advice:
 
 



 
   


  Featured Expert Pat Phelan, Data modeler

Category: Database design
Pat has an eclectic background that dates back to when the field was still called Data Processing and used punched cards. He has worked on systems ranging from IBM mainframes, through mini-computers (DEC, HP, PR1ME, etc), to microcomputers, to process control machines. Ask him your questions about database design! 
   
   View Pat's answers to previous questions 
  
 







 
   This Week: In the forums
  
 
 
  
  
   
   Hiding tables in SQL Server
Member "Tapan" wants to hide tables and table users but is wondering if doing so will stop users from running queries from Query Analyzer? Go to our "SQL Server Tech Forum" if you can help. 
  
   
  
  
   
   Learning a database language
Member "bowe" is a newbie looking to learn a useful database-web connectivity language. What's your favorite? One member chose JSP -- do you agree? Go to our "Database-web connectivity" forum if you can help. 
  
   




 Tip of the Week:
 Oracle backup and recovery scripts, part III: Backup and recovery under Windows NT
The third installment of Rajendra Gutta's series of hot and cold
backup and recovery script for Oracle, this time for the Windows NT
platform. Includes scripts, checklists, and troubleshooting tips. 
 
  Read full tip
 


 


 
   


 
 


   
   

 
 

   
  
  Site Highlights
 
 



 
  
   
   
SQL Server Tips
Get expert advice on Microsoft SQL Server development, management, performance, migration, integration and more.
Sign up for SearchDatabase.com's "SQL Server Tips" now
 

SearchDatabase.com's White Paper Library
Access hundreds of white papers on targeted database topics, including data security, enterprise Java, IBM DB2 and more!
Enter the library
  
  
  
  
  
  
   
The E-Business Suite Update
Click here to sign up now
Stay informed on the latest developments with Oracle applications -- sign up for the E-Business Suite Update, brought to you by our new sister site, SearchOracle.com.   
  
  
 


 
  
  
   
   

 
 
 

  
  
  
   
  
  
   

 
  

 
  New newsletters!

This week: Your thoughts about the Oracle/PeopleSoft saga

2003-07-14 Thread SearchDatabase.com

Title: TechTarget





 
   
   
   A weekly  newsletter from TechTarget
  
 



 

  



 
 
  
   July 14, 2003  
  
  Receive this email as text About this email
 
 


 
 
  
   

 
   

 
  
  
 
 
   
   

 
 

   
  
  In this Issue
 
 



 
 
  From the editor:
   Your thoughts about the Oracle/PeopleSoft saga 
 
   
 
  Featured Topic:
   Database design 
 
  
 
  Expert Technical Advice:
   New expert advice, forum posts and tips 
 
  
 
  Site Highlights:
   * Technical tips on DB2, SQL and more
* Database product and vendor research made simple
* White paper of the week: Data profiling in the beginning of the project life cycle 
 
 

 


 
   


 
 


   
   

 
 

   
  
  From the Editor:
 



 
 
   


  by Tim DiChiara, Senior Site Editor 
   
 A few weeks ago, I asked for your thoughts about the Oracle/PeopleSoft saga -- specifically your response to the surprising results of our poll showing 40% of SearchDatabase.com members believe that PeopleSoft customers would benefit from the merger. I also asked for feedback from those of you running PeopleSoft on SQL Server, which may have the most to lose.
 
A whole bunch of you offered your two cents. The comments were mostly hostile to Oracle, with Frank M.'s succinct comment representative: "Without question, PeopleSoft customers would suffer." However, a few of you pointed out the upsides to such a deal. Read what your peers think here.
 
Our brand-new sister site SearchOracle.com has complete coverage of the merger. Check it out for all the latest news, as well as technical tips, scripts and expert advice for the Oracle DBA and developer.
 
Till next time, Tim DiChiara, Editor 
  
 


 


 
   


 
 


   
   

 
 

   
  
  Featured Topic:
 



 

   Database design
   by Tim DiChiara, Senior Site Editor 
   
 Taking the time to design stable, fast and secure databases is critical for avoiding future administration headaches. To help you in this endeavor, we present a collection of tips about effective design inside... 
   
   
   
Read more about this topic

 


 


 
   


 
 


   
   

 
 

   
  
  Expert Technical Advice:
 
 



 
   


  Featured Expert Pat Phelan, Data modeler

Category: Database design
Pat has an eclectic background that dates back to when the field was still called Data Processing and used punched cards. He has worked on systems ranging from IBM mainframes, through mini-computers (DEC, HP, PR1ME, etc), to microcomputers, to process control machines. Ask him your questions about database design! 
   
   View Pat's answers to previous questions 
  
 







 
   This Week: In the forums
  
 
 
  
  
   
   Problems with DTS used for replication
Member "Rify" is trying to replicate a table from DB2/400 to SQL Server using DTS but is having access problems. Go to our "Data Warehousing and Data Analysis" forum if you can help. 
  
   
  
  
   
   How to hide tables in SQL Server
Member "Tapan" wants to hide tables and table users but is still wondering if doing so will stop users from running queries from Query Analyzer? Go to our "SQL Server" forum if you can help. 
  
   




 Tip of the Week:
 Build a Java servlet app that executes SQL statements against a database
This detailed tutorial by Joel Murach will show you how to use a Java servlet, JSP and a static Java class to interactively execute any standard SQL statement against any database. 
 
  Read the complete tip
 


 


 
   


 
 


   
   

 
 

   
  
  Site Highlights
 
 



 
  
   
   
Technical tips on DB2, SQL and more
Trying to add text search to DB2 applications? Wondering how to split delimiter-separated lists with a T-SQL UDF?
Browse SearchDatabase.com's collection of technical tips and access expert solutions to your toughest database-related challenges.
 

Database product and vendor research made simple
Don't waste your time scouring the Web for vendor information or product comparisons -- check out SearchDatabase.com's new Product and Vendor Guide!
Browse the Product and Vendor Guide now
  
  
  
  
  
  
   
White paper of the week
Download "Reveals the Meaning of Enterprise Data" now
The primary cause of failure in data warehousing and enterprise Application Integration projects is inadequate, misunderstood source data. In this white paper,  IDC examines how data profiling at the beginning of these projects will greatly reduce the risk of project failure along with saving companies time, money and frustrations. 
Sponsored By: Evoke Software

DBA Tips: Stress test SQL Server, Create serial number columns in DB2, and more...

2003-07-16 Thread SearchDatabase.com

SEARCHDATABASE.COM | Database Administrator Tips
July 16, 2003

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
FROM OUR SPONSOR:

Attention Oracle DBAs - Free Data Dictionary 
http://searchDatabase.com/r/0,,16157,00.htm?questsoftware 

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

IN THIS ISSUE | Table of Contents

1. DATABASE ADMINISTRATOR TIPS 
  - SQL Server: Generating a database population routine
  - Oracle: Check all active processes and the SQL hit ratio 
  - DB2: Creating serial number columns
  - More recent tips from members
 
2. IMPORTANT ANNOUNCEMENTS AND LINKS
  - Ask the experts: Your database questions answered
  - Featured Topic: Database design
  - Introducing SearchOracle.com

___
* Sponsored by Quest Software *

Is your Oracle database running at full speed? Can you identify
bottlenecks and code that needs tuning? Start down the path to Oracle
database healthtoday with a free, online Oracle data dictionary
compliments of Quest Software. Download your free data dictionary
now: 

http://searchDatabase.com/r/0,,16157,00.htm?questsoftware
  
*** 

___
THIS WEEK'S TIPS:

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
GENERATING A DATABASE POPULATION ROUTINE | Baya Pavliashvili

Here is a SQL Server script that will populate your data model with
data and stress test it prior to making it available to users. 

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci913717,00.html


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
CHECK ALL ACTIVE PROCESSES, THE LATEST SQL, AND THE SQL HIT RATIO

This quick script from member Rajesh George is useful for Oracle DBAs
in the process of tuning and identifying slow SQL. It will provide
information about the currently active sessions, the latest SQL, as
well as the hit ratio.

 CLICK for the full tip... 
http://www.searchOracle.com/tip/1,289483,sid41_gci913363,00.html

 NOTE: All Oracle-related tech tips have moved! Click here:
http://www.SearchOracle.com/


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
CREATING SERIAL NUMBER COLUMNS | Barrie Sosinsky

Auto-incrementing columns are important when you need serial numbers
or key fields for joins. In DB2 for versions 7 and later you can add
the IDENTITY clause to the CREATE TABLE statement to create such a
column. Here's how.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci914811,00.html

___
MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS:

SPLIT DELIMITER-SEPARATED LISTS | Andrew Novick
http://www.searchDatabase.com/tip/1,289483,sid13_gci911718,00.html
Creating and parsing lists of items in a string is a frequent
request. Here's a SQL Server UDF that shows you how to do it.

TOP 20 DB2 PERFORMANCE MYTHS | Richard A. Yevich  Susan Lawson  
http://www.searchDatabase.com/tip/1,289483,sid13_gci910646,00.html
Think you know DB2 performance tuning? Think again! Yevich and Lawson
debunk some commonly-held beliefs about DB2 performance.

FIND OUT ABOUT TEMP/SORT AREA USAGE | Rajesh George
http://www.searchOracle.com/tip/1,289483,sid41_gci913360,00.html
This Oracle script will give you an idea about the existing usage of
the TEMP/SORT area. If you are frequently getting outputs for the SQL
in this tip, you have a shortage of sort area in memory or you need
to fine tune application SQL. 

BUILD A SERVLET-BASED APP THAT EXECUTES SQL AGAINST A DATABASE
http://searchoracle.techtarget.com/tip/1,289483,sid41_gci913448,00.htm 
This tutorial by Joel Murach will show you how to use a Java servlet,
JSP, and a static Java class to interactively execute any standard
SQL statement against any database, including Oracle.

BACKUP AND RECOVERY UNDER WINDOWS NT | Rajendra Gutta
http://searchoracle.techtarget.com/tip/1,289483,sid41_gci912782,00.html
The third installment of Rajendra Gutta's series of hot and cold
backup and recovery script for Oracle, this time for the Windows NT
platform. Includes scripts, checklists, and troubleshooting.

ORACLE BACKUP AND RECOVERY SCRIPTS, PART II: HOT BACKUP UNDER UNIX
http://searchoracle.techtarget.com/tip/1,289483,sid41_gci911798,00.html
Rajendra Gutta continues his series of quality backup and recovery
script for Oracle on Unix. Includes scripts, checklists, and
troubleshooting.

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

This week: Summertime database hits

2003-07-21 Thread SearchDatabase.com

Title: TechTarget

A weekly newsletter from TechTarget

July 21, 2003

Receive this email as text About this email

In this Issue

From the editor:
The best thing since SQL

Featured Topic:
Summertime database hits

Expert Technical Advice:
New expert advice, forum posts, and tips

Site Highlights:
* Targeted Oracle resources
* 24/7 access to database experts
* Free chapter excerpt from "Oracle 9i JDeveloper Handbook"

From the Editor:

by Tim DiChiara, Senior Site Editor

I recently read an excellent article over at DevX, which made the startling claim that Java Data Objects (JDO) are "the best thing since the database industry standardized on SQL about 25 years ago."

According to the author, before JDO, database programming was "stuck in the '80s," with only cumbersome SQL to work with. Developers tried many times to solve the impedance mismatch between the application code (objects) and the data store code (tables, rows, columns, and SQL) but never succeeded until JDO.

There's only one thing holding JDO back from taking over the world: the relational database vendors themselves. The DBMS vendors "are not endorsing the open standard yet because it removes the vendor lock-in they have enjoyed and nurtured for the past 20 years."

What do you think? Is JDO the answer to all your database development problems? Relational evangelists like Chris Date and his sycophants would undoubtedly disagree. Does SQL suffice for all your needs now? Do you think the superiority of .NET makes the debate irrelevant? We will cover JDO more on SearchDatabase.com -- and lobby for JDO adoption on your behalf to the vendors -- if you deem it worthwhile. Email me at [EMAIL PROTECTED] and let me know!

(On a related note, our extensive Java coverage is now split between Oracle-specific tips, news, and advice on SearchOracle.com and general Java and DB2-related information on SearchDatabase.com.)

Till next time, Tim DiChiara, Editor

Featured Topic:

Summertime database hits
by Tim DiChiara, Senior Site Editor

Although it's the height of summer here in the northern hemisphere, data management still takes precedence over margaritas. We analyzed our stats and came up with a list of your favorite tips, advice, and news so far this summer. Enjoy!

Read more about this topic

Expert Technical Advice:

Featured Expert Mike Lampa, CEO, BAG, Inc.

Category: Database design

Mike is co-founder and CEO of BAG, a business intelligence consultancy. He has over 21 years experience in strategic planning, program management, and designing, building and supporting data warehouse and operational data store implementations. Intricately involved in the daily activities of BAG, Mr. Lampa can often be found building data and process models to aid in improved operations efficiency and decision support automation for clients.

View Mike's answers to previous questions

This Week: In the forums

Difference between paging and swapping in Oracle?
Member "naveens32" is wondering what is the difference between paging and swapping in Oracle. Go to our "Oracle Administration" forum if you can help.

Problem with the outer join
Member "smahamkl" is looking for suggestions about how to optimize the performance of a SQL query with a few left outer joins? Go to our "SQL Server Tech Forum" if you can help.

Tip of the Week:
Generating a SQL Server population routine
Many data models work very well with a handful of rows but fail miserably when the application grows. This is why it is important to populate your data model with data and stress test it prior to making it available for users. Here's how in SQL Server.

Read complete tip

Site Highlights

Targeted Oracle Resources
Our new sister site SearchOracle.com features targeted newsletters in such categories as E-Business Suite and Oracle Administration.
Click here for more information

24/7 access to database experts
SearchDatabase.com's Ask the Expert section features a select group of top gurus on such topics as OODBMS, SQL, data warehousing and more.
Click here for more information about our panel of industry experts.

Webcast Alert: DB2 for z/OS security

2003-07-23 Thread SearchDatabase.com

The new version 8 of DB2 for z/OS provides many enhancements for
security. Tune-in now and listen as Roger Miller, lead DB2 strategist
for IBM, shares his expertise concerning the latest security upgrades
in version 8 of DB2 for z/OS. Attend now:
http://searchDatabase.com/r/0,,16230,00.htm

TITLE: DB2 for z/OS security
WHEN:AVAILABLE NOW
SPEAKER: Roger Miller, lead DB2 strategist, IBM Silicon Valley
Laboratory
SPONSOR: SearchOracle.com
http://searchOracle.com/r/0,,16014,00.htm

JOIN US TODAY!
http://searchDatabase.com/r/0,,16230,00.htm

-- SPONSORED BY: SEARCHORACLE.COM --
The new SearchOracle.com features unbiased database industry news,
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 - click here for a full
list:
http://searchOracle.com/r/0,,16014,00.htm

ABOUT THIS WEBCAST

Listen as top IBM DB2 guru Roger Miller discusses how to effectively
secure the latest version of DB2. Register for this webcast now and
you'll receive more information on:

** Upgraded security features
** New options for granularity, integration and ease of use
** Additional flexibility in applications and SQL
** And more!

Don't miss your chance to hear an expert overview of version 8 of DB2
for z/OS - attend now:
http://searchDatabase.com/r/0,,16230,00.htm

ABOUT THE SPEAKER

Roger Miller has worked nearly a quarter century on DB2 development,
product design and strategy. He often helps customers to use the
product, answers many questions and presents frequently to user
groups. He was a customer for ten years before working on many facets
of DB2, ranging from overall design issues to SQL, languages,
install, security, audit, standards, performance, concurrency, and
availability. He is currently lead DB2 strategist at IBM's Silicon
Valley Laboratory.

===
To subscribe to DB2 Tips go to:
http://searchDatabase.techtarget.com/OptIn/1,290894,sid13,00.html?cid=466137em=tid=252FE=1

Not a SearchDatabase.com member? We'll activate your membership with
your subscription.
===

INVITE A COLLEAGUE

If you think this webcast would interest your colleagues, simply
forward them this invitation.

Visit SearchTechTarget.com today for the latest IT news, webcasts,
white papers and more from additional IT-specific Web sites within
the TechTarget network.
http://searchtechtarget.com/?Offer=sttfoot

: ABOUT THIS NEWSLETTER ::
This newsletter is published by TechTarget, the most targeted IT
media. http://www.techtarget.com

Unsubscribe from 'Updates on upcoming online events'
- Simply Reply to this E-mail with REMOVE 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.
- Uncheck the box next to the newsletter you wish
to unsubscribe from.
- When finished, click Save Changes to My Profile.

This week: Oracle geeks of the round table

2003-07-28 Thread SearchDatabase.com

Title: TechTarget

A weekly newsletter from TechTarget

July 28, 2003

Receive this email as text About this email

In this Issue

From the editor:
Oracle geeks of the round table

Featured Topic:
Database Administration 101

Expert Technical Advice:
New expert advice, forum posts, and tips

Site Highlights:
* Oracle Discussion Forums
* 24/7 expert advice
* Webcast series: The 2003 Guide to Web Services

From the Editor:

by Tim DiChiara, Senior Site Editor

"There was just a lot of nerds standing around having fun...No magicians or naked ladies or anything. Just the ability to come and talk to people who have nothing to sell."

That's how Mogens Norgaard described his experience at OracleWorld in Denmark this year. Norgaard is a founder of the "Oak Table Network," a group of elite Oracle gurus, authors, and consultants that will also be appearing at September's OracleWorld in San Francisco. Our News Editor Ellen O'Brien recently profiled the OTN in a fun article Oracle geeks of the round table.

We've featured many of the geeks' work on SearchDatabase.com and SearchOracle.com over the years, including Anjo Kolk's very popular webcast series:

The death of the buffer cache hit ratio
Off-the-shelf or great performance: An Oracle applications dilemma is resolved

Does anybody know of a similar cult of SQL Server or DB2 gurus out there? If so, email me and we'll profile them as well.

Till next time, Tim DiChiara, Editor

Featured Topic:

Database Administration 101
by Tim DiChiara, Senior Site Editor

What does the modern enterprise DBA do? In today's challenging multi-DBMS environments, the answer is "just about everything." Inside is a collection of tutorials and expert advice about the most important job duties of a DBA...

Read more about this topic

Expert Technical Advice:

Featured Expert Mike Lampa, CEO, BAG, Inc.

Category: Database design
Mike is co-founder and CEO of BAG, a Texas-based business intelligence consultancy. He has over 21 years experience in strategic planning, program management, and designing, building and supporting data warehouse and operational data store implementations. Intricately involved in the daily activities of BAG, Mr. Lampa can often be found building data and process models to aid in improved operations efficiency and decision support automation for clients.

View Mike's answers to previous questions

This Week: In the forums

DB2 CCSID - PQ56697
Member "maf" is upgrading to DB2 V7 for OS/390 but a ptf relating to CCSID is causing him some concern. PQ56697 seems to say that he would have to convert any tablespace that has a zero in the CCSID field before upgrading to V7 and that all tables would need to be changed at the same time. Has anyone encountered this situation? Go to our "DB2 Tech Forum" if you can help.

Translating the FORMAT function to T-SQL
Member "Ricky" is migrating from Microsoft Access to SQL Server and is experiencing problems with the translation of the FORMAT function in Access SQL to T-SQL. Any advice? Go to our "SQL Server Tech Forum" if you can help.

Tip of the Week:
List privileges granted to a user on DB2
This handy script will list all the privileges granted (directly and indirectly) to the user of your DB2 DBMS.

Read the complete tip

Site Highlights

Oracle Discussion Forums
Our sister site SearchOracle.com features discussion forums on Oracle Database Administration, Data Warehousing and BI, E-Business Suite and more!
Interact with fellow Oracle developers and DBAs now.

24/7 expert advice
Our Ask the Expert section features leading authorities on such topics as OODBMS, DB2, SQL server and more.
Click here for more info on SearchDatabase.com's panel of industry experts.

Webcast series: The 2003 Guide to Web Services
Click here for more information
This webcast series will address the ever-changing Web services technologies and provide you with the most current view of Web services including the new economics of integration,

DBA Tips: SQL Server data migration, reorganizing Oracle tables, and more...

2003-08-14 Thread SearchDatabase.com

SEARCHDATABASE.COM | Database Administrator Tips
August 13, 2003

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
FROM OUR SPONSOR:

Attention Oracle DBAs - Free Data Dictionary 
http://searchDatabase.com/r/0,,17007,00.htm?questsoftware 

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

IN THIS ISSUE | Table of Contents

1. DATABASE ADMINISTRATOR TIPS 
  - SQL Server: Data migration script for static tables
  - SQL Server: Use the firehose cursor
  - Oracle: Reorganize a table and release the unused space
  - More recent tips from members
 
2. IMPORTANT ANNOUNCEMENTS AND LINKS
  - Ask the experts: Your database questions answered
  - Featured Topic: Data management career tips

___
*** Sponsored by Quest Software *** 

Is your Oracle database running at full speed? Can you identify
bottlenecks and code that needs tuning?  Start down the path to
Oracle database health today with a free, online Oracle data
dictionary compliments of Quest Software. Download your free data
dictionary now! 

http://searchDatabase.com/r/0,,17007,00.htm?questsoftware 
  
*** 

___
THIS WEEK'S TIPS:

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
DATA MIGRATION SCRIPT FOR STATIC TABLES | Rajasekhar Sahitala
 
Suppose that you have an application in which you have a table
containing static data and you need this data whenever you recreate
the database. Using this SQL Server script, you can create a batch of
insert statements that you can keep in your database creation script
and start using the database after the database creation without
reloading any data. 

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci915924,00.html


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
USE THE FIREHOSE CURSOR | Barrie Sosinsky

SQL Server supports several types of cursors but one read-only,
non-scrollable cursor that is specially optimized for fast
performance and worthy of note is the firehose cursor. Here's a short
introduction.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci911716,00.html


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
A SIMPLE WAY TO REORGANIZE A TABLE AND RELEASE THE UNUSED SPACE

This tip from member Debajit Mishra describes a simple solution to
better manage the table space and performance during ETL operations
in Oracle 9i.

 CLICK for the full tip... 
http://www.searchOracle.com/tip/1,289483,sid41_gci918141,00.html

 NOTE: All Oracle-related tech tips have moved! Click here:
http://www.SearchOracle.com/tips

___
MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS:

RESEEDING IDENTITIES IN SQL SERVER | Baya Pavliashvili
http://www.searchDatabase.com/tip/1,289483,sid13_gci913732,00.html
Reseeding identities in IDENTITY columns are commonly used as primary
keys for SQL Server tables. Here are some tips about reseeding
identities and some pitfalls to avoid.

JDBC: DATABASE PROGRAMMING WITH J2EE | Art Taylor
http://www.searchDatabase.com/tip/1,289483,sid13_gci917202,00.html
As a registered member of SearchDatabase.com, you're entitled to a
complimentary copy of Chapter 1 from JDBC: Database programming with
J2EE written by Art Taylor and published by Prentice Hall PTR. This
chapter focuses on JDBC design, how Java works with relational
databases, the JDBC API and more. 

HOW TO USE RESUMABLE SPACE ALLOCATION IN ORACLE 9I | Sanjay Gupta
http://www.searchOracle.com/tip/1,289483,sid41_gci915006,00.html
This tip discuss how to use a new feature in Oracle 9i called
Resuamable Space Allocation. Before 9i, it was not possible to
suspend a session when some space-related problem occured, so as a
result, whole transactions got rolled back and you had to start your
work all over again.

GENERATING A DATABASE POPULATION ROUTINE | Baya Pavliashvili
http://www.searchDatabase.com/tip/1,289483,sid13_gci913717,00.html
Here is a SQL Server script that will populate your data model with
data and stress test it prior to making it available to users. 

CHECK ALL ACTIVE PROCESSES, THE LATEST SQL, AND THE SQL HIT RATIO
http://www.searchOracle.com/tip/1,289483,sid41_gci913363,00.html
This quick script from member Rajesh George is useful for Oracle DBAs
in the process of tuning and identifying slow SQL. It will provide
information about the currently active sessions, the latest SQL, as
well as the hit ratio.

CREATING SERIAL NUMBER COLUMNS | Barrie Sosinsky
http://www.searchDatabase.com/tip/1,289483,sid13_gci914811,00.html
Auto-incrementing columns are important when you need serial numbers
or key fields for joins. In DB2 for versions 7 and later you can add
the IDENTITY clause to the CREATE TABLE

Webcast Alert: Oracle performance tuning, part 1

2003-08-14 Thread SearchDatabase.com

Performance tuning is an integral factor in running a successful
Oracle shop. Our expert series on performance tuning features
informative tips on every aspect from disk I/O to SQL. Tune-in to
part 1 of the Oracle performance tuning series now:
http://searchDatabase.com/r/0,,16844,00.htm


TITLE:   Oracle performance tuning, part 1
WHEN:AVAILABLE NOW 
SPEAKER: Don Burleson, Author and Principal of BEI Oracle Consulting
SPONSOR: SearchOracle.com
 http://searchOracle.com/r/0,,16833,00.htm  

JOIN US TODAY!
http://searchDatabase.com/r/0,,16844,00.htm 


-- TARGETED ORACLE  DATABASE NEWSLETTERS --
SearchOracle.com features unbiased database industry news, 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 - click here for a full list: 
http://searchOracle.com/r/0,,16833,00.htm  



ABOUT THIS WEBCAST 

This three-part webcast series with expert Don Burleson covers
various components of Oracle performance tuning, from fundamental
tactics to advanced tuning tricks. Part 1 presents an overview of
Oracle performance tuning essentials. 

Part 1 of this webcast series covers:
** How to tune disk I/O
** Influences from the server
** And more!

Tune-in to this expert webcast now:
http://searchDatabase.com/r/0,,16844,00.htm


ABOUT THE SPEAKER 

Don Burleson has more than 20 years of full-time DBA experience, and
has written 14 books, including Oracle high-performance SQL tuning
and most recently the Oracle9i UNIX Administration Handbook. He has
also published more than 60 articles in national magazines, serves as
Editor-in-Chief of Oracle Internals magazine, and is owner of BEI
Oracle Consulting.

===
To subscribe to Oracle Daily News go to:
http://searchOracle.techtarget.com/OptIn/1,290894,sid41,00.html?cid=466744em=tid=3417FE=1

Not a SearchOracle.com member? We'll activate your membership with
your subscription.
===


INVITE A COLLEAGUE 

If you think this webcast would interest your colleagues, simply
forward them this invitation.


Visit SearchTechTarget.com today for the latest IT news, webcasts,
white papers and more from additional IT-specific Web sites within
the TechTarget network.
http://searchtechtarget.com/?Offer=sttfoot


:  ABOUT THIS NEWSLETTER  ::
This newsletter is published by TechTarget, the most targeted IT
media. http://www.techtarget.com

Copyright 2003 TechTarget. All rights reserved.


Unsubscribe from 'Updates on upcoming online events'
 - Simply Reply to this E-mail with REMOVE 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.
 - Uncheck the box next to the newsletter you wish 
   to unsubscribe from.
 - When finished, click Save Changes to My Profile.

This week: Whither Sybase?

2003-08-14 Thread SearchDatabase.com

Title: TechTarget

A weekly newsletter published by TechTarget

August 11, 2003

Receive this e-mail as text About this e-mail

In this Issue

From the editor:
Whither Sybase?

Featured Topic:
Data management career tips

Expert Technical Advice:
New expert advice, forum posts, and tips

Site Highlights:
* White paper: Enterprise Application integration
* Product and Vendor Guide
* OracleWorld: Sept. 7-11, San Francisco

From the Editor:

by Tim DiChiara, Senior Site Editor

Although their iAnywhere products dominate the mobile database landscape, Sybase remains stuck in the single digits in overall DBMS market share. Lately, they have been refocusing their efforts on enterprise integration and web services. Is this a good move, or the beginning of the end? In other words, whither Sybase?

As a Computer Weekly story pointed out last week, Sybase continues to release new versions of its DBMS Adaptive Server Enterprise (ASE) -- version 12.5.1 will ship this autumn. However, are these releases attracting any new customers or are they really meant for its legacy install base?

Sybase fans: now is your time to speak out. E-mail me at [EMAIL PROTECTED] and convince me that Sybase is still a worthy DBMS for the enterprise and that we should increase our Sybase coverage. Do you think Sybase is technically superior to Oracle, DB2, and SQL Server? It was once known for its super-high performance -- is that still the case? How can Sybase increase its paltry 2% market share: find a vertical market niche, implement some sort of technical revolution, or what? Or do you think that Sybase has been doomed ever since they sold their soul to Microsoft back in 1987?

For more background information about Sybase, check out our news and technical advice sections.

Till next time, Tim DiChiara, Editor

Featured Topic:

Data management career tips
by Tim DiChiara, Senior Site Editor

Even in this dour economy, database administrators and developers continue to be in high demand -- and continue to be highly paid. The collection of tips and advice inside will guide you along the path to becoming a database guru.

Read more about this topic

Expert Technical Advice:

Featured Expert Mike Lampa, CEO, BAG, Inc.

Category: Data warehousing and Business Intelligence
Mike is co-founder and CEO of BAG, a Texas-based business intelligence consultancy. He has over 21 years experience in strategic planning, program management, and designing, building and supporting data warehouse and operational data store implementations. Intricately involved in the daily activities of BAG, Mr. Lampa can often be found building data and process models to aid in improved operations efficiency and decision support automation for clients.

View answers

This Week: In the forums

AS/400 DB2 V5R1 migration tools
Member "Rama" is wondering if there are any tools to migrate data and schema definitions from AS/400 DB2 V5R1 to Oracle 9i? Oracle Migration Workbench apparently doesn't work. Go to our "DB2 Tech Forum" forum if you can help.

Offshore job migration
Members have been duking it out on the topic of outsourcing IT work overseas -- there have been almost 60 posts in the past week. Check out the very lively debate and let's hear your (civil) thoughts! Go to our "DBA Water Cooler" forum.

Tip of the Week:
Fast Guide: Becoming an Oracle Certified Professional
Whether you're an Oracle newbie or a self-proclaimed guru, getting an Oracle Certified Professional seal of approval may be your key to staying afloat in a tough economy. So why not begin your journey today? This fast guide is designed to give you expert advice on where to begin your certification studies, passing the final exam and putting your certification into effect in the workplace.

Read complete tip

Site Highlights

White paper: Evoke reveals the meaning of enterprise data
This white paper examines how data profiling at the beginning of data warehousing and Enterprise Application integration projects will greatly reduce the risk of project failure along with saving companies time, money and frustrations.
Click here to download now

SearchDatabase.com Product & V

This week: Sybase fanatics speak out

2003-08-18 Thread SearchDatabase.com

Title: TechTarget

A weekly newsletter published by TechTarget

August 18, 2003

Receive this e-mail as text About this e-mail

In this Issue

From the editor:
Sybase fanatics speak out

Featured Topic:

Grid computing
by Tim DiChiara, Senior Site Editor

The hype cycle for grid computing is reaching its peak, with the major DBMS vendors leading the way. What is it anyway? Is it right for your company? Read more inside...

Read more about this topic

Expert Technical Advice:

Featured Expert Craig Mullins, Director of Technology Planning, BMC Software

Category: DB2
Craig has extensive experience in the field of database management, having worked as an application developer, a DBA and an instructor with multiple database management systems, including DB2, Oracle and SQL Server. Additionally, Craig worked as a Research Director with the Gartner Group covering the field of database administration. He is the author of the DB2 Developer's Guide, the industry-leading book on DB2 for OS/390, and has published more than 100 articles on database technology. Ask Craig your tough DB2 questions!

View Craig's answers to past questions

This Week: In the forums

Inserting & deleting a node in a tree
Member "VO" is using Joe Celko's nested set method but is wondering how to delete a node? Go to our "SQL Server Tech Forum" forum if you can help.

SQL5005C error: Unable to install DB2 UDB v8 PE
Member "Okonita" is having a difficult time installing DB2 UDB v8 Personal Edition for Linux, Unix, and Windows on his home PC. Go to our "DB2 Tech Forum" forum if you can help.

Tip of the Week:
Learning guide: DB2 basics
DB2 took top honors in some DBMS market share reports this year, which means many companies may have already, or will soon be, switching over to IBM's brand of data management. With that in mind, we created this learning guide, highlighting basic DB2 information that can help Oracle, SQL Server and other database pros get up to speed on the new system.

Read complete tip

Site Highlights

Webcast: Oracle tuning, Part 1
Tune in to part one of this three part tutorial series and learn the ins and outs of Oracle tuning. You'll find out how to tune disk I/O, influences from the server and m

Webcast Alert: Oracle performance tuning, part 2

2003-08-20 Thread SearchDatabase.com

Tune in to Oracle performance tuning, part 2 and learn the ins and
outs of effective Oracle system tuning. Register now:
http://searchDatabase.com/r/0,,17224,00.htm


TITLE:   Oracle performance tuning, part 2
WHEN:Available now
SPEAKER: Don Burleson, author and principal of BEI Oracle Consulting
SPONSOR: SearchOracle.com
 http://searchOracle.com/r/0,,16833,00.htm  

JOIN US TODAY!
http://searchDatabase.com/r/0,,17224,00.htm


-- TARGETED ORACLE  DATABASE NEWSLETTERS --
SearchOracle.com features unbiased database industry news, 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 - click here for a full list: 
http://searchOracle.com/r/0,,16833,00.htm  



ABOUT THIS WEBCAST 

In the second part of this three-session tutorial series, Don
Burleson presents key tips and expert advice for effective Oracle
system performance tuning. Register for this webcast now and you will
receive information on:

** SGA tuning
** Proactive monitoring with STATSPACK
** Monitoring real-time waits
** And more!

Attend part two of the Oracle performance tuning series now:
http://searchDatabase.com/r/0,,17224,00.htm


Did you miss part one of the Oracle performance tuning series?
Tune-in now and hear an informative overview of Oracle performance
tuning essentials:
http://searchDatabase.com/r/0,,17268,00.htm



ABOUT THE SPEAKER 

Don Burleson has more than 20 years of full-time DBA experience, and
has written 14 books, including Oracle high-performance SQL tuning
and most recently the Oracle9i UNIX Administration Handbook. He has
also published more than 60 articles in national magazines, serves as
Editor-in-Chief of Oracle Internals magazine, and is owner of BEI
Oracle Consulting.

===
To subscribe to Oracle E-Business Suite Update go to:
http://searchOracle.techtarget.com/OptIn/1,290894,sid41,00.html?cid=467200em=tid=3420FE=1

Not a SearchOracle.com member? We'll activate your membership with
your subscription.
===


INVITE A COLLEAGUE 

If you think this webcast would interest your colleagues, simply
forward them this invitation.


** SearchDatabase.com Product  Vendor Guide **
Access hundreds of business intelligence-specific vendor listings and
product descriptions with the SearchDatabase.com Product  Vendor
Guide. Categories include executive information systems, data mining
and more.
http://searchDatabase.com/r/0,,17227,00.htm
---

:  ABOUT THIS NEWSLETTER  ::
This newsletter is published by TechTarget, the most targeted IT
media. http://www.techtarget.com

Copyright 2003 TechTarget. All rights reserved.


Unsubscribe from 'Updates on upcoming online events'
 - Simply Reply to this E-mail with REMOVE 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.
 - Uncheck the box next to the newsletter you wish 
   to unsubscribe from.
 - When finished, click Save Changes to My Profile.

Expert advice on SQL

2003-08-20 Thread SearchDatabase.com

Do you have a specific question on SQL looping? Are you unfamiliar
with various dynamic SQL options? Get answers to all your SQL
questions from SearchDatabase.com's resident SQL guru and featured
expert of the month, Rudy Limeback. For more information on Rudy and
our Expert of the Month series, click here:
http://searchDatabase.com/r/0,,17304,00.htm

~
** Expert Advice: SQL ** 
~
This month, we're proud to highlight SQL expert Rudy Limeback, Web
and SQL Design Consultant, r937.com. Don't miss your chance to
interact with Rudy one-on-one. Send him your questions on any
SQL-related topic - and be sure to browse through his answers to
previous inquiries:

** SQL for a fixed width flat file
http://searchDatabase.com/r/0,,17303,00.htm
** ON DELETE SET NULL for lookup tables
http://searchDatabase.com/r/0,,17302,00.htm
** Performing INSERT calculations
http://searchDatabase.com/r/0,,17301,00.htm
** ANDs and ORs and NULLs in MySQL
http://searchDatabase.com/r/0,,17300,00.htm
** And more
http://searchDatabase.com/r/0,,17299,00.htm

~
** About the series ** 
~
Ever wish you could interact directly with leading authorities? Do
you have technical questions on specific database topics?
SearchDatabase.com's Expert of the Month series is your chance to
pose your comments, concerns and inquiries to experts from top
companies across the industry. For more information on the series and
this month's featured expert, click here:
http://searchDatabase.com/r/0,,17297,00.htm

** Interested in helping spread the word?  Tell your fellow DBAs and
developers about this new series simply by forwarding this e-mail.

:  ABOUT THIS NEWSLETTER  ::
This newsletter is published by TechTarget, the most targeted IT
media. http://www.techtarget.com

Copyright 2003 TechTarget. All rights reserved.


Unsubscribe from 'Updates on new site content'
 - Simply Reply to this E-mail with REMOVE 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.
 - Uncheck the box next to the newsletter you wish 
   to unsubscribe from.
 - When finished, click Save Changes to My Profile.

Can you define the top 10 database terms?

2003-08-27 Thread SearchDatabase.com

Dear SearchDatbase.com member,

Are you fluent in the language of databases? Can you hold your own
when forced to converse via abbreviations and acronyms? Do you know
the staple database phrases - and are you updated on the latest
lingo? 

Put your skills to the test - see if you can match the definitions of
this month's top 10 entries from the SearchDatabase.com Glossary to
the appropriate term. 

~
TOP 10 DATABASE TERMS
~

10. This term sometimes seems to refer to a visualization of a
structure and sometimes to a formal text-oriented description...
http://searchDatabase.com/r/0,,17605,00.htm

9. The science of developing computer databases and algorithms for
the purpose of speeding up and enhancing biological research.
http://searchDatabase.com/r/0,,17606,00.htm

8. Developed by IBM in the 1970s, this level of protocol makes sure
that data units arrive successfully from one network point to the
next and flow at the right pace.
http://searchDatabase.com/r/0,,17607,00.htm

7. In a database table, this a key from another table that refers to
(or targets) a specific key, usually the primary key, in the table
being used.
http://searchDatabase.com/r/0,,17608,00.htm

6. Its purpose is to combine database language and procedural
programming language.
http://searchDatabase.com/r/0,,17609,00.htm

5. A way to collect the data from any table so that it can be
conveyed as input to another table-oriented application such as a
relational database application.
http://searchDatabase.com/r/0,,17610,00.htm

4. For your convenience, we've compiled a cheat sheet of these,
including ! and ^... 
http://searchDatabase.com/r/0,,17611,00.htm

3. A standard interactive and programming language for getting
information from and updating a database.
http://searchDatabase.com/r/0,,17612,00.htm

2. A type of database that is optimized for data warehouse and online
analytical processing applications.
http://searchDatabase.com/r/0,,17613,00.htm

1. A revolutionary concept that changed the rules in computer program
development by organizing programming around data rather than
logic...
http://searchDatabase.com/r/0,,17614,00.htm

~
Are there additional applications, programs, abbreviations or terms
you'd like to gain a better understanding of? Browse the
SearchDatabase.com Glossary and access our comprehensive list of
database-related definitions.
http://searchDatabase.com/r/0,,17615,00.htm

 ===
To subscribe to SAP Professional: Career Tips go to:
http://searchSAP.techtarget.com/OptIn/1,290894,sid21,00.html?cid=467609em=tid=3108FE=1

Not a SearchSAP.com member? We'll activate your membership with your
subscription.
===
 
~
 *** TARGETED ORACLE NEWSLETTERS ***
Activate your free subscription to a targeted SearchOracle.com
newsletter today and have a concise technical report delivered to
your inbox. Newsletters are available on E-Business Suite, Oracle
Administration and more - click here for a full list:
http://searchOracle.com/r/0,,17566,00.htm
~


:  ABOUT THIS NEWSLETTER  ::
This newsletter is published by TechTarget, the most targeted IT
media.  http://www.techtarget.com

Copyright 2003 TechTarget. All rights reserved.


To unsubscribe from Updates on new site content:

Reply to this e-mail with REMOVE in the Subject line
 - OR -
Go to unsubscribe:
http://SearchDatabase.com/u?cid=467609
  
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.

White Paper Roundup: Data security, data integration and more

2003-08-28 Thread SearchDatabase.com

Dear SearchDatabase.com member,

Visit the SearchDatabase.com White Paper Library today and read these
free white papers.


Juice Your Microsoft Excel Applications: Unleash the true potential
of Excel as a dynamic portal to your corporate data
Sponsored by: Juice Software, Inc.

Excel is used daily to support critical data analysis and
decision-making processes. More often than not, the data required
must be gathered and updated manually in Excel through an arduous and
error-prone process. Download this white paper and learn more about
using Excel to optimize your data analysis initiatives.

Download now:
http://searchDatabase.com/r/0,,17561,00.htm


The Future of Data Integration and ETL: 
Proprietary Engines or SQL Code Generators?
Sponsored by: Sunopsis

Companies are realizing that many of today's data integration
projects often require more functionality than traditional ETL
products can provide. This white paper offers an analysis of the
traditional engine based approach versus the code generation
approach. Download now and learn more about the different major
technological approaches to data integration, their pros and cons,
and how to select the right approach for you.

Download now:
http://searchDatabase.com/r/0,,17562,00.htm
 

Leverage GoldenGate's Data Synchronization for High Availability 
Business Continuity
Sponsored by: GoldenGate Software

This white paper considers the strengths and weaknesses of several of
the most widely used technologies utilized to protect data.
Additional topics include the merits of data synchronization as
compared against common security measures based on data availability,
data protection, resource requirements, networking capability and
total cost of ownership.

Download now:
http://searchDatabase.com/r/0,,17563,00.htm


PRODUCT  VENDOR GUIDE

Access hundreds of database-specific vendor listings and product
descriptions - Visit the SearchDatabase.com Product and Vendor Guide.
Categories include data warehousing, business intelligence and more.
http://searchDatabase.com/r/0,,17570,00.htm 

===
To subscribe to Oracle E-Business Suite Update go to:
http://searchOracle.techtarget.com/OptIn/1,290894,sid41,00.html?cid=467570em=tid=3420FE=1

Not a SearchOracle.com member? We'll activate your membership with
your subscription.
===



:  ABOUT THIS NEWSLETTER  ::
This newsletter is published by TechTarget, the most targeted IT
media.  http://www.techtarget.com

Copyright 2003 TechTarget. All rights reserved.


To unsubscribe from White Paper Alerts:

Reply to this e-mail with REMOVE in the Subject line
 - OR -
Go to unsubscribe:
http://SearchDatabase.com/u?cid=467570
  
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.

DBA Tips: SQL Server isolation level, DB2 statistics, and more...

2003-08-28 Thread SearchDatabase.com

SEARCHDATABASE.COM | Database Administrator Tips
August 28, 2003

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
FROM OUR SPONSOR:

Free database white papers
http://searchdatabase.techtarget.com/whitepapers3/0,,sid13,00.html

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

IN THIS ISSUE | Table of Contents

1. DATABASE ADMINISTRATOR TIPS 
  - SQL Server: Check the isolation level of any SPID
  - DB2: Using the Run Statistics utility
  - Oracle: Insert statement generator
  - More recent tips from members
 
2. IMPORTANT ANNOUNCEMENTS AND LINKS
  - Ask the experts: NESTED GROUP BYS
  - Learning Guide: DB2 basics
  - Featured Topic: Performance tuning

___
*** Free white papers *

Download the key papers you need today to make better-informed
decisions. Targeted categories include: Data analysis and Business
Intelligence; Data Security, Data Storage, Database Web Integration,
and more. Click here to access the free SearchDatabase.com white
papers section 

http://searchdatabase.techtarget.com/whitepapers3/0,,sid13,00.html
  
*** 

___
THIS WEEK'S TIPS:

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
CHECK THE ISOLATION LEVEL OF ANY SQL SERVER SPID | Paul Wehland
 
How do you check the isolation level of other users (i.e., other
SPIDs)? DBCC USEROPTIONS cannot do it. The way aound this is to use
the undocumented DBCC PSS command 

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci920866,00.html


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
USING THE RUN STATISTICS UTILITY | Barrie Sosinsky

A short overview of DB2's Run Statistics utility, which is used to
collect information about the organization of your table structures.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci921669,00.html


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
INSERT STATEMENT GENERATOR | Ravi Nookala

This Oracle script generates INSERT statements from an existing table
that can be used as a backup or source script for future data loads.

 CLICK for the full tip... 
http://www.searchOracle.com/tip/1,289483,sid41_gci920868,00.html

 NOTE: All Oracle-related tech tips have moved! Click here:
http://www.SearchOracle.com/tips

___
MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS:

DATA MIGRATION SCRIPT FOR STATIC TABLES | Rajasekhar Sahitala
http://www.searchDatabase.com/tip/1,289483,sid13_gci915924,00.html 
Suppose that you have an application in which you have a table
containing static data and you need this data whenever you recreate
the database. Using this SQL Server script, you can create a batch of
insert statements that you can keep in your database creation script
and start using the database after the database creation without
reloading any data. 

USE THE FIREHOSE CURSOR | Barrie Sosinsky
http://www.searchDatabase.com/tip/1,289483,sid13_gci911716,00.html
SQL Server supports several types of cursors but one read-only,
non-scrollable cursor that is specially optimized for fast
performance and worthy of note is the firehose cursor. Here's a short
introduction.

A SIMPLE WAY TO REORGANIZE A TABLE AND RELEASE THE UNUSED SPACE
http://www.searchOracle.com/tip/1,289483,sid41_gci918141,00.html
This tip from member Debajit Mishra describes a simple solution to
better manage the table space and performance during ETL operations
in Oracle 9i.

RESEEDING IDENTITIES IN SQL SERVER | Baya Pavliashvili
http://www.searchDatabase.com/tip/1,289483,sid13_gci913732,00.html
Reseeding identities in IDENTITY columns are commonly used as primary
keys for SQL Server tables. Here are some tips about reseeding
identities and some pitfalls to avoid.

JDBC: DATABASE PROGRAMMING WITH J2EE | Art Taylor
http://www.searchDatabase.com/tip/1,289483,sid13_gci917202,00.html
As a registered member of SearchDatabase.com, you're entitled to a
complimentary copy of Chapter 1 from JDBC: Database programming with
J2EE written by Art Taylor and published by Prentice Hall PTR. This
chapter focuses on JDBC design, how Java works with relational
databases, the JDBC API and more. 

HOW TO USE RESUMABLE SPACE ALLOCATION IN ORACLE 9I | Sanjay Gupta
http://www.searchOracle.com/tip/1,289483,sid41_gci915006,00.html
This tip discuss how to use a new feature in Oracle 9i called
Resuamable Space Allocation. Before 9i, it was not possible to
suspend a session when some space-related problem occured, so as a
result, whole transactions got rolled back and you had to start your
work all over again.

GENERATING A DATABASE POPULATION ROUTINE | Baya Pavliashvili
http://www.searchDatabase.com/tip/1,289483,sid13_gci913717,00

This week: Introducing our new career center

2003-09-02 Thread SearchDatabase.com

Title: TechTarget

A weekly newsletter published by TechTarget

September 02, 2003

Receive this e-mail as text About this e-mail

In this Issue

From the editor:
Introducing our new career center

Featured Topic:
Data warehousing best practices

Expert Technical Advice:
New expert advice, forum posts, and tips

Site Highlights:
* White paper of the week

* Webcast: Oracle performance tuning part 3

* SearchDatabase.com Product and Vendor Guide

From the Editor:

by Tim DiChiara, Site Editor

I'm happy to announce the availability of our new and improved job search engine for database administrators, developers, and managers. We've partnered with Dice.com to give you access to almost 28,000 career opportunities -- all only a few clicks away.

Did you know that there are 1,148 openings for database admins right now across the U.S.? How does 1,474 database developer opportunities sound? Besides the extensive search engine, other features in the Career Center include:

Announce your availability and let employers come to you
JobAlert agents that will scour the database automatically and email the results to you daily
Tons of career-related tips and advice
An exclusive salary survey specifically for data management pros

Click here to access the SearchDatabase.com Career Center. And good luck!

Till next week, Tim DiChiara, Editor

Featured Topic:

Data warehousing best practices
by Tim DiChiara, Site Editor

Bill Inmon coined the term "data warehousing" over 15 years ago and it remains popular, propelled by BI and CRM. Newbies and gurus alike will benefit from our exclusive news analyses and expert advice inside...

Read more about this topic

Expert Technical Advice:

Featured Expert Craig Mullins, Director of Technology Planning, BMC Software

Category:DB2
Craig has extensive experience in the field of database management, having worked as an application developer, a DBA and an instructor with multiple database management systems, including DB2, Oracle and SQL Server. Additionally, Craig worked as a Research Director with the Gartner Group covering the field of database administration. He is the author of the DB2 Developer's Guide, the industry-leading book on DB2 for OS/390, and has published more than 100 articles on database technology. Ask Craig your tough DB2 questions!

Read Craig's answers to previous questions

This Week: Writing a test plan for a new data warehouse

Subquery vs. correlated query
Member "Balaji" is wondering about the difference between a subquery and a correlated query. Go to our "SQL Server Tech Forum" if you can help.

Writing a test plan for a new data warehouse
Member "Mboo" is looking for help in gathering the core functions to test a new data warehouse on SQL Server. Go to our "Data warehousing and analysis" forum if you can help.

Tip of the Week:
Check the isolation level of any SQL Server SPID

SQL Server DBAs: Quick, how do you check the isolation level of other users (i.e., other SPIDs)? DBCC USEROPTIONS cannot do it. Stumped? The way aound this is to use
the undocumented DBCC PSS command

Read complete tip

Site Highlights

White paper of the week
Read this week's featured white paper and learn the strengths and weaknesses of several of the most widely used technologies utilized to protect data. Download "Leverage GoldenGate's Data Synchronization for High Availability and Business Continuity".
Download now

Webcast Alert: Protecting your database from hack attacks

2003-09-03 Thread SearchDatabase.com

Tune in and listen as Aaron Newman, CTO of Application Security Inc.
discusses widely overlooked topics in database security and
presents a view of common database security levels from a hacker's
perspective. 

Tune in now:
http://searchDatabase.com/r/0,,17713,00.htm


TITLE:   Protecting your database from hack attacks
WHEN:Available now
SPEAKER: Aaron Newman, CTO of Application Security Inc.
SPONSOR: SearchOracle.com
 http://searchDatabase.com/r/0,,17711,00.htm

JOIN US TODAY!
http://searchDatabase.com/r/0,,17713,00.htm

NOTE: To access this webcast, you must: Disable pop up blockers;
Disable firewalls blocking streaming media/audio; Adjust your cookie
settings to receive Broadcast.com media. Test your system here:
http://audience.broadcast.yahoo.com


-- TARGETED ORACLE  DATABASE NEWSLETTERS --
SearchOracle.com features unbiased database industry news, 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. Click here for a full list:  
http://searchDatabase.com/r/0,,17711,00.htm



ABOUT THIS WEBCAST 

During this webcast, Aaron Newman presents key tips and expert advice
on database security. Discussion topics include:

** The database from a hacker's perspective
** Common security flaws and generic attacks
** Attacks specific to Oracle, Microsoft SQL Server and Sybase
** SQL injection and buffer overflow attacks 
** And more!

Don't miss your chance to learn essential database security measures
-- tune in to Protecting your database from hack attacks now:
http://searchDatabase.com/r/0,,17713,00.htm


ABOUT THE SPEAKER 

Aaron Newman is the founder and Chief Technology Officer of
Application Security Inc. (AppSecInc). Widely regarded as a
leading authority on database security, Aaron co-authored the
Oracle Security Handbook, has delivered numerous presentations on
database security to various groups, and has written several
white papers on database security.


PRODUCT  VENDOR GUIDE

Access hundreds of database-specific vendor listings and product
descriptions - Visit the SearchDatabase.com Product and Vendor Guide.
Categories include data warehousing, business intelligence and more.
http://searchDatabase.com/r/0,,17570,00.htm 

===
To subscribe to Oracle E-Business Suite Update go to:
http://searchOracle.techtarget.com/OptIn/1,290894,sid41,00.html?cid=467800em=tid=3420FE=1

Not a SearchOracle.com member? We'll activate your membership with
your subscription.
===
  

:  ABOUT THIS NEWSLETTER  ::
This newsletter is published by TechTarget, the most targeted IT
media.  http://www.techtarget.com

Copyright 2003 TechTarget. All rights reserved.


To unsubscribe from Webcast Alerts:

Reply to this e-mail with REMOVE in the Subject line
 - OR -
Go to unsubscribe:
http://SearchDatabase.com/u?cid=467800
  
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.

Webcast Alert: Best practices for upgrading to Oracle9i

2003-09-04 Thread SearchDatabase.com

Are you considering or planning an upgrade to Oracle 9i? What is the
best approach for your shop - and what measures should you take to
prepare? Learn about the enhanced features and capabilities of Oracle
9i from top expert Brian Peasland - tune in to Upgrading to Oracle
9i: Reasons to upgrade now:
http://searchDatabase.com/r/0,,17773,00.htm 


TITLE:   Upgrading to Oracle 9i: Reasons to upgrade
WHEN:Available now
SPEAKER: Brian Peasland, Senior Database Administrator at SGT, Inc.
SPONSOR: Oracle 
 http://searchDatabase.com/r/0,,17820,00.htm

JOIN US TODAY!
http://searchDatabase.com/r/0,,17773,00.htm 

NOTE: To access this webcast, you must: Disable pop up blockers;
Disable firewalls blocking streaming media/audio; Adjust your cookie
settings to receive Broadcast.com media. Test your system here:
http://audience.broadcast.yahoo.com


--- SPONSORED BY: ORACLE ---
Oracle9i Database will reduce your database management overhead. A
new report from Rauch Associates proves that Oracle9i Database
Release 2 is easier and faster to manage than IBM DB2 V8.1. Click to
download a copy of the report for free.
http://searchDatabase.com/r/0,,17820,00.htm



ABOUT THIS WEBCAST 

Oracle 9i offers greater availability, the ability to change database
configuration quickly, improved manageability and more. Tune in to
this webcast and listen as database administration expert Brian
Peasland discusses:

** The top reasons to upgrade 
** Different methods to upgrade
** Requirements to be satisfied before upgrading 
** Ways to recognize and prevent potential upgrade problems 
   and more!

Don't miss your chance to learn best practices for upgrading to
Oracle 9i - tune in now:
http://searchDatabase.com/r/0,,17773,00.htm


ABOUT THE SPEAKER 

Mr. Peasland has been in the IT field for 14 years working as a
Computer Operator, Operations Analyst, Systems Administrator,
Application Developer, and finally a Database Administrator. For more
information, please visit:
http://searchDatabase.com/r/0,,17821,00.htm

===
To subscribe to Oracle E-Business Suite Update go to:
http://searchOracle.techtarget.com/OptIn/1,290894,sid41,00.html?cid=467845em=tid=3420FE=1

Not a SearchOracle.com member? We'll activate your membership with
your subscription.
===


:  ABOUT THIS NEWSLETTER  ::
This newsletter is published by TechTarget, the most targeted IT
media.  http://www.techtarget.com

Copyright 2003 TechTarget. All rights reserved.


To unsubscribe from Webcast Alerts:

Reply to this e-mail with REMOVE in the Subject line
 - OR -
Go to unsubscribe:
http://SearchDatabase.com/u?cid=467845
  
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.

OracleWorld Preview: On the road to OracleWorld

2003-09-05 Thread SearchDatabase.com

Title: OracleWorld 2003 live with SearchDatabase.com

A newsletter published by TechTarget

September 05, 2003
Receive this e-mail as textAbout this e-mail

SPONSORED BY: Quest Software
White Paper: How to Survive in a Multi-Database Environment

OracleWorld takes users into future

by Ellen O'Brien, SearchOracle.com News Writer

OracleWorld 2003 opens Monday at the Moscone Center in San Francisco, Calif., and the five-day technology event comes at a time when Oracle is under intense scrutiny within the IT industry.

White Paper Alert: Structured Records Management for Business Applications

2003-09-09 Thread SearchDatabase.com

Dear SearchDatabase.com member,

Managing electronic records and documents in a legally and
financially secure manner is crucial to every business. Download
Structured Records Management for Business Applications and learn
how to setup a platform and infrastructure that would enable your
shop to bring formal electronic records management to your e-business
initiatives. Download now:
http://searchDatabase.com/r/0,,18044,00.htm?ibm

ABOUT THIS FEATURED WHITE PAPER SPONSORED BY IBM

Most of today's critical business records are created and stored in
electronic form. This week's featured white paper, Structured
Records Management for Business Applications highlights how to
manage your electronic documents using IBM's new DB2 Records Manager.
In this white paper, you will learn how to:

** Preserve critical documents
** Reduce your risk
** Comply with Federal regulations
** And more!

Download this white paper now:
http://searchDatabase.com/r/0,,18044,00.htm?ibm

===
To subscribe to DB2 Tips go to:
http://searchDatabase.techtarget.com/OptIn/1,290894,sid13,00.html?cid=468114em=tid=252FE=1

Not a SearchDatabase.com member? We'll activate your membership with
your subscription.
===

THE SEARCHDATABASE.COM WHITE PAPER LIBRARY

Looking for more information on data integration? Browse the
SearchDatabase.com White Paper Library and access hundreds of titles.
http://searchdatabase.com/whitepapers

: ABOUT THIS NEWSLETTER ::
This newsletter is published by TechTarget, the most targeted IT
media. http://www.techtarget.com

To unsubscribe from White Paper Alerts:

Reply to this e-mail with REMOVE in the Subject line
- OR -
Go to unsubscribe:
http://SearchDatabase.com/u?cid=468114

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.

This week: OracleWorld wrap-up

2003-09-15 Thread SearchDatabase.com

Title: TechTarget

A weekly newsletter published by TechTarget

September 15, 2003

Receive this e-mail as text About this e-mail

In this Issue

From the editor:
OracleWorld wrap-up

Featured Topic:
Your SQL questions answered

Expert Technical Advice:
New expert advice, forum posts, and tips

Site Highlights:
* Webcast: Upgrading to Oracle 9i
* OracleWorld 2003
* White paper of the week

From the Editor:

by Tim DiChiara, Senior Site Editor

Last week, I predicted information and sensory overload for my week at OracleWorld in San Francisco. I was right, fortunately or unfortunately.
Most of the hundreds of technical sessions were useful and educational and every guru worth his or her salt was there and available to answer questions. But did we really need 100+ sessions devoted to 10g when the products are not even available yet? Larry Ellison also talked up grid computing, of course, and was actually rather convincing, though he did repeat much of what he said last year about RAC. Whatever else you may think about Larry, he is a relatively concise and sober speaker.

Meanwhile in the vendor exhibit hall, the usual gimmicks and silliness abounded: At every turn there were lasers, throbbing techno music, "free" trinkets (the only cost: more spam), race cars, planes, cowboys, and even one presentation involving somebody wearing a strait jacket while balancing on a rubber ball, the point of which eluded me. It all smacked of desperation -- not too surprising given the horrible IT economy.

Thankfully, I missed the sight of 15,000 geeks rocking out to the Violent Femmes' music for angst-ridden '80s teens on Wednesday. My nervous system does have its limits. If anybody was there, I'd love to hear your opinion (email me at [EMAIL PROTECTED]).

San Francisco was lovely as usual, although it, as usual, was a study in contrasts. The walk to my hotel brought me from the excess of the Moscone Center, past ultra-chic Cartier jewelry boutiques, to the edges of the Tenderloin district, the city's human freakshow. I actually saw one person carrying around a box of syringes. An ugly "theater of the absurd," indeed. What else should one expect from a state where Arnold Schwarzenegger is running for governor?

Anyway, in case you missed it, here is a sampling of our exclusive coverage of the show:

Oracle users leery of grid strategy

Even pros struggle with Oracle security

Beta testers give 10g rave reviews

Self-managing tools are among 10g's perks

Grid computing: An interview with Oracle VP Robert Shimp

Complete coverage of OracleWorld '03.

As always, thanks for your support!

Tim DiChiara, Editor

Featured Topic:

Your SQL questions answered
by Tim DiChiara, Senior Site Editor

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...

Read more about this topic

Expert Technical Advice:

Featured Expert Tony Bain Founder and database consultant, Tony Bain Group

Category: SQL Server
Tony Bain has worked exclusively with SQL Server for the last six last years while consulting for many leading businesses. He is the co-author of numerous SQL Server books, including "VB.NET and SQL Server 2000: Building an effective data layer" and the "SQL Server 2000 stored procedure handbook." Tony has MCSE, MCSD and MCDBA certifications and is a regular public speaker at technical conferences.

Read Tony's answers to previous questions

This Week: In our discussion forums

Oracle vs. SQL Server for GIS database
Member "Jeffrey" is wondering if anybody can compare the two DBMSs when it comes to spatial data, especially in terms of performance. Go to our "DBA Water Cooler" if you can help.

Queries run slowly when in SQL Server stored procedure
Member "Rify" has a query that takes 10 seconds in Query Analyzer but over a minute in a stored procedure. Why? Go to our "SQL Server " forum if you can help.

Tip of the Week:
Improving DB2 buffer performance
Here is how you can improve DB2 buffer performance with prefetching,
the process by which pages of data pages are read and stored in
memory in advance of their use by a query.

Read complete tip

Site Highlights

Webcast Alert: Oracle 9i OLAP

2003-09-16 Thread SearchDatabase.com

Tune in and listen as William Endress, Director of Product
Management, OLAP at Oracle Corporation, discusses how the OLAP option
to the Oracle9i Database brings multidimensional technology to
mainstream data warehousing.

Tune in now:
http://searchDatabase.com/r/0,,18110,00.htm 


TITLE:   Oracle 9i OLAP
WHEN:AVAILABLE NOW 
SPEAKER: William Endress, Director of Product Management, OLAP at 
 Oracle Corporation
SPONSOR: SoftTree Technologies, Inc.
 http://www.softtreetech.com 

JOIN US FOR THIS EXPERT WEBCAST TODAY!
http://searchDatabase.com/r/0,,18110,00.htm 

NOTE: To access this webcast, you must: Disable pop up blockers;
Disable firewalls blocking streaming media/audio; Adjust your cookie
settings to receive Broadcast.com media. Test your system here:
http://audience.broadcast.yahoo.com


- SPONSORED BY: SOFTREE TECHNOLOGIES, INC. -
SoftTree Technologies, Inc. releases DB Mail (TM) version 2. This
version now supports creating and sending electronic faxes, emails,
page/cell phone messages, administrative alerts and network popup
messages from Oracle, Sybase, Microsoft SQL Server and IBM DB2
databases running on any platform. For more information on DB Mail
(TM) visit the company's Web site:
http://www.softtreetech.com  



ABOUT THIS EXPERT WEBCAST 

Due to replicated data stores and proprietary APIs, OLAP servers have
traditionally lived at the fringes of the data warehouse as
standalone multidimensional databases. The OLAP option to the
Oracle9i Database brings multidimensional technology to mainstream
data warehousing through the integration of multidimensional data
types within the Oracle Database. During this webcast, William
discusses:

** The role of the OLAP option within the Oracle Database 
** How the OLAP option can upgrade the analytic capabilities of 
   the data warehouse 
** Oracle's unique architecture as a relational-multidimensional
   database
** How SQL can be used to access the multidimensional engine and 
   data types and more!

Don't miss your chance to hear this expert overview of Oracle 9i OLAP
-- tune in now:
http://searchDatabase.com/r/0,,18110,00.htm


ABOUT THE SPEAKER 

William (Bud) Endress is the Director of Product Management, OLAP
within the Oracle's Server Technology Division. In this role, he is
responsible for directing the product agenda for the Oracle option to
the Oracle9i Database. Prior to this Mr. Endress was Director of
Product Management for Oracle Express Server. He has also held senior
product management positions for analytic applications at Oracle
Corporation.

===
To subscribe to Oracle E-Business Suite Update go to:
http://searchOracle.techtarget.com/OptIn/1,290894,sid41,00.html?cid=468302em=tid=3420FE=1

Not a SearchOracle.com member? We'll activate your membership with
your subscription.
===


THE SEARCHDATABASE.COM WHITE PAPER LIBRARY

Looking for more information on data integration? Browse the
SearchDatabase.com White Paper Library and access hundreds of titles.
http://searchdatabase.com/whitepapers

:  ABOUT THIS NEWSLETTER  ::
This newsletter is published by TechTarget, the most targeted IT
media.  http://www.techtarget.com

Copyright 2003 TechTarget. All rights reserved.


To unsubscribe from Webcast Alerts:

Reply to this e-mail with REMOVE in the Subject line
 - OR -
Go to unsubscribe:
http://SearchDatabase.com/u?cid=468302
  
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.

Webcast Alert: Future trends in the DBMS market

2003-09-19 Thread SearchDatabase.com

The traditional role of the database administrator is shifting under
the pressure of new technological and economical demands. Tune into
this webcast and join author and database expert Craig Mullins as he
discusses future directions in the database management system (DBMS)
market and how they will impact the DBA.
http://searchDatabase.com/r/0,,18269,00.htm


TITLE:   The future of the database
WHEN:Available now
SPEAKER: Craig Mullins, Director of Technology Planning, BMC 
 Software
SPONSOR: Oracle
http://ad.doubleclick.net/clk;6230438;8448658;u?http://www.oracle.com/go/?Src=1746961Act=229
 

JOIN US FOR THIS EXPERT WEBCAST TODAY!
http://searchDatabase.com/r/0,,18269,00.htm

NOTE: To access this webcast, you must: Disable pop up blockers;
Disable firewalls blocking streaming media/audio; Adjust your cookie
settings to receive Broadcast.com media. Test your system here:
http://audience.broadcast.yahoo.com


--- SPONSORED BY: ORACLE ---
Oracle9i Database will reduce your database management overhead. A
new report from Rauch Associates proves that Oracle9i Database
Release 2 is easier and faster to manage than IBM DB2 V8.1. Click to
download a copy of the report for free.

http://ad.doubleclick.net/clk;6230438;8448658;u?http://www.oracle.com/go/?Src=1746961Act=229



ABOUT THIS EXPERT WEBCAST 

Certain trends across the DBMS market today are changing the
traditional role of the DBA. Tune in to this webcast and listen as
expert Craig Mullins discusses:

** General industry patterns and specific DBMS market trends
** Skills essential to a successful career as a DBA today, including
   Java, .NET and XML
** New demands on the DBA, including data integration and federation
** And much more!

Tune in to this webcast now and hear expert advice on adapting to the
shifting role of the database administrator:
http://searchDatabase.com/r/0,,18269,00.htm


ABOUT THE SPEAKER 

Craig Mullins has extensive experience in the field of database
management, having worked as an application developer, a DBA, and an
instructor with multiple database management systems, including DB2,
Oracle and SQL Server. Craig is currently Director of Technology
Planning for BMC Software. For more information, visit:
http://searchdatabase.com/ateExpertBio/0,289623,sid13_cid383906,00.html 

===
To subscribe to Webcast Alerts go to:
http://searchOracle.techtarget.com/OptIn/1,290894,sid41,00.html?cid=468724em=tid=3405FE=1

Not a SearchOracle.com member? We'll activate your membership with
your subscription.
===


WEBCAST LIBRARY
Access informative webcasts on metadata, Oracle performance tuning
and more - visit the SearchDatabase.com Webcast Library.
http://searchdatabase.techtarget.com/webcasts

:  ABOUT THIS NEWSLETTER  ::
This newsletter is published by TechTarget, the most targeted IT
media.  http://www.techtarget.com

Copyright 2003 TechTarget. All rights reserved.


To unsubscribe from Webcast Alerts:

Reply to this e-mail with REMOVE in the Subject line
 - OR -
Go to unsubscribe:
http://SearchDatabase.com/u?cid=468724
  
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.

This week: Webcast extravaganza

2003-09-22 Thread SearchDatabase.com

Title: TechTarget





 
   
   
   
A weekly  newsletter published by TechTarget
   
  
 



 

  



 
 
  
   September 22, 2003  
  
  Receive this e-mail as text About this e-mail
 
 


 
 
  
   

 
   

 
  
  
 
 
   
   

 
 

   
  
  In this Issue
 
 



 
 
  From the editor:
   Webcast extravaganza 
 
   
 
  Featured Topic:
   Your DB2 questions answered 
 
  
 
  Expert Technical Advice:
   New expert advice, forum posts, and tips 
 
  
 
  Site Highlights:
   * White paper of the week: UNIX management strategies

* Are you getting the most out of your membership?

* Learn more about the shifting role of the DBA 
 
 

 


 
   


 
 


   
   

 
 

   
  
  From the Editor:
 



 
 
   


  by Tim DiChiara, Site Editor 
   
 If you haven't watched any of our webcasts recently, you've missed out on some high quality educational opportunities. But  all is not lost. You can still watch any webcast we've recorded, anytime (even with a 56K modem!).  
For all you developers and DBAs out there, we've covered some meaty topics in the past month or two, featuring some well-known experts in the industry. Here's a sampling:  




The future of database administration  - with Craig Mullins, Director of Technology Planning at BMC Software

Protecting your database from hack attacks  - with Aaron Newman, CTO of Application Security, Inc. 

Upgrading to Oracle 9i - with Brian Peasland, Database administrator at SGT, Inc.

Ensuring data quality with metadata - with Mike Lampa, CEO of B.A.G., Inc.

Oracle 9i OLAP - with William Endress, Product Manager, OLAP at Oracle 



If you are looking for more, our webcast library is stocked full of advice and tips direct from the top authors and gurus in the industry. If you don't find what you are looking for, send me a note, and we'll try to cover that topic in a future presentation. 

(On a technical note, if you're having problems viewing these webcasts be sure to disable your pop-up blockers, adjust your cookie settings to receive Broadcast.com media, and configure your firewall to allow streaming media/audio.)

Tim DiChiara, Editor 
  
 


 


 
   


 
 


   
   

 
 

   
  
  Featured Topic:
 



 

   Your DB2 questions answered
   by Tim DiChiara, Site Editor 
   
 Best-selling author and SearchDatabase.com expert Craig Mullins has answered hundreds of your UDB and mainframe DB2 questions. Browse them inside or ask your own... 
   
   
   
Read more about this topic

 


 


 
   


 
 


   
   

 
 

   
  
  Expert Technical Advice:
 
 



 
   


  Featured Expert Tony Bain, Founder and database consultant, Tony Bain Group


Category:SQL Server
Tony Bain has worked exclusively with SQL Server for the last six last years while consulting for many leading businesses.  He is the co-author of numerous SQL Server books, including "VB.NET and SQL Server 2000: Building an effective data layer" and the "SQL Server 2000 stored procedure handbook." Tony has MCSE, MCSD and MCDBA certifications and is a regular public speaker at technical conferences. 
   
   Read Tony's answers to previous questions 
  
 







 
   This Week: In the forums
  
 
 
  
  
   
   Problems shrinking a SQL Server database
Member "Ranga" has a 400 GB database that is taking forever to run a shrink on. How can one monitor its progress? Is shrinking the best approach for a VLDB? Go to our "SQL Server Tech Forum" if you can help.
 
  
   
  
  
   
   Informatica PowerMart help
Member "cogniman" is looking for information and opinions about Informatica's PowerMart. Go to our "Data Warehousing and Data Analysis" forum if you can help.
 
  
   




 Tip of the Week:
 Performance tuning, step 1: Planning a tuning engagement

The first part of expert Carol Francum's series identifies a
standard approach for performing or evaluating Oracle database and
applications tuning efforts. This primer identifies the basic
elements of performance tuning, the tools used and a basic
methodology for obtaining the information used to evaluate a
database. It is designed for the non-technical user; i.e., the
applications user, project managers or anyone who would like
understand what those techies and sysadmins do. 
 
  Read complete tip
 


 


 
   


 
 


   
   

 
 

   
  
  Site Highlights
 
 



 
  
   
   
White paper of the week: UNIX management strategies
Download this white paper and access time-saving UNIX management tips, strategies for improving ROI on your shop's IT investments and more.
Download now

 Sponsored By: NetIQ
 

Are you getting the most out of your membership?
Sign up for the Oracle E-Business Suite Update and you'll receive

White Paper Alert: Top 10 reports for effective database management

2003-09-23 Thread SearchDatabase.com

Dear SearchDatabase.com member,

Do you want to improve user experience, exceed SLAs, save time and
increase the return on your database investments? Download The Top
10 Reports Every IT Manager Lives For and learn how to better manage
your UNIX problems. Download now:
http://searchDatabase.com/r/0,,18756,00.htm?netiq 


ABOUT THIS FEATURED WHITE PAPER SPONSORED BY NETIQ

While Web technologies deliver the performance, flexibility, and
integration that you need, the management process can be grueling. 
This week's featured white paper, The Top 10 Reports Every IT
Manager Lives For presents 10 critical UNIX system views and
management reports that can help answer your most pressing questions.

Read the guide to discover more information on:

** Methods for analyzing and improving database performance and 
   response rate
** The impact of additional users on my database
** Balancing data load and storage allocations across several 
   databases
** Strategies for ensuring application servers are running at
   optimal performance levels and more

Download this white paper now:
http://searchDatabase.com/r/0,,18756,00.htm?netiq 

===
To subscribe to White Paper Alerts go to:
http://searchOracle.techtarget.com/OptIn/1,290894,sid41,00.html?cid=468856em=tid=3404FE=1

Not a SearchOracle.com member? We'll activate your membership with
your subscription.
===


SEARCHDATABASE.COM WHITE PAPER LIBRARY

Looking for more information on UNIX and database management? Browse
the SearchDatabase.com White Paper Library and access hundreds of
titles.
http://searchdatabase.com/whitepapers

:  ABOUT THIS NEWSLETTER  ::
This newsletter is published by TechTarget, the most targeted IT
media.  http://www.techtarget.com

Copyright 2003 TechTarget. All rights reserved.


To unsubscribe from White Paper Alerts:

Reply to this e-mail with REMOVE in the Subject line
 - OR -
Go to unsubscribe:
http://SearchDatabase.com/u?cid=468856
  
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.

Webcast Roundup: Upgrading to Oracle 9i and more

2003-09-24 Thread SearchDatabase.com

Dear SearchDatabase.com member,

View these webcasts recently held on SearchDatabase.com:

1. Oracle 9i OLAP
2. The future of the database
3. Upgrading to Oracle 9i: Reasons to upgrade
4. Ensuring data quality with metadata


WEBCAST #1: Oracle 9i OLAP

SPEAKER: William Endress, Director of Product Management, OLAP at 
 Oracle Corporation
SPONSOR: SoftTree Technologies
http://www.softtreetech.com

ABOUT THIS EDITORIAL WEBCAST:
The OLAP option to the Oracle9i Database brings multidimensional
technology to mainstream data warehousing through the integration of
multidimensional data types within the Oracle Database. This webcast
highlights:

** The role of the OLAP option within the Oracle Database and how it 
   can upgrade the analytic capabilities of the data warehouse
** Oracle's unique architecture as a relational-multidimensional 
   database
** How SQL can be used to access the multidimensional engine and data
   types and more!

ATTEND TODAY: 
http://searchDatabase.com/r/0,,18110,00.htm


WEBCAST #2: The future of the database

SPEAKER: Craig Mullins, Director of Technology Planning, BMC 
 Software
SPONSOR: Oracle
http://ad.doubleclick.net/clk;6230438;8448658;u?http://www.oracle.com/go/?Src=1746961Act=229
   

ABOUT THIS EDITORIAL WEBCAST:
Certain trends across the DBMS market today are changing the
traditional role of the DBA. Tune in to this webcast and listen as
expert Craig Mullins discusses:

** General industry patterns and specific DBMS market trends
** Skills essential to a successful career as a DBA today, including
   Java, .NET and XML
** New demands on the DBA, including data integration and federation
   and more!

ATTEND TODAY:
http://searchDatabase.com/r/0,,18754,00.htm 


WEBCAST #3: Upgrading to Oracle 9i: Reasons to upgrade

SPEAKER: Brian Peasland, Senior Database Administrator at SGT, Inc.
SPONSOR: Oracle 
http://searchDatabase.com/r/0,,17820,00.htm

ABOUT THIS EDITORIAL WEBCAST: 
Oracle 9i offers greater availability, the ability to change database
configuration quickly, improved manageability and more. During this
webcast, expert Brian Peasland discusses:

** The top reasons to upgrade 
** Requirements to be satisfied before upgrading and different 
   methods for upgrading 
** Ways to recognize and prevent potential upgrade problems and more!

ATTEND TODAY:
http://searchDatabase.com/r/0,,18516,00.htm  


WEBCAST #4: Ensuring data quality with metadata

SPEAKER: Mike Lampa, CEO of BAG Inc.
SPONSOR: SearchOracle.com
http://searchOracle.com/r/0,,18724,00.htm 

ABOUT THIS EDITORIAL WEBCAST:
Using metadata information helps the business community maintain
quality data across the business value chain. Tune in to this webcast
and listen as metadata expert Mike Lampa examines:

** The importance of data quality, 
** The role of the data steward 
** How metadata solutions can help the data steward with his mission
   and more!

ATTEND TODAY:
http://searchDatabase.com/r/0,,18755,00.htm 


NOTE: To access these webcasts, you must: Disable pop up blockers;
Disable firewalls blocking streaming media/audio; Adjust your cookie
settings to receive Broadcast.com media. Test your system here:
http://audience.broadcast.yahoo.com 


===
To subscribe to Webcast Alerts go to:
http://searchOracle.techtarget.com/OptIn/1,290894,sid41,00.html?cid=468852em=tid=3405FE=1

Not a SearchOracle.com member? We'll activate your membership with
your subscription.
===


:  ABOUT THIS NEWSLETTER  ::
This newsletter is published by TechTarget, the most targeted IT
media.  http://www.techtarget.com

Copyright 2003 TechTarget. All rights reserved.


To unsubscribe from Webcast Alerts:

Reply to this e-mail with REMOVE in the Subject line
 - OR -
Go to unsubscribe:
http://SearchDatabase.com/u?cid=468852
  
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.

White Paper Alert: Insight into Oracle9iAS integration

2003-09-30 Thread SearchDatabase.com

Dear SearchDatabase.com member,

Enterprise Integration is a critical requirement for every shop.
Unfortunately, finding a general-purpose integration solution is
challenging and can put a strain on your budget. Download Oracle9iAS
Integration and learn how to avoid high costs and successfully
integrate leading B2B communication standards, emerging Web services
standards, and virtually any packaged or legacy application into
enterprise business processes with Oracle9iAS. 
Download now: 
http://searchDatabase.com/r/0,,19179,00.htm?oracle 


ABOUT THIS FEATURED WHITE PAPER SPONSORED BY ORACLE

This week's featured white paper, Oracle9iAS Integration, provides
an overview of Oracle9iAS Integration, a component of the Oracle
Application Server. This white paper features: 

** An overview of the key requirements of business integration
** Insight into the primary challenges of business integration
** Ways to use the Oracle9iAS integration component to meet all
   integration objectives
** And more!

Don't miss your chance to gain insight into Oracle9iAS Integration -
download now:
http://searchDatabase.com/r/0,,19179,00.htm?oracle 

===
To subscribe to White Paper Alerts go to:
http://searchOracle.techtarget.com/OptIn/1,290894,sid41,00.html?cid=469221em=tid=3404FE=1

Not a SearchOracle.com member? We'll activate your membership with
your subscription.
===


THE SEARCHDATABASE.COM WHITE PAPER LIBRARY 

Browse hundreds of white papers by author, keyword or topics such as
Oracle9iAS Integration and more -- visit the SearchDatabase.com White
Paper Library today:
http://searchdatabase.techtarget.com/whitepapers

:  ABOUT THIS NEWSLETTER  ::
This newsletter is published by TechTarget, the most targeted IT
media.  http://www.techtarget.com

Copyright 2003 TechTarget. All rights reserved.


To unsubscribe from White Paper Alerts:

Reply to this e-mail with REMOVE in the Subject line
 - OR -
Go to unsubscribe:
http://SearchDatabase.com/u?cid=469221
  
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.

DBA Tips: How SQL Server is hacked, and more...

2003-10-01 Thread SearchDatabase.com

SEARCHDATABASE.COM | Database Administrator Tips
October 1, 2003

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
FROM OUR SPONSOR:

Download the Oracle Data Dictionary! 
http://searchDatabase.com/r/0,,19209,00.htm?questsoftware 

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

IN THIS ISSUE | Table of Contents

1. DATABASE ADMINISTRATOR TIPS 
  - SQL Server: How SQL Server is hacked
  - DB2: Formatting the date with SQL
  - Oracle: Using hidden Oracle paraemters
  - More recent tips from members
 
2. IMPORTANT ANNOUNCEMENTS AND LINKS
  - Free webcast: The future of database administration
  - Ask the experts: Your toughest DBMS questions answered
  - Featured Topic: Your SQL Server questions answered

___
** Sponsored by Quest Software 

Is your Oracle database running at full speed? Can you identify
bottlenecks and code that needs tuning? Start down the path to Oracle
database health today with a free, online Oracle data dictionary
compliments of Quest Software. Download your free data dictionary
now! 

http://searchDatabase.com/r/0,,19209,00.htm?questsoftware 
  
*** 

___
THIS WEEK'S TIPS:

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
HOW SQL SERVER IS HACKED | David Litchfield
 
Database servers are a soft target for hackers even though they
should be the most secure boxes within an organization's IT
infrastructure. This chapter from David Litchfeld's new book SQL
Server Security covers both software vulnerabilities, configuration
issues, hacker tools, attacks that require and don't require
authentication, and more. 

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci930221,00.html


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
FORMATTING THE DATE WITH SQL | Ravinder Bahadur

Here is a simple way to provide a format for date fields in DB2.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci920867,00.html


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
HIDDEN ORACLE, PART II: USING UNDOCUMENTED PARAMETERS

In part 1 of this series, guru Don Burleson explored ways to extract
undocumented packages, hints, utilities and executables from Oracle. 
Now Don is ready to explore some ways that the undocumented Oracle
parameters are used to aid the Oracle professional in managing and
tuning their systems.

 CLICK for the tip...
http://www.searchOracle.com/tip/1,289483,sid41_gci928423,00.html

___
MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS:

SPLIT DELIMITER-SEPARATED LISTS | Rajasekhar Sahitala
http://www.searchDatabase.com/tip/1,289483,sid13_gci915927,00.html 
This SQL Server function is useful for splitting a string of values
delimited by a special character; e.g., a comma or a space.

DB2 DISCOVERY | Barrie Sosinsky
http://www.searchDatabase.com/tip/1,289483,sid13_gci928300,00.html
Here is a quick introduction to DB2 Discovery, which provides a more
automated approach to problems associated with client/server
communication.

SELECTIVITY AND COMPOSITE INDEXES | Sethuraj Nair
http://www.searchOracle.com/tip/1,289483,sid41_gci928040,00.html
Badly ordered composite keys will prevent you from getting the best
out of indexing in Oracle. Columns with excellent selectivity at the
beginning of the index considerably boost its performance. This
script will help DBAs get an idea about the selectivity of component
columns of all existing indexes, make a decision about re-ordering
the columns in the indexes based on selectivity, and more...

HIDDEN ORACLE, PART I: EXPLORING UNDOCUMENTED UTILITIES
http://www.searchOracle.com/tip/1,289483,sid41_gci928422,00.html
Each new release of Oracle brings new hidden utilities. They are
sometimes used by internal Oracle development staff and left in
Oracle for emergency support. Many of these undocumented utilities
are very powerful but can be complex. In this article, Oracle guru
Don Burleson describes how to find hidden utilities, executables,
parameters, v$ views, system events, and SQL hints. 

CHECK THE ISOLATION LEVEL OF ANY SQL SERVER SPID | Paul Wehland
http://www.searchDatabase.com/tip/1,289483,sid13_gci920866,00.html 
How do you check the isolation level of other users (i.e., other
SPIDs)? DBCC USEROPTIONS cannot do it. The way aound this is to use
the undocumented DBCC PSS command 

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

DBA Tips: Splitting DB2 transactions, resolving SQL Server blocking problems, and more...

2003-10-08 Thread SearchDatabase.com

SEARCHDATABASE.COM | Database Administrator Tips
October 8, 2003

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
FROM OUR SPONSOR:

How does your salary compare to those of your peers? 
http://searchdatabase.techtarget.com/dice/0,294542,sid13,00.html?track=NL-94Offer=dbdicesur93

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

IN THIS ISSUE | Table of Contents

1. DATABASE ADMINISTRATOR TIPS 
  - SQL Server: Problem-solving blocking situations
  - DB2: Little by little, step by step: Splitting DB2 transactions
  - Oracle: Speed up transport between primary and standby database
  - More recent tips from members
 
2. IMPORTANT ANNOUNCEMENTS AND LINKS
  - Free webcast: The future of database administration
  - Ask the experts: Converting columns to rows
  - Featured Topic: 600 DBMS tips and scripts

___
 SearchDatabase.com Career Center *

How does your salary compare to those of your peers? Visit
SearchDatabase.com's new Career Center powered by Dice and take our
salary survey. You'll find training, certification and resume
resources along with over 27,000 IT job openings to search through.
Register now and receive e-mails when a listing matches your search
criteria, have your profile automatically sent to Dice.com member
companies, access a host of career resources and tips and much more! 

http://searchdatabase.techtarget.com/dice/0,294542,sid13,00.html?track=NL-94Offer=dbdicesur93
  
*** 

___
THIS WEEK'S TIPS:

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
PROBLEM-SOLVING BLOCKING SITUATIONS | Robert Hauck
 
This procedure for SQL Server 2000 is intended to help with
problem-solving blocking situations. The author developed it to
contact users when their client software holds locks that are holding
up other users. It works faster than viewing the blocking status
through Enterprise Manager.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci912793,00.html?track=NL-94


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
LITTLE BY LITTLE, STEP BY STEP: SPLITTING DB2 TRANSACTIONS
by Alexander Kuznetsov

Sometimes you may need to insert, update or delete a lot of rows.
Doing that in one SQL statement may be unwise. Here is how to split a
large transaction into several smaller ones in DB2.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci931229,00.html?track=NL-94


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
SPEED UP DATA TRANSPORT BETWEEN PRIMARY AND STANDBY DATABASE

Ravinder Bhalla presents a quick tip to speed up data transport
between primary and standby Oracle databases in a DataGuard
environment. 

 CLICK for the tip...
http://www.searchOracle.com/tip/1,289483,sid41_gci930276,00.html?track=NL-94

___
MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS:

HOW SQL SERVER IS HACKED | David Litchfield
http://www.searchDatabase.com/tip/1,289483,sid13_gci930221,00.html?track=NL-94 
Database servers are a soft target for hackers even though they
should be the most secure boxes within an organization's IT
infrastructure. This chapter from David Litchfeld's new book SQL
Server Security covers both software vulnerabilities, configuration
issues, hacker tools, attacks that require and don't require
authentication, and more. 

FORMATTING THE DATE WITH SQL | Ravinder Bahadur
http://www.searchDatabase.com/tip/1,289483,sid13_gci920867,00.html?track=NL-94
Here is a simple way to provide a format for date fields in DB2.

HIDDEN ORACLE, PART II: USING UNDOCUMENTED PARAMETERS
http://www.searchOracle.com/tip/1,289483,sid41_gci928423,00.html?track=NL-94
In part 1 of this series, guru Don Burleson explored ways to extract
undocumented packages, hints, utilities and executables from Oracle. 
Now Don is ready to explore some ways that the undocumented Oracle
parameters are used to aid the Oracle professional in managing and
tuning their systems.

SPLIT DELIMITER-SEPARATED LISTS | Rajasekhar Sahitala
http://www.searchDatabase.com/tip/1,289483,sid13_gci915927,00.html?track=NL-94 
This SQL Server function is useful for splitting a string of values
delimited by a special character; e.g., a comma or a space.

DB2 DISCOVERY | Barrie Sosinsky
http://www.searchDatabase.com/tip/1,289483,sid13_gci928300,00.html?track=NL-94
Here is a quick introduction to DB2 Discovery, which provides a more
automated approach to problems associated with client/server
communication.

SELECTIVITY AND COMPOSITE INDEXES | Sethuraj Nair
http://www.searchOracle.com/tip/1,289483,sid41_gci928040,00.html?track=NL-94
Badly ordered composite keys will prevent you from getting the best
out of indexing in Oracle. Columns

Webcast Alert: Integration of globally diverse data

2003-10-08 Thread SearchDatabase.com

Tune in to Integration of globally diverse data and listen as
integration expert James Bean discusses the rationale for global data
integration and provides several options for capturing, validating,
processing and integrating globally diverse data.

Tune in now:
http://searchDatabase.com/r/0,,19264,00.htm?track=NL-97


TITLE:Integration of globally diverse data
WHEN:  Available now
SPEAKER: James Bean, President and CEO, The Relational Logistics 
Group
SPONSOR: Oracle
   
http://searchDatabase.com/r/0,,19265,00.htm?track=NL-97 

JOIN US FOR THIS EXPERT WEBCAST TODAY!
http://searchDatabase.com/r/0,,19264,00.htm?track=NL-97 

NOTE: To access this webcast, you must: Disable pop up blockers;
Disable firewalls blocking streaming media/audio; Adjust your cookie
settings to receive Broadcast.com media. Test your system here:
http://audience.broadcast.yahoo.com


--- SPONSORED BY: ---
Connect with Oracle Application Server Integration! Whether you're
linking your Web site to an ERP system, extending business processes,
or coping with proliferating data silos, OracleAS Integration offers
a flexible solution for all your integration challenges. Click for a
FREE white paper, Deriving Value from the Extended Enterprise.
http://searchDatabase.com/r/0,,19265,00.htm?track=NL-97  



ABOUT THIS EXPERT WEBCAST 

One of the greatest challenges facing today's database professionals
is the global marketplace created by e-commerce. In order to
successfully service new global markets, the enterprise must now
effectively capture, validate, process and integrate globally diverse
data. During this webcast, integration expert James Bean:

** Describes the rationale for global data integration
** Offers tips on gathering and authenticating global data
** Provides several options for integrating globally diverse data 
** And more!

Tune in now:
http://searchDatabase.com/r/0,,19264,00.htm?track=NL-97


ABOUT THE SPEAKER 

James Bean is the chairman and founder of the Global Web Architecture
Group and the Relational Logistics Group. He is a respected expert in
the fields of Business and Technology, having completed numerous
worldwide client engagements for XML Training, XML Vocabulary
Development, Global E-Commerce Strategies, Information Architecture
and Database Design.  

===
To subscribe to Webcast Alerts go to:
http://searchOracle.techtarget.com/OptIn/1,290894,sid41,00.html?track=NL-97cid=469581em=tid=3405FE=1

Not a SearchOracle.com member? We'll activate your membership with
your subscription.
===


THE SEARCHDATABASE.COM WEBCAST LIBRARY

Browse hundreds of informative webcasts on data integration - Visit
the SearchOracle.com Webcast Library.
http://searchDatabase.techtarget.com/webcasts?track=NL-97

:  ABOUT THIS NEWSLETTER  ::
This newsletter is published by TechTarget, the most targeted IT
media.  http://www.techtarget.com?track=NL-97

Copyright 2003 TechTarget. All rights reserved.


To unsubscribe from Webcast Alerts:

Reply to this e-mail with REMOVE in the Subject line
 - OR -
Go to unsubscribe:
http://SearchDatabase.com/u?cid=469581?track=NL-97
  
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.

White Paper Alert: Database Server Virtualization and Consolidation

2003-10-09 Thread SearchDatabase.com

Dear SearchDatabase.com member,

Are your database servers working at peak performance levels... or
are select applications threatening to overload server capacity in
your shop? Learn how to achieve and maintain optimal database
performance levels -- Download Database Server Virtualization and
Consolidation now:
http://searchDatabase.com/r/0,,19408,00.htm?track=NL-255savantissystems

ABOUT THIS FEATURED WHITE PAPER SPONSORED BY SAVANTIS SYSTEMS

This featured white paper presents an overview on how to virtualize
the database layer by pooling underutilized database server resources
into a Database Area Network (DAN). Download Database Server
Virtualization and Consolidation now and learn how to efficiently
allocate capacity across multiple database applications. This white
paper also explains:

* How to reduce database TCO
* The impact of recent database server consolidation trends
* An overview of database server virtualization and more!

Don't miss your chance to learn how to improve capacity management
and resource utilization in your shop - download Database Server
Virtualization and Consolidation now:
http://searchDatabase.com/r/0,,19408,00.htm?track=NL-255savantissystems

===
To subscribe to White Paper Alerts go to:
http://searchOracle.techtarget.com/OptIn/1,290894,sid41,00.html?track=NL-255cid=469691em=tid=3404FE=1

Not a SearchOracle.com member? We'll activate your membership with
your subscription.
===

THE SEARCHDATABASE.COM WHITE PAPER LIBRARY

The SearchDatabase.com white paper library features hundreds of
titles across such targeted topics as enterprise integration,
database administration, data security and more. Browse the
SearchDatabase.com White Paper Library now:
http://searchdatabase.techtarget.com/whitepapers?track=NL-255

: ABOUT THIS NEWSLETTER ::
This newsletter is published by TechTarget, the most targeted IT
media. http://www.techtarget.com?track=NL-255

To unsubscribe from White Paper Alerts:

Reply to this e-mail with REMOVE in the Subject line
- OR -
Go to unsubscribe:
http://SearchDatabase.com/u?cid=469691?track=NL-255

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.

This week: Beyond the big three

2003-10-13 Thread SearchDatabase.com

Tune in to this webcast and learn more about the rationale for global data integration. Listen as expert James Bean discusses several options for capturing, validating, processing and integrating globally diverse data.
Sponsored By: Oracle Corporation

Select newsletters you would like to receive from the list below.

Ask the Oracle Experts

Oracle E-Business Suite Update

Oracle Daily News

E-mail

Not a member? We'll activate your membership with your subscription.

TDWI = BI Education
Attend the TDWI World Conference in San Diego, November 2-7, 2003. Industry experts deliver over 50 courses on the hottest BI and DW topics. Register now for this premier event.
Register today

DB2 @ SHARE
Join other IBM enterprise-class DB2 professionals in Long Beach for the most comprehensive user-run IT technical education and training opportunity available.
Check it out!

Data Mining
Visit the SearchDatabase.com Product and Vendor Guide and browse product comparisons and vendor solutions across such targeted categories as data mining and more.
Browse now

ABOUTTHISNEWSLETTER

This newsletter is published by TechTarget, the most targeted IT media.

To unsubscribe from "Updates on new site content":

-
Reply to this e-mail with REMOVE in the Subject line

-
Go to unsubscribe and enter your e-mail address to cancel your subscription

White Paper Alert: Oracle9i Database Release 2 Product Family

2003-10-14 Thread SearchDatabase.com

Dear SearchDatabase.com member,

Oracle9i Database Release 2 is available in three different editions,
each suitable for different development and deployment scenarios.
Download Oracle 9i Database Release 2 Product Family and find out
which edition is right for your business.
http://searchDatabase.com/r/0,,19560,00.htm?track=NL-255oracle

ABOUT THIS FEATURED WHITE PAPER SPONSORED BY ORACLE

This week's featured white paper, Oracle 9i Database Release 2
Product Family describes the features and options of each edition of
the Oracle9i Database Release 2 product family: Oracle 9i Database
Standard edition, Oracle 9i Database Enterprise edition and Oracle 9i
Database Personal edition. This white paper provides:

** An in-depth guide to the distinct features and capabilities of
each edition
** A comparison of the new features of each edition in the areas of
scalability, security and manageability
** And more!

Don't miss your chance to learn about the Oracle9i Database Release 2
product family - download now:
http://searchDatabase.com/r/0,,19560,00.htm?track=NL-255oracle

===
To subscribe to Oracle E-Business Suite Update go to:
http://searchOracle.techtarget.com/OptIn/1,290894,sid41,00.html?track=NL-255cid=469956em=tid=3420FE=1

Not a SearchOracle.com member? We'll activate your membership with
your subscription.
===

THE SEARCHDATABASE.COM WHITE PAPER LIBRARY

Browse the SearchDatabase.com White Paper Library and access hundreds
of white papers across targeted categories.
http://searchdatabase.techtarget.com/whitepapers?track=NL-255

: ABOUT THIS NEWSLETTER ::
This newsletter is published by TechTarget, the most targeted IT
media. http://www.techtarget.com?track=NL-255

To unsubscribe from White Paper Alerts:

Reply to this e-mail with REMOVE in the Subject line
- OR -
Go to unsubscribe:
http://SearchDatabase.com/u?cid=469956?track=NL-255

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.

DBA Tips: Limit DB2 results, clean SQL Server logs, and more...

2003-10-15 Thread SearchDatabase.com

SEARCHDATABASE.COM | Database Administrator Tips
October 15, 2003

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
FROM OUR SPONSOR:

Complimentary DB2 System Catalog Poster 
http://searchDatabase.com/r/0,,19747,00.htm?track=NL-94questsoftware

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

IN THIS ISSUE | Table of Contents

1. DATABASE ADMINISTRATOR TIPS 
  - SQL Server: Useful scripts to clear out old plan history logs
  - DB2: Limiting result sets with FETCH FIRST and OPTIMIZE FOR
  - Oracle: Performance tuning, step 3: Working the plan
  - More recent tips from members
 
2. IMPORTANT ANNOUNCEMENTS AND LINKS
  - Free DB2, SQL Server, and Oracle book chapter downloads
  - Ask the experts: Your tough questions answered
  - Featured Topic: Beyond the big three

___
** Sponsored by Quest Software 

Tired of having to reference cumbersome manuals every time 
you need to look up information about your DB2 catalogs? Get 
with the times and download Quest Software's free electronic 
desktop catalog poster of DB2 UDB V8. 

http://searchDatabase.com/r/0,,19747,00.htm?track=NL-94questsoftware
  
*** 

___
THIS WEEK'S TIPS:

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
USEFUL SCRIPTS TO CLEAR OUT OLD PLAN HISTORY LOGS | Robert Hauck
 
When a plan's history gets long, it helps to be able to clear out any
old ones that you don't need to see anymore. Use these scripts rather
than deleting them one at a time via Enterprise Manager.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci911715,00.html?track=NL-94


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
LIMITING RESULT SETS WITH FETCH FIRST AND OPTIMIZE FOR 
by Alexander Kuznetsov

The FETCH FIRST and OPTIMIZE FOR clauses are best for limiting the
amount of rows if the result set is big. Here's how to use them in
DB2.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci932208,00.html?track=NL-94


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
PERFORMANCE TUNING, STEP 3: WORKING THE PLAN | Carol Francum 

In step 1 we identified the elements of a basics of an Oracle
performance tuning plan. Then, in step 2, we identified the current
state for subsequent stages and determined the relative priorities
which need to be met in terms of user requirements and management
requirements. The next step in a tuning program is to assess the
details of the system, in terms of specific architecture, processes
and code. 

 CLICK for the tip...
http://searchoracle.techtarget.com/tip/1,289483,sid41_gci930520,00.html?track=NL-94

___
MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS:

PROBLEM-SOLVING BLOCKING SITUATIONS | Robert Hauck
http://www.searchDatabase.com/tip/1,289483,sid13_gci912793,00.html?track=NL-94 
This procedure for SQL Server 2000 is intended to help with
problem-solving blocking situations. The author developed it to
contact users when their client software holds locks that are holding
up other users. It works faster than viewing the blocking status
through Enterprise Manager.

LITTLE BY LITTLE, STEP BY STEP: SPLITTING DB2 TRANSACTIONS
http://www.searchDatabase.com/tip/1,289483,sid13_gci931229,00.html?track=NL-94
Sometimes you may need to insert, update or delete a lot of rows.
Doing that in one SQL statement may be unwise. Here is how to split a
large transaction into several smaller ones in DB2.

SPEED UP DATA TRANSPORT BETWEEN PRIMARY AND STANDBY DATABASE
http://www.searchOracle.com/tip/1,289483,sid41_gci930276,00.html?track=NL-94
Ravinder Bhalla presents a quick tip to speed up data transport
between primary and standby Oracle databases in a DataGuard
environment. 

HOW SQL SERVER IS HACKED | David Litchfield
http://www.searchDatabase.com/tip/1,289483,sid13_gci930221,00.html?track=NL-94 
Database servers are a soft target for hackers even though they
should be the most secure boxes within an organization's IT
infrastructure. This chapter from David Litchfeld's new book SQL
Server Security covers both software vulnerabilities, configuration
issues, hacker tools, attacks that require and don't require
authentication, and more. 

FORMATTING THE DATE WITH SQL | Ravinder Bahadur
http://www.searchDatabase.com/tip/1,289483,sid13_gci920867,00.html?track=NL-94
Here is a simple way to provide a format for date fields in DB2.

HIDDEN ORACLE, PART II: USING UNDOCUMENTED PARAMETERS
http://www.searchOracle.com/tip/1,289483,sid41_gci928423,00.html?track=NL-94
In part 1 of this series, guru Don Burleson explored ways to extract
undocumented packages, hints, utilities and executables from Oracle. 
Now Don is ready to explore some

Webcast Alert: Database Cross-training for a Heterogeneous World

2003-10-22 Thread SearchDatabase.com

How is the changing face of the database market affecting the Big
Three vendors in the space? What impact does increasingly
heterogeneous database management have on the future role of the DBA?
Don't miss your chance to hear top Oracle, SQL Server and DB2 experts
debate these issues and more during the live webcast, Database
Cross-Training for a Heterogeneous World.
http://searchDatabase.com/r/0,,19843,00.htm?track=NL-97

TITLE: Database Cross-Training for a Heterogeneous World
WHEN:Tuesday, October 28, 2003 at 2:00 p.m. EST (19:00 GMT)
SPEAKER: Guy Harrison, CTO, APM Business Unit, Quest Software, Inc.
SPEAKER: Kevin Kline, Director of Development, SQL Server Solutions,
Quest Software, Inc.
SPEAKER: Deb Jenson, Director of Database Product Strategy, Quest
Software, Inc.
SPONSOR: Quest Software
http://www.quest.com

PRE-REGISTER FOR THIS VENDOR WEBCAST HERE:
http://searchDatabase.com/r/0,,19843,00.htm?track=NL-97

NOTE: To access this webcast, you must: Disable pop up blockers;
Disable firewalls blocking streaming media/audio; Adjust your cookie
settings to receive Broadcast.com media. Test your system here:
http://audience.broadcast.yahoo.com

ABOUT THIS VENDOR WEBCAST

What applications and technologies do you need to maintain a
competitive edge in an increasingly heterogeneous database market?
Register now for this live webcast and listen as Oracle expert Guy
Harrison, SQL Server guru Kevin Kline and DB2 authority Deb Jenson
discuss key database industry trends.

During this live webcast, the experts will:

** Discuss the current market positions of Oracle, DB2, and SQL
Server
** Debate how trends and vendor strategies will impact the future of
database management
** Explore how the role of the DBA will evolve in the coming years

Don't miss your chance to attend this live webcast -- pre-register
now:
http://searchDatabase.com/r/0,,19843,00.htm?track=NL-97

SPONSORED BY: QUEST SOFTWARE, INC.
Quest Software, Inc., a leader in application management, provides
products to help customers develop, deploy, manage and maintain
enterprise applications without expensive downtime or business
interruption. For more information about Quest Software, visit the
company's Web site at: http://www.quest.com

ABOUT THE SPEAKERS

Guy Harrison is the CTO, Application Performance Management Business
Unit of Quest Software. He is a recognized Oracle expert with more
than 15 years experience in Oracle administration, development,
performance tuning and project management. Guy is the author of
Oracle SQL High Performance Tuning (Prentice-Hall, 1997, 2000) and
Oracle Desk Reference (Prentice-Hall, 2000).

Kevin Kline is the Director of Technology for the SQL Server
Solutions Group at Quest Software. He is a recognized SQL Server
expert and author of SQL in a Nutshell and Transact-SQL Programming,
both going on their second editions. He is currently the executive
vice president of the international SQL Server user's group, PASS.

Deb Jenson is the Director of Database Product Strategy for Quest
Software. A recognized DB2 expert, she has more than 13 years
experience working with DB2, both mainframe and distributed. She is
the creator of Quest Central for DB2, which was later adapted for
Oracle and SQL Server.

===
To subscribe to Webcast Alerts go to:
http://searchOracle.techtarget.com/OptIn/1,290894,sid41,00.html?track=NL-97cid=470266em=tid=3405FE=1

Not a SearchOracle.com member? We'll activate your membership with
your subscription.
===

: ABOUT THIS NEWSLETTER ::
This newsletter is published by TechTarget, the most targeted IT
media. http://www.techtarget.com?track=NL-97

To unsubscribe from Webcast Alerts:

Reply to this e-mail with REMOVE in the Subject line
- OR -
Go to unsubscribe:
http://SearchDatabase.com/u?cid=470266?track=NL-97

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.

DBA Tips: Kill SQL Server processes, monitor DB2 v8, and more...

2003-10-22 Thread SearchDatabase.com

SEARCHDATABASE.COM | Database Administrator Tips
October 22, 2003

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
FROM OUR SPONSOR:

New Data Profiling and Data Quality Web Seminar from DataFlux 
http://searchDatabase.com/r/0,,20167,00.htm?track=NL-94dataflux 

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

IN THIS ISSUE | Table of Contents

1. DATABASE ADMINISTRATOR TIPS 
  - SQL Server: Script to kill all database processes
  - DB2: Introduction to monitoring DB2 v8
  - Oracle: Run multiple sessions of DBV
  - More recent tips from members
 
2. IMPORTANT ANNOUNCEMENTS AND LINKS
  - Free DB2, SQL Server, and Oracle book chapter downloads
  - Ask the experts: Subquery or join?
  - Featured Topic: Ask the experts

___
* Sponsored by DataFlux (A SAS Company) ***

Join DataFlux as they discuss the importance of data profiling and
data quality at this special web seminar on October 23rd at 1:00 p.m.
EDT. Learn how a strategy using both elements can enhance the data
that drives your CRM, ERP and data warehousing initiatives. Register
today for Data Profiling and Data Quality: The Blueprint for
Effective Data Management! 

http://searchDatabase.com/r/0,,20167,00.htm?track=NL-94dataflux
  
*** 

___
THIS WEEK'S TIPS:

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
SCRIPT TO KILL ALL DATABASE PROCESSES | Parthasarathy Mandayam
 
Here's a situation you SQL Server DBAs may face: you have to restore
production copies of your database daily onto development servers.
The problem is that the restore process requires exclusive access to
the database. So, the author has come up with this nifty script to
silently kill all users connected to the database.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci840255,00.html?track=NL-94


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
INTRODUCTION TO MONITORING DB2 V8 | Philip Gunning

Regardless of how well a RDBMS performs, the monitoring of SQL
statements and resources is required to ensure continued good
performance and to identify problem areas. DB2 v8 provides built-in
monitoring capability through the use of snapshot monitoring and
event monitoring. Here is a detailed introduction.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci931152,00.html?track=NL-94


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
RUN MULTIPLE SESSIONS OF DBV | Michael Vergara

Ever had to do a lot of Oracle DBVERIFY commands?  You build a
script, or multiple scripts, and when they start running you wish you
had more or less of them?  Here's a UNIX script that will run a
dynamically variable number of concurrent dbv commands. 

 CLICK for the tip...
http://www.searchOracle.com/tip/1,289483,sid41_gci930274,00.html?track=NL-94

___
MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS:

USEFUL SCRIPTS TO CLEAR OUT OLD PLAN HISTORY LOGS | Robert Hauck
http://www.searchDatabase.com/tip/1,289483,sid13_gci911715,00.html?track=NL-94 
When a plan's history gets long, it helps to be able to clear out any
old ones that you don't need to see anymore. Use these scripts rather
than deleting them one at a time via Enterprise Manager.

LIMITING RESULT SETS WITH FETCH FIRST AND OPTIMIZE FOR 
by Alexander Kuznetsov
http://www.searchDatabase.com/tip/1,289483,sid13_gci932208,00.html?track=NL-94
The FETCH FIRST and OPTIMIZE FOR clauses are best for limiting the
amount of rows if the result set is big. Here's how to use them in
DB2.

PERFORMANCE TUNING, STEP 3: WORKING THE PLAN | Carol Francum 
http://searchoracle.techtarget.com/tip/1,289483,sid41_gci930520,00.html?track=NL-94
In step 1 we identified the elements of a basics of an Oracle
performance tuning plan. Then, in step 2, we identified the current
state for subsequent stages and determined the relative priorities
which need to be met in terms of user requirements and management
requirements. The next step in a tuning program is to assess the
details of the system, in terms of specific architecture, processes
and code. 

PROBLEM-SOLVING BLOCKING SITUATIONS | Robert Hauck
http://www.searchDatabase.com/tip/1,289483,sid13_gci912793,00.html?track=NL-94 
This procedure for SQL Server 2000 is intended to help with
problem-solving blocking situations. The author developed it to
contact users when their client software holds locks that are holding
up other users. It works faster than viewing the blocking status
through Enterprise Manager.

LITTLE BY LITTLE, STEP BY STEP: SPLITTING DB2 TRANSACTIONS
http://www.searchDatabase.com/tip/1,289483,sid13_gci931229,00.html?track=NL-94
Sometimes you may need to insert, update or delete a lot

This week: Locking down your DBMS

2003-10-27 Thread SearchDatabase.com

Title: TechTarget

A weekly newsletter published by TechTarget

October 27, 2003

Receive this e-mail as text About this e-mail

In this Issue

From the editor:
What does the future hold for the data center?

Featured Topic:

Locking down your DBMS
by Tim DiChiara, Senior Site Editor

The need for data security may be obvious, but the path getting there certainly isn't. The collection of technical tips, expert advice, webcasts and analysis below will help you lock down your Oracle, DB2, or SQL Server DBMS.

Read more about this topic

Expert Technical Advice:

Featured Expert Rudy Limeback,
Web and SQL Design Consultant, r937.com

Category: SQL
Rudy has worked with commercial databases since the mid-1970's, starting with IDMS, a Codasyl network system, and progressing through IBM's DB2 and Microsoft's SQL Server relational databases. He has developed data warehouses and transactional databases, always with an emphasis on making them easy to use for developers and end users alike. He specializes in writing SQL statements that are simple and easy to maintain. Rudy now operates r937.com, developing databases for use with dynamic Web sites. Ask him your tough SQL questions!

Read Rudy's answers to previous questions

This Week: In the forums

Object-oriented vs. relational model
Member "Wallace" is wondering what the key differences are between the object-oriented and relational data models. Go to our "DBA Water Cooler" to offer your thoughts.

Moving Data from Excel to SQL Server
Member "Ashu" wants to move some dynamic Excel data into SQL Server but is having trouble using DTS to do it. Help him figure out his problem in our "SQL Server Tech Forum".

Tip of the Week:
Learning guide: SQL Server basics

As more and more companies turn to SQL Server, administrators of other systems will have to learn its intricacies. With that in mind, we created this learning guide, highlighting basic SQL Server information that can help Oracle and DB2 DBAs get up to speed on Microsoft's enterprise DBMS.

Read complete tip

Site Highlights

Access Targeted Data Quality Solutions
Overwhelmed by all of the different information on the Web? Visit the SearchDatabase.com Product and Vendor Guide and browse product comparisons and vendor solutio

Webcast Today: Heterogeneous Database Management

2003-10-28 Thread SearchDatabase.com

How is the changing face of the database market affecting the Big
Three vendors in the space? What impact does increasingly
heterogeneous database management have on the future role of the DBA?
Join us today at 2:00 p.m. EDT and listen as top Oracle, SQL Server
and DB2 experts debate these issues and more during this live
webcast, Database Cross-Training for a Heterogeneous World.
http://searchDatabase.com/r/0,,20130,00.htm?track=NL-97

TITLE: Database Cross-Training for a Heterogeneous World
WHEN:TODAY - October 28, 2003 at 2:00 p.m. EST (19:00 GMT)
SPEAKER: Guy Harrison, CTO, APM Business Unit, Quest Software, Inc.
SPEAKER: Kevin Kline, Director of Development, SQL Server Solutions,
Quest Software, Inc.
SPEAKER: Deb Jenson, Director of Database Product Strategy, Quest
Software, Inc.
SPONSOR: Quest Software
http://www.quest.com

ATTEND THIS VENDOR WEBCAST TODAY AT:
http://searchDatabase.com/r/0,,20130,00.htm?track=NL-97

ABOUT THIS VENDOR WEBCAST

What applications and technologies do you need to maintain a
competitive edge in an increasingly heterogeneous database market?
Register now for today's live webcast and listen as Oracle expert Guy
Harrison, SQL Server guru Kevin Kline and DB2 authority Deb Jenson
discuss key database industry trends.

During today's live webcast, the experts will:

Don't miss your chance to interact with top database experts during
today's live webcast:
http://searchDatabase.com/r/0,,20130,00.htm?track=NL-97

ABOUT THE SPEAKERS

Guy Harrison is the CTO, Application Performance Management Business
Unit of Quest Software. He is a recognized Oracle expert with more
than 15 years experience in Oracle administration, development,
performance tuning and project management. Guy is the author of
Oracle SQL High Performance Tuning (Prentice-Hall, 1997,2000) and
Oracle Desk Reference (Prentice-Hall, 2000).

===
To subscribe to Webcast Alerts go to:
http://searchOracle.techtarget.com/OptIn/1,290894,sid41,00.html?track=NL-97cid=470458em=tid=3405FE=1

Not a SearchOracle.com member? We'll activate your membership with
your subscription.
===

: ABOUT THIS NEWSLETTER ::
This newsletter is published by TechTarget, the most targeted IT
media. http://www.techtarget.com?track=NL-97

To unsubscribe from Webcast Alerts:

Reply to this e-mail with REMOVE in the Subject line
- OR -
Go to unsubscribe:
http://SearchDatabase.com/u?cid=470458?track=NL-97

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.

Learning Guide: SQL Server Basics

2003-10-29 Thread SearchDatabase.com

SQL Server is gaining ground in the database space... but how
familiar are you on the fundamentals and intricacies of the DBMS
touted as the low-cost big-player? Get caught up to speed on
essential SQL Server facts, tips and tricks with the
SearchDatabase.com Learning Guide: SQL Server Basics.
http://searchDatabase.com/r/0,,20555,00.htm?track=NL-78

SearchDatabase.com's  Learning Guide: SQL Server Basics is designed
to provide DBAs with a quick, convenient reference for key SQL Server
terms, manuals, comparisons, security features and more. Whether
you're a seasoned SQL Server pro, Oracle expert or DB2 guru, the
Learning Guide: SQL Server Basics features a collection of the most
valuable information on SQL Server. 

~
Enter SearchDatabase.com's Learning Guide: SQL Server Basics: 
http://searchDatabase.com/r/0,,20555,00.htm?track=NL-78
~

SearchDatabase.com's Learning Guide: SQL Server Basics is a
compilation of top resources and expert advice across several
categories:

** SQL Server Basics: 
   SQL Server administration dos and don'ts
** SQL Server Basics: 
   Hundreds of free SQL Server tips and scripts
** SQL Server/Oracle comparisons: 
   Options for replicating Oracle data to SQL Server
** SQL Server/DB2 Comparisons: 
   DBMS reviews and comparisons
** SQL Server/DB2 Comparison: 
   Top 10 SQL Server security blunders, part I  part II
** And more!
http://searchDatabase.com/r/0,,20555,00.htm?track=NL-78

~
Get all the information you need on SQL Server today -
visit the SearchDatabase.com Learning Guide: SQL Server Basics:
http://searchDatabase.com/r/0,,20555,00.htm?track=NL-78
~

===
To subscribe to Developer Tip go to:
http://searchSAP.techtarget.com/OptIn/1,290894,sid21,00.html?track=NL-78cid=470976em=tid=235FE=1

Not a SearchSAP.com member? We'll activate your membership with your
subscription.
===
 

:  ABOUT THIS NEWSLETTER  ::
This newsletter is published by TechTarget, the most targeted IT
media.  http://www.techtarget.com?track=NL-78

Copyright 2003 TechTarget. All rights reserved.


To unsubscribe from Updates on new site content:

Reply to this e-mail with REMOVE in the Subject line
 - OR -
Go to unsubscribe:
http://SearchDatabase.com/u?cid=470976?track=NL-78
  
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.

DBA Tips: DB2 cluster indexes, the size of SQL Server databases, and more...

2003-10-29 Thread SearchDatabase.com

SEARCHDATABASE.COM | Database Administrator Tips
October 29, 2003

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
FROM OUR SPONSOR:

How does your salary compare to those of your peers?
http://searchdatabase.com/r/0,,18964,00.htm?track=NL-94

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

IN THIS ISSUE | Table of Contents

1. DATABASE ADMINISTRATOR TIPS 
  - SQL Server: Find the size of every database
  - DB2: Cluster indexes
  - Oracle: Compile all invalid objects
  - More recent tips from members
 
2. IMPORTANT ANNOUNCEMENTS AND LINKS
  - Free DB2, SQL Server, and Oracle book chapter downloads
  - Ask the experts: Migrating from DB2 to SQL Server
  - Featured Topic: Locking down your DBMS

___
*** SearchDatabase.com Career Center **

How does your salary compare to those of your peers? Visit
SearchDatabase.com's new Career Center powered by Dice and take our
salary survey. You'll find training, certification and resume
resources along with over 27,000 IT job openings to search through.
Register now and receive e-mails when a listing matches your search
criteria, have your profile automatically sent to Dice.com member
companies, access a host of career resources and tips and much more! 

http://searchdatabase.com/r/0,,18964,00.htm?track=NL-94
  
*** 

___
THIS WEEK'S TIPS:

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
FIND THE SIZE OF EVERY DATABASE | Madhusudan Naidu Gundapaneni
 
This handy script will find the size of every database in SQL Server
2000 without using the sp_spaceused function.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci931564,00.html?track=NL-94


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
CLUSTER INDEXES: UNDER THE HOOD | Alexander Kuznetsov

There is a widespread misconception that data rows are stored on the
leaf level of a cluster index. With DB2, this is not true. Why should
we care? In some cases, it certainly pays to understand what's going
on under the hood. This is one of those cases, so let us discuss
cluster indexes in more detail.

 CLICK for the full tip... 
http://www.searchDatabase.com/tip/1,289483,sid13_gci934007,00.html?track=NL-94


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
COMPILE ALL INVALID OBJECTS | Daniel Lanz

Even a simple change to an object in Oracle makes other objects
invalid. It is urgent to recompile the objects in the right order
because of their dependences of each other. This script will compile
all invalid objects in the required order and list all objects that
need a manual correction.  

 CLICK for the tip...
http://www.searchOracle.com/tip/1,289483,sid41_gci930536,00.html?track=NL-94

___
MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS:

SCRIPT TO KILL ALL DATABASE PROCESSES | Parthasarathy Mandayam
http://www.searchDatabase.com/tip/1,289483,sid13_gci840255,00.html?track=NL-94 
Here's a situation you SQL Server DBAs may face: you have to restore
production copies of your database daily onto development servers.
The problem is that the restore process requires exclusive access to
the database. So, the author has come up with this nifty script to
silently kill all users connected to the database.

INTRODUCTION TO MONITORING DB2 V8 | Philip Gunning
http://www.searchDatabase.com/tip/1,289483,sid13_gci931152,00.html?track=NL-94
Regardless of how well a RDBMS performs, the monitoring of SQL
statements and resources is required to ensure continued good
performance and to identify problem areas. DB2 v8 provides built-in
monitoring capability through the use of snapshot monitoring and
event monitoring. Here is a detailed introduction.

RUN MULTIPLE SESSIONS OF DBV | Michael Vergara
http://www.searchOracle.com/tip/1,289483,sid41_gci930274,00.html?track=NL-94
Ever had to do a lot of Oracle DBVERIFY commands?  You build a
script, or multiple scripts, and when they start running you wish you
had more or less of them?  Here's a UNIX script that will run a
dynamically variable number of concurrent dbv commands. 

USEFUL SCRIPTS TO CLEAR OUT OLD PLAN HISTORY LOGS | Robert Hauck
http://www.searchDatabase.com/tip/1,289483,sid13_gci911715,00.html?track=NL-94 
When a plan's history gets long, it helps to be able to clear out any
old ones that you don't need to see anymore. Use these scripts rather
than deleting them one at a time via Enterprise Manager.

LIMITING RESULT SETS WITH FETCH FIRST AND OPTIMIZE FOR 
by Alexander Kuznetsov
http://www.searchDatabase.com/tip/1,289483,sid13_gci932208,00.html?track=NL-94
The FETCH FIRST and OPTIMIZE FOR clauses are best for limiting the
amount of rows if the result set is big. Here's how to use them

Webcast Roundup: Heterogeneous database management more

2003-10-29 Thread SearchDatabase.com

Dear SearchDatabase.com member,

View these webcasts recently held on SearchDatabase.com:

1. Database Cross-Training for a Heterogeneous World
2. Integration of globally diverse data
3. Data migration strategies for Oracle 11i upgrades


WEBCAST #1: Database Cross-Training for a Heterogeneous World

WHEN:AVAILABLE NOW
SPEAKER: Guy Harrison, CTO, APM Business Unit, Quest Software, Inc.
SPEAKER: Kevin Kline, Director of Development, SQL Server Solutions, 
 Quest Software, Inc.
SPEAKER: Deb Jenson, Director of Database Product Strategy, Quest 
 Software, Inc.
SPONSOR: Quest Software
 http://www.quest.com  

ABOUT THIS WEBCAST: 
Tune in to this webcast and listen as Oracle expert Guy Harrison, SQL
Server guru Kevin Kline and DB2 authority Deb Jenson discuss key
database industry trends.

Tune in and listen as top experts:

** Discuss the current market positions of Oracle, DB2, and SQL 
   Server
** Debate how trends and vendor strategies will impact the future of 
   database management
** Explore how the role of the DBA will evolve in the coming years 
** And more 

ATTEND TODAY:
http://searchDatabase.com/r/0,,20229,00.htm?track=NL-97


WEBCAST #2: Integration of globally diverse data

WHEN:Available now
SPEAKER: James Bean, President and CEO, The Relational Logistics 
 Group
SPONSOR: Oracle
 http://searchOracle.com/r/0,,19265,00.htm?track=NL-97

ABOUT THIS WEBCAST:
In order to successfully service new global markets, the enterprise
must now effectively capture, validate, process and integrate
globally diverse data. During this webcast, integration expert James
Bean:

** Describes the rationale for global data integration
** Offers tips on gathering and authenticating global data
** Provides several options for integrating globally diverse data 
** And more!

ATTEND TODAY:
http://searchDatabase.com/r/0,,20230,00.htm?track=NL-97
 

WEBCAST #3: Data migration strategies for Oracle 11i upgrades

WHEN:AVAILABLE NOW
SPEAKER: Rich Butterfield, Co-Founder and Vice President, Corporate 
 Strategy, OuterBay Technologies, Inc.
SPONSOR: Oracle
 http://searchOracle.com/r/0,,19923,00.htm?track=NL-97

ABOUT THIS WEBCAST:
Listen as Rich Butterfield discusses proven migration strategies
based on best practices and case studies of successful Oracle 11i
upgrades. During this webcast, you'll learn more about estimated
outage windows by specific modules (GL, AR, AP, FA, PA, PO) and their
data growth in the post-11i upgrade environment. Additional
discussion topics include:

** Reducing the 11i outage window 
** Reducing the costs associated with 11i upgrade
** Minimizing the performance impact of data growth post-11i upgrade
** And more!

ATTEND TODAY:
http://searchDatabase.com/r/0,,20231,00.htm?track=NL-97


NOTE: To access these webcasts, you must: Disable pop up blockers;
Disable firewalls blocking streaming media/audio; Adjust your cookie
settings to receive Broadcast.com media. Test your system here:
http://audience.broadcast.yahoo.com 


===
To subscribe to Webcast Alerts go to:
http://searchOracle.techtarget.com/OptIn/1,290894,sid41,00.html?track=NL-97cid=470963em=tid=3405FE=1

Not a SearchOracle.com member? We'll activate your membership with
your subscription.
===


SEARCHDATABASE.COM WEBCAST LIBRARY

Browse hundreds of informative webcasts on integration, data
migration and more - Visit the SearchDatabase.com Webcast Library:
http://searchdatabase.techtarget.com/webcasts?track=NL-97

:  ABOUT THIS NEWSLETTER  ::
This newsletter is published by TechTarget, the most targeted IT
media.  http://www.techtarget.com?track=NL-97

Copyright 2003 TechTarget. All rights reserved.


To unsubscribe from Webcast Alerts:

Reply to this e-mail with REMOVE in the Subject line
 - OR -
Go to unsubscribe:
http://SearchDatabase.com/u?cid=470963?track=NL-97
  
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.

White Paper Alert: Best practices for optimal IT performance

2003-10-29 Thread SearchDatabase.com

Dear SearchDatabase.com member,

In an increasingly complex world of distributed, fragmented
technology environments, optimal performance of IT systems is
increasingly important and more challenging to achieve. Download
Does Your IT Department Need a Health Check? and learn how to
assess the health of your IT organization.
http://searchDatabase.com/r/0,,20238,00.htm?track=NL-255oracle

ABOUT THIS FEATURED WHITE PAPER SPONSORED BY ORACLE

This week's featured white paper, Does Your IT Department Need a
Health Check? describes how to assess the health of your IT
organization. Download now and learn:

** How to measure your company's IT wellness against such checkpoints
as security, availability and performance
** The causes of unplanned downtime
** How to improve IT health through outsourcing
** And more!

Don't miss your chance to learn best practices for optimal
performance in your IT department - download now:
http://searchDatabase.com/r/0,,20238,00.htm?track=NL-255oracle

===
To subscribe to Oracle E-Business Suite Update go to:
http://searchOracle.techtarget.com/OptIn/1,290894,sid41,00.html?track=NL-255cid=470803em=tid=3420FE=1

Not a SearchOracle.com member? We'll activate your membership with
your subscription.
===

THE SEARCHDATABASE.COM WHITE PAPER LIBRARY

Looking for additional white papers on Oracle technologies? Browse
the SearchDatabase.com White Paper Library and access hundreds of
white papers across targeted categories.
http://searchdatabase.com/whitepapers?track=NL-255

: ABOUT THIS NEWSLETTER ::
This newsletter is published by TechTarget, the most targeted IT
media. http://www.techtarget.com?track=NL-255

To unsubscribe from White Paper Alerts:

Reply to this e-mail with REMOVE in the Subject line
- OR -
Go to unsubscribe:
http://SearchDatabase.com/u?cid=470803?track=NL-255

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.

White Paper Roundup: Data Warehousing Oracle9i RAC more

2003-10-30 Thread SearchDatabase.com

Dear SearchDatabase.com member,

Visit the SearchDatabase.com White Paper Library today and read these
free white papers.

1. Flexible Database Clusters with Oracle9i RAC
http://searchDatabase.com/r/0,,20371,00.htm?track=NL-255polyserve

2. Kodo JDO Simplifies the Buy versus Build Decision
http://searchDatabase.com/r/0,,20368,00.htm?track=NL-255

3. Evoke Reveals the Meaning of Enterprise Data
http://searchDatabase.com/r/0,,20369,00.htm?track=NL-255

Flexible Database Clusters with Oracle9i RAC
Sponsored by: PolyServe

This white paper features a case study of three different Oracle9i
RAC applications running on a 16-node cluster of Intel-based servers.
Download this white paper now and learn more about whether a cluster
of this magnitude is manageable, how it affects TCO and the concept
of flexible database clusters.
http://searchDatabase.com/r/0,,20371,00.htm?track=NL-255polyserve

Kodo JDO Simplifies the Buy versus Build Decision
Sponsored by: SolarMetric

This white paper explores key financial reasons impacting the buy vs.
build decision. Download this white paper and receive a quantitive
framework to assist with this decision and learn how different
factors including risk, application functionality and Total Cost of
Ownership can help you determine ROI of a buy vs. build persistence
decision.
http://searchdatabase.com/r/0,,20368,00.htm?track=NL-255

Evoke Reveals the Meaning of Enterprise Data
Sponsored by: Evoke Software

This white paper explores the idea that inadequate, misunderstood
source data is the primary cause of failure in data warehousing and
Enterprise Application projects. Download this white paper now and
learn how data profiling at the beginning of your projects can
greatly reduce the risk of project failure along with saving you
time, money and frustrations.
http://searchDatabase.com/r/0,,20369,00.htm?track=NL-255

SEARCHDATABASE.COM WHITE PAPER LIBRARY

Browse hundreds of white papers by author, keyword or topics -- such
as Oracle9i RAC, Enterprise data and more -- visit the
SearchDatabase.com White Paper Library today:
http://SearchDatabase.techtarget.com/whitepapers?track=NL-255

===
To subscribe to White Paper Alerts go to:
http://searchOracle.techtarget.com/OptIn/1,290894,sid41,00.html?track=NL-255cid=471039em=tid=3404FE=1

Not a SearchOracle.com member? We'll activate your membership with
your subscription.
===

: ABOUT THIS NEWSLETTER ::
This newsletter is published by TechTarget, the most targeted IT
media. http://www.techtarget.com?track=NL-255

To unsubscribe from White Paper Alerts:

Reply to this e-mail with REMOVE in the Subject line
- OR -
Go to unsubscribe:
http://SearchDatabase.com/u?cid=471039track=NL-255

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.

Webcast Alert: Oracle Clusters

2003-10-30 Thread SearchDatabase.com

How can you achieve highly available Oracle9i scalable Oracle9i
RAC? Pre-register for Oracle Clusters: What You Need to Know and
learn how to use cluster file systems and other technology for
faster, lower-cost clusters.
http://searchDatabase.com/r/0,,20372,00.htm?track=NL-97

TITLE: Oracle Clusters: What You Need to Know
WHEN:Monday, November 3, 2003 at 2:00 p.m. EST (19:00 GMT)
SPEAKER: Michael Callahan: Co-Founder Chief Technology Officer,
PolyServe, Inc.
SPEAKER: Kevin Closson, Principal Engineer, PolyServe, Inc.
SPONSOR: PolyServe, Inc.
http://www.polyserve.com

PRE-REGISTER FOR THIS VENDOR WEBCAST HERE:
http://searchDatabase.com/r/0,,20372,00.htm?track=NL-97

ABOUT THIS VENDOR WEBCAST

Expensive Unix SMP servers are giving way to Oracle database clusters
on low-cost Intel-based servers. Pre-register now for this webcast
and listen as top experts Michael Callahan and Kevin Closson shed
light on the compelling forces behind this trend.

Tune in to this webcast and listen as top experts discuss:

** How inexpensive servers, fibre channel SANs and flexible database
cluster technology are transforming the data center
** How to build manageable clusters
** Key components for highly available Oracle9i and scalable
Oracle9i RAC
** Proof points from the world's largest implementation of Oracle9i
RAC on Linux and more!

Don't miss your chance to hear an expert overview of Oracle clusters
- Pre-register now:
http://searchDatabase.com/r/0,,20372,00.htm?track=NL-97

-- SPONSORED BY: POLYSERVE, INC. ---
Low-Cost, Flexible Database Clusters with Oracle9i RAC and Linux
http://www.searchDatabase.com/survey?track=NL-97s=549693

The world's largest, most flexible Oracle9i RAC implementation yet
achieved is featured in this case study of three different database
applications running on a 16-node cluster of Linux- and Intel-based
servers. Is a cluster of this magnitude manageable? How does it
affect TCO? This free white paper addresses these and other
questions, while also introducing the concept of flexible database
clusters.
Click here:
http://www.searchDatabase.com/survey?track=NL-97s=549693

ABOUT THE SPEAKERS

Michael Callahan was formerly the head of Advanced Development at Ask
Jeeves. He has over 15 years of research experience in computer
vision, scientific visualization, differential geometry and topology,
networking and distributed file systems.

Kevin Closson's 15-year career has included engineering, technical
support and application development positions, specializing in Oracle
and SMP (Symmetric Multiprocessing) platforms. Prior to PolyServe,
Kevin held positions with IBM, Sequent Computer Systems and Veritas
where his main engineering focus was throughput and scalability
enhancements of the Oracle server on high-end Unix SMP and clustered
systems.

===
To subscribe to Oracle E-Business Suite Update go to:
http://searchOracle.techtarget.com/OptIn/1,290894,sid41,00.html?track=NL-97cid=471037em=tid=3420FE=1

Not a SearchOracle.com member? We'll activate your membership with
your subscription.
===

SEARCHDATABASE.COM WEBCAST LIBRARY

Browse hundreds of informative webcasts on clusters - Visit the
SearchDatabase.com Webcast Library:
http://searchdatabase.techtarget.com/webcasts?track=NL-97

: ABOUT THIS NEWSLETTER ::
This newsletter is published by TechTarget, the most targeted IT
media. http://www.techtarget.com?track=NL-97

To unsubscribe from Webcast Alerts:

Reply to this e-mail with REMOVE in the Subject line
- OR -
Go to unsubscribe:
http://SearchDatabase.com/u?cid=471037track=NL-97

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

This week: Top tips for achieving optimal normalization

2003-11-03 Thread SearchDatabase.com

Title: TechTarget

A weekly newsletter published by TechTarget

November 03, 2003

Receive this e-mail as text About this e-mail

In this Issue

From the editor:
New experts ready to answer your questions

Featured Topic:

Normalization
by Tim DiChiara, Senior Site Editor

Optimal normalization is the key to good database design. And
good design is the key to optimal database performance,
efficiency, and integrity. The tips and expert advice below will
help you master this important skill.

Read more about this topic

Expert Technical Advice:

Featured Expert Rudy Limeback,
Web and SQL Design Consultant, r937.com

Category: SQL
Rudy has worked with commercial databases since the
mid-1970's, starting with IDMS, a Codasyl network system, and
progressing through IBM's DB2 and Microsoft's SQL Server
relational databases. He has developed data warehouses and
transactional databases, always with an emphasis on making them
easy to use for developers and end users alike. He specializes in
writing SQL statements that are simple and easy to maintain. Rudy
now operates r937.com, developing databases for use with dynamic
Web sites. Ask him your tough SQL questions!

Read Rudy's answers to previous questions

This Week: In the forums

What is meant by the term "relation"
Member "Allan" is asking what is meant by the term
"relation" in the context of a relational database. Go to our
"DBA Water Cooler" to read how the epxerts responded or offer
your thoughts.

IDMS to DB2 migration
Member "Ranji" is looking for the pros and cons of
migrating from IDMS to DB2. Offer your thoughts in our "DB2
Server Tech Forum".

Tip of the Week:
Learning Guide: Solving common DB2 errors

When you get an error code in DB2, it's easy enough
to look it up in the Messages and Codes manual. But knowing what
is wrong doesn't always help you to solve the problem. Here, DB2
guru Craig Mullins helps SearchDatabase.com members solve some
common SQL errors..

Read complete tip

Site Highlights

Learning Guide: SQL Server Basics
Looking to brush up on your SQL Server skills? This SearchDatabase.com Learning Guide highlights information critical for any DBA looking to brush up on SQL Server information.
Browse the SQL Server Learning Guide

Sign up for the SearchDatabase.com Daily News
Log in to SearchDatabase.com, edit your member profile and sign up for the Daily News. You'll receive the latest database industry and product announcements, as well as technology analysis and reviews.
Sign up now

Featured webcast, "Oracle Clusters: What You Need to Know"
Tune in to this webcast now
Tune in to this webcast and learn how to

Webcast Today: Oracle Clusters

2003-11-03 Thread SearchDatabase.com

How can you achieve highly available Oracle9i scalable Oracle9i
RAC? Join us today at 2:00p.m. EST for the webcast Oracle Clusters:
What You Need to Know and learn how to use cluster file systems and
other technology for faster, lower-cost clusters.
http://searchDatabase.com/r/0,,20572,00.htm?track=NL-97

TITLE: Oracle Clusters: What You Need to Know
WHEN:TODAY - November 3, 2003 at 2:00 p.m. EST (19:00 GMT)
SPEAKER: Michael Callahan: Co-Founder Chief Technology Officer,
PolyServe, Inc.
SPEAKER: Kevin Closson, Principal Engineer, PolyServe, Inc.
SPONSOR: PolyServe, Inc.
http://www.polyserve.com

ATTEND THIS VENDOR WEBCAST TODAY AT:
http://searchDatabase.com/r/0,,20572,00.htm?track=NL-97

ABOUT THIS VENDOR WEBCAST

Expensive Unix SMP servers are giving way to Oracle database clusters
on low-cost Intel-based servers. Join us today for this live webcast
and listen as top experts Michael Callahan and Kevin Closson shed
light on the compelling forces behind this trend.

Tune in to today's live webcast and listen as top experts discuss:

Don't miss your chance to interact with top experts - join us today
at 2:00 p.m. EST for Oracle Clusters - What You Need to Know.
http://searchDatabase.com/r/0,,20572,00.htm?track=NL-97

-- SPONSORED BY: POLYSERVE, INC. ---
Low-Cost, Flexible Database Clusters with Oracle9i RAC and Linux
http://www.searchDatabase.com/survey?track=NL-97s=549693

ABOUT THE SPEAKERS

===
To subscribe to Today's News go to:
http://searchOracle.techtarget.com/OptIn/1,290894,sid41,00.html?track=NL-97cid=471173em=tid=3417FE=1

Not a SearchOracle.com member? We'll activate your membership with
your subscription.
===

SEARCHDATABASE.COM WEBCAST LIBRARY

Browse hundreds of informative webcasts on clusters - Visit the
SearchDatabase.com Webcast Library:
http://searchdatabase.techtarget.com/webcasts?track=NL-97

: ABOUT THIS NEWSLETTER ::
This newsletter is published by TechTarget, the most targeted IT
media. http://www.techtarget.com?track=NL-97

To unsubscribe from Webcast Alerts:

Reply to this e-mail with REMOVE in the Subject line
- OR -
Go to unsubscribe:
http://SearchDatabase.com/u?cid=471173track=NL-97

Please note, unsubscribe requests may take up to 24

Webcast Alert: The Next Wave of Web Services Tools

2003-11-04 Thread SearchDatabase.com

View this webcast and learn to use Service Oriented Integration (SOI)
to create mission critical integration solutions while improving ROI.


TITLE:   Using Web Services to Build Mission Critical Integration 
 Solutions
WHEN:AVAILABLE NOW
SPEAKER: Eric Newcomer, IONA Chief Technology Officer
SPEAKER: Peter Cousins, IONA Technical Director
SPONSOR: IONA Technologies, Inc. 

http://searchWebServices.com/r/0,,19807,00.htm?track=NL-97iona 

JOIN US FOR THIS VENDOR WEBCAST TODAY!
http://searchDatabase.com/r/0,,20781,00.htm?track=NL-97 

NOTE: To access this webcast, you must: Disable pop up blockers;
Disable firewalls blocking streaming media/audio; Adjust your cookie
settings to receive Broadcast.com media. Test your system here:
http://audience.broadcast.yahoo.com. Yahoo! Webcast User Assistance
1-888-756-9100.



ABOUT THIS VENDOR WEBCAST 

Don't miss out on today's LIVE interactive webcast geared towards IT
professionals, architects and Web service developers interested in
creating mission critical integration solutions using Web services. 

The webcast will educate attendees on an emerging class of Web
service tools, dubbed Service Oriented Integration (SOI). These tools
bridge the gap between the hype of Web services and the reality of
integrating mission-critical systems. 

Topics covered:
** How to build secure, transactional, stateful Web services
** Beyond HTTP - how to create SOAP bindings for MQSeries, TIBCO or 
   other enterprise backbones
** How to create reliable, fault tolerant Web services
** Case studies of Web service solutions from IONA's Fortune 500 
   customers

Attend this webcast now:
http://searchDatabase.com/r/0,,20781,00.htm?track=NL-97

--- SPONSORED BY: IONA TECHNOLOGIES, INC. --
Free Strategy Brief - Service-Oriented Integration 

Searching for integration solutions that can respond to the needs of
your middleware platforms and applications? Download the latest IONA
white paper, 'Service-Oriented Integration: A Strategy Brief,' that
helps IT professionals better understand how Service-Oriented
Integration software can benefit their organizations, courtesy of
IONA's Artix. Learn how SOI and Artix can help reduce the liability
of your heterogeneous systems. Download now:
http://searchWebServices.com/r/0,,19807,00.htm?track=NL-97iona 



ABOUT THE SPEAKER 

Eric Newcomer, IONA Chief Technology Officer

In the role of Chief Technology Officer at IONA, Eric is responsible
for IONA's technology roadmap and the direction of IONA's e-Business
Platforms as relates to standards adoption, architecture, and product
design. Eric joined IONA in November 1999, and most recently served
as IONA's Vice President of Engineering, Web Services Integration
Products. Eric is a member of the XML Protocols and Web Services
Architecture working groups at the W3C and IONA's Advisory Committee
representative to UDDI.org. 

Eric has 24 years experience in the computer industry and is the
author of Understanding Web Services, the highest selling Web
Services book on Amazon.com. 
 

Peter Cousins, IONA Technical Director

Peter Cousins is Artix technology director at IONA Technologies.
Previously he was Chief Architect / CTO Office of Level 8 Systems,
Inc., where he was one of the founding visionaries of the Enterprise
Application Integration (EAI) industry. His current focus is on
highly distributed integration networks, using technologies such as
Web Services and ORB/Transaction Processing microkernels. He advised
some of the largest financial services and telecommunications firms,
and spends considerable time with Global 1000 companies as a
distributed transaction systems technology luminary.

===
To subscribe to OracleWorld 2003 live with SearchDatabase.com go
to:
http://searchDatabase.techtarget.com/OptIn/1,290894,sid13,00.html?track=NL-97cid=471272em=tid=3130FE=1

Not a SearchDatabase.com member? We'll activate your membership with
your subscription.
===


Visit the SearchDatabase.com webcasts archives for the most
up-to-date Expert QA sessions with industry experts. 
http://searchDatabase.com/webcasts?track=NL-97
---

:  ABOUT THIS NEWSLETTER

1 2 >

1 - 100 of 188 matches

Mail list logo