# SQL Server

**Microsoft SQL Server** is a relational database management system developed by Microsoft.

It is designed to store and retrieve data as requested by other software applications.\
The core features of SQL Server include:

* Data storage and retrieval: SQL Server provides a secure and scalable platform to store a large amount of structured and semi-structured data efficiently.
* Data querying and manipulation: It offers advanced querying capabilities, such as the ability to write complex queries using SQL language, join tables, create views, and retrieve data based on specific criteria.
* Business intelligence and analytics: SQL Server provides tools and services for data analysis, reporting, and visualization, allowing users to gain insights from the stored data to make data-driven decisions.
* Data security and integrity: It offers robust security features, like authentication, access control, and encryption, to protect sensitive data from unauthorized access or modifications.
* High availability and scalability: SQL Server supports features like clustering, failover, and replication to ensure continuous availability of data and support for growing demands by scaling up or out the database infrastructure.

## Platform as a Service

SQL Server is deployed on site in cegedim.cloud data centers.

The same level of service as the Compute offer is guaranteed: instance deployment, operational maintenance, flexibility, security and monitoring are all handled by our experts.

SQL Server 2016, 2017, 2019 and 2022 are available in self-service via our ITCare cloud management platform.

Two editions are supported: Standard and Enterprise.

Two topologies are available:

* Stand-alone instance
* Always On cluster

The **Always On** cluster topology is production-ready but is only available on demand. Only SQL Server 2022 Enterprise edition is available for self-service provisioning.

Sizing can be configured to suit your needs.

<table><thead><tr><th></th><th width="209.33333333333331">Stand-alone instance</th><th>Always On cluster</th></tr></thead><tbody><tr><td>Instances</td><td>1</td><td>3</td></tr><tr><td>CPU (per instance)</td><td>2 - 16 vCPU</td><td>2 - 16 vCPU</td></tr><tr><td>RAM (per instance)</td><td>8 - 384 GB</td><td>8 - 384 GB</td></tr><tr><td>Supported Version(s)</td><td><ul><li>2016</li><li>2017</li><li>2019</li><li>2022</li></ul></td><td><ul><li>2016</li><li>2017</li><li>2019</li><li>2022</li></ul></td></tr><tr><td>Backup</td><td><span data-gb-custom-inline data-tag="emoji" data-code="2705">✅</span> Option</td><td><span data-gb-custom-inline data-tag="emoji" data-code="2705">✅</span> Option</td></tr><tr><td>Monitoring</td><td><span data-gb-custom-inline data-tag="emoji" data-code="2705">✅</span> Option</td><td><span data-gb-custom-inline data-tag="emoji" data-code="2705">✅</span> Option</td></tr><tr><td>24/7 Monitoring</td><td><span data-gb-custom-inline data-tag="emoji" data-code="2705">✅</span> Option</td><td><span data-gb-custom-inline data-tag="emoji" data-code="2705">✅</span> Option</td></tr><tr><td>Replication (DRP)</td><td><span data-gb-custom-inline data-tag="emoji" data-code="2705">✅</span> Option</td><td><span data-gb-custom-inline data-tag="emoji" data-code="2705">✅</span> Option</td></tr><tr><td>Availability</td><td>99.8%</td><td>99.9%</td></tr><tr><td>Multi-AZ deployment</td><td><span data-gb-custom-inline data-tag="emoji" data-code="274c">❌</span></td><td><span data-gb-custom-inline data-tag="emoji" data-code="2705">✅</span></td></tr><tr><td>Self-service</td><td><span data-gb-custom-inline data-tag="emoji" data-code="2705">✅</span></td><td><span data-gb-custom-inline data-tag="emoji" data-code="274c">❌</span></td></tr></tbody></table>

For more information, please read [sql-server-features](https://academy.cegedim.cloud/databases/sql-server/sql-server-features "mention").