Microsoft SQL Server: Difference between revisions

Revision as of 19:42, 29 March 2025

Latest revision as of 22:25, 22 August 2025

(4 intermediate revisions by 3 users not shown)

Line 4:

{{Infobox software

| name = Microsoft SQL Server

| logo = MSSQLSMicrosoft SQL Server 2025 icon.svg

| logo size = 100px

| screenshot =

| caption =

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 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===