|
January, 2007
In
This Issue
|
|
All articles have been reprinted with the written consent of their respective authors. | ||||||||||||||||
|
||||||||||||||||
|
Using Oracle Forms by Bogdan V Grosu Oracle forms, is a component of the Oracle SQL database. The Oracle technology is to design and build enterprise application in a quick and efficient way. This article is designed to give a short introduction to the Oracle Forms 10g toolset and the basic components of a forms application. Basic Forms Concepts A form simply allows you to work visually with the data in the database. It is a representation of the data in the database tables, a collection of objects that yields a graphic interface to the data. Click here for the article.
| ||||||||||||||||
|
||||||||||||||||
|
Change Control for DB2 Access Paths An important aspect of efficient DB2 operation is the on-going analysis and management of DB2 access path changes. Whether you are implementing changes into your DB2 applications, upgrading to a new version of DB2, or simply trying to achieve optimum performance for existing application plan and packages, an exhaustive and thorough BIND management process is a necessity. However, many organizations are not doing everything possible to keep access paths up-to-date with the current state of their data. There are several reasons why the acknowledged “best practice” of REOG/RUNSTATS/REBIND is not followed religiously. In this month’s column I will examine some of the issues involved in managing access path changes. Furthermore, we’ll look at some methods for introducing a better change control discipline for the DB2 access path generation process. Click here for the article.
|
||||||||||||||||
|
||||||||||||||||
|
Purging Merge Metadata MSmerge_contents causes problems for anyone that is running merge replication for any length of time. The problem is that MSmerge_contents will grow forever unless you manage it. Merge replication makes very heavy use of MSmerge_contents which can cause problems as the size grows. This is normally manifested by deadlocking and the entire replication system slowing down. This occurs, because the time to locate the appropriate rows increases as the size increases. Before getting to the script itself, you have to understand what is going on and why we are purging the metadata. Click here to see the article.
In A Nutshell
Interested in learning more tips and techniques for SQL Server? "In A Nutshell"
is what you are looking for. Kevin Kline,
author of O'Reilly's "SQL in a Nutshell" and "Transact-SQL Programming" and President of The Professional Association for SQL Server,
offers tips, techniques and much more. Updated numerous times a week,
there is always valuable material to be had!
Click
here
to see what Kevin is up to in the SQL Server world. | ||||||||||||||||
|
||||||||||||||||
|
Protecting MySQL Sessions With SSH Port Forwarding (Part 2) In my last article, I described how to secure connections to a MySQL server using SSH port forwarding (or SSH tunneling). Responses to the article included requests for information on connecting to an SSH server running under Windows and instructions on closing a tunnel opened from within Visual Basic. In this article I will show how to use the OpenSSH For Windows tool to host SSH tunnels on a Windows server, and will also cover how to use the shellexecuteex, terminateprocess and closeHandle API calls to open and close an SSH tunnel from within VB. The instructions given will be based on a Windows 2000 installation, but should be adaptable to any NT based system.
Click here to see this article. | ||||||||||||||||
|
||||||||||||||||
At the completion of a major project milestone or phase, the team should take
a short pause to ensure that the prior work was completed successfully and that
the project team and the client are ready to proceed to the next major phase.
Sometimes these criteria are called exit and entry criteria, or "gates."
However, all of these terms point out a need to validate where the project is at
and ensure everyone is ready to proceed. The basic questions tend to be
similar from phase to phase, and even from project to project. Therefore, they
tend to be good candidates for a checklist. Any final reviews at this time tend
to be Quality Assurance related since they are focused more on the processes
completed rather than reviewing any specific deliverables. The specific
deliverable reviews should have been completed earlier.
Click
here for more information on using
milestone reviews. | ||||||||||||||||
|
||||||||||||||||
|
Webcasts
| ||||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
Interactive Crossword
Puzzle: "Saying Goodbye in 2006"
|
||||||||||||||||
|
||||||||||||||||
|
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 visit http://qlist01.quest.com/UnsubMailingList/ 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 |
||||||||||||||||
