Creating new root certificate

In SSL communication you would need a certificate signed by recognized CA. You can generate the new certificate, but if it is not signed  by root certificate it would not be excepted. Is this possible to generate a root certificate without having access to recognized CA. The answer is yes

makecert -sv SignRoot.pvk -cy authority -r signroot.cer -a
    sha1 -n "CN=Dev Certification Authority" -ss my -sr localmachine

See article SSL with Self-hosted WCF Service for more detail. It also shows how to generate new certificate, sign it by the root certificate and associate it with a port.

Difference between cluster and cloud computing

Although these two paradigms are similar they can be distinguished be the following
1. clusters usually have corporate access, while clouds have public access through internet
2. clusters have not usage measurement, while clouds do and actually and it provide service by demand
3. resources are usually pre-reserved in clusters while in clouds they are demand driven (rapid elastic)

Here is a good article WHAT ARE THE DIFFERENCE BETWEEN CLOUD, CLUSTER AND GRID COMPUTING?

Tips and Triks

How To Show Full File Path in VS 2005 Title Bar

Unattended Service installation
     installUtil.exe /username=domain\username /password=password /unattended C:\My.exe

Useful commands/statements

1. Check if Procedure exist before creating it

EXISTS (SELECT * FROM sys.objects WHERE type = 'P' AND name = 'MyProc')

Return bool

Ex.

IF EXISTS (SELECT * FROM sys.objects WHERE type = 'P' AND name = 'MyProc')
DROP PROCEDURE MyProc
GO
CREATE PROCEDURE MyProc...

2.

SET NOCOUNT ON  - Stops the message indicating the number of rows affected by a Transact-SQL statement from being returned as part of the results.

For stored procedures that contain several statements that do not return much actual data, this can provide a significant performance boost because network traffic is greatly reduced.

3.  SP
 sp_help [object] provides info on object