(Richard Carr) In denormalised databases, such as those used for reporting purposes or to feed data warehouses, it is common to need to query information from a group of columns where only one has a value. This can be simplified with the coalesce function.
Author: SSWUG Research
Non-root installation feature of Informix: Client perspective
(Kollol Kumar Misra, Mamta Sharma and Tapan Kumar Ghosh) Starting with IBM Informix 11.70xC2, Informix started supporting the non-root installation feature. This feature, sometimes called private installation, allows Informix to be installed by a user other than root and permits the software to run
SQL Server JOINs with Examples
(Archit Patel) I will explain types of SQL JOINs in this article. JOINs in SQL Server can be classified as follows:
Absolute versus Relative Reference
(mdinh) It’s important for software developers to understand the differences between absolute versus relative references.
SQL Translation Framework
(Kerry Osborne) My favorite new Oracle Database 12c feature is the SQL Translation Framework. The feature grew out of SQL Developer’s ability to translate SQL from non-Oracle RDBMS’s. For example, there is a pre-built Sybase ASE translation package that is designed to translate the Sybase dialect of
DB12c DBCA – Create a Pluggable Database
(Bobby Curtis) With the release of Oracle Database 12c, there is a lot of excitement and thoughts about multi-tenant databases. This basically means that we can run more database while achieving a smaller foot print on servers and within the infrastructure. This concept of multi-tenant databases
Faster DB2 Performance with IBM FlashSystem
(Karen Orlando and Megan Gilge) This IBM Redbooks Solution Guide provides an overview of IBM FlashSystem running in a DB2 environment with a focus on performance and the benefits gained from running DB2 with Flash storage.
SQL SERVER – Database in RESTORING State for Long Time
(Pinal Dave) A very interesting question I received the other day.
Programming model support in lightweight Java servers
(Roman Kharkovski) Software developers have a lot of tools at their disposal when building modern applications with Java application servers. One of the many trends is the use of lightweight application servers. There is no strict definition of “lightweight”, but generally speaking these are product
Programming model support in lightweight Java servers
(Roman Kharkovski) Software developers have a lot of tools at their disposal when building modern applications with Java application servers. One of the many trends is the use of lightweight application servers. There is no strict definition of “lightweight”, but generally speaking these are product