|
October, 2006
In
This Issue
|
|
All articles have been reprinted with the written consent of their respective authors. | ||||||||||||||||
|
||||||||||||||||
|
Freeware - DB2 System Catalogs Quest Software presents DB2 z/OS v8, LUW v8.2 and LUW v9.1 System Catalogs. These are all freeware reference tools for viewing information on DB2's System Catalogs. The definitions and column information for each catalog table are provided from DB2 documentation. Click
here for more information and to download these catalogs. |
||||||||||||||||
|
||||||||||||||||
|
It’s Almost Here! This fall’s BIG Toad™ announcement is just around the corner. Don’t miss out - sign up today and be the first to hear the news!
| ||||||||||||||||
|
||||||||||||||||
|
Continuous Protection of Enterprise Data: A Comprehensive Approach Many consider the insider threat to represent the greatest vulnerability and exposure to enterprise resources. Database attacks are on the rise even as the risks of data breaches are increasing. Several industries must deal with legislation and regulation on data privacy. This paper will review how to protect sensitive data wherever the data resides: at application-level; within databases, files and operating systems; and in storage. We will address the management of associated encryption keys, access control and reporting -- helping organizations mitigate risk and reduce costs, while protecting consumer, employee and partner information. The approach safeguards information by cryptographic protection from point-of-creation to point-of-deletion, to keep sensitive data locked down across applications, databases, and files -- including ETL data loading tools, FTP processes and EDI data transfers. This design principle optimizes placement of functions for encryption and security enforcement among the modules of a distributed computer system.
Click here
for the article. | ||||||||||||||||
|
||||||||||||||||
|
Advanced Queuing Working Example This article provides a brief overview on configuring and using Oracle's Advanced Queuing features using PL/SQL. This will demonstrate the basic functionality of Oracle Advanced Queuing (AQ). AQ was first introduced in Oracle8 and has been extended and improved on in future versions. Click here for the article.
|
||||||||||||||||
|
||||||||||||||||
|
Ad-hoc SQL is Bloating My Instance "My instance is using 100's of meg RAM for caching queries that only ever run once". Poor application implementation can cause database admin angst. Often the developer innocently writes up their code to build SQL commands, which then are passed to a middle layer to execute. I have done this myself back when I was a c/c++ developer. However, had I the know-how, I would have used parameterized/prepared queries; the reason being that SQLServer (and probably other databases) do clever things to make it fast. The one I want to discuss is the 'prepare' command. Click here for 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. | ||||||||||||||||
|
||||||||||||||||
|
Creating a Trigger A trigger is a stored unit of code that is attached to a table within the database. A trigger cannot be called or used in a select statement in the same way a procedure or function can but are called automatically when an action takes place on the table it is associated with. There are 12 different types of triggers that are possible and these can be split into 3 different groups, they all have the same functionality and limitations but are called at different stages of a table action. To create a trigger the code needs to be entered into the MySQL command line either by typing it in long hand or by using a source file. In this topic triggers will be created against the tables contained in the setup.myp script.
Click here to see the topic. | ||||||||||||||||
|
||||||||||||||||
The way that the project team is organized is directly related to the way the entire organization is structured. There are three major organization structures to manage work and people. Functionally Based In a functional organization, a project team is staffed with people from the same department. All the resources needed for the project team come from the functional organization. For instance, if the project is related to the finance function, the project resources come from the Finance Division. If you need IT, finance and legal resources, they would all be available from within the Finance Division. A second way that a project is staffed in a functional organization is by executing portions of a project in one functional organization at a time. For example, let’s say that a large project needed resources from the Finance, Purchasing, IT and Manufacturing departments. In a functional organization, the project would be broken down by organizational unit and each unit would do their own part relatively independently. The IT Department would work on their piece. The Finance Department would work on their piece. The Manufacturing and Purchasing Departments would work on their pieces. At the end, all of the independent solutions would be integrated into one final solution.
Click
here for more information on
project organization types. | ||||||||||||||||
|
||||||||||||||||
|
Webcasts
| ||||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
Interactive Crossword
Puzzle: "Child of the 70's"
|
||||||||||||||||
|
||||||||||||||||
|
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 |
||||||||||||||||
