The one difference I was hoping for was an auto-complete facility like you get in Visual Studio. In my opinion, it's so long overdue that people might forget about even doing it!
Otherwise, 2005's a good improvement over 2000 with all the features you mentioned, but with the brand new GUI it still feels like an incremental update and not a complete revolution that I was expecting. Though, I'll hold my final judgement until I get a chance to play with it properly.
Paul
I think the addition of varchar(max) and the xml data types are pretty compelling. Not exciting stuff, but they can really clean up the way you solve problems.
I'll also suggest a different method. Try solving (or at least imagining) problems using the new features in SQL 2005, then go back to SQL 2000 and see what you miss having.
Very nice article. There was not much mentioned about Visual Studio 2005 and SQL 2005 integration. From your experiences as a developer, aside from the new features, what can to do with the VS 2005 and SQL 2005 that you can't do with SQL 2000?
Thanks
This set of articles was very informative in a concise manner.
I would like to see an article on migration issues and things to consider. We have been running SQL 2000 and I have been using the 2005 Management Studio alternately with the 2000 Enterprise Manager and doing my research into how best to proceed to a migration now that we have made the decision to do so.
There are always gotchas when migrating depending on setup and configuration. I am going to be migrating SQL 2000 (running on Win 2003 servers) to SQL 2005. I have done a great deal of research on it. There are still some questions to hardware configuration for optimization of 2005 that I have found difficult to find any reference to.
If you were of a mind to do so, I would personally appreciate some Dos and Don'ts for migrating.
Thank you..cherie
I'm a little confused about the excitement behind varchar(max). In the article it states, "TEXT is hard to work with in programming environments." Now maybe it's just the environment I've been programming in for the past several years (Visual Studio .NET, mostly C#), but I haven't found text (or ntext) to be hard at all. Through ADO.NET I can SELECT, INSERT, and UPDATE text/ntext columns just like any other column.
What am I missing?
