Infrastructure at your Service

 
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 wollen….

Read More
Oracle Team

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

By | Database management | 12 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 by…

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 and…

Read More

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

By | Database management | 3 Comments

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 with…

Read More
Oracle Team

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 middleware…

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
Oracle Team

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 we…

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 SQL…

Read More
David Hueber

Oracle 12c: Pluggable databases not that isolated

By | Database management | 13 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 certain…

Read More
Oracle Team

Oracle Database 12c: Grid Infrastructure, quoi de neuf?

By | Operation systems | One Comment

A la lecture du New Features Guide, on trouve dans le chapitre sur Grid Infrastructure beaucoup de nouvelles fonctionnalités pour Grid Infrastructure, ASM et ACFS, mais l’événement est l’annonce d’une grosse évolution dans l’architecture du cluster. Flex Cluster En effet, cette version 12c introduit une nouvelle architecture nommée Flex Cluster dont voici un aperçu: Schema Oracle documentation Les objectifs annoncés sont “évolutivité, flexibilité et facilité de gestion”. Ainsi, nous pourrons choisir l’organisation “topologie” de notre…

Read More
Stéphane Savorgnano

Microsoft TechEd Madrid: Optimizing T-SQL & SQL Server 2014 Futures and Features

By | Technology Survey | No Comments

Today, I am beginning my second TechDay by a session about Optimizing T-SQL. You need to know about this if you are using SQL Database or Microsoft SQL Server 2012. Tobias Ternström, Lead Program Manager, was the speaker of this session. His team, five hundred persons, works on SQL Server engine and mostly focuses on performance. There are 3 three different ways to run SQL: Physical machine can be scale-up full control roll your own…

Read More
Oracle Team

Oracle Database 12c: Gérer le Password File avec ASM

By | Database management | No Comments

En dehors de l’annonce de Flex ASM, ASM évolue peu dans Oracle 12c. La plus intéressante des améliorations pour les administrateurs de bases de données en cluster est l’introduction de la gestion des “Password Files” dans ASM. C’est l’objet de ce posting. Rappel Tout d’abord, un retour sur l’utilité du Password File et des éléments de configuration: Orapwd est l’outil pour créer un fichier de mots de passe pour authentifier les utilisateurs Oracle à qui l’on…

Read More