Blog

Enterprise Average Cost Per User

Jun 16 2015

When pricing the costs of building an application, knowing your projected Average Cost Per User (ACPU) is a critical first step. When starting a new project having this data early on can help influence how you design your system. It can also be an early way to know whether the economics of an idea are […]

Benefits of Amazon Web Services (AWS)

May 27 2015

Amazon Web Services (AWS) and cloud computing in general is a major paradigm shift in terms of how to best operate enterprise systems. In the past, companies would buy hardware based on loose metrics or even a gut feel of what capacity they need to grow. This would even come down to end of year […]

ROLLUP, CUBE, and GROUPING SETS

Oct 15 2013

The ROLLUP, CUBE, and GROUPING SETS operators are extensions of the GROUP BY clause. The GROUPING SET is the union of the aggregates based on the columns specified in each set in the grouping set. Multiple columns that are in inner parentheses in the GROUPING SETS list are treated as a single set. The following […]

START WITH CONNECT BY SQL

Oct 15 2013

The START WITH… CONNECT BY clause can be used to select data that has a hierarchical relationship such as manager to employee relationships. The root of the hierarchy is selected with the START WITH condition. In the example below from Oracle, the top level manager has an employee_id of 100. The output is sorted by […]

Grails Domain Class Reload Issuing Count Query

Aug 08 2012

When a Grails domain class is reloaded after a change, the Hibernate plugin for Grails verifies the domain class reloaded successfully by calling its count() method. Unfortunately, while somewhat rare, it is possible to have a domain class mapped to a very large table (or a view that joins very large tables) where a count […]

12345...