Removing Duplicate Rows

Oracle
For our example we need to insert a duplicate row into HR.EMPLOYEES first. The new row has to be identical on first_name, last_name, email and department_id columns. To insert such a row, we have to disable the unique constraint on the HR.EMPLOYEES table.
ALTER TABLE employees DISABLE CONSTRAINT emp_email_uk;
INSERT INTO employees (
EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER,
HIRE_DATE, [...]

How to Save Large Objects with ASP.NET 2.0 to SQL Server 2005

Prepare Database for Storage of Large Objects
VARBINARY(MAX) datatype is used for storage of binary large objects (BLOB) in SQL Server 2005. The formerly used IMAGE datatype is still available for compatibility reasons but should not be used for new projects.

Best practice to avoid fragmentation of the PRIMARY-filegroup is to create a text/image-filegroup for storing large [...]

Nightly Full Export Without Showing SYSTEM Password Using Data Pump

In addition to RMAN backup I have a full export batch running every night on all databases. The SYSTEM password has been kept in the batch script. Whoever can logon to the system and read the file knows the SYSTEM password.
In 10g with DBMS_DATAPUMP called from a simple PL/SQL package I can schedule the nightly [...]