Another interesting day, full information. Once I return and I find more time, I will work out some topics. For the moment I'll provide you today with some 2-sentence topics:
- Sql Server 2005: on logging in to Sql Server 2005 and you are not using any encryption, Sql Server will encrypt your login & password automatically. I forgot to ask if this is only with the native driver ...
- Sql Server 2005: Do you remember the application roles, with which you can make a difference in user-rights between different applications (in fact different connections)? Well, it is now recommended to use login-less users instead of these application roles. I will search this out , because I forgot why - too much information the last days :-).
- Sql Server 2008 will contain a SQL Provider for Powershell.
- Sql Server 2008: The boundaries for the new date-datatype are 0001-01-01 till 9999-01-01, the time-datatype goes to 100 ns. However you can define less precision if you want (less bytes to store).
- Sql Server 2008: the insert statement can now contain multiple rows, e.g.
insert Table1 values (1, 2, 3) , (10, 2, 30) , (100, 300, 400)
- Sql Server 2008: object dependencies do not lie anylonger (e.g. after a drop and recreate of a procedure which is allready depending on another). Although make sure that you always use the 2-part naming style, it is schema.objectname.
- Sql Server 2008: user defined data-types can now be as large as 2 Gb.
- Sql Server 2008 CTP5 (november 2007) will contain backup-compression. Backup-compression can be defined at the database level as well as in the backup-statement itself.
- Sql Server 2008 CTP6 (february 2008) will contain data-compression for DWH fact tables. Not for blob data. For blob data, it is recommended to use the new filestream datatype. Rule of thumb I heard here: put never files > 100 Mb in your database. Personally, I am not pro putting files in your database anyway, although it might have some advantages (transactional consistency). This last one is included in the filestream datatype, so happy again.
I have to leave, the 1st session of today will start.