Most Helpful Customer Reviews
|
|
45 of 50 people found the following review helpful:
4.0 out of 5 stars
The easiest gets better, November 14, 2005
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.
|
|
|
17 of 19 people found the following review helpful:
5.0 out of 5 stars
Solid product - Great Price, January 29, 2006
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.
|
|
|
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
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.
|
|
|
Most Recent Customer Reviews
|
