Note: This list may not be complete. No component, listed or unlisted, may be used outside of
the technology in which it is released. The usage decision for a component is found in the Decision
and Decision Constraints.
Master Data Services (MDS)
|
Master Data Services (MDS) is the SQL Server solution for master data management. Master data management (MDM) describes the efforts made by an organization to discover and define non-transactional lists of data, with the goal of compiling maintainable master lists. |
Microsoft Azure Structured Query Language (SQL) Server
|
Azure SQL Database is an always-up-to-date, fully managed relational database service built for the cloud. This site provides an overview of Microsoft Azure Structured Query Language (SQL) Server, the cloud implementation of Microsoft Structured Query Language (SQL) Server. |
Microsoft Connectors for Oracle and Teradata by Attunity
|
Developed by Attunity with Microsoft, these connectors use direct integration into internal SSIS buffering APIs, cutting through .NET and other layers. These connectors also use the high speed load/extract utilities offered by Oracle and Teradata. Microsoft provides versions of these connectors that support corresponding specific versions of SQL Server. These connectors may be used with all approved versions of SQL Server identified by this TRM entry. |
Microsoft Object Linking and Embedding, Database (OLE DB) Driver for SQL Server
|
OLE DB Driver for SQL Server was designed to provide a simplified method of gaining native data access to SQL Server using OLE DB. It provides a way to innovate and evolve new data access features without changing the current Windows Dynamic Access Control (DAC) components, which are now part of the Microsoft Windows platform. |
Microsoft Open Database Connectivity (ODBC) Driver for Structured Query Language (SQL) Server
|
ODBC is the primary native data access application programming interface (API) for applications written in C and C++ for SQL Server. |
Microsoft SQL Server T-SQL ScriptDom
|
ScriptDom being a full-fidelity parser, is great for statically analyzing Transact-SQL (T-SQL) code to proactively identify anti-patterns. |
Microsoft Structured Query Language (SQL) Server Data-Tier Application Framework
|
A data-tier application (DAC) is a logical database entity that defines all of the SQL Server objects - such as tables, views, and instance objects, including logins - associated with a user`s database. |
Microsoft Structured Query Language (SQL) Server Setup
|
SQL Server Setup includes a shared feature option for installing a standalone machine learning server that runs outside of SQL Server. It`s called Machine Learning Server (Standalone) and includes Python and R. |
Microsoft Structured Query Language (SQL) Server Volume Shadow Copy Service (VSS) Writer (an extension of Windows Server VSS)
|
The SQL Writer Service provides added functionality for backup and restore of SQL Server through the Volume Shadow Copy Service framework. Volume Shadow Copy Service is a part of the Windows Server Operating system and is approved as part of that TRM entry. The Microsoft SQL Server Writer Service is a component of SQL Server that allows SQL Server to utilize VSS. |
Structured Query Language (SQL) Server - Analysis Services (SSAS)
|
Microsoft SQL Server Analysis Services (SSAS) is an Online Analytical Processing, OLAP, data mining and reporting tool in Microsoft SQL Server. |
Structured Query Language (SQL) Server Browser
|
The SQL Server Browser program runs as a Windows service. SQL Server Browser listens for incoming requests for Microsoft SQL Server resources and provide information about SQL Server instances installed on the computer. |
Structured Query Language (SQL) Server Data Quality Services (DQS)
|
SQL Server Data Quality Services (DQS) is a knowledge-driven data quality component for data cleansing that consists of the Data Quality Server and the Data Quality Client. |
Structured Query Language (SQL) Server Enterprise Manager
|
SQL Server Enterprise Manager is the primary administrative tool for Microsoft SQL Server 2000 and provides a Microsoft Management Console (MMC) compliant user interface. This component became SQL Server Management Studio (SSMS) in later releases. |
Structured Query Language (SQL) Server Integration Services (SSIS)
|
SQL Server Integration Services (SSIS) enables you to utilize extract, transform and load (ETL) data from any data source type without the need for direct coding. |
Structured Query Language (SQL) Server Management Studio (SSMS)
|
SQL Server Management Studio (SSMS) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server.
Note: Beginning with MS SQL Server 2016 SQL Server Management Studio (SSMS) will no longer be a component of the SQL Server database engine. SSMS will be an independent software requiring its own install. SSMS is only a component of MS SQL Server 2014 and earlier. A new TRM entry has been created for SSMS, please reference this entry for the latest versions and features of SSMS. |
Structured Query Language (SQL) Server Native Client
|
SQL Server Native Client, also known as SQL Server Native Client (SNAC), refers to the Open Database Connectivity (ODBC) and Object Linking and Embedding, Database (OLE DB) drivers for SQL Server, prior to SQL Server 2022 (16.x). |
Structured Query Language (SQL) Server Reporting Services (SSRS)
|
SQL Server Reporting Services (SSRS) is a server-based report generation software system that is included in most versions SQL Server. Report Builder is a component of the SQL Server Reporting Services (SSRS); however, Report Builder does have its own TRM entry because Report Builder can be installed as stand-alone software. |
Transact-SQL (T-SQL) reference (Database Engine)
|
T-SQL is central to using Microsoft Structured Query Language (SQL) products and services. All tools and applications that communicate with a SQL Server database do so by sending T-SQL commands. |
Visual Studio 2010 Shell is installed with Structured Query Language (SQL) Server 2014 and 2012
|
When you install SQL Server 2014 or SQL Server 2012, you find that SSMS requires Visual Studio 2010 Shell (Isolated) and SSDT requires Visual Studio 2010 Shell (Integrated). SQL Server Management Studio (SSMS) ships with SQL Server Database Engine in those versions.
According to Microsoft lifecycle policy of Visual Studio 2010, the support ended on July 14, 2020. However, if Visual Studio 2010 Shell (Isolated) or Shell (Integrated) is installed with SQL Server 2014 or SQL Server 2012, Visual Studio 2010 Shell will be supported until the end of support for SQL Server 2014 (July 09, 2024) or for SQL Server 2012 (July 12, 2022). |