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.

Automate Repetitive Tasks on Your Computer

Pre-Solution:

There are 2 approaches:

1. Reviewing the code.

2. Automate this repetitive tasks using third party software. I am exploring second option by researching this topic.

Here’s what I found:

1. http://freddy1990.com/index.php?page=product&name=scar

2. Use IBM Rational Robot for this but keep in mind it’s not cheap. It’s also probably been renamed few times since started using it so just search for Rational testing products in general. It’s fully script-able, allowing you to monitor the screen and send key presses and what not.

3. First purchase SOTI Pocket Controller Pro then just use the normal AutoIt automation tools. It’s a little different because can’t actually capture popup windows like you may be used to, but it can automate clicks, and then loop and wait for things using the GetPixel methods to check it the screen is what you expect.

4. Selenium IDE is an integrated development environment for Selenium tests. It is implemented as a Firefox extension, and allows you to record, edit, and debug tests. Selenium IDE includes the entire Selenium Core, allowing you to easily and quickly record and play back tests in the actual environment that they will run.  Selenium IDE is not only recording tool: it is a complete IDE. You can choose to use its recording capability, or you may edit your scripts by hand. With autocomplete support and the ability to move commands around quickly, Selenium IDE is the ideal environment for creating Selenium tests no matter what style of tests you prefer.

http://www.slideshare.net/joaopmaia/web-app-testing-with-selenium – a slideshow on how to use Selenium for web testing

http://www.pushtotest.com/docs/testmaker-help/testmaker-tutorials/building-tests-of-rich-internet-applications-using-ajax-and-selenium/task-1-record-and-playback-a-web-application-functional-test – a sample of how to use Selenium IDE’s record and playback features.

5. http://code.google.com/p/webdriver/ Webdriver and selenium are going to be merged at some point.

6. Hp QuickTestPro

7. DejaClick. This is a free add-on for Mozilla Firefox. This tool does not require to do coding. We can record, parameterize (data driven) and play-back the scripts. This tool also provide some details for performance parameters as well (like time it took to load the entire page, time it took during network etc)

8. WaTiR – Web Automated Testing in Ruby – that’s a very popular one that handles any interface on a web page, aside from interacting with java applets directly. WaTiJ exists as well if you prefer Java, and WaTiN if you like .NET. There are plenty more but I thought I’d mention that in particular, for the rest, check:

http://www.softwareqatest.com/qatweb1.html

Â

Exploring AutoIt:

You can use debugger: http://www.thefoolonthehill.net/drupal/AutoIt%20Debugger

Â