Yukon
I read carefully the .Net Magazine article on Yukon, thanks Randy.
If this is coming to life like that, most of the new things are for me exciting stuff.
I like:
- XML as native data storage.
- Intellisense in stored procedures with the future VS release.
That's pretty cool but I hope it could be also for T-SQL
- SQL Server Workbench
- VB and C# integration. globally it's a good idea. I am just a bit afraid about debugging.
I wonder how it will going debugging my application and the data layer !
- multiple results set on a single connection
- Varchar(max) if it's true this is a great new ! At last no more 8k limit
- Automatic notifications are a very good idea
- Recursives functions. This is excellent
- Try catch is a good combination to use with Transactions, if as I said below, it's ANSI SQL-3 standard.
- Reporting services as long as it's simple to use as in Access.
I dislike:
- XML format for big databases, how about performances ?
- Integration of .Net in SQL Server will make the product too much platform dependent.
With T-SQL it's not big deal to copy stored procedures, with few changes, to Oracle for example on Unix or Windows. What's about a stored procedure written in C#?
I have no problem to develop muy middle tier in .Net, but I like a kind of independancy with the data layer. A mismatch will not benefit Yukon.
Other features need to be seen. Is Array parameters can be a door to crosstables ?
I didn't read anything new about Cube or OLAP.
In conclusion I admit that I have more 'I like it' than 'I dislike it'.
That's not so bad at all and this new release seems promising.