Microsoft SQL Server
≈ 4 min read
Names in other languages
No names in other languages are held for this entry yet.
Article bodies are English and are not machine-translated. A name in another language is not a translation of the article.
Microsoft SQL Server is a proprietary relational database management system developed by Microsoft using 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 applications—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 users.
Microsoft SQL Server is a proprietary relational database management system developed by Microsoft using 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 applications—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 users. ===Discontinued editions=== Microsoft Data Engine: Version 1.0 is based on SQL Server version 7.0. Afterwards, it was replaced by Microsoft SQL Server Data Engine. Microsoft SQL Server Data Engine: Also called Desktop Engine, Desktop Edition, it is based on SQL Server 20001. Included with some versions of Microsoft Access, Microsoft development tools, and other editions of SQL Server. Intended for use with those management and development tools, it did not include any other GUI. Later, Microsoft also made available a web admin tool. After SQL Server 2000, it was replaced by SQL Server 2005 Express Edition. Personal Edition: SQL Server 2000. Had workload or connection limits like MSDE, but no database size limit. Includes standard management tools. Intended for use as a mobile / disconnected proxy, licensed for use with SQL Server 2000 Standard edition. Similar to Standard Edition in SQL Server 2000, but Full-Text Search not working in Windows 98, transactional replication limited to subscriber. Datacenter: SQL Server 2008 R2 Datacenter is a full-featured edition of SQL Server and is designed for datacenters that need high levels of application support and scalability. It supports 256 logical processors and virtually unlimited memory and comes with StreamInsight Premium edition. The Datacenter edition has been retired in SQL Server 2012; all of its features are available in SQL Server 2012 Enterprise Edition. Windows CE Edition: Introduced in SQL Server 2000, and was replaced by SQL Server 2005 Mobile Edition. SQL Server 2005 Mobile Edition: Replaced by SQL Server 2005 Compact Edition after 1 release. SQL Server 2005 Compact Edition: Replaced by SQL Server Compact 3.5 after 1 release. ==Supplemental packages== Tools published by Microsoft include: SQL Server 2000: Samples: Northwind and pubs Sample Databases, Updated Samples for SQL Server 2000. Tools: Stress Testing and Performance Analysis tools (Read80Trace and OSTRESS), PSSDIAG Data Collection Utility, Notification services (up to service pack 1), Security Tools, Best Practices Analyzer 1.0, Reporting Services (up to Service Pack 2), Reporting Services Report Packs, SQL Server 2000 Driver for JDBC (up to service pack 3), SQLXML 3.0 (up to service pack 3). Documentation: SQL Server 2000 Books Online, SQL Server 2000 System Table Map, Resource Kit, SQL Server 2000 — Getting Started Guide.
Text derived from https://en.wikipedia.org/w/index.php?oldid=1378340086 under CC BY-SA 4.0; modifications have been made.