get the version information of SQL server

Microsoft support has a web page for this.

In short,
1. run 'select @@version'.

Version Number	Service Pack
6.50.479	SQL Server 6.5 Service Pack 5a (SP5a) Update
6.50.416	SQL Server 6.5 Service Pack 5a (SP5a)
6.50.415	SQL Server 6.5 Service Pack 5 (SP5)
6.50.281	SQL Server 6.5 Service Pack 4 (SP4)
6.50.258	SQL Server 6.5 Service Pack 3 (SP3)
6.50.240	SQL Server 6.5 Service Pack 2 (SP2)
6.50.213	SQL Server 6.5 Service Pack 1 (SP1)
6.50.201	SQL Server 6.5 RTM

Version Number	Service Pack
7.00.1063	SQL Server 7.0 Service Pack 4 (SP4)
7.00.961	SQL Server 7.0 Service Pack 3 (SP3)
7.00.842	SQL Server 7.0 Service Pack 2 (SP2)
7.00.699	SQL Server 7.0 Service Pack 1 (SP1)
7.00.623	SQL Server 7.0 RTM (Release To Manufacturing)

if the version number string is started with "8.", "9." or later, then run
"SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')"

The following results are returned:

• The product version (for example, 8.00.534)
• The product level (for example, "RTM" or "SP2")
• The edition (for example, "Standard Edition"). For example, the results resemble the following:
  
  8.00.534 SP2 Standard Edition

Release	Sqlservr.exe
RTM	2000.80.194.0
SQL Server 2000 SP1	2000.80.384.0
SQL Server 2000 SP2	2000.80.534.0
SQL Server 2000 SP3	2000.80.760.0
SQL Server 2000 SP3a	2000.80.760.0
SQL Server 2000 SP4	2000.8.00.2039

9.00.1399.06

RTM

Enterprise Edition

The following table lists the Sqlservr.exe version number.

Release	Sqlservr.exe
RTM	2005.90.1399
SQL Server 2005 Service Pack 1	2005.90.2047
SQL Server 2005 Service Pack 2	2005.90.3042
SQL Server 2005 Service Pack 3	2005.90.4035

10.0.1600.22

RTM

Enterprise Edition

The following table lists the Sqlservr.exe version number.

Collapse this tableExpand this table

Release	Sqlservr.exe
RTM	2007.100.1600.0
SQL Server 2008 Service Pack 1	2007.100.2531.0

TPM and Linux

Trusted Computing in IBM Research

The H Open Source - Linux and TPM

Trusted Computing, IBM resources page on TPM and Linux

TPM EmulatorTalk.pdf

Use TPM on Linux

How to use a TPM with Linux @GrouNation

[lINUX]TPM and eCryptfs

TPM Emulator

SoftTPM is located, but no files could be downloaded.

Microsoft TechNet – Windows Trusted Platform Module Management Step-by-Step Guide, Microsoft's guide to the use of TPM with Windows.

full disk encryption and filesystem encryption

eCryptfs seems support TPM. in its README,
...Future versions of eCryptfs will allow hardware token devices, such as a TPM chip, to protect your secret keys....
But there is a file named ecryptfs-utils-83/src/utils/ecryptfs_generate_tpm_key.c.
It is necessary to look into further.
eCryptfs: An Enterprise-class Cryptographic Filesystem for Linux introduce the eCryptfs in detail.


MetFS (FUSE) doesn't support TPM by observing its source.

EncFS (FUSE), no clue now.

CryptoFS (FUSE) doesn't support TPM by observing its source.


TrueCrypt (On-The-Fly Disk encryption) doesn't support TPM explicitly.

Full disk Encryption in wikipedia is a good start for information of this kind.

Fedora Core 4 support disk encryption. (dm-crypt ?)
Fedora's Release note: FeatureEncryptedFilesystems outline something on this topic.

Comparison of disk encryption software - BestCrypt, Bloombase Keyparc, Check Point Full Disk Encryption, cryptoloop, dm-crypt, eCryptfs, FREE CompuSec, loop-AES, Scramdisk, SecureDoc, TrueCrypt

RSA and SSL weak keys ?

ssl weak key generation (supposed to effect only debian). By reading the document, I think it is not really weak key on RSA, but debian's patch on OpenSSL causes predictable rsa key set.

script to check for weak SSH hostkeys -

SSL keys

Cryptographic API and RSA

Cryptography

Windows PKI blog
How to encrypt small data block with only RSA public key using Microsoft ECSP

accelerometer

Orientation in Firefox and beyond shows how to handle "MozOrientation" event in FF 3.6.
Safari Reference Library shows the API.
PhoneCap opens up the iPhone's SDK to Web developers - allowing them to access features such as the accelerometer and geo-location tools directly from HTML and Javascript powered Web pages.
iPhone Tutorial - Reading the Accelerometer

Geolocation

Geolocation API Specification in W3C
Geolocation API - Gears API
Google Gears also provide this feature for Android 1.x device or emulator, Windows Mobile, Windows, Mac OS Tiger/Leopard/Snow Leopard, Linux.
Google Gears Portable for FF 3.6
gears' source code
Learn how to perform GeoLocation with Google Gears

Android

The Developer's Guide
Android 中文論壇, G3 Hero
[Android]HTC Hero[台灣版]取得Root權限方法
market下載的遊戲與程式能直接安裝在記憶卡嗎?
Android in Wikipedia
Nexus One到貨第二話：來看Android 2.1好體驗
Dalvik: how Google routed around Sun’s IP-based licensing restrictions on Java ME

Android and the Linux kernel community
Linux 2.6.33 Boosts Graphics, Dumps Android

FIPS-140 and HSM

FIPS 140
it is necessary to meet the requirement of FIPS 140-2 level 3

SafeNet HSM Implementation

HSM reseller in Taiwan
Thalesgroup's HSM: nShield Solo


Tutorial: nCipher NetHSM and OpenSSL

wsgi

werkzeug.pocoo.org - a simple collection of various utilities for WSGI application

webob - web object (WSGI)

modwsgi - wsgi module

bobo - a small simple easy to learn and remember web framework for Python

wsgi spec - python web server gateay interface v 1.0

cherryPy +Apache with mod_wsgi

Django