How to Recover SQL Server 2008 Password

Here's how to recover the SA password on a Microsoft SQL Server 2008 database: How to recover SA password on Microsoft SQL Server 2008 R2

./M6

Elasticsearch For Beginners: Indexing your Gmail Inbox

Just came across this post Elasticsearch For Beginners: Indexing your Gmail Inbox that exemplifies the usage of Elasticsearch and Python.

./M6

Could not close zip file php://output.

Ever got a "Could not close zip file" when using PHPExcel Writer? Usually the full error message is something like

[exception.PHPExcel_Writer_Exception] exception 'PHPExcel_Writer_Exception' 
with message 'Could not close zip file php://output.' 
in /var/www/vhosts/yourdomain/phpexcel/Classes/PHPExcel/Writer/Excel2007.php:399

This is caused because the PHPExcel requires access to the /tmp directory but the apache configuration is not allowing it.

The solution is easy and fast, just add the /tmp to your php_admin_value open_basedir parameter, as in this example:

php_admin_value open_basedir "[your current paths]:/tmp"

When using EHCP, it is recommended to update the Virtualhost configuration in all your templates (apachetemplate, apachetemplate_ipbased, apache_subdomain_template, apache_subdomain_template_ipbased) located in /var/www/new/ehcp:

php_admin_value open_basedir "{homedir}:/usr/share/php:/usr/share/pear:/tmp"

./M6

Embracing SQL in Postgres

On the flame ware between SQL vs. ORM, I prefer SQL, and here's some hits why: Embracing SQL in Postgres

./M6

Virtuemart 3 Plugin Development

Here's some "hard to find" Virtuemart plugin development documentation that will help in the development of version 2 and version 3 of Virtuemart plugins: Virtuemart vmPSPlugin.

./M6

Debugging in PHP with XDebug

Debugging in PHP does not necessarily mean "print" or "log" debugging, even if one's using Lampp.

While checking out how to set up a good Joomla! 3 development environment, I've learned how to set up XDebug and configure it for PHP debugging.
Just check the correct XDebug version numbers and don't just "copy-paste" the settings.

./M6

Enable NTFS Write support on Mac OS X

Here's how to have NTFS support on Mac OS X:
./M6