|
In this issue:
|
November, 2007
|
|
|
|
Simplifying Oracle Database Administration
by John Pocknell, Bert Scalzo and Mike
Ault
There's no doubt about it, Oracle DBAs have a tough job to do. They probably
have a background in application development/design or system administration and
quickly have established themselves as resident experts on everything Oracle as
well as a host of other things, such as networking, system administration and
data modeling. There are many different types of DBAs . . .
Click here to read the article.
|
|
|
DB2 9 SQL Cookbook
by Graeme Birchall
This book, which originally began
as a series of notes for
Graeme's own use, has become an essential go to guide for all things DB2
(except z/OS), including quick
find concepts and explanations for quirks in SQL. Over the years, new chapters have
been added as DB2 has evolved and Graeme has worked out better
problem solving strategies.
Click here
to read the book.
| 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! |
|
|
|
DDL Replication in SQL Server 2000 and 2005
by Dinesh Asanka
You may have wondered how to add, drop, or alter (type or size) a column of a
table that is an article of a publication. I have seen this question in many
forums and discussion boards. Obviously, dropping the replication, making the
necessary changes, and then recreating the replication is not efficient. Your
customers may not even allow you to drop the replication, as this method will
virtually shut down the system. In today's competitive environment, you cannot
afford to shut down your system even for a few minutes. Therefore, you need to
come up with a solution that lets you conduct the operation without breaking the
replication.
Click here to see the article.
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.
|
|
|
|
Using the Ruby MySQL Module
by Paul DuBois
Programs that access MySQL databases can be written in the Ruby scripting language by using Tomita
Masahiro’s MySQL module. This module provides a Ruby client API; it is implemented as a wrapper
around the MySQL C client API. This document describes how to install the MySQL module and use it to
write MySQL-based Ruby scripts.
Click here to see this article. |
| Project
Management Tips & Techniques
|
|
Use the Capability Maturity Model to Assess Your Processes
by Tom Mochal |
 |
Each month, Tom Mochal presents a set of project
management tips and techniques for handling various aspects of
planning and managing a project. Tom is the recent winner of the
2005 PMI Distinguished Contribution Award. His company, TenStep,
Inc. develops business methodologies, including a project management
process called TenStep (www.TenStep.com)
and a project lifecycle process called LifecycleStep (www.LifecycleStep.com).
The Capability Maturity Model (CMM) describes a continuum of five stages
that define how well a company or organization follows common and repeatable
processes to get work done. The CMM was developed from 1984 to 1987 by Watts
Humphrey and the Software Engineering Institute (SEI). The SEI is a part of
Carnegie Mellon University. The work was funded, and continues to be funded,
by the Department of Defense (DoD), which was originally looking for ways to
compare and measure the various contractors that were developing software
for the DoD.
Click
here to learn more about using the Capability Maturity Model.
|
|
Webcasts
For detailed information on these webcasts, please visit our News and
Events page.
|
|
|
|
|
|
|
|
November's Puzzle: "The Right Datatype for the Job"
| Test your
knowledge of PL/SQL with the this month's 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
|
| |
|
|
