Truncate tables that have a foreign key

›
A script to truncate tables that have foreign keys referencing them. It also keeps one record in the table, the one with ID=0. In this case,...

Unlimited login attempts on Oracle 11g

›
In Oracle 10g, by default, each user has unlimited login attempts before being blocked. In Oracle 11g this behaviour is changed to 10 attemp...

Reconfigure OracleXE built-in webserver's port

›
OracleXE comes with a built-in webserver, running on port 8080. Since this is a wellknown port, chances are that it is already in use on you...

Cannot load package & required privilege is not held by the client

›
How to start a filesystem dtsx package from sql agent, without a config file or without adding a package password to the command line: - s...
2 comments:

External tables

›
Data can be imported into and exported from Oracle 10g in different ways. E.g. by using the SQL*Loader tool for text files (sqlldr) or the D...

SQLite enforces foreign key constraints

›
As of version 3.6.19, SQLite finally supports foreign key constraints that can be enforced. http://sqlite.org/releaselog/3_6_19.html A pragm...

Measuring disk I/O speed

›
Disk thruput tester is a handy tool to test the sequential read and write performance of storage media, like harddisks and SSD. It supports ...
1 comment:

Winload.exe missing or corrupt (0xc000000e)

›
Today we had a problem with Acronis Disk Doctor. We used it to try to resize a existing partition. The tool doesn't directly support dyn...

Cursor variants in Oracle 10g

›
Examples of different types of cursors. Each has its own pros and cons. Example 1 is the most straightforward and easiest to understand. The...
1 comment:

Create handwritten truetype font for free using fontcapture

›
Fontcapture ( http://www.fontcapture.com/ ) is the only website I could find that offers a service to convert handwritten characters into a ...

Netsend

›
Windows Vista and Windos 7 are no longer shipped with the command line tool netsend. Fortunately, a freeware alternative is available at: ht...

List of freeware tools

›
Explorer & OS Total Commander (shareware): http://www.ghisler.com/ 7-Zip: http://www.7-zip.org/ VirtualCloneDrive: http://www.slysof...

Great directors and actors

›
Just a list for myself, because I keep forgetting names. Directors Darren Aronofski: Pi, Requiem For A Dream, The Wrestler Christopher Nolan...

Oracle SQL Developer screen redraw glitch

›
Perform the following steps to fix the redraw, or screen refresh, bug that can occur in Oracle SQL Developer when used on Windows Vista and ...
4 comments:

Remove visual rings / circles from pen tablet in Windows 7

›
When using a pen in stead of a mouse in Windows, rings or circles may appear when you click. This happens at least in Vista and Windows 7. I...
3 comments:

Limited connectivity using wireless internet in Vista Home SP1

›
I've had an issue with "limited connectivity" on my Vista Home SP1 installation. It is a laptop that connects wirelessly (WiFi...
2 comments:

Simple way to read Excel or Access data in SQL Server

›
-- list of available providers exec master..xp_enum_oledb_providers -- Three ways to read in Access data (file: c:\db1.mdb, tabel: TEST) ...

Converting WAV DTS to MP3

›
A WAV DTS file contains a multi-channel encoded digital format called DTS and has .wav as extention. Playing such a file in Zoomplayer or Wi...
19 comments:

Money pit on Oak Island

›
Very bizarre story: http://www.activemind.com/Mysterious/Topics/OakIsland/ I've put it here so I don't forget to check progress on t...
1 comment:

Drupal Clean URL's with IIS7

›
Drupal can work with clean URL's (or URL write). The most talked about solution is using Helicon's ISAPI _Rewrite ISAPI add-in, whic...
4 comments: