The basics about Microsoft SQL Server 2014

Microsoft SQL Server 2014 is a DBMS for Windows platforms. It is used to build, deploy, and manage locally hosted or cloud-based applications.

Features of SQL Server 2014

The latest version of SQL Server 2014 has the following benefits :

The new in-memory capabilities for online transaction processing (OLTP) built into SQL Server accelerate online transaction performance by up to 30 times.

An improved and updatable in-memory column base enhances the benefits of compression. In use, query performance is up to 100 times faster, and data compression gains up to 90 percent. Such storage savings, coupled with query acceleration, can handle much larger data volumes.

New hybrid capabilities include simplified backup to Azure and the ability to configure an Azure Always virtual machine as a secondary replica always available. A disaster recovery configuration is achieved at a lower cost that allows for quick recovery.

Azure’s new in-memory OLTP technology enables the use of the parallel processing architecture in transaction processing to improve VM consistency, performance, and scalability.

In addition to the core database engine, depending on the database edition, SQL Server 2014 provides integration, analysis, reporting, master data, and data quality services. Other components of SQL Server 2014 include StreamInsight, which supports streaming, and management and development tools.

Versions of SQL Server 2014

The relational DBMS of SQL Server 2014 is offered in three main editions. Enterprise, Business Intelligence and Standard.

The Enterprise version is for mission-critical applications and data warehouses.

The Business Intelligence version corresponds to the global functions of the company and the self-service decision-making . The maximum memory per instance of SQL Server is limited to 128 GB.

Finally, the Standard Edition is for pure database, reporting and analytics functionality. The computing capabilities are limited to one socket or four cores, the lesser of the two; the maximum memory usage is 64 GB per instance of Analysis Services and Reporting Services .

Other editions are available, including a Developer Edition for application programming purposes (in contrast to production use) and a Web Edition that supports Internet applications.

The free edition Express is mostly a basic test version designed to become familiar with SQL Server. The Express Edition uses the same database engine and is compatible with major editions of SQL Server, but its database is restricted to a maximum of 10 GB.

The relational DBMS of Microsoft SQL Server 2014 runs exclusively on Windows and supports many versions of this operating system.

Microsoft SQL Server 2014 Licenses for Windows

SQL Server 2014 software licenses are available from:

online resellers who offer Full Packaged Product full licenses of SQL Server software;
OEMs who offer pre-installed licenses on their hardware;

licensing partners and enterprise software consultants who offer Microsoft volume licensing programs to enterprise customers.

Two major SQL Server 2014 licensing options exist:

server + CAL that allows customers to obtain licenses for users or devices at a lower cost, which adds to the SQL Server deployment as needed;

by heart that provides a more accurate and consistent measure of computing power, regardless of whether SQL Server is deployed on physical, on-premises, virtual, or cloud servers.

You must contact Microsoft for the applicable rates .

The full, free trial version of SQL Server 2014 is available for 180 days. Microsoft offers Premier Mission Critical Support for SQL Server 2014 that depends on the specific needs and usage of the enterprise.

Supported data types

In addition to the standard numeric, character, and date / time data types supported by all relational DBMSs , Microsoft SQL Server 2014 supports variable binary data types, XML, and money, as well as user-defined types. .

Evaluation of performances

SQL Server leads in the TPC-E and TPC-H benchmarking assessments conducted by the Transaction Processing Performance Council (TPC). Microsoft publishes this detailed information about the performance evaluations of its database.

Leave a Reply

Your email address will not be published. Required fields are marked *