Create one table from another in SQL Server

To create one table from another in SQL Server you can use the following query:

select * into New_table from Existing_table

This will create a new table with the existing structure of old table.

Drupal:CMS in PHP for Creating Websites

Drupal is a free and open-source content management system (CMS) and content management framework (CMF) written in PHP and distributed under the GNU General Public License which means anyone is free to download it and share it with others.

The standard release of Drupal, known as Drupal core, contains basic features common to content management systems. These include user account registration and maintenance, menu management, RSS-feeds, page layout customization, and system administration. The Drupal core installation can be used as a brochureware website, a single- or multi-user blog, an Internet forum, or a community website providing for user-generated content.

Although Drupal offers a sophisticated programming interface for developers, no programming skills are required for basic website installation and administration.

Drupal runs on any computing platform that supports both a web server capable of running PHP (including Apache, IIS, lighttpd, and nginx) and a database (such as MySQL, MariaDB, PostgreSQL, SQLite, MongoDB or Microsoft SQL Server) to store content and settings. Drupal 6 requires PHP 4.4.0+ while Drupal 7 requires PHP 5.2 or higher.

You can download Drupal 7.9 using the following link:
http://drupal.org/project/drupal

Simple FTP using Batch File

For FTP, I have used two batch files.
File1- example.bat

Create example.bat file with the following contents:

open <ip address>
<ftpUserName>
<ftpPassword>
bin
lcd "<path of local folder where the file is present>"
cd /
prompt off
put filename.extension
quit

File2- Sendexample.bat

Create Sendexample.bat file with the following contents:

ftp -s:example.bat

Thats It...Enjoy

Also if you need to ftp multiple files use "mput" option instead of "put".

Capture IP Address using Asp.Net

The code given below gives you the IP address of the User Accessing the site.

1) HttpContext.Current.Request.UserHostAddress;

OR

2) HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"];

To get the IP Address of the machine and not the proxy use the following code:

1) HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"];

Zip files using batch file

You can zip files using batch file.
Example :
zip -r -9 -S -u C:\abc.zip C:\*.csv

Another way if you have winzip installed is,
Example :
WINZIP32 -min -a -ex C:\abc.zip C:\*.csv

DotNetNuke Web CMS

DotNetNuke is an open source platform for building web sites based on Microsoft .NET technology.It is written in VB.NET.
The DotNetNuke web content management system is extensible and customizable through the use of skins, modules, data providers, language packs and templates.
It is distributed under both a Community Edition BSD-style license and commercial proprietary licenses as the Professional and Enterprise Editions.
To Download DotNetNuke Resources you can use this link.: Click Here
As it is a CMS, it makes the job of developing websites easy. One of the sites that I worked upon using Nuke is http://www.harmonicenvironments.com/
From the site, you can get an idea of how nuke can be used to develop sites.

Joomla - Easy Way To Develop Websites

Hi friends, I have been using Joomla since long, and worked with different CMS. I found Joomla to be one of the best CMS in PHP for developing websites.
Joomla! is actually a free and open source content management system (CMS) for publishing content on the World Wide Web and intranets.
Joomla! is written in PHP, uses object-oriented programming (OOP) techniques and software design patterns, stores data in a MySQL database, and includes features such as page caching, RSS feeds, printable versions of pages, news flashes, blogs, polls, search, and support for language internationalization.

You can download the latest version of Joomla (i.e 1.6) for free.Click Here.

You can learn developing sites in Joomla by yourselves by sitting at home. You just need to be creative and computer savvy. You can google for tutorials related to Joomla development. I assure you its not difficult. Any help related to the topic you can leave out the comment and I will surely reply for the same asap.