Amazon.com: Microsoft SQL Server Developer Edition 2005 [OLD VERSION]: Software

As a long time user of SQL Server, I was glad when Microsoft finally moved away from Sybase and started developing SQL Server on their own. Unfortunately, SQL Server 7 took a bit too long to finish and I was stuck with SQL Server 6.5.

For my Enterprise work, however, I had to move to Oracle. To embed custom code, other than T-SQL code, I was also forced to move to Oracle and Java. There was no facility in SQL Server.

With the 2000 release, SQL Server finally became a contender. With far better tools than any other RDBMS and an engine that could work well with larger databases, SQL was on the right track. It just was not quite there.

With SQL Server 2005, Microsoft finally has a real contender. First, there is a very strong database engine with features that can compete with other Enterprise level databases. While there are still some features missing, the release is fairly strong.

* Database mirroring
* Failover clustering
* Database snapshots and other recovery options

SQL Server now also offers the ability to write custom code inside the database, using any .NET language, like C# and VB.NET.

SQL Server has a few built in features that bring it up a notch, as well. The database now natively handles XML as a datatype. In addition, in supports native encryption.

For the DBA, object schemas are now separated from users, allowing you to easily move ownership away from owners who have left the company. The new schema also allows for easier security on groups of objects.

Out of the box, SQL Server has a plethora of extras that have additional cost with the competition:

* The new version of DTS, now labeled SQL Server Integration Services (SSIS) is a fully debugable ETL engine with the ability to work on multiple paths at the same time.

* Business Inteligence tools include an updated Analysis Services, the KPI (key performance indicator) framework and built in business analytics.

* Improvements to SQL Server Reporting services, including the ability to set up reporting aggregates for business users to create reports on the fly, without developer or dba time.

* SQL Server Broker - finally a easy, built in way of creating asynchronous applications in SQL Server.

On the negative, Microsoft dumped a lot of features during the beta. While I understand some of the reasons behind the removal, I would have like to have had separate date and time objects, as one example.

I also feel SQL Server Notification Services are a bit half-baked at this point in time. While much better than the version that shipped as an add-on to SQL Server 2000, they still feel a bit bolted on.

Overall, the main reason many shops will switch to SQL Server with the 2005 release comes down to ROI. With the extras out of the box, SQL Server is still a no brainer for small and medium enterprises. With this release the product is more applicable for larger enterprises, as well.

Help other customers find the most helpful reviews

Was this review helpful to you? Yes No

Report abuse | Permalink

Comment Comment

17 of 19 people found the following review helpful:

5.0 out of 5 stars Solid product - Great Price, January 29, 2006

By

Bill Giovinetti "Billg_sd" (San Diego, CA USA) - See all my reviews
(REAL NAME)

This review is from: Microsoft SQL Server Developer Edition 2005 [OLD VERSION] (CD-ROM)

The developer edition, to my surprise, included all of the features for me to develop enterprise level Business Intelligence projects and do some DB design work too. It integrates well with Visual Studio 2005.

When connected online, installation is easy...and it installs the prerequisites for you.

Help other customers find the most helpful reviews

Was this review helpful to you? Yes No

Report abuse | Permalink

Comment Comment

7 of 9 people found the following review helpful:

5.0 out of 5 stars Essentially the full version of Sql Server 2005 without the license to use it for business, May 30, 2007

By

Eric Rosko - See all my reviews

This review is from: Microsoft SQL Server Developer Edition 2005 [OLD VERSION] (CD-ROM)

If you're anyone who needs to back up a remote 2000/2005 sql svr database, this is the cheapest way to do it. While the free express edition management studio express is great, it doesn't have a built-in import/export feature that you get with the management tool in this dev edition. If you don't need the Tasks->Import/Export functionality, or features not found in the free sql svr express/managment studio express, then this product really won't help you.

The tool let's you import 2000 databases into sqlsvr2005 or express, but you can't export to 2000. The Sql Svr management tool is the perfect way to administer your sql svr express databases too.

Basically, the import->export feature is the reason to buy this.

Help other customers find the most helpful reviews

Was this review helpful to you? Yes No

Report abuse | Permalink

Comment Comment (1)

Share your thoughts with other customers: Create your own review

› See all 16 customer reviews...

Most Recent Customer Reviews

4.0 out of 5 stars Review of SQL Server 2005 Developer
Software Installed ok and was able to connect to a database ok. Overall product was ok.

Published 15 months ago by Mark Chan

5.0 out of 5 stars Great for developers!
I started developing database for version 2005 from version 2000. There aren't lots of changes but it was nice to be able to play with it and see all the new features in a local... Read more

Published on May 20, 2009 by Paul A. Hernandez

5.0 out of 5 stars Best Value
Excellent for developing purposes. Database system and analysis software in the same suite, best value for this price.