Ramblings of a DBA

Tara Kizer
posts - 166, comments - 837, trackbacks - 75

My Links

Advertisement

News

Subscribe
Search this Blog

Archives

Post Categories

Work

Top 10 Cool Things about SQL Server 2005 Express Edition

You've probably already heard by now about SQL Server 2005 Express Edition.  It's the next evolution of MSDE 2000. 

Here's the Top 10 Cool Things about SQL Server 2005 Express Edition:

  1. Integrated common language runtime (CLR) support. Stored procedures and functions can be written using your favorite programming language.
  2. Native XML support.
  3. XCopy support for moving databases from one location to another.
  4. Robust and reliable installation using either graphical user interface (GUI) or silent modes.
  5. Automated servicing and patching.
  6. Deep integration with Visual Studio to provide access to rich data controls like the DataGridView, DataNavigator, and DataConnector.
  7. Support for databases up to 4GB.
  8. Support for disconnected systems with SQL Server Service Broker and Replication.
  9. SQL Server Express Manager, a new, easy-to-use database management and query analysis tool (available August 2004).
  10. Easier deployment via Visual Studio ClickOnce (available in Beta 3).

I was going to wait to start looking at SQL Server 2005 when it becomes available for download in the next few weeks for the MSDN subscribers, but I'll probably install Express Edition tomorrow.  It allows you to easily upgrade to the other editions anyway.

Print | posted on Tuesday, June 29, 2004 3:06 PM | Filed Under [ SQL Server - General ]

Feedback

Gravatar

# re: Top 10 Cool Things about SQL Server 2005 Express Edition

Some of the best parts are missing the ETL/DTS improvements which looked great in Beta1 and the BI Workbench, Reporting Services.

However, for free it's pretty powerfull.
6/29/2004 8:55 PM | Valter Borges
Gravatar

# re: Top 10 Cool Things about SQL Server 2005 Express Edition

keep in mind this is still a beta
6/29/2004 10:26 PM | eyechart
Gravatar

# re: Top 10 Cool Things about SQL Server 2005 Express Edition

For free it's already much better the MSDE. Woo Hoo. Has anyone downloaded the Beta for Visual Studio or any of the kewl VS Express Betas?
6/30/2004 5:56 AM | Derrick Leggett
Gravatar

# re: Top 10 Cool Things about SQL Server 2005 Express Edition

What does "Native XML support" mean. Sounds a bit iffy to me.
7/8/2004 5:54 AM | Magnus
Gravatar

# re: Top 10 Cool Things about SQL Server 2005 Express Edition

NAtive XML support means there is an XML datatype.
7/27/2004 6:58 PM | Euan Garden
Gravatar

# re: Top 10 Cool Things about SQL Server 2005 Express Edition

I'm really missing replication in this one. :(
7/28/2004 1:28 PM | Alen
Gravatar

# re: Top 10 Cool Things about SQL Server 2005 Express Edition

Is there no replication?
4/24/2006 1:15 PM | Andrew
Gravatar

# re: Top 10 Cool Things about SQL Server 2005 Express Edition

SQL 2005 Express can only be a subscriber.

Subscriber is the server or database that receives data from another server or database.
5/10/2006 8:24 PM | Larb
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET