whats the difference between == and === ?

The difference between == and === is that:

1. == converts the variable values to the same type before performing comparison. This is called type coercion.
2. === does not do any type conversion (coercion) and returns true only if both values and types are identical for the two variables being compared.

Example:

1. var one = 1;
2. var one_again = 1;
3. var one_string = "1"; // note: this is string
4. console.log(one == one_again); // true
5. console.log(one === one_again); // true
6. console.log(one == one_string); // true. See below for explanation.
7. console.log(one === one_string); // false. See below for explanation

System.InvalidCastException: 'Unable to cast object of type 'System.Net.FileWebRequest' to type 'System.Net.HttpWebRequest'

System.InvalidCastException: 'Unable to cast object of type 'System.Net.FileWebRequest' to type 'System.Net.HttpWebRequest'

 The error because the URL is not proper. please pass the proper url containing http:// or https://.

and also check that URL is correct.

SQL Server - Running large Sql files

When we try to open a large Sql file in SQl Server, it's gives the error

"The operation could not be completed. not enough storage is available to complete this operation

The template specified cannot be found. Please check that the full path is correct"

Solution:

use the sqlcmd tool to execute the file.

To execute a SQL script:

1. Start the Command Prompt
2. Run the below command  

sqlcmd -S DatabaseServer -d Database -i C:\Users\Administrator\Downloads\script.sql -x

Error "A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe"

Error "A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe"

Solution:
This is login authenticate problem. Please check the following things:

• In the SQL Server Properties, please check that "SQL Server and Windows Authentication Mode" is enabled, if not enable, please enable and restart the SQL Server.
   
• Is Login have the permission to particular Database?
   
• This might be a firewall issue as you mentioned it only happens when security agent installed. Please make sure you have properly configured security agent to allow Database Engine Services accesses.
   

How to Update Private Nameserver / Child Nameserver in BigRock?

Register and Update Private Name Servers / Child Name Servers in Big Rock

1. Login to your Bigrock Account and Select the domain for which you would like to update the nameserver details.
2. Click on the ‘Child Name Servers’ link.
   
3. You have to provide Appropriate Host Name and its appropriate IP address
   
4. Go back to the main page and select the “Name Servers” option 
   
5. Now, Enter the already registered private nameservers here and update name servers