Monday, December 4, 2006
« Nikhil Kothari's Web Development Helper | Main | Sending Email in Office 2007 »

SQL Express

Many people don't realize the full potential of SQL Express. Yes, there are several limitations including the following:

BUT, I would say the list of supported items is much more impressive for a free, "lightweight" DB engine:

  • Stored Procedures, Triggers, and Views
  • T-SQL Enhancements (exception handing, recursive queries, and support for new data types, etc.)
  • SQL CLR
  • User-defined Types
  • Native XML
  • XQuery
  • Service Broker
  • Merge Replication (Subscriber only)
  • Transactional Replication (Subscriber only)
  • Report Server
  • Native Support for Web Services (For reporting services)

To see a complete comparison of the various SQL versions, take a look at Microsoft's SQL Server 2005 Features Comparison.

This is my first post from Word 2007… We'll see how it goes.

Monday, December 4, 2006 4:20:42 PM (Central Standard Time, UTC-06:00)
Express doesn't come with jobs (aka SQL Agent), but it DOES come with Service Broker. See this link (http://blogs.msdn.com/rogerwolterblog/archive/2006/04/13/575974.aspx) for a post about how to use Service Broker to mimic a job scheduler. Cool.
Monday, December 4, 2006 4:37:28 PM (Central Standard Time, UTC-06:00)
Very cool! Thanks for the info.
Wednesday, December 20, 2006 7:27:24 PM (Central Standard Time, UTC-06:00)
One of the disadvantages of Visual Studio Express 2005 is the fact that it does not come bundled with 64 bit compiler support. Now if you have a 64 bit server or workstation you'll likely want to compile your own 64 bit binaries. I figured out a way to do this using the Platform SDK. Check it out.
Name
E-mail
(will show your gravatar icon)
Home page

Comment (HTML not allowed)  

Enter the code shown (prevents robots):