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…
Few days ago, I was at a customer that encountered some problems trying to restore his MySQL database. Indeed he got the following error message trying to restore his xwiki database:
mysql@dba-ecm-srv11:/ [mysqld1] mq < /MyBackupFile.sql
ERROR 2006 (HY000) at line 283: MySQL server has gone away
Data can be corrupted in different ways, for example an I/O issue when reading data from the storage or a memory issue when updating data. The db_block_checking parameter allows to change the behavior of an Oracle database concerning block checking.
This posting will present this parameter and some tests to measure its impact on the database.
In a WebLogic server domain set as a Production domain, when we try to connect to the Node Manager with WLST we get the following error: Cannot connect to Node Manager. : Access to domain ‘testcluster’ for user ‘weblogic’ denied This blog gives the solution to solve the issue. First of all, we observe that the Node Manager is working fine because it is accessible with the WLS admin console and the managed servers can…
En 2012, les principaux systèmes de gestion de bases de données relationnelles (SGBDR) sur le marché sont propriétaires. Nous parlons régulièrement d’Oracle Database, MySQL, Microsoft SQL Server. En dehors de ces solutions commerciales, il existe un SGDBR open-source largement utilisé: il s’agit de PostgreSQL et il est l’objet de cet article.
Recently, at a customer site, I discovered the Attunity connector 1.1 for Oracle. The customer uses this connector to transfer data from Oracle to SQL Server using Integration Services (SSIS) and informed me that performances are greatly improved. So I decided to post a blog about this connector and perform a benchmark between Attunity connector and Microsoft OLE DB provider for Oracle.
In my precedent article, I announce you the first fix for SQL Server 2012.
One week after, the first cumulative update is downloadable on Microsoft website for SQL Server 2012.
With the appearance of WebLogic Server as Oracle application server and the emergence of the Oracle Fusion Middleware suite, some may wonder what will be the support of their Oracle Internet Application server license, e. g. Oracle Forms and Reports services, Business Intelligence Edition, etc. As a consultant, I am often dealing with these kinds of problems and aiming to improve license benefits. In this post, I want to focus on Oracle Internet Application server licenses.