SQL Server Express Edition database product is user-friendly and based on SQL Serever technology. Ease of wear can be seen starting from the setup program interface that guides the user in the installation process.
Tool-based GUI (Graphical User Interface) that present accompanying the SQL Server Express Edition in indeed very minimal, only SQL Server Configuration Manager and SQL Server Surface Area Configuration. However, we can download tool for managing instances of SQL Server Express Edition databace, that is, SQL Server Management Studio Express Edition (SSMS-EE), free of channel! The integration of very closely between SQL Server Express Edition with visual developing will also greatly assist us in developing database application.
SQL Server Express Edition uses the database engine and API for accessing the same data as the other versions of SQL Server. The difference, among others are:
1. There is no support for features that are required by the enterprise.
2. Only supports a single processor.
3. The memory for the buffer pool is limited to 1 GB.
4. The maximum size of the database is limited to 4 GB only.
Absence of Features such as high availability and enterprise business intelligence in SQL Server Express Edition is not a big problem, because the application developed on top of SQL Server Express Edition can work in a seamless in SQL Server Workgroup Edition, Standart Edition, and of course also in SQL Server Enterprise Edition.
Thus, the scalability of the database application that are developed useing SQL Server continues the tradition in presenting the product user-friendly database and are available to all walks of life, Microsoft SQL Server Express Edition present as the successor product of Microsoft SQL Server 2000 Desktop Engine (MSDE 2000). As the product is provided free of charge, what are the strenghts and weaknesses? Express Edition can be guaranteed and its implementation can be adapted to the needs of the moment.
SQL Server Express Edition is a product that is designed for application developers who are just a fad or a hobby making the application database, and can also be used by ISV (independent software vendor) as the initial application of the database platform that they sell to the public. The right to redistribute the SQL Server Express Edition can be obtained free of charge, simply through the registration process only.
Although available for free, SQL Server Express Edition offer many advanced features, because it is built using the same database engine as other SQL Server editions. Additional benefits it brings is that applications developed on top of SQL Server Express Edition can be easily upgraded skalabilitasnya, due to be moved to other SQL Server editions are seamless. Of course there are differences, one of which is the User Instance feature is only available in SQL Server Express Edition.
Security also gets enough attention, because the default installation of SQL Server Express Edition was "safe", with kill features connectivity initial installation time. The User Instance feature facilitates type regular users to connect a databace to a SQL Server Express Edition without the need to use administrator rights.
With a variety of new features that are more sophisticated than previous versions — MSDE 2000 SQL Server Edition, then it is worthy to serve as the initial database platform in developing database applications. Through the integration of very closely with Visual Studio (and of course the NET Framework 2.0), then we can easily develop a database application, SQL Server Express Edition as a database platform that is very exciting for all of us.
Download Here :
SQL Server 2012 Management Studio Express from