Crimson Miracle Security Seminar

On March 22nd Miracle and Crimson will host a security seminar centering on the protection and use of personal data. The main focus will be on the PCI standard, the effect of GDPR and how the two interact. PCI is a standard created by the PCI Security Standards Council which is backed by major card issuers. The purpose of the standard is to protect card information. GDPR (General Data Protection Regulation), which will come into effect on May 25 2018, aims at strengthening and unifying data protection for individuals within the EU.

The seminar is open to everyone and is relevant to management, technicians and other staff of organizations that handle card information and personal data. The morning session has a wider scope and the afternoon session dives deeper into the technical aspects.

More information and registration here

SQL Saturday Iceland 2017

Miracle is a sponsor for SQL Saturday Iceland and therefore I am posting this on behalf of the preparation team.

The second annual SQL Saturday Iceland free training event is approaching fast. On March 18th around 20 speakers will be in Iceland to tell us all about the Microsoft Data Platform. There will be three tracks to choose from: one focusing on developers, one focusing on DBAs and one focusing on BI. There are 21 sessions so everybody should be able to find something to their liking. The conference is held at Reykjavik University and the sessions are in English. The best thing about this is that access is completely free and the conference is open to all. Although the sessions are free we ask that you register as we will also be serving complimentary lunch and we need to estimate the required quantities. Please register at


The three-day Building Desktop APEX Applications course will be hosted by Miracle between March 28th and 30th in Reykjavík, Iceland. APEX, which is included at no additional cost with Oracle Database, has become increasingly popular in recent years as a simple and powerful tool to build web interfaces on top of Oracle-based business applications. The course will be led by Scott Spendolini who has worked as an APEX consultant and instructor for many years. He has written two books on the subject of APEX development and security and worked for a few years as Senior Product Manager for APEX at Oracle Corporation. The course is intended for Oracle database application developers and business users who want to gain an understanding of how to build APEX applications. Please see for further information.

Coming to Reykjavik – Troubleshooting Oracle Performance

Miracle will host the Troubleshooting Oracle Performance course by Christian Antognini in Reykjavik in May 2017. Based on the 2nd edition of the book Troubleshooting Oracle Performance this 2-day seminar is an introduction to diagnosing and resolving performance problems in database-backed applications involving Oracle Database. Application developers, database administrators, and performance analysts will benefit from the contents of this course. Please see for further details.

The Myth of Self-Service Analytics

Recently, I read an article titled ‘The Myth of Self-Service Analytics’ ( which discusses the danger of jumping on magic solutions based on colourful software tools which, supposedly, can enable everyone and anyone to analyse information and business data. My favourite gripe is about Self-service BI because there is more than meets the eye when it comes to this topic. There are several points to keep in mind while discussing Self-service BI because they are, as usual, not black and white but grey.


  1. BI companies want to sell their Self-service BI (SSBI) tools as widely as possible.
  2. The target group for SSBI tools is the management level. Data analysts and information professionals are preferably left out of the sales process as they understand what is really needed to make sense of data and present information in an appropriate manner.
  3. Self-service BI can NEVER work without a data warehouse of some kind. This means that the whole concept is, to a point, a deception. “Here is your tool, here is your database with 25 thousand tables. Give me sales figures and a forecast for the next year tomorrow.” It goes without saying that this is an unrealistic scenario.
  4. SSBI can work for superusers who work with a set of well-defined data. Nevertheless, there is always a risk of more than one version of the truth under those circumstances. Of course, that danger is also present when data scientists and information professionals are involved but the risk is greatly reduced.
  5. SSBI has been around for a long time but not necessarily under that name. DSS – DW – OLAP – Analytics – SSBI. These are not necessarily exactly the same concepts but there is a very big overlap. To a certain extent making users self-sufficient has always been the goal of BI and it is certainly possible but it doesn’t happen without a solid foundation and that foundation is your data warehouse.