HomeProgramSQL Server

MS SQL Server versions

SQL Server currently has many different versions. Below is a list of versions with features of each version.

  1. Enterprise - the most advanced version with full functionality.
  2. Standard - less features than Enterprise, use when you don't need to use advanced features.
    Workgroup - suitable for large companies with many remote offices.
  3. Web - designed specifically for web applications.
  4. Developer - similar to Enterprise but only grant a single user to develop, test, demo. You can easily upgrade to the Enterprise edition without reinstalling.

  5. Express - this version is only used at a simple level, up to 1 CPU and 1GB of memory, the maximum size of the database is 10GB.
  6. Compact - free embedded into web application development environments. The maximum size of the database is 4GB.
  7. Datacenter - big change on SQL Server 2008 R2 is the Datacenter Edition version. No memory limit and support for more than 25 installations.
  8. Business Intelligence - Business Intelligence Edition was just introduced on SQL Server 2012. This version has the features of the Standard version and supports some advanced features of BI like Power View and PowerPivot but does not support advanced features. about availability as AlwaysOn Availability Groups .
  9. Enterprise Evaluation - The SQL Server Evaluation Edition is a great choice to use all features and get a free installation of SQL Server for learning and development. This version has an expiration time of 6 months from the date of installation.

Previous article: What is MS SQL Server?

Next lesson: Instructions on how to install MS SQL Server

5 ★ | 1 Vote
SQL Serverlearn SQL Servermssql

You should read it

May be interested

  • Network basics: Part 3 - DNS ServerNetwork basics: Part 3 - DNS Server
    a dns server is a server that contains a database of public ip addresses and hostnames associated with them. in most cases, the dns server is used to resolve or translate those common names into ip addresses as required.
  • New points in SQL 2008 (Part 1)New points in SQL 2008 (Part 1)
    sql server 2008 will be released around february 2008, along with new versions of visual studio and windows. ctp (community technology preview) of sql 2008 is now available on the internet and you can download it from the microsoft url. in this article we will highlight some of the new features and benefits of sql server 2008
  • Capture execution diagrams with SQL Server 2005 ProfilerCapture execution diagrams with SQL Server 2005 Profiler
    executable diagrams are one of the best tools for diagnosing query errors in order to adjust the execution of queries on sql server. in previous versions of sql server 2005, the only option for query performance was text diagrams or graph execution diagrams for manual queries. on sql server 2005, you can capture execution plans in two ways
  • Microsoft reminds users that Windows Server 20H2 is about to be discontinuedMicrosoft reminds users that Windows Server 20H2 is about to be discontinued
    in fact, microsoft has planned to stop rolling out new security updates for all versions of windows server, including version 20h2, on august 9, 2022.
  • How to set up your own Git server on LinuxHow to set up your own Git server on Linux
    while you can count on globally renowned git hosting services like github, in some cases it is better to host a personal git server for enhanced privacy, customizability, and security.
  • Backup for Exchange Server with DPM 2007 (Part 1)Backup for Exchange Server with DPM 2007 (Part 1)
    although we can still use earlier versions of dpm (dpm 2006) to back up exchange server, it does include a two-step method. with the new version, dpm 2007 is used to support online exchange backup, so you won't need to
  • Use IIS to set up FTP Server on WindowsUse IIS to set up FTP Server on Windows
    set up an ftp server (file transfer protocol server) to share and convert large files with unlimited traffic.
  • How to change DNS server on the most popular routersHow to change DNS server on the most popular routers
    changing the dns server settings on your router is not difficult, but every manufacturer uses their own custom interface, which means the process can be very different depending on which router you are owned.
  • Install Role, configure role on Windows Server 2012Install Role, configure role on Windows Server 2012
    like previous versions, windows server 2012 has many associated roles. roles and features are tools you need to install or enable to complete your it administration tasks, if you don't install them, you can't do anything. in this article, we will learn how to install and configure the most important roles.
  • ClearOS - Linux server web interfaceClearOS - Linux server web interface
    currently, clearos is the linux server operating system that is of particular interest to the community. compared to other linux server versions, clearos gives users many unexpected advantages

SQL Server