Monthly Archives: January 2013

Useful Stuff #2

logo-MS-SQL-Server

In Sql Server, if your scheduled  maintainance plan holds a backup of your database and its log transaction, and it fails, it will cause lots of space loss. Here’s how to arrange that quickly, but you must revisit your maintainance plan… that’s a better idea.


USE [DATABASE_NAME]
GO
CHECKPOINT
BACKUP TRANSACTION [DATABASE_NAME]WITH NO_LOG
DBCC SHRINKFILE('[DATABASE_LOG_FILE]',5000)
DBCC SHRINKDATABASE('[DATABASE_NAME]',10)

Useful stuff #1

oracle

This is a new serie of posts I always told my self to start it. This reminder is about useful Oracle queries, unix commands and so…

The first one is an Oracle select command to query foreign key name, column, referenced table and column.


SELECT
c_list.CONSTRAINT_NAME as FK_NAME,
substr(c_src.COLUMN_NAME, 1, 20) as SRC_COLUMN,
c_dest.TABLE_NAME as DEST_TABLE,
substr(c_dest.COLUMN_NAME, 1, 20) as DEST_COLUMN
FROM ALL_CONSTRAINTS c_list, ALL_CONS_COLUMNS c_src, ALL_CONS_COLUMNS c_dest
WHERE c_list.CONSTRAINT_NAME = c_src.CONSTRAINT_NAME
AND c_list.R_CONSTRAINT_NAME = c_dest.CONSTRAINT_NAME
AND c_list.CONSTRAINT_TYPE = 'R'
AND c_src.TABLE_NAME = '<your-table-here>'
GROUP BY c_list.CONSTRAINT_NAME, c_src.TABLE_NAME,
c_src.COLUMN_NAME, c_dest.TABLE_NAME, c_dest.COLUMN_NAME;

Must-Know Open Source products

Open Source

The Open source community is in a constant growth showing a high level of creativity and competitiveness. When I thought I mastered lots of things about Open Source, I just received the SMILE annual report for Open source solutions test and evaluation: Just wow! I must refresh my directory. The report describes every product in 6 axis charts, varying between 0 and 5 levels:

  • Reputation
  • Dynamic
  • Backend/Framework quality
  • Available resources
  • Scalability
  • Functional scope
Evaluation Chart

Evaluation Chart

I extracted a sort of summary from the whole report with the (~) best product in each field, just to remember 😉

  1. Remote access:
    OpenSsh
  2. Park and stock inventory:
    GLPI
  3. Deployment& Backup:
    Bascula, Chef, Puppet
  4. High availability:
    Linux-HA
  5. Security:
    ClamAv, Wireshark
  6. VPN:
    Open VPN, Openswan
  7. Firewall:
    NetFilter
  8. Monitoring and metrics:
    Nagios, Centereon
  9. Unix Based OS:
    DEBIAN, FReeBSD
  10. Virtualisation:
    KVM, XEN
  11. Cloud Computing:
    Open Stack, Open Nebula
  12. VOIP & TELEPHONE:
    Asterisk, Kannel  
  13. Messaging, Mailing, Groupware:
    Zimbra, Postfix (I would add  JSMPP for SMS messaging cause I liked their work)
  14. HTTP Accelerator:
    Squid, Varnish
  15. Entreprise Directory:
    Open LDAP
  16. DB:
    MYSQL, Postgres, Firebird*(I added Firebird  for their great work on embedded databses)
  17. Big DATA:
    Hadoop, Pig, Hive
  18. BPM/Workflow:
    Bonita
  19. Dev tools:
    Eclipse, Maven, Subversion(Netbeans is worth trying too)
  20. Test, continuous integration:
    Jenkins
  21. Enterprise Service Bus (ESB) :
    Mule
  22. Web dev frameworks:
    Spring, JQUERY, Symfony
  23. Mobile Crosss-platform frameworks:
    PhoneGap/Cordoba
  24. PKI:
    EJBCA
  25. Load Test:
    JMETER
  26. Search Engine:
    Lucene, Solr
  27. Application Server:
    JBoss AS, Apache Tomcat
  28. MOM & EAI:
    ActiveMQ
  29. CRM:
    Sugar CRM
  30. ETL decisional:
    Talend
  31. Decisional Reporting:
    Jasper Report, Pentaho
  32. E-Commerce:
    Magento
  33. ERP/PGI:
    OpenERP
  34. CMS:
    Drupal
  35. GED & ECM:
    Alfresco, Nuxeo
  36. E-Learning:
    Moodle

There is a lot of other stuff in the report which you may download here or just subscribe on Smile mailing service to receive its annual report. The report is written in french but you may understand even if you are not good at it.
For abbreviations on the list, you may find by googling 🙂 Underlined green products are the ones  I know, knew, or worked with. Bold ones are the ones I master;)