Wednesday, 25 May 2011

ASP.NET ServerVariables Collection Information


The ServerVariables collection is used to retrieve the server variable values.

Syntax

System.Web.HttpContext.Current.Request.ServerVariables["REMOTE_HOST"].ToString()

ParameterDescription
server_variableRequired. The name of the server variable to retrieve

Server Variables

VariableDescription
ALL_HTTPReturns all HTTP headers sent by the client. Always prefixed with HTTP_ and capitalized
ALL_RAWReturns all headers in raw form
APPL_MD_PATHReturns the meta base path for the application for the ISAPI DLL
APPL_PHYSICAL_PATHReturns the physical path corresponding to the meta base path
AUTH_PASSWORDReturns the value entered in the client's authentication dialog
AUTH_TYPEThe authentication method that the server uses to validate users
AUTH_USERReturns the raw authenticated user name
CERT_COOKIEReturns the unique ID for client certificate as a string
CERT_FLAGSbit0 is set to 1 if the client certificate is present and bit1 is set to 1 if the cCertification authority of the client certificate is not valid
CERT_ISSUERReturns the issuer field of the client certificate
CERT_KEYSIZEReturns the number of bits in Secure Sockets Layer connection key size
CERT_SECRETKEYSIZEReturns the number of bits in server certificate private key
CERT_SERIALNUMBERReturns the serial number field of the client certificate
CERT_SERVER_ISSUERReturns the issuer field of the server certificate
CERT_SERVER_SUBJECTReturns the subject field of the server certificate
CERT_SUBJECTReturns the subject field of the client certificate
CONTENT_LENGTHReturns the length of the content as sent by the client
CONTENT_TYPEReturns the data type of the content
GATEWAY_INTERFACEReturns the revision of the CGI specification used by the server
HTTP_<HeaderName>Returns the value stored in the header HeaderName
HTTP_ACCEPTReturns the value of the Accept header
HTTP_ACCEPT_LANGUAGEReturns a string describing the language to use for displaying content
HTTP_COOKIEReturns the cookie string included with the request
HTTP_REFERERReturns a string containing the URL of the page that referred the request to the current page using an <a> tag. If the page is redirected, HTTP_REFERER is empty
HTTP_USER_AGENTReturns a string describing the browser that sent the request
HTTPSReturns ON if the request came in through secure channel or OFF if the request came in through a non-secure channel
HTTPS_KEYSIZEReturns the number of bits in Secure Sockets Layer connection key size
HTTPS_SECRETKEYSIZEReturns the number of bits in server certificate private key
HTTPS_SERVER_ISSUERReturns the issuer field of the server certificate
HTTPS_SERVER_SUBJECTReturns the subject field of the server certificate
INSTANCE_IDThe ID for the IIS instance in text format
INSTANCE_META_PATHThe meta base path for the instance of IIS that responds to the request
LOCAL_ADDRReturns the server address on which the request came in
LOGON_USERReturns the Windows account that the user is logged into
PATH_INFOReturns extra path information as given by the client
PATH_TRANSLATEDA translated version of PATH_INFO that takes the path and performs any necessary virtual-to-physical mapping
QUERY_STRINGReturns the query information stored in the string following the question mark (?) in the HTTP request
REMOTE_ADDRReturns the IP address of the remote host making the request
REMOTE_HOSTReturns the name of the host making the request
REMOTE_USERReturns an unmapped user-name string sent in by the user
REQUEST_METHODReturns the method used to make the request
SCRIPT_NAMEReturns a virtual path to the script being executed
SERVER_NAMEReturns the server's host name, DNS alias, or IP address as it would appear in self-referencing URLs
SERVER_PORTReturns the port number to which the request was sent
SERVER_PORT_SECUREReturns a string that contains 0 or 1. If the request is being handled on the secure port, it will be 1. Otherwise, it will be 0
SERVER_PROTOCOLReturns the name and revision of the request information protocol
SERVER_SOFTWAREReturns the name and version of the server software that answers the request and runs the gateway
URLReturns the base portion of the URL


Examples

You can loop through all of the server variables like this:
<%
for each x in Request.ServerVariables
  response.write(x & "<br />")
next
%>



Posted By : Mr. Palash Paul

Monday, 23 May 2011

How the Data Stores in SQL Server

Data Page

 

Data pages are the fundamental area to store data in SQL server.

 

The data pages contains

  1. Pages header
  2. Data Row
  3. Row Offset or pointers.

 

The maximum size of a data page is 8 KB

 

Extents

 

Extents are basic units in which page are managed. An extents are 8 physical continuous pages, that is 8*8=64 KB.

 

SQL Server has two types of extents:

·             Uniform extents are owned by a single object; all eight pages in the extent can   only be used by the owning object.

·             Mixed extents are shared by up to eight objects. Each of the eight pages in the extent can be owned by a different object.

Type of Data Pages

The following table shows the page types used in the data files of a SQL Server database.

Page type

Contents

Data

Data rows with all data, except text, ntext, image, nvarchar(max), varchar(max), varbinary(max), and xml data, when text in row is set to ON.

Index

Index entries.

Text/Image

Large object data types:

·             text, ntext, image, nvarchar(max), varchar(max), varbinary(max), and xml data

Variable length columns when the data row exceeds 8 KB:

·             varchar, nvarchar, varbinary, and sql_variant

Global Allocation Map, Shared Global Allocation Map

Information about whether extents are allocated.

Page Free Space

Information about page allocation and free space available on pages.

Index Allocation Map

Information about extents used by a table or index per allocation unit.

Bulk Changed Map

Information about extents modified by bulk operations since the last BACKUP LOG statement per allocation unit.

Differential Changed Map

Information about extents that have changed since the last BACKUP DATABASE statement per allocation unit.

 

 

 

Published By : Mr. Joydeep Das

 

Thursday, 19 May 2011

[ APPS ] Way2Sms Desktop Version


Step 1: Create login OR Register in way2sms.com (http://site6.way2sms.com/jsp/UserRegistration.jsp)
Step 2: Download and Extract the attach file (Way2sms.rar), you will find the "sms.exe" just run the same 
Step 3: Login with your User name & Password



















Step 4: Click on for Add New Contact 

















Step 5: Click on for get all saved Contacts









Step 6: DblClick on the Name or Number to send message









Step 4: Send Sms to any one without login in the www.way2sms.com web site.
Step 5: NJOY!!!!!!!!