About MH17

Written on 18 July 2014, 01:41pm

Tagged with: ,

About airlines:
- it will be very difficult for Malaysian Airlines to recover after 2 major aircraft losses 4 months apart
- all the airlines claim that the safety comes first, but it took 298 lives to avoid the airspace over the conflict area
- about the Air Traffic Control (both Eurocontrol and Ukrainian ATC): they have their part of the fault in the sense that they could have requested the traffic to be diverted out of the conflict area. The only thing that they did was to ask the aircraft to climb 1000 meters feet above the normal cruising altitude; still insufficient to avoid the missile.

malaysia-plane-900
Image: Boston.com
(more…)

Service management

Written on 16 July 2014, 09:16pm

Tagged with: ,

- How many Service Desk staff does it take to change a light-bulb?
a) None. Restoration of service is a Level 1 Support function

Multiple choices here :)

I recently spent some time reading about service management, more specifically, ITIL. Some notes – in random order – below:
- Service - a means of delivering value to customers by facilitating outcomes that customers want to achieve without the ownership of specific costs or risks
- Service Management – a set of specialized organisation capabilities for providing value to customers in the form of services
- Process – a structured set of activities designed to accomplish a specific objective.
(more…)

Oracle – merge multiple records into single row

Written on 15 May 2014, 10:09am

Tagged with: ,

Another post in the series ‘remember this SQL trick:)

The within group clause can be used to merge multiple records into a single row. In the classic emp table with ename and deptno columns, the query is:

select
   deptno,
   listagg (ename, ',') 
WITHIN GROUP 
(ORDER BY ename) enames
FROM 
   emp
GROUP BY 
   deptno

The article below displays more ways of doing this, but the query above worked for me.
Oracle SQL: displaying multiple column values per row