|
Ok, I'm probably being dumb, but I can't find a summary saying 'here is the new stuff you can do in T-SQL in Denali'. There is obviously NEXT VALUE FOR, and support for paging - but is there a definitive 'this is what's new' post somewhere?
(comments are locked)
|
|
I liked this concise article from Aaron Bertrand. For example, dual monitor support is new. One part that's missing, at least so far according to Aaron, is the "bread crumb" feature that let's us click on an error message and it takes you to the error in the sproc. I especially liked that feature! ;0) [Edit] The link mentioned above is hardly comprehensive. At times I wonder if I have reading comprehension problems! Anyway, you may have seen this and it doesn't claim to be an exhaustive list, but maybe this is more relevant to what you're asking. See... that one is missing THROW as well...
Dec 03 '10 at 01:09 PM
Matt Whitfield ♦♦
(comments are locked)
|
|
I have compiled a large list of features (around 60+) and blog posts and articles explaining each feature. You can find it here: What is new in SQL Server Denali
(comments are locked)
|
|
In fairness Mark, I have written many blog posts focusing on different features introduced in Denali, including one on THROW. My list isn't comprehensive yet either (for example, I haven't yet blogged about AlwaysOn or the FMTONLY replacements). Here are a couple of links that might be useful to Matt. This is a list of all the posts I've written and tagged with "denali" - this includes a slide deck of a "What's New in Denali" presentation I gave for the Philadelphia SQL Server User Group this week: http://sqlblog.com/blogs/aaron_bertrand/archive/tags/denali/default.aspx And here is an article on THROW specifically (which, as has been noted, did not make it into the CTP1 Books Online): Just to clear up any misunderstanding, the Books Online process is not a simple "just throw a web page up there." In can often take weeks or longer to publish a simple page, since it has to be updated in several other places (all deep links, table of contents, index, etc) and it also has to be translated (the CTP and Books Online ship in more than just English). Not saying THROW shouldn't be there, but during the early beta phase we have to compromise. If it's a choice between getting the product with some docs missing, and waiting for complete docs (which will never happen during dev, because dev and doc do not move at the same speed), I know what I would vote for. @AaronBertrand - Thanks - the thing i was looking for wasn't a Books Online section - or a series of posts - just a single blog post or something like that, maybe from one of the SQL Engine team, basically summarising what's new in T-SQL. Even just a dump of the differences in the BNF between 2008 and 2011 would be invaluable.
Dec 13 '10 at 12:17 AM
Matt Whitfield ♦♦
(comments are locked)
|
|
You can get answers from this link. Yep - knew about that one, but the way that THROW is added in by a MSFT peep in the Community Content section irks me...
Dec 03 '10 at 01:08 PM
Matt Whitfield ♦♦
(comments are locked)
|
Matt - you really missed out not seeing Tobias Ternstrom from the SQL Programming Team (he is lead on programability -> T-SQL, CLR etc.) at the PASS Summit.
He showed the programability enhancements like THROW and the replacement for the borken SET FMTONLY. He is a great presenter and really funny.
@WilliamD - Yeah, I know. It's the fact that the MSDN missed out THROW which leads me to wonder if there is a more definitive resource...
Nah - definitive resources for stuff on an unfinished product. Even the MSDN stuff says that it is open to change, so no dice I think.
Well, yeah, CTP1 isn't what RTM will be. But is the question 'what have you actually shipped' so hard to answer?! ;)