As this is a technical blog I will not give a report of this night, so after only 4 hours in bed:
What do I remember from yesterday?
First half of the day, community work, nice conversations with other peers. And a lot of Belgians, we were 6 or 7!
Last half of the day was more sql related. I missed the keynote so I went to Francois Ajenstat's session about what's new in Sql Server 2008. this is part of what 2008 will bring us for the data-engine:
- This year (november) another CTP
- February 2008 a last CTP
- 2008 Q2 the RTM (with the same price as todays 2005)
- Transparant data encryption (so without your application to be rewritten - he said)
- Log file compression in relation to database mirroring (I am not sure what about logshipping - I will check this out)
- Possibility to apply rules to sql server through policies (naming conventions, configuration settings, ...)
- Resource governor to limit % cpu and memory usage for a certain workload
--> will be included in november CTP.
--> very important REMARK: if we want IO resource governor also included in Sql 2008, we have to argue to the product-team !
- Concept of identity (OO vs relational ?? - I will check this out)
- New (interesting) datatype: filestream to be viewed as an intelligent pointer to your files on the filesystem
- New long-expected split of date and time + a new data-type datetime2 which stores 7 decimal places iso 3 milli-seconds
- A spacial data-type to store geographic data. This one will not be an option which is to be paid as in Oracle (it seems) but available in-the-box from the Express Edition on.
- Full-text makes part of the sql engine and is not longer a separate service (I can not overview the consequence of this yet)
- Wauw, intellisense is there !!
- Performance monitor: We now the dmv's from Sql 2005. In 2008 this information is stored for later analysis.
- and a lot more, ...
So, dear reader, a lot to discover during this week!
o Pedro