2010年4月22日 星期四

get the version information of SQL server

Microsoft support has a web page for this.

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

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

Version NumberService Pack
7.00.1063SQL Server 7.0 Service Pack 4 (SP4)
7.00.961SQL Server 7.0 Service Pack 3 (SP3)
7.00.842SQL Server 7.0 Service Pack 2 (SP2)
7.00.699SQL Server 7.0 Service Pack 1 (SP1)
7.00.623SQL 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
ReleaseSqlservr.exe
RTM2000.80.194.0
SQL Server 2000 SP12000.80.384.0
SQL Server 2000 SP22000.80.534.0
SQL Server 2000 SP32000.80.760.0
SQL Server 2000 SP3a2000.80.760.0
SQL Server 2000 SP42000.8.00.2039


9.00.1399.06RTMEnterprise Edition
The following table lists the Sqlservr.exe version number.

ReleaseSqlservr.exe
RTM2005.90.1399
SQL Server 2005 Service Pack 12005.90.2047
SQL Server 2005 Service Pack 22005.90.3042
SQL Server 2005 Service Pack 32005.90.4035

10.0.1600.22RTMEnterprise Edition
The following table lists the Sqlservr.exe version number.
Collapse this tableExpand this table
ReleaseSqlservr.exe
RTM2007.100.1600.0
SQL Server 2008 Service Pack 12007.100.2531.0







2010年4月21日 星期三

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

2010年4月16日 星期五

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