Monthly Archives: May 2008

Difference Between MSSQL Server 2005 Express, Standard and Workgroup Edition

MS SQL 2005 Express Edition features are as follows :
* Price : Free
* CPU : No
* 1 GB max memory limit for buffer pool : Yes
* 4GB max database size : Yes
* SQL Server Agent : Yes
* Full Text Search : Yes
* IMPORT/EXPORT : No
* Basic Integration Services : No
* Advanced Integration Services : Yes

MSSQL 2005 Standard Edition features are as follows :
* Price : Not Free
* CPU : Yes
* 1 GB max memory limit for buffer pool : No
* 4GB max database size : No
* SQL Server Agent : Yes
* Full Text Search : Yes
* IMPORT/EXPORT : Yes
* Basic Integration Services : Yes
* Advanced Integration Services : Yes

MSSQL 2005 Workgroup Edition features are as follows :
* Price : Not Free
* CPU : Yes
* 1 GB max memory limit for buffer pool : No
* 4GB max database size : No
* SQL Server Agent : Yes
* Full Text Search : Yes
* IMPORT/EXPORT : Yes
* Basic Integration Services : No
* Advanced Integration Services : No

Differences between basic hosting and VPS Hosting ?

VPS Hosting provide much better performance than a shared or a reseller hosting account.VPS Hosting provides us the privileges which are more or less compared to a dedicated server such as SSH Root access to VPS, custom installations etc.

It is possible to install any custom applications or softwares on the VPS Hosting package. However, there are some applications such as Java and others which require more resources when compared to softwares and applications such as PHP or MySQL.

Applications and software installation are all dependant upon the configuration allocated to your VPS. Hence, many companies provide wide range of virtual private servers to help you select the best configuration as per your requirements.With VPS you will get administrative rights which will provide you with complete rights on the VPS. Some of the applications / softwares supported on a VPS are as follows:
PHP, MySQL, Apache, cPanel, Plesk, Virtuozzo, FFMPEG, exim, ZendOptimizer, ioncube, Ruby on Rails ( RoR ), python, Imagemagick, FTP, Perl, .htaccess, Mod rewrite, Server Side Includes, SpamAssassin, SSH Server, phpMyAdmin, Awstats, Webalizer, Horde Webmail, Microsoft® FrontPage extensions, Fantastico ( Standard ), Custom Cron Jobs, BIND DNS Server, Linux Firewall, Application Vault ( Optional ), Postgres SQL, ODBC, Windows Firewall Service Pack 1, Microsoft FTP Server, MailEnable Standard, Microsoft ASP, ASP.NET, SpamAssassin ( Only with Plesk ), Microsoft IIS 6.0, MS Exchange Server ( backend server with no mailstore mounted ), SQL Server MSDE ( Requires Plesk Power Pack ), MSSQL 2005 Express Edition, Lighttpd, FastCGI, RubyGems, AJAX etc.

Plesk:: How can I Manage IP on a Windows VPS Hosting

1) First login to Plesk
2) Now click on Server on the left-hand Side
3) Click on IP Addresses
4) You will now be able to view IP address on the Server

Follow these Steps to add new IP:-

1) In IP Addresses, click on Add New IP Address
2) You will now be able to view IP address from
3) Select Network for the IP Address
4) Enter the IP and subnet mask
5) Select the option, shared or dedicated
6) In SSL Certificates, select the type of SSL certificate
7) Click on OK

Steps to Remove IP from the VPS:-

1) In IP Address, click on IP address to be removed
2) Click on Remove
3) Confirm Removal and Click on OK

Adding IPs to Client’s IP pool :

1) In IP Address, click on the number in clients column of the IP address that you wish to add
2) Click on Add New Client icon
3) Select the client that you need the IPs to be added

Removing IPs to Client’s IP pool :

1) In IP Address, click the number in the client of the IP to be removed
2) Select the Client and Confirm Removal
3) Click on OK

Default Domain Setup for IP Address :-

1) In IP Address, in hosting column, click on the IP address to be managed
2)  Select the Domain from the list
3)  Click the set it as default

IP Address Edit : Allocation and SSL Certificate

1) In IP address, click on IP address that is needed to be managed
2) Select allocation
3) Select SSL

What is ASP.NET?

It is the latest incarnation of Microsoft’s middleware for the Internet. ASP.NET is built upon the .NET Framework. The .NET Framework has 2 main components that is : the common language runtime (CLR) and the .NET Framework class library. The CLR is the foundation of the .NET Framework.

You can think of it as an agent that manages code at execution time for both Windows and ASP.NET applications. The class library, the other main component of the .NET Framework, is an object-oriented collection of reusable components that you can use to develop applications for both Windows and the Web. ASP.NET is therefore the required environment that supports developers who use the .NET Framework to develop Web-based applications.

The .NET framework is a free download, but the development tools can be pricey.In ASP.NET, you don’t need to write any code to display the data: you will just need to write the code to bind the data to an object called a DataGrid (which can be done in just a couple of lines). Then, you just have to create a reference on your page to where that DataGrid should go. The DataGrid will be rendered as a table, and will contain all of the data extracted from the database.

VPS:Burstable RAM

Burstable RAM is the memory which is available beyond the guaranteed RAM.Burstable RAM is basically shared RAM amongst each VPS on the hardware node. It is divided equally among each VPS and is there for when each VPS needs it. For example your VPS might have 256mb guaranteed ram, and 1024mb burstable RAM.

This means that after you have used up your guaranteed RAM, there is still 768mb burstable ram available for burst usage – IF there’s enough free memory on the host server.Burstable RAM, means that you can go up to that much usage, but it must only be for a short time. In other words, you can burst to that plateau of RAM, but cannot always remain at that level.

« Older Entries