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…
DBA Archives - Page 3 of 4 - Blog dbi services
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…
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.
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.
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…
Recently, during my many missions, a client asked me to give access rights to the SQL Server Logs from SSMS to his application managers.
As you know, you must give the role “securityadmin” to have such rights but with this role you can also manage logins, CREATE DATABASEs and change passwords.
This is “too many rights” for this IT manager… but no other way!
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.
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).
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.