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.
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 and deletes as an alternative to specifying primary keys
Developers can now easily add the capability for end-users to load spreadsheet data into existing tables within an application
The calendar wizards have been enhanced to include the ability to create an Edit page as part of creating the calendar
Building on their initial introduction in Release 4.0, the look and feel of Websheets in Release 4.1 has been substantially improved and the controls redesigned to make it more intuitive for users
A complete list of APEX new features can be found on: http://www.oracle.com/technetwork/developer-tools/apex/application-express/apex-41-new-features-459652.html
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 posting focuses on the shell internals and “nightmare” more than on Oracle related issues.
I decided to take some times in this cold February’s month to continue this small series. This time, I’m going to speak about Reporting Services (SSRS) and these new features.
Like my other article “SQL Server 2012: New features on Integration Services (SSIS)“, this article presents a summary from new features and enhancements for SQL 2012 Reporting Services.
J’ai eu le plaisir de suivre une formation chez Oracle University à Colombes (Paris). En tant que stagiaire, le cours s’intitulait Oracle Weblogic Administration Essential. Ce post traite de la notion de cluster Weblogic. J’y expose les avantages du clustering weblogic, les principaux éléments à connaître ainsi qu’un exemple de configuration via la console d’administration.
Last week, from Wednesday to Friday we had the pleasure to welcome Martin Bach an OAK table member, also Oracle Certified Master and Oracle ACE, for an Oracle Grid Infrastructure training.
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 DBA should know that Feature Pack exists, how to find it and of course use it.
Le marché du Database Activity Monitoring (DAM) devenant de plus en plus important avec des produits tels que Imperva, Guardium ou Sentrigo, je me suis intéressé au produit Oracle Database Firewall, qu’Oracle présente comme un substitut aux différents acteurs du marché des DAMs.
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 has no idea when the slave(s) will get and process them. Of course such configuration can lead, in case of failover, to some transaction loss since there is no guaranty that the transactions have been transmitted on the standby server(s).