Microsoft SQL Server Express Editions Benefits

Old 2 Comments on Microsoft SQL Server Express Editions Benefits 538

The Enterprise level SQL Server edition has more features and possibilities than technologist would ever implement unless he or she is working with an enterprise level organization, i.e., Microsoft may be the only organization using them all.(Just kidding… Well, who else uses every single feature offered?) This is where the SQL Server Express Editions provide a significant alternative. The SQL Server Express Editions Microsoft provides are limited to:

  • 1 processor socket (4 cores)
  • 1 GB of memory per database instance
  • 10 GB Maximum relation Database size

 

DatabaseThere are additional limitations that we will not mention here, due to the reason you can gauge from the 3 items already noted, whether Microsoft’s SQL Express will fill the need with smaller scale usage for server and web applications.

1. It is great for your Windows lab environment

2. You should be able to choose all default settings during the install.

3. The bare minimum; yet, powerful features of SQL, will provide what you normally need without the learning curve confusion. You can constantly build upon your knowledge of why and when additional features are needed after you get the fundamentals down.

SQL Express Server can be upgraded to other featured pack versions like standard and enterprise.

SQL Express Server is free.

Even though Microsoft presently has a SQL 2014 Server express edition available for download, often technologist will use a few versions behind; IMHO and others, it is a good practice to allow time for the bugs to be found in newer versions of software before production use, hence I’ve provided a link to

Microsoft SQL Server 2012 Express

http://www.microsoft.com/en-us/download/details.aspx?id=29062

Grab the most commonly used components. Install in the A , B order.

A) SQL Server 2012 Express

B) SQL Server Management Studio 2012 Express

Hope this helps you with your setup know-how of SQL. Note the differences between Microsoft’s SQL Server & MYSQL. As you develop small to medium size applications it is good to be familiar with both. At the very least, you can test and decide if you will upgrade to a higher version of Microsoft’s SQL in the future. But for today, you can get basic experience with minimum to free costs.

Author

James Lynch

POCBOOKS.COM “If something you read changes your life, it becomes your reality.” The author of the Product of Culture Trilogy James is also an Information Technology Professional and Consultant "Whether a person is aware of it or not, like technology, everything has an answer. You can't be afraid to ask questions, You just may receive what you have been looking for!"

Related Articles

2 Comments

  1. Katy Pillman July 19, 2014 at 1:26 pm

    Question: Can you connect to these from open-world? Not localhost?

  2. James Lynch July 19, 2014 at 1:34 pm

    Hi Katy, Even though I have not configured for remote access, all it would require is port forwarding through a firewall or router.

Leave a comment

Back to Top