All articles

SQL Server 2012: New Licensing

As we approach the release of version of SQL Server 2012, I think a little article about the Licencing is appropriate.

Using IOzone for Linux disk performance analysis

Who never had to measure the disk performances on a system? Speaking about Linux performance monitoring includes a significant part on disk performances. If you are facing applications or databases running slower than expected or than on other environments, you(…)

HA with Oracle Fusion Middleware Forms & Reports 11g R2

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 platform. For the Linux platform, it’s approximately the same even though the node manager is(…)

SQL Server 2012: How to create a Server Role?

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(…)

Configuration of tmpfs on SLES 11 for Oracle 11.2 and AMM

This post presents the configuration of the tmpfs filesystem size on SLES 11 in order to use the Oracle 11.2 Automatic Memory Management feature (AMM) through the Oracle instance parameter memory_target.

SQL Server 2012: RTM now available

The so called Release to Manufacturing (RTM) version of SQL Server 2012 now is available.

Jonathan Lewis @ dbi services: Oracle Optimizer workshop

Last week, Oracle Ace Director Jonathan Lewis held an Oracle Optimizer Workshop at dbi services BaselArea. I would like to share some of the key learnings of this really interesting exchange I experienced together with my colleagues.

Windows 8 customer preview now available!

Following my article about Windows 8, today, Microsoft released the customer preview. It's just a small article to announce this fresh news!(…)

Oracle Application Express (APEX) 4.1: a migration guide

  Oracle Application Express - APEX 4.1 Introduces many new features such as : Improved error handling and user-defined exception processing Application Express now supports the use of ROWID for updates, inserts(…)

Why Perl is my choice for scripting

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 small procedure on a simple Linux shell (ksh and bash). This(…)