Updates
Latest Tweet
What's New?
Check out for latest innovation, a computer based training video collection
Like this Page
Pro SQL Server 2005 Review by Donald Bickel
Outstanding Reference for Database Developers Moving to SQL 2005 From 2000
We have been heavy users (both as developers and administrators) of SQL Server 2000 since it came out in 2000. We were anxious to upgrade to SQL Server 2005 and did so in early 2006. For the first couple of months we largely utilized SQL 2005 in the same way that we had done with SQL 2000 (with the exception of using the new Management Studio) and did not really exploit the new features of SQL 2005. This book definitely opened our eyes to many of the new features of the SQL 2005 database and we are using many of those features in our current development efforts.
The Pro SQL Server 2005 book spent a significant amount of pages on process changes between 2000 and 2005 and then dove into the significant functional differences between the databases. As users of the Reporting Services features rolled out mid-stream in SQL 2000 we were very interested to read the coverage dedicated to it in this book. This book cannot serve as a comprehensive reference to all of the new features in SQL 2005 (there are entire volumes dedicated to each topic) and the authors did not attempt to. However, I felt like they did as good a job as was possible in such a concise manner.
I particularly enjoyed the section on the CLR embedded into SQL 2005 but wished that it could have been a bit longer. Overall, this is an excellent title and I encourage all database developers and administrators moving from SQL 2000 to check it out.