Database Administration & Monitoring

Oracle Exadata – poor optimization for FIRST_ROWS

By Franck Pachot . In a previous blog, I discussed the difference between rownum and row_number(), in particular their behaviour in implicitely adding a first_rows(n) to the optimizer. That reminded me that I forgot to blog about an(…)

Best practice for the sending of an Oracle execution plan

By Franck Pachot . You have a query that takes too long and you want help to analyze the execution plan? Then you need to get it with relevant information, and correctly formatted. Autotrace is not a good option(…)

Archivelog deletion policy for Standby Database in Oracle Data Guard

By Franck Pachot . Do you use ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY for your Oracle databases in Data Guard? Maybe you also use the Fast Recovery Area as archive log destination. That’s good practice! But did(…)

SQL Server 2012: First Hotfix for Service Pack 1 available

This month, Microsoft has released the first hotfix for SQL Server Service Pack 1. Analysis This Hotfix concerns the installation of SQL Server components and Analysis Services. If you have installed the RTM version with Analysis Service and successfully installed(…)

SQL Server 2012: Feature Pack

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

Diving into Databases

By dbi services, we are a few poeples passionate by diving.We take this opportunity to let you dive into the two databases lakes Oracle and SQL server and see their similarities and differences. For this first level of diving(…)

Il était une fois … SQL Server!

Cet article propose une introduction à Microsoft SQL Server en peignant son historique et en procurant un rapide aperçu de son architecture et des termes associés à cette technologie.