Internet on iPad via adhoc wifi hotspot

›
Scroll down for the solution, read on for some trial-and-error background info. When no direct wifi internet connection is available, then...

Bluetooth device not found on Dell laptop

›
If you are sure you have a built-in bluetooth device on your Dell laptop, but you cannot find it in control panel or device manager, then tr...
1 comment:

CTAS disregards number precision and scale

›
When using a "create table as select" (CTAS) to create a table based on a query, when that query also contains a window function/a...

Subtitle Workshop blank screen with Matroska/MKV containing H.264

›
Scroll down to solution for the workaround to get video in stead of a black screen. Read on for a little bit more background information. ...
11 comments:

TNS service names ODBC dropdown box garbled, messed up, gibberish

›
Most likely cause is that there are two or more different Oracle clients installed, with two or more home folders and tnsnames.ora files. ...
1 comment:

CDBurnerXP: drive not recognized

›
CDBurnerXP is a freeware tool for burning CD's and DVD's, including blueray. However, it sometimes does not recognize the drive to b...

The nearby-future of storage

›
The ioDrive Duo by FusionIO out-performs even multiple SSD's placed in parallel. The 320GB version of the ioDrive has a read/write speed...

SQL Server statistics

›
Statistics are information about the distribution of data in a column, maintained internally by the database engine. Rules and behaviour w...

Set cscript as default script engine

›
To set cscript as the default scripting engine on the system: cscript //h:cscript //s This way, the "wscript.echo" method always ...
1 comment:

Derived table vs subquery

›
There are several ways to combine datasets: Subquery: SELECT clause, correlation Join (cross/left/right/inner/full): FROM clause, no corre...

SQL Developer thick/OCI driver

›
The following error messages may appear when using SQL Developer to select data from a SQL Server table via a (heterogeneous or DG4ODBC) dat...

Oracle JDBC connections

›
The following JDBC drivers exist for Oracle: classes111.jar: Java 1.1 classes12.jar: 1.2 and 1.3 ojdbc14.jar: 1.4 and 1.5 (no JDBC3 and ...

Databases

›
Row-oriented: Oracle DB SQL Server SQL Server CE MySql: InnoDB Sybase Advantage Database Server (ADS) MS Access Column-oriented: Ex...

No login prompt for website

›
Suppose you want to login with Internet Explorer to an intranet website, that uses Windows Authentication as the authentication mechanism. W...
1 comment:

Run SSMS using different Windows account

›
You can log on to a SQL Server database using SQL Server Management Studio (SSMS) with a Windows Authentication login / NT account / Windows...

Change column position

›
In Oracle, it is not straightforward to change the position of a column. Let alone one that contains data. Without resolving to manually c...

Change column data type

›
In Oracle, it is not straightforward to change the data type of a column that contains data. Without resolving to manually changing metadata...

Most recognizable samples

›
Breakbeats Al Green - I’m Glad You’re Mine (0:00) [Eric B. & Rakim - Mahogany, The Notorious B.I.G. - I Got a Story to Tell, RZA - My ...
2 comments:

Identifying keys

›
A key that is made up of one field is a simple key. All other keys are combined keys. There are two types of combined keys, compound and com...

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,...