Application Articles

SQL Server Family

Obfuscating your SQL Server Data

If you are required to use real production data to test applications, any sensitive data should be “disguised” before loading it into the development environment. (source: http://www.simple-talk.com/sql/database-administration/obfuscating-your-sql-server-data/)

Encrypting Your Valuable Data With SQL Server 2005

Security has become extremely important in today’s fiercely completive business environment. Industry standards require you to implement firm techniques to secure your data. (source: http://www.sql-server-performance.com/articles/dev/encryption_2005_1_p1.aspx)

What is the FTP layer for?

The FTP Layer allows file operations (such as installing Extensions or updating the main configuration file) without having to make all the folders and files writable. This has been an issue on Linux and other Unix based platforms in respect of file permissions. This makes the site admin’s life a lot easier and increases security of the site.

You can check the write status of relevent folders by going to ”Help->System Info” and then in the sub-menu to “Directory Permissions”. With the FTP Layer enabled even if all directories are red, Joomla! will operate smoothly.

NOTE: the FTP layer is not required on a Windows host/server.

Can Joomla! 1.5 operate with PHP Safe Mode On?

Yes it can! This is a significant security improvement.

The safe mode limits PHP to be able to perform actions only on files/folders who’s owner is the same as PHP is currently using (this is usually ‘apache’). As files normally are created either by the Joomla! application or by FTP access, the combination of PHP file actions and the FTP Layer allows Joomla! to operate in PHP Safe Mode.