The circle of life – ** .Net – Training – MOSS **

  • Past Post

  • Vistor Locations

  • Advertisements

SQL Express: Great product

Posted by Clayton James on June 7, 2006

I have been using SQL Express for a clients project over the last few months, and I must say wow!

Microsoft have really improved on their previous free SQL product MSDE. For one, SQL Express at least has "SQL" in the name for clear identification.

  • Supports only one CPU.
  • 1 GB of memory
  • 4 GB of limit for database size – excluding log files. However, there is no restriction on number of databases that can be present on the server.
  • Unlike MSDE, SQL Server Express does not implement a ' (5) concurrent workload throttle' mechanism to limit its scalability under heavy load. Many people confused this with 5 concurrent connections which isn't the case
  • Unlike MSDE, this edition does not include SQL Agent, DTS, and replication publishing.
  • Does not support Windows 9x, Me, and NT.
  • SQL Server Agent service is not available
  • AND……. the best feature is that you now have a database management UI which is a consistent look and feel across all SQL 2005 editions.

New Features

Michael Otey has blogged about the new features here

Abstract from blog 

"As a part of the release of SQL Server 2005 Service Pack 1, we’re happy to announce the availability of a new package of SQL Server Express called Advanced Services.  Advanced Services includes SQL Server Reporting Services and Full Text Search, along with SQL Server Management Studio Express and SQL Server Express Toolkit (used to build reports).  SQL Server Express also continues to be available without the complementary features to keep a small download package for those who require it.  For a more in-depth comparison of the versions, check out the feature comparison page we’ve created to help with deciding which version of SQL Server Express is right for you."

How cool is this, Reporting Services, Full Text Search. This is a great product and I applaude Microsoft for providing this free of charge. My clients reports were all completed in Crystal so now I can move them across to reporting services.


One Response to “SQL Express: Great product”

  1. Great post.. thanks for sharing 😀

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: