Infrastructure at your Service

David Hueber

Oracle 12c Backup & Recovery: What’s new?

By | Database management | One Comment
 

  After months of waiting, Oracle Database 12c is finally available. In this posting, I am going to provide a summary of the new features of Oracle 12c in terms Backup and Recovery. Pluggable, what else? For sure, the most remarkable change in this brand new version is the Pluggable Database or so called Multitenant Database concept, which is a huge change in the whole RDBMS architecture. So what does it offers in terms of…

Read More
Stephane Biehler

A comparison of Java Virtual Machines: Hotspot JVM vs JRockit JVM

By | Application integration & Middleware | 11 Comments
 

 You might know that there are many JVMs available today, but do you know the difference between them? In this blog I will not state all JVMs as it will take too much time But I will talk about Hotspot and JRockit, because they are pretty used and because they will eventually merge in Java 8! That’s what they say at least… What’s a JVM? Well this is a reminder and you might want to…

Read More
Stéphane Haby

SQL Server 2014: AlwaysOn-Verfügbarkeitsgruppen – jetzt mit Microsoft Cloud!

By | Database management | No Comments
 

  SQL Server 2014 bietet jetzt (oder bald :roll:) die Möglichkeit der Integration von AlwaysOn-Verfügbarkeitsgruppen mittels virtueller Maschinen, gehostet in der Windows-Azure-Infrastruktur (IaaS). Sie können sekundäre Datenbanken direkt in der Cloud vorhalten, wie das Beispiel zeigt: Der Einsatz von asynchroner sekundärer Replikation in der Cloud ist durch die Integration des Assistenten in SQL Server Management Studio (SSMS) erleichtert worden. Was sind die Vorteile dieser Entwicklung? Der erste Vorteil ist Kostensenkung, wenn Sie Ihre Hochverfügbarkeitslösung erweitern…

Read More
Oracle Team

Oracle Database 12c: Moving a datafile is now possible online

By | Database management | 9 Comments
 

  Gone are the days where you had to put a tablespace or your complete database offline in order to move or rename a datafile. Oracle 12c features a new command that allows to move datafiles when both database and datafile are online! Up to Oracle 11.2.0.3, you had three ways to relocate a datafile: Put the tablespace offline Put the datafile offline Shutdown and mount the database Oracle 11g: Tablespace offline Renaming a datafile…

Read More
Stéphane Savorgnano

High availability and disaster recovery on Windows Azure VMs

By | Technology Survey | No Comments
 

  To be honest, I am not a specialist of Windows Azure. In order to learn a little bit more about this subject, I decided to follow a TechEd Europe 2013 session about High Availability and Desaster Recovery on Windows Azure Virtual Machines. Overview of Windows Azure Windows Azure is Microsoft’s application platform for the public cloud. You have the possibility to use this platform in many different ways: build a web application that runs…

Read More

Oracle Database 12c: Flashback Data Archive (FDA) – new features

By | Database management | One Comment
 

  Oracle Database 12c was published in June and among the new features of this release are multiple improvements of the Flashback Data Archive (FDA), an option also known as Oracle Total Recall. In this post, I will present the new features coming with Oracle 12c. Overview Before speaking about these improvements, let me point out the main concept of Oracle FDA. Flashback Data Archive appeared with Oracle 11g and improved the flashback technology introduced…

Read More
Pierre Sicot

Oracle Database 12c: Oracle OEM express

By | Database management | No Comments
 

  Together with Oracle Database 12c, Oracle has introduced a new administration console named Oracle Enterprise Manager Express (Oracle OEM Express). This “light” version of Enterprise Manager Database Console – which is not supported in Oracle 12c anymore – is a management product built into Oracle Database 12c. There is no installation or management required, the database creation with dbca enables OEM Express and gives you the URL connect string. As there is no mid-tier or…

Read More
Stéphane Haby

SQL Server 2014 CTP1 is available

By | Technology Survey | No Comments
 

  Last week, I gave you some news about SQL Server 2014 (here). SQL Server 2014 Community Technology Preview 1 (CTP1) now is available for download on TechNet here (you need a TechNet subscription).   Attention: Only the new feature “in-memory OLTP – codename Hekaton” has been added to this CPT. I hope that other features will soon come with the next CTPs. If you don’t have a TechNet subscription yet, be patient, it should arrive…

Read More
Pierre Sicot

Discovering Oracle database 12c targets (CDB, PDB) in Cloud Control 12c

By | Technology Survey | No Comments
 

  In my consultant’s activity at dbi services, I had the opportunity to test the new databasion version Oracle 12c. As an Enterprise Manager Cloud Control 12c fan, when the 12.1.0.3.0 Oracle database plugin was made available, I decided to test the Cloud 12c behavior with the Oracle 12c database and also CDB and PDB (Container Database and Pluggable Database). Before installing the Oracle Database Plugin 12.1.0.3, the 12c databases are seen up but when…

Read More
Stéphane Savorgnano

Microsoft TechEd Madrid: Windows Server 2012 R2, High Availability, SQL Server Data Tools

By | Technology Survey | No Comments
 

  Let’s talk about my third day at TechEd 2013. I started with a session about: Windows Server 2012 R2 and High Availability The goal of High Availability is to deal with possible points of failure in your infrastructure. There are multiple ways to manage HA on the market: Server Server redundancy deployments Run server inside a clustered VM Backup Monitor via a SCOM Management Pack Database SQL Server 2012 AlwaysOn Mirroring, Replication, Backup Run…

Read More
David Hueber

Oracle 12c: Pluggable databases not that isolated

By | Database management | 12 Comments
 

  As you probably know, the multitenant databases is the new feature of Oracle 12c to solve the dilema of applications segregation. Thanks to a multitenant container database, it allows to manage many databases as one taking advantage of resources consolidation. A perfect way to manage several applications in a single container. However are these plugglable databases that isolated as expected? Not exactly: As I will show in this posting, a single PDB can, under…

Read More