Your newsletter subscriptions

Promoted Resources

Today's Top Picks for Our Readers:

Recommended by

Don't you have a chop with useful queries to use in your daily adventures and desventures with the database? I include in this first post a…

A very powerful way to do a table's update in a SQL Server database is to link it with another table with a join, and updating the fields…

The operator to concatenate in SQL Server is '+', but this operator is also used to add values. Being the same operator for both, the…

Data warehouse security is vital for organizations that take the huge step of collating all their important data in one place. Unauthorized…

Db2look is an utility to extract the definition of database objects.

A simple way to export data from a query, table, etc.. of an oracle database to a flat file is to use the SPOOL command in SQLPlus. This…

Pentaho was created in 2004 and at this moment, it is the leader of the Open Source BI solutions. It offers a large spectrum of resources…

We could need to access to MySQL from SQL Server. An easy way to do it is creating a linked server that uses an ODBC connection..

DB2 command line utility has different options.

Maybe there are other methods, in this short article, a simple way to know the port that serves DB2 server.