Today, some nice-to-know's
- Sql Server 2005 SP3 (not known yet when it will come out) will probably contain an instruction to do an active checksum verification on all pages of a database
- Sql Server 2008 CTP (November):
* What concerns the features about Transparant Data Encryption in Sql Server 2008:
Tempdb will (implicitly) be completely encrypted. In later versions only those pages which will be encrypted in the destination database, will be encrypted in tempdb. So the tempdb-part of this feature will be implemented in 2 steps.
* About the framework (I forgot the name) to collect resource usage. I saw some usefull reports with history information about
- disk usage
- query statistics
- server activity: usage of cpu, memory, disk i/o and network
Not in the CTP yet, but in the RTM, MS will (try to) deliver a connector for monitoring Sql Server 2005 too.
- Creation of a plan guide will be much simplier in Sql Server 2008 than in 2005. Whatch for the procedure with the name "sp_create_plan_guide_from_cache". It will be available in the CTP foreseen for February 2008
- Just as with the resouce governor for I/O (mentioned in yesterdays post), bug-reporting and suggestions for new features can always be sent to Microsoft at connect.microsoft.com