Friday, January 29, 2010

What is the concept of Load balancing ?,what is RADWARE? what are the uses of it?

Load balancing is a Process in which web Server Traffic is distributed on multiple servers to increase the performance of the applications. It is also useful if any one server will fail,, in this situation Application will run.

For load balancing there must be 2 or more server are employed. In case one of the servers begins to get overloaded, the requests are forwarded to another server. Load balancing brings down the service time by allowing multiple servers to handle the requests. This service time is reduced by using a load balancer to identify which server has the appropriate availability to receive the traffic.


Load balancing allows the service to continue even in the face of server down time due to server failure or server maintenance. If you are load balancing across several servers and one of the servers fails, your service will still be available to your users.
 
RADWARE- Radware is a device , solve the problem of load balancing and many more. it generally distribute the request or can say that Traffic redirections in multiple servers and provides the health monitoring and server failure detection. provide maximum bandwidth utilization also provide security threads.

Thursday, January 21, 2010

Generate Script of Database schema and data both

You can Create Database script in sqlserver 2005 with data and schema.

Just open Your Sql server management studio -> Tools-> Extrnal Tools.

Write Title - Publishing Wizard

Select on Command  and select Your ( sql server install folder) \90\Tools\Publishing\1.2\SqlPubWiz.exe

click apply  and ok.

(If you didn't find the above location than you must install this Setup )

Now select Tools->Publishing Wizard.

Database publishing Wizard is open now .

select server and select database and set location of files and  set Schema and data  to  Schema and Data

click next and finish this will Generate script with insert query of data.