An IT Solution

By default Sql server 2005 does not support remote connection using TCP/IP. This error generally occur when you try to connection a remote or network server using IP address or server name. Now the question arises how to make enable remote connection for sql server 2005. Here is the solution:- Start >> Programs>> Microsoft SQL Server 2005 >>Configuration Tools >>SQL Server Surface Area Configuration This following images display graphical represents of solution. Follow steps highlighted in red Follow steps highlighted in red Now press apply and ok. By pressing OK. the current settings will not take effect. To make these settings effective you have to restart sql server. Go to start >> Run >> services.msc press Ok it will dispaly services window. now go to "SQL Server (MSSQLSERVER)", right click and "Restart service to take effect" If still this will not work try restarting your system/pc

To complete this task you have to visit http://www.html-kit.com/favicon/ Provide your image which you want to use a icon it will generate icon for you. Follow the steps given in site. Write following code in header section of page. <link rel="shortcut icon" href="Images/favicon.ico" type="image/ico"> <link rel="shortcut icon" type="image/ico" href="Images/favicon.ico">

The actual post has shifted. Please click here to visit actual post.

To implement Google analytics you must have an Gmail account.

Recommended reading C# optimization tips 1) Return Multiple Resultsets The database code if has request paths that go to the database more than once then, these round-trips decreases the number of requests per second your application can serve. Solution: Return multiple resultsets in a single database request, so that you can cut the total time spent communicating with the database. You'll be making your system more scalable, too, as you'll cut down on the work the database server is doing managing requests. 2) Connection Pooling and Object Pooling Connection pooling is a useful way to reuse connections for multiple requests, rather than paying the overhead of opening and closing a connection for each request. It's done implicitly, but you get one pool per unique connection string. Make sure you call Close or Dispose on a connection as soon as possible. When pooling is enabled, calling Close or Dispose returns the connection to the pool instead of closing the underlying dat...

Recommended read part - 3 14) Avoid Unnecessary Indirection How it affects performance: When you use byRef, you pass pointers instead of the actual object. Many times this makes sense (side-effecting functions, for example), but you don't always need it. Passing pointers results in more indirection, which is slower than accessing a value that is on the stack. Solution: When you don't need to go through the heap, it is best to avoid it there by avoiding indirection. 15) Use "ArrayLists" in place of arrays How it improves performance An ArrayList as everything that is good about an array PLUS automatic sizing, Add, Insert, Remove, Sort, Binary Search. All these great helper methods are added when implementing the IList interface. Tradeoffs: The downside of an ArrayList is the need to cast objects upon retrieval. 16) Always check Page.IsValid when using Validator Controls Always make sure you check Page.IsValid before processing your forms when using Validator Controls. ...

Recommended Read Part - 2 6) Use the String builder to concatenate string How it affects performance: String is Evil when you want to append and concatenate text to your string. All the activities you do to the string are stored in the memory as separate references and it must be avoided as much as possible. i.e. When a string is modified, the run time will create a new string and return it, leaving the original to be garbage collected. Most of the time this is a fast and simple way to do it, but when a string is being modified repeatedly it begins to be a burden on performance: all of those allocations eventually get expensive. Solution: Use String Builder when ever string concatenation is needed so that it only stores the value in the original string and no additional reference is created. 7) Avoid throwing exceptions How it affects performance: Exceptions are probably one of the heaviest resource hogs and causes of slowdowns you will ever see in web applications, as well as windows ...