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
…
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
…
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
…
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
…
MySQL 5.6 proposes improved partition maintenance through “partition exchange”. Even if not yet available, dbi services performed some tests on the MySQL Community Edition5.6.2 m5 release (still under Development).
dbi services search and test all tools or functions possible to optimize or to win something to propose the best tuning possible in their client.
The property of Spare columns is not the most used in client environment that we have seen.
This article present a script to find the potential columns that can have the sparse property with the
…
Last Week at my Customer, I used dbua to upgrade an oracle database 10h to 11g, the migration run successfully. But next day I had a monitoring message that the diag directory is groing very fast.
Aprés le post sur « Utilisons les securefile », revenons sur le sujet LOB avec une approche performance, stockage.
Nous rencontrons parfois des modèles de données étranges, nous aurions envies en tant que DBA de tout reprendre à zéro pour refaire un modele relationnel en 3em forme normal (3NF), plus efficace et mieux conçu dans notre « RDBMS » favori, mais la réalité étant
…
This post describes some basic Oracle database management issues database administrators might be confronted with. It is about space management and differences observed while monitoring the available space from several point of views (tablespace/datafile) in Grid Control 11g. It also relates and explains an issue (ORA-01652) observed on pre 11.2 Oracle releases (targets) concerning the tablespace/datafile space management and the…
La nouvelle version d’Oracle SQL Developer (version 3.0.03.45) est prête pour les administrateurs de base de données/DBA (voici une vidéo sur cette version). Elle s’est vue agrémentée d’outils nécessaires aux tâches d’administration. Les tests ci-dessous vous présentent, à travers quelques copies d’écrans, les fonctionnalités de l’outil, en espérant vous donner l’envie de l’adopter.
What is finally the primary objective of a database? Storing Data 
The question is, how Oracle makes it. For many beginners a confusing topic is
to get the picture between physical storage and logical one. So how does it works?
Are you experiencing network access issues after a migration to Oracle Database 11g Release 2 (11.2)? If yes, you probably have to allow the concerned PL/SQL packages to access your network again. This posting will show you how.
