IDG Connect

Good IT related articles

http://www.idgconnect.com/

Build NAS server using Samba

Good article on How to Build a home NAS server using Samba

http://www.redhatmagazine.com/2007/06/26/how-to-build-a-dirt-easy-home-nas-server-using-samba/

Windows Developer Power Tools

Find all the tools available on Windows platform

http://www.windevpowertools.com/ToolList/Tag/Chapter%201

Perl 6

Perl 6 cookbook under progress

http://svn.pugscode.org/pugs/examples/cookbook/

Improving Perl Programming

Good one from O’Reilly blogs articles

http://www.onlamp.com/pub/a/onlamp/2007/04/12/five-ways-to-improve-your-perl-programming.html

Building sites out of Adobe’s Flex and PHP

Excellent Article on How to start building Website Like Youtube using open source technology PHP, MySql and Adobe’s Flex

http://www.onlamp.com/pub/a/php/2007/05/24/creating-mytube-with-flex-and-php.html?page=1

SQL Command Reference

Data Definition Statements

CREATE TABLE table ( table-def-item-list )

DROP TABLE table [ drop-options ]

ALTER TABLE table alter-action

CREATE VIEW view [ ( column-list ) ]

AS query-spec [ WITH CHECK OPTION ]

DROP VIEW view [ drop-options ]  CREATE db-object-type db-object-name [ db-object-spec ]

DROP db-object-type [ drop-options ]

ALTER db-object-type alter-action

GRANT { ALL PRIVILEGES | privilege-list }

ON { table | db-object-type db-object-name }
TO { PUBLIC | user-list } [ WITH GRANT OPTION ]
REVOKE { ALL PRIVILEGES | privilege-list }
ON { table | db-object-type db-object-name }
FROM { PUBLIC | user-list } [ WITH GRANT OPTION ]

Basic Data Manipulation Statements
SELECT [ ALL | DISTINCT ] { select-item-list | * }
INTO variable-list    FROM table-ref-list  [ WHERE search-condition ]
 
SELECT [ ALL | DISTINCT ] { select-item-list | * }
INTO host-variable-list    FROM table-ref-list  [ WHERE search-condition ]

[ GROUP BY column-ref-list ]  [ HAVING search-condition ]  [ ORDER BY sort-item-list ]
 
 
 
INSERT INTO table [ ( column-list ) ] { VALUES ( insert-item-list ) | query-expr }
 
DELETE FROM table [ WHERE search-condition ]  UPDATE table SET set-assignment-list [ WHERE search-condition ]
 
 
Transaction Processing Statements
 
COMMIT [ WORK ]

ROLLBACK [ WORK ]
 
 
 
Cursor-Based Statements
 
DECLARE cursor [ SCROLL ] CURSOR FOR query-expr
[ ORDER BY sort-item-list ]  [ FOR { READ ONLY | UPDATE [ OF column-list ] } ]
 
OPEN cursor
CLOSE cursor
FETCH [ [ fetch-dir ] FROM ] cursor INTO variable-list
 
DELETE FROM table WHERE CURRENT OF cursor
UPDATE table SET set-assignment-list WHERE CURRENT OF cursor
 
NEXT | PRIOR | FIRST | LAST | ABSOLUTE row-nr | RELATIVE row-nr
 

Top 10 New Features in Windows Server 2008

10: The self-healing NTFS file system
9: Parallel session creation
8: Clean service shutdown.
7: Kernel Transaction Manager
6: SMB2 network file system.
5: Address Space Load Randomization (ASLR)
4: Windows Hardware Error Architecture (WHEA).
3: Windows Server Virtualization
2: PowerShell
1: Server Core

Read Detailed Article here: http://www.betanews.com/article/Top_10_New_Features_in_Windows_Server_2008/1180045346/1

BioPerl

Bioperl is a collection of Perl modules that facilitate the development of Perl scripts for bioinformatics applications. As such, it does not include ready to use programs in the sense that many commercial packages and free web-based interfaces do (e.g. Entrez, SRS). On the other hand, Bioperl does provide reusable Perl modules that facilitate writing Perl scripts for sequence manipulation, accessing of databases using a range of data formats and execution and parsing of the results of various molecular biology programs including Blast, clustalw, TCoffee, genscan, ESTscan and HMMER. Consequently, bioperl enables developing scripts that can analyze large quantities of sequence data in ways that are typically difficult or impossible with web based systems.

Browse this tutorial

http://www.bioperl.org/wiki/Bptutorial.pl

Search for Extraterrestrial Information (SETI)

SETI@home is a scientific experiment that uses Internet-connected computers in the Search for Extraterrestrial Intelligence (SETI). You can participate by running a free program that downloads and analyzes radio telescope data.

SETI (Search for Extraterrestrial Intelligence) is a scientific area whose goal is to detect intelligent life outside Earth. One approach, known as radio SETI, uses radio telescopes to listen for narrow-bandwidth radio signals from space. Such signals are not known to occur naturally, so a detection would provide evidence of extraterrestrial technology. Radio telescope signals consist primarily of noise (from celestial sources and the receiver’s electronics) and man-made signals such as TV stations, radar, and satellites. Modern radio SETI projects analyze the data digitally. More computing power enables searches to cover greater frequency ranges with more sensitivity. Radio SETI, therefore, has an insatiable appetite for computing power.

Previous radio SETI projects have used special-purpose supercomputers, located at the telescope, to do the bulk of the data analysis. In 1995, David Gedye proposed doing radio SETI using a virtual supercomputer composed of large numbers of Internet-connected computers, and he organized the SETI@home project to explore this idea. SETI@home was originally launched in May 1999