|
April, 2003
In
This Issue
|
|
All articles have been reprinted with the written consent of their respective authors. | |||||||||||||
|
|||||||||||||
|
Create Many Tables, Constraints,
and Data This function allows users to create 4,000 tables, 32,000 foreign key constraints, and 16 million rows of data for testing purposes. Click Here
for the script. |
|||||||||||||
|
|||||||||||||
|
Killing the Oracle DBMS_JOB Take control of Oracle's queue with a step by step approach to getting rid of those pesky DBMS_JOBs. Let's face it, Oracle's job scheduling facility is a wonderful tool for scheduling Oracle related jobs without having to maintain a cron job on Unix or an AT job in windows. It is also very robust and reliable. It is that very reliability and robustness that gives many of us our problems. If you have any form of jobs running on your system, you will at one time or another come across the issue of a run-away job that just doesn't seem to want to end. Or maybe you will try and shutdown the database only to find out that it is waiting to complete a job. I would like to offer some help in the management of those job queues when they just don't seem to want to end or go away. Click Here
for the article. |
|||||||||||||
|
|||||||||||||
|
Protecting DB2 Data Your company's data is one of its most precious resources, and it's facing threats from all sides. Do you know how to protect it? Companies are spending millions to secure their information, but the incidence of network intrusions that result in compromised data is on the rise. What are they doing wrong? If current security efforts are failing, what's needed? I'll list the elements of a sound security solution in this article. Click
Here for the article. |
|||||||||||||
|
|||||||||||||
|
SQL Server Upgrade
Recommendations and Best Practices As the DBA in your organization, you are central to the success of the SQL Server environment. In the case of a system upgrade, you need to act as a ‘driver’ for an upgrade project to ensure success based on your technical expertise and role in the organization. Over this multi-part series, these articles will outline proven and recommended best practices for the upgrade process. This process is detailed from both technical and logistical perspectives which are both critical to the success of the project. Click
Here for the paper. |
|||||||||||||
|
|||||||||||||
Before the main work on a project begins, a number of items need to be in place. For smaller projects, many of these conditions are met informally or implicitly. However, the larger a project gets, the more important it is that these criteria be met formally and explicitly. Click Here
for tips and techniques on What Should be in Place Before a Project
Starts?. |
|||||||||||||
|
|||||||||||||
Free Seminars
Free e-Seminars
|
|||||||||||||
|
|||||||||||||
|
|||||||||||||
|
|||||||||||||
|
Interactive Crossword
Puzzle: "Do You Know Your Fours?"
|
|||||||||||||
|
|||||||||||||
|
We love getting white papers, tips, articles, and code examples/archives from our readers around the world. Send your submission to newsletter@quest-pipelines.com. If your article is published, it will be mailed to over 28,000 subscribers. Our mission at Quest Software - RevealNet Labs is to anticipate the daily responsibilities and challenges faced by database professionals. Our products help thousands of people solve problems and implement solutions every day. This newsletter is designed to help facilitate the sharing of information among database professionals. About the Newsletter This newsletter is distributed to Quest Software - RevealNet Labs customers, prospects and friends who have subscribed to it from our website. If you would like to unsubscribe, please send a note to unsubscribe@quest-pipelines.com and we will make every effort to remove you from our list. Subscribe a Friend! Do you know someone who would like to receive the Pipeline Newsletter? If so, please enter their email address in the box below and click SUBMIT.
Past Issues of the Pipeline Newsletter |
|||||||||||||
