Microsoft SQL Server: Difference between revisions

Revision as of 05:46, 15 February 2025

Latest revision as of 22:25, 22 August 2025

(10 intermediate revisions by 8 users not shown)

Line 3:

{{Use mdy dates|date=February 2023}}

{{Infobox software

| name = Microsoft SQL Server

| logo = Microsoft SQL Server 2025 = icon.svg

| 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" />

| operating system = [[Linux]], [[Microsoft Windows Server]], [[Microsoft Windows]]

| platform =

| language = English, Chinese, French, German, Italian, Japanese, Korean, Portuguese (Brazil), Russian, Spanish and Indonesian<ref name="Download Microsoft SQL Server 2008 R2" />

| genre = [[Relational database management system]]

| license = [[Proprietary software]]

| website = {{URL|https://www.microsoft.com/sql-server}}

}}

'''Microsoft SQL Server''' (Structured Query Language) 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 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 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===

Line 183:

SQL Server Reporting Services (SSRS) is a report generation environment for data gathered from SQL Server databases. It is administered via a web interface. Reporting services features a web services interface to support the development of custom reporting applications. Reports are created as [[Report Definition Language|RDL]] files.<ref name="SQL Server Reporting Services" />

Reports can be designed using recent versions of [[Microsoft Visual Studio]] (Visual Studio.NET 2003, 2005, and 2008)<ref name="Reporting Services" /> with [[Business Intelligence Development Studio]], installed or with the included [[Report Builder]]. Once created, RDL files can be rendered in a variety of formats,<ref name="Render Method" /><ref name="Device Information Settings" /> including Excel, [[PDF]], [[Comma-separated values|CSV]], [[XML]], [[BMP file format|BMP]], [[Windows Metafile|EMF]], [[GIF]], [[JPEG]], [[Portable Network Graphics|PNG]], and [[TIFF]],<ref name="Image Device Information Settings" /> and HTML Web Archive.

=== Notification Services ===

Line 230:

{{Main|Business Intelligence Development Studio}}

[[Business Intelligence Development Studio]] (BIDS) is the [[Integrated Development Environment|IDE]] from [[Microsoft]] used for developing data analysis and Business Intelligence solutions utilizing the Microsoft [[SQL Server Analysis Services]], [[SQL Server Reporting Services|Reporting Services]] and [[SQL Server Integration Services|Integration Services]]. It is based on the [[Microsoft Visual Studio]] development environment but is customized with the SQL Server services-specific extensions and project types, including tools, controls and projects for reports (using Reporting Services), [[OLAP cube|Cubes]] and [[data mining]] structures (using Analysis Services).<ref name="Business Intelligence Development Studio" /> For SQL Server 2012 and later, this IDE has been renamed SQL Server Data Tools (SSDT).

== See also ==