T-SQL Command Reference

Feb
04

Local Variable Declaration

DECLARE @X  INT
DECLARE @A INT, @B INT, @C CHAR(10)

A local variable is initially assigned a NULL value. A value can be assigned to a local variable by using the SET or SELECT statement.

DECLARE @X INT
SET @X = 1
SELECT @X = COUNT(*) FROM db.dbo.books

IF ... ELSE statement

Posted By admin read more

Mount ISO image without burning a CD

Feb
04

Microsoft has an unsupported virtual CD-ROM software for FREE. To download, use the link below:

Download Microsoft Virtual CD Control Panel

Readme for Virtual CD-ROM Control Panel v2.0.1.1

THIS TOOL IS UNSUPPORT BY MICROSOFT PRODUCT SUPPORT SERVICES

System Requirements
===================
- Windows XP Home or Windows XP Professional

Posted By admin read more

Apache mod_vhost_alias module fails to set DOCUMENT_ROOT

Feb
04

Mass virtual hosting using mod_vhost_alias or mod_rewrite module simplifies pattern-based virtual hosting. However, there is a major problem if your virtual host application makes use of the DOCUMENT_ROOT environment variable. According to the Apache documentation, the mod_vhost_alias does NOT correctly sets the DOCUMENT_ROOT variable and hence pontentially break PHP web applications that makes use of this environment variable.

Posted By admin read more

Enable Out-Of-Office replies to the Internet

Feb
04

By default, Microsoft Exchange Server 2003 Out-of-Office replies to the Internet is disabled. This is done to disallow Out-of-Office auto-replies to be sent outside of the organization to prevent outsider to learn when users are out of the office.

To enable Out-Of-Office replies to the Internet:

1. On the Exchange Server machine, go to Start - Programs - Microsoft Exchange - Systems Manager.

2. Double click Global Settings, and then click Internet Message Formats.

Posted By admin read more

Setting mail header for a foreign language

Feb
04

Depending on the client's regional settings and an ability to read foreign language on the client's computer, emails sent using traditional text/plain mail header may not be readable by foreign receipients. To allow mails to be sent in correct format, the following mail headers must be set in addition to From, CC and BCC mail headers.

MIME-Version: 1.0
Content-Type: text/plain; charset=ks_c_5601-1987
Content-Transfer-Encoding: quoted-printable

Posted By admin read more

Exchange Server and firewall

Feb
04

An Exchange Mail user who has a problem establishing a connection to the server may have one or more TCP ports blocked. The blockage may be from computer or router firewall, or your Internet provider may simply blocks the ports needed by the Exchange Server such as TCP port 135. Various Internet providers, including Cox, Comcast and Verizon have blocked the port 135 at one point and they may still do.

To determine whether the TCP port is blocked, you may simply use 'telnet' command to test out the port. For example, if your server IP is 1.2.3.4 and the port in question is 135...

Posted By admin read more

Configuring SSL on Weblogic 8.1

Feb
04

If you're new to SSL, please read our SSL Overview. You may also find BEA documenation and BEA viewlet helpful. The information contained herein supplements BEA documentation, and answers some of the unanswered questions.

SSL installation on Weblogic 8.1 involves 4 main steps:

Posted By admin read more

SSL Certificate File Formats

Feb
04

Secure Sockets Layer (SSL) provides secure connections by allowing two applications connecting over a network connection to authenticate the other's identity and by encrypting the data exchanged between the applications. A server identity is verified by three components: Private Key, Digital Certificate and Trusted Certificate Authority.

Posted By admin read more

How to create a htpasswd file with encrypted password?

Feb
04

htpasswd is used to create and update the flat-files used to store usernames and password for basic authentication of HTTP users. Resources available from the Apache HTTP server can be restricted to just the users listed in the files created by htpasswd. This program can only manage usernames and passwords stored in a flat-file.

To restrict access to certain HTTP resources, we need to create two files: .htaccess and .htpasswd (or equivalent per httpd.conf setting). The .htaccess file looks something like:

-- [.htaccess] file content begins --

Posted By admin read more

freevps installation on CentOS 4.1

Feb
04

1. download FreeVPS Kernel, and FreeVPS Tools for RH_EL4 from the following location:

http://www.freevps.com/download/rpms/RH_EL4/

Download both single and SMP versions:

kernel-freevps-1.5-1.i686.rpm
kernel-freevps-smp-1.5-1.i686.rpm
freevps-tools-1.4-2.i386.rpm

*Note: A sigle processor version is necessary to satisfy dependency requirement for freevps-tools.

2. Install the new kernel packages

Posted By admin read more

Pages

Subscribe to Web Traffic Exchange RSS