So you get a new CTP. How do you find out whats changed?

Well the first port of call should be BOL. We are told that for Katmai, BOL content will ship with the feature, which is good to know.

But what if you don't have BOL or you don't trust it. Well the system resource database contains most features. So have a look at that.

I recently did this for a build of Katmai without BOL and was able to find system procedures, functions and dmvs that were new.

I'm going to start a DataDude project on the resource database that way I can easily track changes between releases.

So how do I look at the resource database. The easiest way is to copy the mdf and ldf files in your data folder and then attach the database as another name.


This is cross posted from my SQLBlogcasts blog which can be found here, http://sqlblogcasts.com/blogs/simons/Whats new in Katmai?

Categories:
SQL Server 2008

Add comment


(Will show your Gravatar icon)  

  Country flag

biuquote
  • Comment
  • Preview
Loading



Theme design by Nukeation based on Jelle Druyts