(Martin Brown) Erlang is a multi-purpose programming language that is primarily used for developing concurrent and distributed systems. Part 1 of this series introduced Erlang and how its functional programming style compares with other programming paradigms such as imperative, procedural, and objec
Other News
Bash: recursive search for content in a file
(Alex Bleasdale) Recursive search example using find, xargs and grep
Moving a database between two SQL Server instances
(Tibor Karaszi) Moving a database from one SQL Server instance to another instance is a pretty frequent task. Reasons vary, of course, some examples:
Slow in the Application, Fast in SSMS?
(Erland Sommarskog) When I read various forums about SQL Server, I frequently see questions from deeply mystified posters. They have identified a slow query or stored procedure in their application. They cull the SQL batch from the application and run it in SQL Server Management Studio (SSMS) to ana
Oracle Data Integrator (ODI) 11g: limitation of load plans
(Uli Bethke) When I first heard about the new load plan feature in ODI 11.1.1.5 I thought it could replace our custom developed scheduling mechanism.
ORA-12547: TNS:lost contact
(Amardeep Sidhu) Very simple issue but took some amount of time in troubleshooting so thought about posting it here. May be it proves to be useful for someone.
Getting the most out of SQL Server information schema views
Information schema views are one of several methods available in SQL Server for accessing metadata. The views let you retrieve metadata about data objects stored within the database. For example, you can use SQL Server information schema views to access details about the data types, nullability or d
Installing Python, Django, and DB2 on Ubuntu 11.04
(Antonio Cangiano) In this brief tutorial I’ll show you how to create a complete Python and Django setup for DB2 on Ubuntu. By following my step-by-step instructions, you’ll be able to install the following components:
Connecting orphaned .ibd files
(Aleksandr Kuzminsky) There are two ways InnoDB can organize tablespaces. First is when all data, indexes and system buffers are stored in a single tablespace. This is typicaly one or several ibdata files. A well known innodb_file_per_table option brings the second one.
Oracle XML capabilities in Oracle Database 11gR2, part 3
(Jeff McCormick) Oracle database professionals must often expose data for relational applications, whether it be document-centric for unstructured XML or data-centric for structured XML.