IDUG Content Committee

by Tony Andrews ( @Tony Andrews ) SQL tricks is a rather broad term, and these articles are really about a number of unique / different things that can be done in the SQL programming language that hopefully readers can learn from and possibly use. ...

4 people recommend this.

David Birnie

BNZ

Carol Goldberg

State of Texas

Rafal Omilian

IBM

alain pary

Database Business Partners SPRL

When you’re starting out with Data Science and you’re building your skills, sooner or later you’ll want to play with Anomaly Detection, and the first thing you’ll see when you look it up is the number of ways you can begin exploring the topic. We can ...

2 people recommend this.

Manik Kainth

Broadcom

Brian Laube

Manulife Financial

Connecting to Db2 remotely means the use of a client. Sometimes that client is installed software and other times it is as thin as a JDBC driver. In any event, a client talking to a Db2 server will invoke one or more bound packages on the server side. ...

Index Compression has been available in Db2 since Version 9. But my impression is that it is under-utilized out in the real world. What is index compression? What is the benefit? Why should it be considered? Read the full article here

1 person recommends this.

Brian Laube

Manulife Financial

IBM Db2 with BLU Acceleration is commonly used in warehouse environments to facilitate industry-leading analytical processing of data. This technology is composed of many valuable pieces, but two that we regularly highlight are extreme compression ...

1 person recommends this.

Brian Laube

Manulife Financial