januari 2008 - Posts
Some sad news on this blog. Ken Henderson was one of the SQL Server gurus who wrote wonderful books and had a real passion for SQL Server. We will sure miss him in the community. My condolences to his family, friends and colleagues. We will see you in the next life khen1234 :'(
Update: Ken's sisters have asked for stories about Ken you would like to share. Please check out this post for more information.
I got your attention didn't I?
Unfortunately the news in this post is not as good. The guys from the Data Platform Insider blog posted a 'Roadmap Clarification' for SQL Server 2008 and I am afraid it has a sad statement: "Microsoft is excited to deliver a feature complete CTP during the Heroes Happen Here launch wave and a release candidate (RC) in Q2 calendar year 2008, with final Release to manufacturing (RTM) of SQL Server 2008 expected in Q3. Our goal is to deliver the highest quality product possible and we simply want to use the time to meet the high bar that you, our customers, expect."
Is it really a sad statement? I think we can all agree that we need the highest quality product for our projects. Apart from this I think many of us still want to implement a lot of SQL Server 2005 features where we have not gotten around too. The leap from SQL Server 2000 to SQL Server 2005 was quite a large one and many projects are still running SQL Server 2000 or did 'simple' migrations to SQL Server 2005. Because SQL Server 2008 builds on the SQL Server 2005 strength the move will be less complicated so maybe we should start implementing those very needed SQL Server 2005 features and have some patience for SQL Server 2008 to come out.
Nevertheless I want to play with data compression so get the next CTP ready please :-)
In case you have not noticed yet, the SQLCat team has released a new version of the Best Practices Analyzer.
Among other things it contains 60+ new rules and the Analysis Services rules have been updated so they match the Best Practices warnings in BIDS 2008.
More information can be found here and the download can be found here.
I was giving a presentation on the new programmability features in SQL Server 2008 when the following question popped up:
"Does the MERGE statement support multiple WHEN MATCHED clauses?"
As you know it is possible to say "WHEN MATCHED AND myField = 0 THEN...", so it would make sense to have multiple WHEN MATCHED statements because depending on the criteria you could have different actions. Since you see this blog post you might have guessed that it is not the obvious answer. Trying to add a second WHEN MATCHED statement will result in the following pretty clear error: "An action of type 'WHEN MATCHED' cannot appear more than once in a 'UPDATE' clause of a MERGE statement".
A second popular question was: "Which version of the .NET framework is included in SQL Server 2008?". This question has been answered by Bob Beauchemin on his blog with a very detailed explanation. Basically it loads the latest CLR version but there is a little catch which is explained by Bob so I recommend you read his post.
Because CU5 is released here is the next announcement.
The question is of course how many of you have already implemented CU5?