Blog Categories Categories
Categories
dbi services Blog
Welcome to the dbi services Blog! This blog focuses on database infrastructure and middleware topics. It covers technologies such as Oracle, Microsoft SQL Server, MySQL, Sybase, Linux, or Documentum (etc.). The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on the postings!
Technology Survey (22)
|
PostgreSQL: une présentationCategory: Technology Survey
Posted On Monday, 07 May 2012
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'...
SQL Server 2012: First cumulative update is onlineCategory: Technology Survey
Posted On Wednesday, 18 April 2012
In my previous article, I announced the first fix for SQL Server 2012.
One week later, the first cumulative update is available on the Microsoft webs...
SQL Server 2012: First fix has arrivedCategory: Technology Survey
Posted On Wednesday, 11 April 2012
This is just a little blog posting to announce that the first fix for SQL Server 2012 came out last week during Easter Break.
SQL Server 2012: New LicensingCategory: Technology Survey
Posted On Monday, 02 April 2012
Since the commercial version of SQL Server 2012 is due to be released in April, a little posting about the changed licensing costs seems appropriate....
SQL Server 2012: RTM now availableCategory: Technology Survey
Posted On Thursday, 08 March 2012
The so called Release to Manufacturing (RTM) version of SQL Server 2012 now is available.
|
Middleware (5)
|
|
Connecting to the WebLogic Node Manager using WLST in a Production domainCategory: Middleware
Posted On Monday, 14 May 2012
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 conne...
Upgrading your Oracle Internet Application Server licenseCategory: Middleware
Posted On Monday, 16 April 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...
HA with Oracle Fusion Middleware Forms & Reports 11g R2Category: Middleware
Posted On Monday, 26 March 2012
In this post, I will explain how to install Oracle Fusion Middleware Forms and Reports 11g R2 for a high availability architecture on a Windows platfo...
Oracle Application Express (APEX) 4.1: a migration guideCategory: Middleware
Posted On Friday, 24 February 2012
In this post, I will describe how to migrate from Oracle APEX 3.0 to Oracle APEX 4.1. I will also focus on some encountered problems as well as the ne...
Oracle WebLogic Essentials : avantages du clusteringCategory: Middleware
Posted On Tuesday, 07 February 2012
J'ai eu le plaisir de suivre une formation chez Oracle University à Colombes (Paris). En tant que stagiaire, le cours s'intitulait Oracle WebLogic Adm...
|
High Availability & Backup/Recovery (9)
|
|
MySQL Data High Availability with semi-synchronous replicationCategory: High Availability & Backup/Recovery
Posted On Friday, 20 January 2012
Starting with MySQL 5.5 it is possible to configure semi-synchronous replication. As you probably know, MySQL replication is asynchronous by default. ...
Block Corruption Oracle 10g vs Oracle 11gCategory: High Availability & Backup/Recovery
Posted On Friday, 11 November 2011
Ayant rencontré récemment des problèmes de blocs corrompus sur des bases Oracle en version Oracle 10g et Oracle 11g, des différences notables sont app...
Database world - high availability: SQL Server vs OracleCategory: High Availability & Backup/Recovery
Posted On Thursday, 27 October 2011
Last week, I attended the Microsoft TechDays for the first time. The Swiss 2011 "edition" took place in Bern. For me this is really a n...
SQL Server 2012 'Denali' : AlwaysOn High Availability - Restore is blockedCategory: High Availability & Backup/Recovery
Posted On Monday, 17 October 2011
During our test to create a failover clustering with the new function 'AlwaysOn High Availability', we had a few difficulties to overcome like the dat...
RMAN backup is failing due to "corrupt blocks"Category: High Availability & Backup/Recovery
Posted On Wednesday, 29 June 2011
Last week, I was not able to complete a backup because of the ORA-19566 error: "exceeded limit of 0 corrupt blocks". Here is what you can do to fix it...
|
Development & Performance (16)
|
|
SQL Server: Attunity connectors for data transfer to OracleCategory: Development & Performance
Posted On Wednesday, 02 May 2012
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 S...
Jonathan Lewis @ dbi services: Oracle Optimizer workshopCategory: Development & Performance
Posted On Thursday, 01 March 2012
Last week, Oracle Ace Director Jonathan Lewis held an Oracle Optimizer Workshop at dbi services Basel Area. I would like to share some of the key lear...
'Query result cache' in Oracle 11gCategory: Development & Performance
Posted On Thursday, 05 January 2012
Oracle has introduced three new caching features in its Oracle 11g release:
Query result cache
Client OCI result cache
PL/SQL function result cac...
Oracle SQL Developer & SQL Data Modeler on UbuntuCategory: Development & Performance
Posted On Monday, 28 November 2011
Oracle SQL Developer and Data Modeler are becoming more and more popular as they are both cost-free and available on many Operating Systems (Linux/Un...
Partition exchange preview in MySQL 5.6Category: Development & Performance
Posted On Tuesday, 25 October 2011
MySQL 5.6 offers improved partition maintenance through "partition exchange". Even if not yet available, dbi services performed some tests on the My...
|
Database Administration & Monitoring (28)
|
|
SQL Server 2012: How to create a Server Role?Category: Database Administration & Monitoring
Posted On Thursday, 15 March 2012
Recently, during one of my missions, a client asked me to give him access rights to the SQL Server logs from SSMS to his application managers. As you ...
Configuration of tmpfs on SLES 11 for Oracle 11.2 and AMMCategory: Database Administration & Monitoring
Posted On Friday, 09 March 2012
Even if we (dbi services) usually advise to setup Oracle Enterprise Linux for Oracle deployments on Linux, it might appear that some customers still...
Martin Bach @ dbi services: workshop on Oracle RACCategory: Database Administration & Monitoring
Posted On Sunday, 29 January 2012
A few days ago, the dbi services consultants had the pleasure to welcome Oracle guru Martin Bach for a three day Oracle Grid infrastructure training. ...
Oracle Database FirewallCategory: Database Administration & Monitoring
Posted On Monday, 23 January 2012
Le marché du Database Activity Monitoring (DAM) devenant de plus en plus important avec des produits tels que Imperva, Guardium ou Sentrigo, je me sui...
Forefront Endpoint Protection (FEP) 2010 and database policiesCategory: Database Administration & Monitoring
Posted On Sunday, 01 January 2012
I have seen at a customer that SQL Server's policy doesn't follow Microsoft's recommendations about antivirus and databases (kb 309422), such as exclu...
|
Operating System & Cluster (12)
|
|
Using IOzone for Linux disk performance analysisCategory: Operating System & Cluster
Posted On Tuesday, 27 March 2012
Who never had to measure the disk performances on a system?
Speaking about Linux performance monitoring includes a significant part of disk performan...
Why Perl is my choice for scriptingCategory: Operating System & Cluster
Posted On Thursday, 16 February 2012
I have been advising to use Perl for a long time in order to automate Oracle processes and operations. This week however, I tried for once to write a ...
Linux: easing the process and performance monitoring with htopCategory: Operating System & Cluster
Posted On Monday, 02 January 2012
I'm pretty sure that most of you already struggled with some low performance systems. In order to analyse such cases several tools and utilities, like...
Windows Server 8 Hyper-V 3.0: a real step forward in virtualizationPosted On Friday, 14 October 2011
I was at the Microsoft Connection Days 2011 in Lausanne yesterday and saw a presentation on Windows Server 8 and Hyper-V 3.0. I take this opportunity ...
LOB : « enq : HW contention »Posted On Saturday, 06 August 2011
Aprés le post sur « Utilisons les securefile », revenons sur le sujet LOB avec une approche performance, stockage. Nous rencontrons parfois...
|
Contact
Your flexible SLA
Blog Roll
- Florian Haas' blog
- Dirk Nachbar's blog on Oracle Fusion Middleware & Application Server
- Oracle Scratchpad - Jonathan Lewis' blog
- Martin Bach's blog
- Striving for optimal performance - Chris Antognini's blog
- The Tom Kyte Blog (Ask Tom)
- Blog of Adar-Consult
- Alex Gorbachev's blog
- Marcus Mönnig's Oracle & Mumbai Blog
Blog Tag Cloud
