Server Monitoring With munin And monit On Debian Etch

In this article Falko Timme describes how you can monitor your Debian Etch server with munin and monit. Munin produces nifty little graphics about nearly every aspect of your server (load average, memory usage, CPU usage, MySQL throughput, eth0 traffic, etc.) without much configuration, whereas monit checks the availability of services like Apache, MySQL, Postfix ...

Access migration to Application Express

The only requirement, is that you have SQL access to any Oracle database (9iR2+), because the workbench is driven using an underlying migration repository. You could use the Express Edition of Oracle for this purpose, which is totally free, if you didn't have SQL access to an existing Oracle database.
Full text

Custom APEX Authentication / Authorisation Schemes

Duncan Mein has created a nice How-to for setting up Custom Authentication (Part 1).

Top 15 free SQL Injection Scanners

SQL Injection is perhaps the most common web-application hacking technique which attempts to pass SQL commands through a web application for execution by the back-end database.

More...

Store MS Word Documents in Oracle

Follow the following steps..... :)

1) Create a table
CREATE TABLE my_docs (
name VARCHAR2(200) NOT NULL,
doc BLOB NOT NULL
);

2)Create a directory object which stores all your doc
CREATE OR REPLACE DIRECTORY documents AS 'C:\work';

3)Create a procedure
CREATE OR REPLACE PROCEDURE load_file_to_my_docs (p_file_name IN my_docs.name%TYPE)
AS
v_bfile BFILE;
v_blob BLOB;
BEGIN
INSERT INTO my_docs (name, doc)
VALUES ( p_file_name, empty_blob())
RETURN doc INTO v_blob;
v_bfile := BFILENAME('documents', p_file_name);
Dbms_Lob.Fileopen(v_bfile, Dbms_Lob.File_Readonly);
Dbms_Lob.Loadfromfile(v_blob, v_bfile, Dbms_Lob.Getlength(v_bfile));
Dbms_Lob.Fileclose(v_bfile);
COMMIT;
END;
/
4)Execute the db procedure...

[This is sgalaxy solution form Oracle forum]

Hacking SQL Server

In this presentation at the Jacksonville SQL Server Users Group, Bayer White playS the part of a developer protecting his application and Brian Knight attempts to hack his application using SQL Injection and cross-site scripting. Then, Bayer will show you how to protect yourself from the hacker and then Brian tries again. Back and forth the chess match goes until someone wins!

Understanding Relationships in E-R Diagrams

Few articles about E-R diagrams worth to read:

Understanding Relationships in E-R Diagrams (part 1, 2, 3)
Documenting Entities, Attributes & Relationships
E-R Diagram Relationship Integrity Constraints
Interpreting Cardinality and Dependency on an E-R Diagram
Guidelines for Naming E-R Attributes
Recursion in E-R Relationships
Notations on Entity-Relationship Models
Entity-Relationship Diagram Checklist

Mini data generator

Will Hitchcock proposed a PL/SQL approach for generating the 1000 rows:

declare
i number := 1;
begin
for i in 0..999 loop
insert into pivot values (i);
end loop;
end;
/

Oracle Menu (om) is only a shell script.

Oracle Menu is only a shell script.

What does it do?
It just helps with often performed tasks and navigating around the file system and can give you useful information quickly.
It can help you perform some of the more monotonous tasks a DBA has to perform without having to know too much.
It can help you if you work between many sites often as it can hide some of the underlying differences, such as filesystem layout etc.

Drupal + Oracle: Inside the OraDrup Project

In this case study, it is described the OraDrup Project, which has the goal of combining the popular open-source Drupal CMS with Oracle Database.

Link 1
Link 2