Today, no keynote, we went directly to the sessions. Therefore I have scheduled my day around 3 goals: SQL Server 2012 and Windows Server 2012 and Parallel Datawarehouse, with the new features in the release AU3.
In this example the below tables from schema G001SCHEMA on Database PROD1 will be added, to an existing Replication from PROD1 to REP
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.