SQL Server 2012 Express: Setup Database Mail (sp_send_dbmail)

Guys good news!
SQL Server 2012 Express still supports Database Mail (DB Mail), but it’s well hidden 🙂

The fully licensed editions of SQL Server 2012 do have an easy setup wizard, but (like in SQL Server 2008) the needed components (service, tables and stored procedures) are still present in the Express-edition!

The tables are programmatically set to ‘hidden‘, because I can still query them by using:

select * from msdb.dbo.sysmail_account

The Stored Procedures (SP’s) are visible though:

How to get things working?
Follow the steps in the blogpost (was originally documented for SQL Server 2005, but still applies to the 2012 Editions of SQL Server).

You may skip step 7:
Click here!





SQL Server 2012 Edition Comparison (features and limitations)

I’ve noticed that I’m searching quite a lot for the SQL Server 2012 comparison between editions (features and limitations).
This time, I’m going to save it by posting it here! 🙂

Bookmark this URL:
Features Supported by the Editions of SQL Server 2012


More info on SQL Server 2012 Licensing and FAQ’s:
SQL Server 2012 Licensing Datasheet and FAQ’s (*.docx)



Join us at LinkedIn!
Don’t forget to join the SQL Server 2014 group on LinkedIn and stay updated!:
linkedin-sql-server-2014-group








SQL Server 2008R2: Edition comparison & Pricing

In addition to my previous post about the SQL Server 2008 editions, here’s another comparison sheet for the 2008 R2 Editions:
Features Supported by the Editions of SQL Server 2008 R2

Many of the differences were kept intact, except for the addition of the Datacenter Edition.
If you want to use the new PowerPivot features, you’ll be forced to buy the Enterprise Edition though.

SQL Server 2008 R2 Pricing
For more information about pricing and licensing, check the SQL Server 2008 R2 Licensing Quick Reference Guide.

Don’t forget: The 2008R2 Express with Advanced Services Edition (free) comes with Reporting Services:





SQL Server 2008: Standard vs Enterprise detailed feature comparison

Before choosing the right edition, you may want to know that there are many versions:

– Enterprise Edition
– Standard Edition
– Workgroup Edition
– Web Edition
– Compact Edition
– Express Edition
– SQL Server 2008 Express Edition.
– SQL Server 2008 Express with Tools.
– SQL Server 2008 Express with Advanced Tools

Standard vs Enterprise: Microsoft published a simple comparison sheet here and a detailed comparison here (PDF).
A full comparison sheet for Compact vs Express is available over here.

Basicly it comes down to a few mind breaking features.
The Enterprise Edition offers extra/extensive features like:
– To work with large amount of data (terabyte-style or billion-row fact-tables)
– More BI features available (such as parallel processing, cube partitioning, and text mining)
– Less downtown (by using online indexing, fast recovery, etc.)
– Replicate data from Oracle (if you want to)

But….the Standard Edition is significantly less expensive than the Enterprise Edition.