Standalone Internet Explorer 7 install
Run Internet Explorer 7 standalone (without touching existing IE6 install). read more →
Download and Install of Java (JRE) on Centos
Here’s how I installed JDK on Centos (thanks to http://www.trading-shim.org/faq/?java) read more →
new explain plan options (dbms_xplan)
I still need to upgrade to 10g … read more →
delete large number of records with intermediate commits
Have to delete a large number of records and running out of undo tablespace ‘ORA-30036: unable to extend segment by 8 in undo tablespace ‘UNDO’? Script below does a delete with intermediate commits ever ‘x’ records. read more →
Progress OpenEdge Database 10.1b install on Centos (RHEL)
What follows is a braindump of every thing I stumled into while getting Progress OpenEdge Database 10.1b up and running on Centos (Red Hat Enterprise Linux). Where Centos is a VMWare virtual machine (guest) with Windows XP as the host operating system. read more →
yum
‘Everythin’ about yum – Yellowdog Updater Modified. Yum is an interactive, automated update program which can be used for maintaining systems using rpm. read more →
Centos 5.0 install fails, kernel panic
The following configuration is at place, VMWare Server (1.0.3) on Windows XP (host operating system). Installation of Centos 5.0 fails with kernel panic. read more →
Create a progress database
Example of manual creation of a progress database using the prostrct utility. read more →
Configure telnet
Install and configure telnet on fresh Debian install read more →
net use: map network share
To map a network share issue command below: read more →
Create, drop and rename a database
Create, rename and drop a database in sql server … read more →
Control Structures
Control structures syntax; IF THEN ELSE, CASE, WHILE . read more →
Use filters to keep your traces meaningfull
Say you have an sql trace for the event ‘TSQL SQL:StmtCompleted’ you are, most probably, NOT interested in the sql statements executed through the SQL Server Agent for instance. read more →
return variables from dynamic sql – sp_executesql
Returing values into tsql variables from a dynamic sql statement using sp_executesql stored procedure. read more →
MSSQL cheat sheet for the Oracle minded
A translation of oracle dba_* tables/v$* views/functions to their respective mssql counterparts. read more →
