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.


 

Internet Explorer 9 features

Internet Explorer 9 features a simplified interface to put the focus on websites. The address bar and search bar have been combined into the One Box. Tabs stack along the very top. Sites load incredibly fast in Internet Explorer 9, and can also be pinned to your taskbar for one-click access. Tracking Protection in Internet Explorer 9 provides an added level of control and choice about the information that third-party websites can potentially use to track your browsing activity.

        Chakra, the new JavaScript engine, compiles the JavaScript into highly efficient machine code in the background, while interpreting the JavaScript in the foreground. Internet Explorer 9 provides built-in developer tools which aid developers in rapid prototyping, testing, and debugging webpages by making changes to code from within the browser itself which can then be previewed. Hardware-accelerated text, video, and graphics mean your websites perform like the applications that are installed on your Windows-
based computer.

Note : You need to have Windows Vista or Windows 7 to run IE 9.

Download Link : Download IE 9

How to Create a Shortcut to Start a Remote Desktop

If you frequently use Remote Desktop to connect to computers remotely, having a desktop shortcut to automatically launch a Remote Desktop connection to a specific computer can reduce the amount of time required to accomplish this task-especially when you use Remote Desktop to connect to several different computers. Copy the Remote Desktop shortcut to your desktop; then modify it to connect immediately to a specific computer when it is launched.

Steps to Follow:

1.Right-click the Remote Desktop icon on the Start menu, and click "Copy."
2.Right-click on the desktop, and click "Paste Shortcut." A copy of the Remote Desktop icon appears on the desktop.
3.Right-click the new Remote Desktop shortcut, and click "Properties."
4.Click inside the box labeled "Target," and use the arrow keys on the keyboard to move the cursor to the end, after "mstsc.exe."
5.Insert a space after "mstsc.exe," and then type "/v:(address)" where "(address)" is the IP address or fully qualified domain name of the computer that you are connecting to. Do not include quotation marks. For example, if the IP address is 192.168.0.1, the new shortcut would read "%systemroot%\system32\mstsc.exe /v:192.168.0.1."
6.Double-click the shortcut to connect to the computer at the address you have entered.

Microsoft Visual Studio Team Foundation Server 2010

Microsoft Visual Studio Team Foundation Server 2010 (TFS) is the collaboration platform at the core of Microsoft’s application lifecycle management (ALM) solution. Team Foundation Server 2010 automates the software delivery process and gives you the tools you need to effectively manage software development projects throughout the IT life cycle.

Basically it is a Microsoft product offering source control, data collection, reporting, and project tracking, and is intended for collaborative software development projects. It is available either as stand-alone software, or as the server side back end platform for Visual Studio Team System (VSTS).

Windows 8 on the way....

Microsoft is looking forward to the next version of Windows after Windows 7. In this context, the software giant already confirmed officially that planning for Windows 8 had started long before Windows 7 was even close to Release Candidate stage. At the same time, Microsoft has also started hiring people to work on specific future features that will end up in Windows 8.

Windows 8 Release Date : Year 2012
Microsoft boss Steve Ballmer who opened the Consumer Electronics Show in Las Vegas, mentioned the new Windows 8 in his speech and called it “system on chip” (SOC).

Microsoft WebMatrix

WebMatrix is a brand new web development tool from Microsoft that includes everything you need for website development. Start from open source web applications, built-in web templates or just start writing code yourself. It’s all-inclusive, simple and best of all free.
Launch Date: 13th Jan 2011
Its a very new launch from Microsoft.I will be back with more details in my next blog.