Microsoft SQL Server: Difference between revisions

Revision as of 12:20, 8 March 2025

Latest revision as of 22:25, 22 August 2025

(6 intermediate revisions by 5 users not shown)

Line 4:

{{Infobox software

| name = Microsoft SQL Server

| logo = MSSQLSMicrosoft SQL Server 2025 icon.svg

| logo size = 100px

| screenshot =

| caption =

| developer = [[Microsoft]]

| released = {{Start date and years ago|1989|4|24}}, as SQL Server 1.0

| latest release version = {{Microsoft SQL Server version}} (CU16CU18 16.0.41654185.43)<ref>[https://learn.microsoft.com/en-us/troubleshoot/sql/releases/download-and-install-latest-updates Latest updates and version history for SQL Server]</ref>

| latest release date = {{Microsoft SQL Server version|releasedate}}

| programming language = [[C (programming language)|C]], [[C++]]<ref name="Lextrait" />

Line 21 ⟶ 20:

}}

'''Microsoft SQL Server''' (Structured Query Language) (often pronounced "sequel") is a proprietary [[relational database management system]] developed by [[Microsoft]] using [[SQL|Structured Query Language]] (SQL, often pronounced "sequel"). As a [[database server]], it is a [[software product]] with the primary function of storing and retrieving data as requested by other [[software application]]s—which may run either on the same computer or on another computer across a network (including the Internet). Microsoft markets at least a dozen different editions of Microsoft SQL Server, aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many [[concurrent user]]s.

== History ==

Line 44 ⟶ 43:

=== Currently ===

{{As of|2025|01}}, the following versions are supported by Microsoft: <ref name="SQL Server End of Support Options">{{cite web |date=Jan 2, 2025 |title= SQL Server end of support options|url=https://learn.microsoft.com/en-us/sql/sql-server/end-of-support/sql-server-end-of-support-overview?view=sql-server-ver16 |access-date=Jan 18, 2025 |website=learn.microsoft.com |publisher=learn.microsoft.com |language=en-US}}</ref>

* SQL Server 2016

* SQL Server 2017

Line 77 ⟶ 76:

; LocalDB: Introduced in SQL Server Express 2012, LocalDB is a minimal, on-demand, version of SQL Server that is designed for application developers.<ref name="LocalDB" /> It can also be used as an embedded database.<ref name="localdbblog" />

;Analytics Platform System (APS): Formerly Parallel Data Warehouse (PDW) A [[massively parallel|massively parallel processing]] (MPP) SQL Server appliance optimized for large-scale [[data warehouse|data warehousing]] such as hundreds of terabytes.<ref name="Analytics Platform System" />

;Datawarehouse Appliance Edition: Pre-installed and configured as part of an appliance in partnership with Dell & HP base on the Fast Track architecture. This edition does not include SQL Server Integration Services, Analysis Services, or Reporting Services. SQLCMD

===Discontinued editions===