|
August, 2005
In
This Issue
|
|
All articles have been reprinted with the written consent of their respective authors. | ||||||||||||||||
|
||||||||||||||||
|
Case Study: Using “On Servererror” Triggers to Work Around ORA-4031s One of the new features in Oracle 10g is “automated shared memory management”, or “ASMM”. When this feature is enabled, the instance, itself, will dynamically increase and decrease four of the SGA structures, in response to the current workload in the instance. One of main benefits of this feature is that it will (hopefully) minimize the possibility of ORA-4031 errors in the instance – because this feature will presumably increase the memory available to the shared pool automatically, before the onset of an ORA-4031.
Click here
for the article. | ||||||||||||||||
|
||||||||||||||||
|
By Popular Demand There are three stories that I am asked to tell again and again. One is the
brick laying (or dish washing) tale about my two children, Scott and Beth, who
do asynchronous and synchronous I/O, respectively. Another is the story of the
large box of balls at the airport that I use to illustrate one of the many
negatives of complex predicates. Both of the stories have been told (see "One Brick at a Time" and "Predicate Evaluation, Part I" listed in
Resources). Recently, I was asked by a friend at the IBM DB2 Information
Management Technical Conference to please document the third story, the story of
my Aunt Louise's grocery buying habits. So, here goes. Ages ago, when I first began using DB2 in a mainframe environment, there was
only one method by which DB2 used an index. But, as of V2R1 of DB2 for MVS (now
OS/390 and z/OS), there have been two methods: the original technique, which
works much like we humans work when we use an index at the back of a book, and
the newer, weird and wonderful technique, which works much like my Aunt Louise
when she buys groceries. Click here
for the article. |
||||||||||||||||
|
||||||||||||||||
|
Database Interaction with PL/SQL, Part 1 This first article in a series focusing on database interactions
with Oracle PL/SQL serves as a good introduction to the
topic. It mainly focuses on the basics of retrieving information from the Oracle
database using the SELECT..INTO statement, as well as two attributes, namely
"%TYPE" and "%ROWTYPE." Readers should have some knowledge of RDBMS, Oracle SQL, and some very fundamental grounding in
PL/SQL.
Click here for the article. |
||||||||||||||||
|
||||||||||||||||
|
10 Steps to Securing your SQL Server
Securing your SQL Server can be an arduous task, but very rewarding. Nothing
makes me personally prouder than running a penetration test on a server that we
just secured and not seeing any hot spots. This article will focus on the ways
to easily secure your SQL Server. Although this takes care of some of the big
issues, securing your SQL Server is an ongoing battle of constantly auditing and
adjusting your plan. So without further ado, here's the laundry list of items to
take care of on your SQL Server . . .
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. | ||||||||||||||||
|
||||||||||||||||
|
Queries - Introduction to SELECT The SELECT query allows data to be read from a table. A selection can be made from a single table or several tables, and you can write expressions around column names, so that table values are processed in some way before reaching the resultset. There can also be a SELECT query with no tables used to evaluate expressions.
Click here for the topic. | ||||||||||||||||
|
||||||||||||||||
It might surprise you to know the number of people that
use yellow sticky pads and a blank wall to create the first draft of the
Work Breakdown Structure. This technique is very easy. You first get the
appropriate people into the same room. These are the project team members
and clients who have the expertise to build the WBS. Typically you start off
by writing the names of the major deliverables on yellow sticky sheets - one
deliverable per sheet. Make sure the attendees agree on the major
deliverables to begin with. If any of the deliverables are very large, you
can create new sticky sheets that describe the deliverable at a lower level,
or individual work products. These are arranged under the higher-level
deliverable. The deliverable needs to be identified at a level low enough
that you understand what it takes to build it. In general two levels should
be enough. One level is typical.
Click
here
for more information | ||||||||||||||||
|
||||||||||||||||
|
Webcasts
| ||||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
Interactive Crossword
Puzzle: "License Plates"
|
||||||||||||||||
|
||||||||||||||||
|
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 |
||||||||||||||||
