SqlServer 2005 - About Sql 2005 & various editions

Sql Server 2005 is a robust database which is a version upgrade after 5+ years, the previous one was Sql Server 2000 and the one before was Sql Server 7.0





Microsoft spent 5 years to come up with this next release which has a lot of cool features,

• Improvements in performance,
• More analysis tools,
• Integrated development with cool dot net IDE and management studio,
• CLR capabilities,
• Http end points,
• Support for service broker and SOA,
• Better Sql jobs control with the new Sql Agent,
• Database Snapshots feature,
• Great database mirroring,
• Log shipping feature,
• Replication improvements,
• and lots n lots of T-Sql and Sql improvements.

I have been working with Sql 2000 for the past 5+ years, and it is one of my favourite databases, i had previous experience working with My Sql and i used to wonder why such a robust database like Sql did not have some good features which mysql had at that time. Example: it had paging at the backend level, you can specify in a query itself how many rows you want, even oracle had pagenum but sql lacked it in 2000 sql server.

The new sql 2005 is very promising and has made up for all the lacking features.

Sql Server 2005 is shipped free with VS Dot net IDE as sql express edition, it comes with sharepoint portal server 2007 and a bunch of other dot net applications. Any developer should learn the new features of Sql server 2005 and my entries would be helpful in that regard.

Sql Server comes in 5 editions:

• Sql Server 2005 Enterprise edition,
• Sql Server 2005 Standard edition,
• Sql Server 2005 Work group edition,
• Sql Server 2005 Developer edition (free for development and testing, exactly like EE),
• Sql Server 2005 Express edition (free like former MSDE)

Best ways to learn sql server 2005:

1) Books online free download - http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

2) Free E-learning courses from Microsoft - (for a limited time it is free soon to end)

https://www.microsoftelearning.com/sqlserver2005/

http://www.microsoft.com/events/series/technetsqlserver2005.mspx

3) Official site - http://www.microsoft.com/sql/default.mspx

4) Cost in $$ for Sql server 2005 - http://www.microsoft.com/sql/howtobuy/default.mspx

5) Made up your mind try it for free (180 day evaluation) - http://www.microsoft.com/sql/downloads/trial-software.mspx

6) Edition comparisons - http://www.microsoft.com/sql/editions/enterprise/comparison.mspx

7) Post a comment on my blog, if i know the answer will let you know :)