Mashed Articles

Enjoyed 2 days off in the Ardennes in the woods around Saint-Hubert, I took a book along that was already a couple of months on my bookshelf: Oracle Essentials 4th Edition. Triggered also by a customer looking into Oracle Advanced Queueing (AQ).

Nice book, giving a good overview of all the features available in and around the Oracle database. Obviously the book doesn’t go into every detail, but it does give a good overview or “refresh”.

While reading the book, I came to realize that the Oracle database is 28 years old! I still remember starting my career in September 1987, developing with the Informix database and 4GL on NCR Unix servers. Informix, together with Progress, was a major competitor of Oracle at that time.

Only in 1995 I really worked with Oracle. Oracle 7 with ESQL/C (embedded SQL) in C on Sun Solaris.

At that time, I learned about the distinguishing feature of Oracle: multiversion read consistency. The fact that Oracle will not fail when reading a row updated by another transaction. Instead, Oracle will retrieve the row as it looked like when the transaction started from its transaction logs. This avoids locking all the rows being read, as opposed to all the other databases, including Informix. Obviously, an update of such row will fail as it was already updated by another transaction.

SQL Server 2005 has a great dynamic management view named sys.dm_io_cluster_shared_drives . If you have clustering and want to know what
shared disk/s which is/are used by clustered SQL Server instance run the following query.

SELECT DriveName
FROM sys.dm_io_cluster_shared_drives
ORDER BY DriveName

Seems like unreasonable request.Well, we had a client who wanted by click on icon on his Desktop to launch a DTS Package which runs on another computer.I’d like to share with you the script that friend of mine created on a workstation that did not have SQL Server installed.

MD “\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033″

COPY sqlresld.dll “\Program Files\Microsoft SQL Server\80\Tools\Binn”

COPY dtsffile.dll “\Program Files\Microsoft SQL Server\80\Tools\Binn”
COPY dtsffile.rll “\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033″
regsvr32.exe “\Program Files\Microsoft SQL Server\80\Tools\Binn\dtsffile.dll”

COPY dtspkg.dll “\Program Files\Microsoft SQL Server\80\Tools\Binn”
COPY dtspkg.rll “\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033″
regsvr32.exe “\Program Files\Microsoft SQL Server\80\Tools\Binn\dtspkg.dll”

COPY dtspump.dll “\Program Files\Microsoft SQL Server\80\Tools\Binn”
COPY dtspump.rll “\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033″
regsvr32.exe “\Program Files\Microsoft SQL Server\80\Tools\Binn\dtspump.dll”

COPY axscphst.dll “\Program Files\Microsoft SQL Server\80\Tools\Binn”
COPY axscphst.rll “\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033″
regsvr32.exe “\Program Files\Microsoft SQL Server\80\Tools\Binn\axscphst.dll”

COPY dtsrun.exe “\Program Files\Microsoft SQL Server\80\Tools\Binn”

COPY dtsrun.rll “\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033″

COPY custtask.dll “\Program Files\Microsoft SQL Server\80\Tools\Binn”
COPY custtask.rll “\Program Files\Microsoft SQL Server\80\Tools\Binn\Resources\1033″
regsvr32.exe “\Program Files\Microsoft SQL Server\80\Tools\Binn\custtask.dll”

COPY sqlunirl.dll %SYSTEMROOT%\system32

PAUSE
————–
“\Program Files\Microsoft SQL Server\80\Tools\Binn\dtsrun.exe” /FProcessAppSalesCube.dts

PAUSE