Technology Tips -

Saturday, April 30, 2011

If you are working with internet facing website and trying to find out which is best available database you should  use for your site, basically Microsoft has also launched another version of SQL Server for small and medium size business for those people who has limited budget and want to do much more on internet, so Microsoft SQL Server Web edition may be the best venue for them.
Take a look at full featured offered by Microsoft with Web SQL Server  or you could say Microsoft SQL Server 2008 Web Edition:
  • ·         Web SQL Server Edition support 4 cpu’s with web workload only.
  • ·         Web SQL Server Edition utilize OS memory.
  • ·         Database size supports 524 PB.
  • ·         32 bit /64 bits hardware support
  • ·         High availability is partial
  • ·         Log shipping is a mechanism that automatically sends transaction backup from a primary database on a primary server instance to another database on separate server – this functionality is supported in Web SQL Server R2.
  • ·         Fail-over clustering is not supported in SSR2W.
  • ·         Automatic page repair during a database mirroring is not supported.
  • ·         Change tracking feature is available in SQL WEB edition as it’s available in sql standard, workgroup and enterprise edition.
  • ·         C2 audit option for tracking failed and access attempt to object is available
  • ·         Hypervisor support, Database migration tool, policy based management, sql server management studio tools are available in web edition as they are available in enterprise, standard and workgroup version.
  • ·         Reporting service manager and reporting designer is available in this edition.
  • ·         Basic data profiling, export report to pdf, word format and images features are available.
  • ·         Pro-grammatically you can do anything you want – so please read Microsoft Manual and SDK for that. 

SQL Server 2008 Web Edition:

Sql server 2008 web edition is designed for small business because of cost and actually this is far cheaper than standard edition where you have to pay more amount and feature is far better than express edition- so people and small business finding ways to reduce cost of database driven website can use sql server for web and design website that would be database drive.
There is no size limit of database where you would have this limit in express edition.

Please let us know you if there is any other feature which is missing.