Database management, Oracle 12c online statistics gathering and startup restrict 21.02.2015 by Oracle Team By Franck Pachot . I’ve written about 12c online statistics gathering in a UKOUG OracleScene article. My opinion is clear about it: you sill need to gather stale stats afterwards or you have mising, stale and inconsistent object(…)
Database management, Oracle How to set NLS for SQL Developer 21.02.2015 by Oracle Team By Franck Pachot . I’m using Oracle SQL Developer 4.1 Early Adopter for a while and I like it. That version comes with a command line (in beta) which goal is to be fully compatible with sqlplus but(…)
Application integration & Middleware QlikView Tips & Tricks – part I 19.02.2015 by Morgan Patou For several months now, I’ve been working on some QlikView projects which is a quite interesting discovery for me. Generally, these projects are limited to the management of QlikView at the administrator level (installation, upgrade,(…)
Database management SQL Server monitoring with nagios: utilisation 18.02.2015 by Stéphane Savorgnano We saw in my last blog how to install the SQL Server plugin for Nagios. In this new blog, I will explain: how to create a wrapper to avoid the unset of the PERLLIB variable how to create and(…)
Database management Case of monitoring snapshot replication from the subscriber side 17.02.2015 by Microsoft Team I don’t work often with SQL Server replication. The main reason is that the number of customers that use replication is pretty low and each time that I have to deal with it, it’s a good opportunity to improve my(…)
Database management, Oracle Is CDB stable after one patchset and two PSU? 16.02.2015 by Oracle Team By Franck Pachot . There has been the announce that non-CDB is deprecated, and the reaction that CDB is not yet stable. Well. Let’s talk about the major issue I’ve encountered. Multitenant is there for consolidation. What is the major(…)
Database management, Oracle OracleText: deletes and garbage 15.02.2015 by Oracle Team By Franck Pachot . In the previous post we have seen how the OracleText index tables are maintained when new document arrives: At sync the new documents are read up to the available memory and words are inserted(…)
Database management, Oracle OracleText: inserts and fragmentation 15.02.2015 by Oracle Team By Franck Pachot . I plan to write several posts about OracleText indexes, which is a feature that is not used enough in my opinion. It’s available in all editions and can index small text or large documents to(…)
Database management SQL Server monitoring with nagios: installation 15.02.2015 by Stéphane Savorgnano Nagios is an IT Infrastructure monitoring solution which is able to monitor SQL Server instances with a specific plugin. I have installed this plugin to test those functionalities and I will explain here how to do it. Prerequisites installation(…)
Database management Considerations about SQL Server database files placement, Netapp storage and SnapManager 12.02.2015 by Microsoft Team When you install SQL Server, you have to consider how to place the database files. At this point you will probably meet the well-known best practices and guidelines provided by Microsoft but are you really aware of the storage vendor(…)