Infrastructure at your Service

DBA Archives - Page 3 of 4 - Blog dbi services

Jérôme Witt

OOW Day 4: Dive in, Rock out – Oracle Party & Tomy Kyte’s 12 things on Oracle 12c

By | Technology Survey | No Comments

Well, this last day really was funny! We met some old friends (they will recognize themselves) and also Oracle guru Jonathan Lewis. We must confess Larry Ellison really has good friends. His America’s cup boat is really amazing (see picture below) as was last night’s party. Today, we were really tired and the speakers too. Most of today’s content was a review of what Pierre and I reported during the week. It fits exactly Tom…

 
Read More
Pierre Sicot

OOW Day 2: Enjoying Oracle’s Real World Performance show

By | Technology Survey | One Comment

I have had the pleasure to go the Real World Performance presentation with the famous Tom Kyte of the Ask Tom blog, Andrew Holdsworth, Head of Oracle’s Real World Performance Team, and Graham Wood, the legendary Oracle Database performance architect. This was not a session but more a show like in a theater! Each of them had a precise role, DBA, chief of development team, system administrator, and Enterprise Manager Cloud 12c showing us in…

 
Read More
Open source Team

PostgreSQL: Un aperçu des outils d’administration

By | Database management | No Comments

Nous avons dans les articles précédents vu comment installer PostgreSQL et quels étaient les composants d’une base. Nous abordons maintenant le point de l’action
sur le moteur avec deux outils orientés administration de la base, généralement utilisés par les DBAs. Il s’agit de psql et de PgAdmin. Nous aborderons aussi dans cet article la configuration de connexion au travers des fichiers de configuration du serveur.

 
Read More
Open source Team

PostgreSQL : Qu’ai-je installé, Où sont mes données ?

By | Technology Survey | One Comment

Dans mon dernier article sur PostgreSQL, j’ai présenté l’installation du logiciel en explorant les 2 solutions suivantes, l’installation Debian et l’installation EntrepriseDB. Ces deux installations créent immédiatement un cluster de base de données, Debian nous imposant le point de stockage et EntrepriseDB nous proposant de saisir une destination. Je vous propose maintenant d’explorer ce qui a été installé sur votre disque à la mise en route de ce cluster de base et d’analyser les différences entre les deux installations.

 
Read More
Stéphane Haby

Stéph@TechEd 2012: Episode 1 – the Pre-Conf. Seminar

By | Technology Survey | No Comments

This morning, I was very happy to go to my first TechEd. Between the 10 seminars, as I said yesterday, I started with SQL Server 2008R2/2012 performance, tuning and optimization session. The thing is that we had just one session for the whole day. I will not copy the presentation of the 2 speakers (Thomas LaRock and Denny Cherry) who presented remarkably this session despite the failure of air conditioning during the morning. Fortunately, it…

 
Read More
Stéphane Haby

SQL Server 2012: Feature Pack

By | Database Administration & Monitoring | 2 Comments

Since the third CTP version of SQL Server 2012 codename Denali, you have some features available to provide an additional value for Microsoft® SQL Server 2012 like the other SQL Server versions. This Feature Pack or Manageability Tool Kit are available but are not the final version. I have compiled all information in this blog to find it easily.

All DBA should know that Feature Pack exists, how to find it and of course use it.Wink

 
Read More
Grégory Steulet

MySQL Data High Availability with semi-synchronous replication

By | Hardware & Storage | No Comments

Starting with MySQL 5.5 it is possible to configure semi-synchronous replication. As you probably know, by default, MySQL replication is asynchronous.  Asynchronous replication means that events/transactions applied on one server are not immediately applied on the other one. In the specific context of MySQL such behavior means that the MySQL Master writes transactions/events to the local binary logs, however it has no idea when the slave(s) will get and process them. Of course such configuration can lead, in case of failover, to some transaction loss since there is no guaranty that the transactions have been transmitted on the standby server(s).

 
Read More
Stéphane Haby

SQL Server 2012 ‘Denali’: a new panel of DMVs

By | Database management | One Comment

Dynamic management views (DMVs) return server state information that can be used to monitor the health of a server instance, diagnose problems and tune performance.
Since few months, I test the future new version SQL Server 2012 codename Denali and I was very surprised form the news DMVs from this version.
I will just explain some DMVs very interesting for a DBA.
My article is based on msdn web site reference and you find in the end from each chapter a msdn reference for more details of the DMV.

 
Read More