|
In this issue:
|
December, 2007
|
|
The Pipelines Newsletter is Moving!!
We are pleased to announce, starting
in January, the Quest Pipelines Newsletter will be joining forces with the
Toad World 360° Newsletter.
Toad World is the online home for Quest’s database experts. While Toad World
allows users of Quest’s Toad products to learn more about how to use these
tools, Toad World also hosts non-product content, including industry-expert blogs, white papers, articles, conference presentations, and free utilities.
|
|
|
|
Messing With 11g 32bit RAC
by Mike
Ault
Well, the 32 bit 11g beta is officially over with the GA of the 11g 32 bit
release on the Oracle download site. I replaced my beta copy with the production
release and started playing about 2 weeks ago. I thought you all might like to
know some of the gotchas I have run into so far . . .
Click here to read the article.
|
|
|
Data Quality Starts With Proper Data Type
by Craig S. Mullins
Data type and length are the most
fundamental integrity constraints applied to data in a database. Simply by
specifying the data type for each column when a table is created, the DBMS
automatically ensures that only the correct type of data is stored in that
column. Processes that attempt to insert or update the data to a non-conforming
value will be rejected. Furthermore, a maximum length is assigned to the column
to prohibit larger values from being stored in the table.
Click here
to read the article.
|
|
PL/SQL Web Programming 1.0 - The URL is the API
by John Russell
Back in the transition between 8i and 9i, I almost had the chance to write a
book about developing database-driven web apps for Oracle. But with so much web
stuff moving to Java and the middle tier, it was too big and amorphous of a
subject. I wrote about specific features, like PL/SQL Server Pages, but not a
whole soup-to-nuts treatment.
Click here to read the article.
| Have you
written a Users Group paper or presentation that you would
like to share with your colleagues around the world?
Send your paper to newsletter@quest-pipelines.com
for possible publication in the Pipeline Newsletter.
If your article is accepted, it will be mailed to over
28,000 readers! |
|
|
|
|
What happened to the SQL Server
Pipelines?!!
The Pipelines for SQL Server has been replaced by an exciting new Quest
resource - SQL Server Pedia! It is the new one stop resource to
learn all things SQL Server. Read blogs and submit questions to
the SQL Server experts, such as Kevin Kline, Bryan Oliver and Patrick
O'Keeffe.
|
|
|
|
Complete Set
by Scott Noyes
Occasionally in MySQL the question pops up, “How can I get all the values
from a table that satisfy all of multiple conditions?” Then we beat the questioner with a large stick, until they give an example of
what they really mean.
Click here to see this article. |
| Project
Management Tips & Techniques
|
|
Use Regression Testing to Validate New Changes
by Tom Mochal |
 |
Regression testing is a technique that can be used in a
number of the acceptance tests and system tests. There are two main
objectives to regression testing. The first is to make certain that a
component with a defect that has been found and fixed actually does work and
provides the expected outputs. Very often, programmers will “tweak” the code
and report the defect fixed without truly resolving the cause of the defect.
The second objective is to . . .
Click
here to learn more about
regression testing.
|
|
Webcasts
For detailed information on these webcasts, please visit our News and
Events page.
|
|
|
|
|
|
|
|
Interactive Crossword
Puzzle: "Holiday Trivia"
1 Down - Oracle, for Example |
Test your
knowledge with the Pipeline Newsletter's Monthly Crossword
Puzzle.
Click here
to Play! |
|
|
|
|
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 monthly 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/
Refer a Friend!
Do you know someone who would like to
receive the Pipeline Newsletter? If so,
click
here!
Subscribe
to re:Quest, Quest's Quarterly newsletter with
articles, new product announcements, success stories and much
more.
|
 |
Past Issues of the Pipeline
Newsletter
|
| | |
|
|
