Monday, August 2, 2010

How to identify your SQL Server version and edition

How to identify your SQL Server version and edition


Run the below command in your SQL Server Query Window:


SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')


Pl. Note: This command will work in SQL 2008, 2005, 2000. not in SQL 7

Friday, July 30, 2010

Compression in IIS 6.0

Guys, Pl. dont miss this if you are using IIS 6,

Pl. find the link for how to implement Compression in IIS 6:



Scott Forsyth's Blog


Enabling HTTP Compression - Microsoft


Customizing the File Types IIS Compresses - Microsoft