Everything about Microsoft SQL Server
Family of database software by Microsoft
Microsoft SQL Server is a proprietary relational database management system developed by Microsoft using Structured Query Language. 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. 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. Wikipedia →
🧭 Start here: a 6-step reading path
- Read the overview: Microsoft SQL ServerA 5-minute orientation
- Skim a recent paper: Evaluating the Practical Effectiveness of LLM-Driven Index Tuning on Microsoft SQL ServerInfluential work since 2022
- Pick up a classic book: MCSEThe most-reprinted book on the subject
- Read the landmark paper: Geospatial stream query processing using Microsoft SQL Server StreamInsightCited 47 times
- Go sideways: Adaptive Server EnterpriseA closely related topic
- Go sideways: History of Microsoft SQL ServerA closely related topic
📖 Definitions
No dictionary entry for this exact phrase.
🗂️ The subject at a glance
🏆 Landmark papers (most cited)
Geospatial stream query processing using Microsoft SQL Server StreamInsight
Fast foreign-key detection in Microsoft SQL server PowerPivot for Excel
Analyzing the Impact of Cardinality Estimation on Execution Plans in Microsoft SQL Server
Materialized view and index selection tool for Microsoft SQL server 2000
International AC: An Education Case on Continuous Monitoring SQL Server Data with ODBC-Linked Tables in Microsoft Access
Microsoft index turning wizard for SQL Server 7.0
Indexes in Microsoft SQL Server
Implementation of Microsoft SQL Server using ‘AlwaysOn’ for High Availability and Disaster Recovery without Shared Storage
🆕 Influential since 2022
Evaluating the Practical Effectiveness of LLM-Driven Index Tuning on Microsoft SQL Server
Verified LLM-Based Query Rewriting for Microsoft SQL Server
STRATEGIC CONSIDERATIONS FOR DATABASE SYSTEMS: POSTGRESQL VS. MICROSOFT SQL SERVER
ORGANIZING ACCESS TO DATA IN SCADA SYSTEMS USING MICROSOFT SQL SERVER
PERANCANGAN BASIS DATA HELPDESK SYSTEM PT XYZ MENGGUNAKAN MICROSOFT SQL SERVER 2019
📚 Books worth reading
MCSELance Mortensen, Rick Sawtell · 1997
The Definitive Guide to DAXMarco Russo, Alberto Ferrari · 2015
MCSE exam notesRick Sawtell · 1998
Data Mining with SQL Server 2005Jamie MacLennan · 2005
Mastering SQL server 2000Mike Gunderloy, Joseph L. Jorden · 2000
SQL Server 2005 DBA Street SmartsJoseph L. Jorden · 2006
SQL server 2008 administrationTom Carpenter · 2010
Professional SQL server 2005 CLR programmingDerek Comingore · 2006
Ranked by number of editions on Open Library, a rough measure of how lasting a book is.
🔗 Related topics
- Adaptive Server Enterprise SAP ASE (Adaptive Server Enterprise), originally known as Sybase SQL Server, and also commonly known as Sybase DB or Sybase ASE, is a relational model…
- History of Microsoft SQL Server The history of Microsoft SQL Server begins with the first Microsoft SQL Server database product – SQL Server v1.0, a 16-bit relational database for the…
- SQL Anywhere SAP SQL Anywhere is a proprietary relational database management system (RDBMS) product from SAP. SQL Anywhere was known as Sybase SQL Anywhere prior to…
- SAP IQ SAP IQ (formerly known as SAP Sybase IQ or Sybase IQ; IQ for Intelligent Query) is a column-based, petabyte scale, relational database software system…
- Embedded database An embedded database system is a database management system (DBMS) that is tightly integrated with application software, and is embedded within the application…
- Oracle NoSQL Database Oracle NoSQL Database is a NoSQL-type distributed key-value database from Oracle Corporation. It provides transactional semantics for data manipulation…
- SQL Server Compact Microsoft SQL Server Compact (SQL CE) is a discontinued relational database produced by Microsoft for applications that run on mobile devices and desktops…
- Ingres (database) Ingres Database (/ɪŋˈɡrɛs/ ing-GRESS) is a proprietary SQL relational database management system intended to support large commercial and government application…