Infrastructure at your Service

Oracle Team

Oracle 12c: Applying PSU 12.1.0.1.1 with Multitenant DB & unplug/plug

By | Database management | No Comments

The concept of Multitenant databases, which was introduced with Oracle 12c in June 2013, allows to run several databases on a single instance. Oracle presents this feature as a good solution for Oracle patching. The reason behind it is that it is now possible to unplug a container database (called PDB) from its original container (called CDB), in order to plug it into a new local or remote Container with a higher level of PSU….

Read More
Oracle Team

Sockets, Cores, Virtual CPU, Logical CPU, Hyper-Threading: What is a CPU nowadays?

By | Application integration & Middleware, Oracle | 6 Comments

By Franck Pachot . Because people know that I really like Oracle AWR reports, they send them to me from time to time. Here is one I have received for Christmas with the following question: ‘Since our AIX server is virtualized, the response times are 4x longer. I feel that we are CPU bound, but cpu usage is mostly idle. Is there something hidden?’ It is a question that is frequently raised with virtualized environments….

Read More
Pierre Sicot

Implementing Oracle Database as a Service (DBAAS)

By | Database management | 3 Comments

Oracle DBAAS (Database As a Service) offers a good solution for on demand access to software and infrastructure. In this posting, I will describe the DBAAS implementation with Enterprise Manager Cloud 12c. Why Database as a Service is interesting When a developer team needs a new database, the system administrator has to configure the host, the storage administrator has to configure the storage, and the database administrator has to download the latest oracle database version…

Read More
Stéphane Haby

With Power Query, converting an internet table to Excel is an easy job!

By | Application integration & Middleware | No Comments

While exploring SQL Server 2014, I was surprised by the powerful Power Query feature. In the recent past, converting an internet table to Excel was a nasty work leading to format problems, implicit conversions, etc. With Power Query, importing tables from the internet is very easy! What is Power Query? Power Query is a tool based on the concept of Power BI (more on this tool here). Power BI is composed of: PowerPivot The first…

Read More
Stéphane Haby

SQL Server 2014 – New Features: xVelocity memory optimized columnstore index

By | Application integration & Middleware | No Comments

Some customers or colleagues recently asked me about the SQL Server concept xVelocity and in particular the SQL Server 2014 feature new xVelocity memory optimized columnstore index. So I decided to write a few words on the dbi services blog. What is xVelocity? Introduced in SQL Server 2012, xVelocity is composed of two features:  xVelocity in-memory analytics engine  xVelocity memory-optimized columnstore index xVelocity in-memory analytics engine The xVelocity in-memory analytics engine is an update of…

Read More
Pierre Sicot

Oracle Database 12c: Database Migration Assistant for Unicode

By | Technology Survey | One Comment

The choice of the correct character set before you create an Oracle 12c database is an important decision. You have to know the type of data you have to store and the languages needed by the Oracle database. Oracle recommends to choose Unicode for its universality and compatibility. It supports all written languages and most of the technical and scientific symbols. Before Oracle 12c changing the database character set was an pretty nasty task and…

Read More
Microsoft Team

IT Pro TechDays 2013 in Lausanne: BYOD, SQL Server & SharePoint

By | Technology Survey | No Comments

I had the opportunity to attend the IT Pro day at the Microsoft Techdays in Lausanne. Let me give you a few insights on my day there. Being a SharePoint specialist but also ramping up on Microsoft SQL Server I tried to balance between SQL and SharePoint related sessions. BYOD As usual, the day started with a Keynote focusing on an overview of the new Windows 8.1 and Windows Server 2012 R2 features. Well… it…

Read More
Morgan Patou

Developing an archive action for Alfresco Share (2 of 2)

By | Application integration & Middleware | 6 Comments

In my last article, I presented the first part of setting up a new action for Alfresco Share, which is an archive action. I advise you to read the first part if you have not read it yet since it is a prerequisite for the proper functioning of the action: Developping an archive action for Alfresco Share (1 of 2). The purpose of this part is to extend the user interface with the creation of an…

Read More
Nathan Courtine

SQL Server 2014: An overview of the New Features

By | Database management | One Comment

The Microsoft Techdays 2013 took place on 12-13 November at the Congress Center in Basel and on 18-19 November at the Beaulieu Congress Center in Lausanne. With more than 400 participants in Lausanne and around 1’000 participants in Basel, the largest technology event Microsoft in Switzerland was a great success. You can follow all the presentations from Lausanne or Basel. In this blog, I will summarize the presentation of SQL Server 2014: les nouveautés by…

Read More
Pierre Sicot

UKOUG Day 4: Oracle Cloud Control 12c for DBAs

By | Technology Survey | No Comments

Today’s first session was a round table session with Andrew Bullock, Director of Application and systems management at Oracle. The main result of this session was that the main people using Enterprise Manager Cloud Control 12c were DBA and not so much system or Weblogic Administrators. It appears also that not so many DBA have realized in production the upgrade from Grid Control 11g to Cloud Control 12c, because in case of a huge number…

Read More
Nicolas Jardot

UKOUG Tech13: Optimizer & SQL statements – hint or not hint that’s the question

By | Technology Survey | No Comments

It’s the final day of Tech13, less sessions but still good topics. Mainly about the Oracle’s optimizer: looking at the execution plans and a debate about hinting SQL statements. I will focus on the hint topic in this blog. Due to trip planning it’s a much shorter day, less time for attending sessions and less time for blogging. I will focus on the debate between Tony Hasler and Jonathan Lewis about how the optimizer takes…

Read More