Logo
Unionpedia
Communication
Get it on Google Play
New! Download Unionpedia on your Android™ device!
Download
Faster access than browser!
 

Microsoft SQL Server

Index Microsoft SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft. [1]

145 relations: Access control, ActiveX Data Objects, Adaptive Server Enterprise, ADO.NET, Application programming interface, Application software, Ashton-Tate, Assembly (CLI), Asynchronous I/O, B-tree, Binary large object, BMP file format, Business intelligence, Business Intelligence Development Studio, C (programming language), C Sharp (programming language), C++, Checksum, Cloud computing, Comma-separated values, Common Language Runtime, Comparison of data modeling tools, Comparison of object-relational database management systems, Comparison of relational database management systems, Computer cluster, Computer data storage, Concurrency control, Concurrent computing, Concurrent user, Data buffer, Data integration, Data mining, Data Mining Extensions, Data warehouse, Database, Database index, Database schema, Database server, Database trigger, Deadlock, Debug code, Decision tree learning, Declarative programming, Docker (software), Encryption, Extract, transform, load, GIF, Git, Graphical user interface, Heap (data structure), ..., IFilter, Import and export of data, Input/output, Integrated development environment, Intelligent code completion, Internet protocol suite, Inverted index, Join (SQL), JPEG, Library (computing), Linux, List of CLI languages, List of relational database management systems, Managed code, Massively parallel, Message queue, Microsoft, Microsoft Access, Microsoft Analysis Services, Microsoft Azure, Microsoft Azure SQL Database, Microsoft Press, Microsoft Visual Studio, Microsoft Windows, Microsoft Word, MSDE, MultiDimensional eXpressions, Multiversion concurrency control, Mutual exclusion, Naive Bayes classifier, Named pipe, Neural network, Object composition, OLAP cube, OLE DB, Online analytical processing, Open Database Connectivity, Optimistic concurrency control, OS/2, PDF, Petabyte, Platform as a service, Portable Network Graphics, Primitive data type, Proprietary software, Query optimization, Query plan, Red Hat Enterprise Linux, Regression analysis, Relational database, Relational database management system, Report Definition Language, Revoscalepy, RevoScaleR, Rounding, Scripting language, Select (SQL), Shared memory, Software, SQL, SQL CLR, SQL compliance, SQL Server Compact, SQL Server Express, SQL Server Integration Services, SQL Server Management Studio, SQL Server Reporting Services, Standard Libraries (CLI), Stored procedure, SUSE Linux Enterprise, Sybase, Tabular Data Stream, Terabyte, Thesaurus, TIFF, Total cost of ownership, Transact-SQL, Type safety, Type system, Ubuntu (operating system), User interface, View (SQL), Visual Basic .NET, Web service, Windows Internal Database, Windows Metafile, Windows NT, Windows Server, Windows service, Workflow, World Wide Web, XML, XML for Analysis, XQuery, .NET Framework. Expand index (95 more) »

Access control

In the fields of physical security and information security, access control (AC) is the selective restriction of access to a place or other resource.

New!!: Microsoft SQL Server and Access control · See more »

ActiveX Data Objects

In computing, Microsoft's ActiveX Data Objects (ADO) comprises a set of Component Object Model (COM) objects for accessing data sources.

New!!: Microsoft SQL Server and ActiveX Data Objects · See more »

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 database server product for businesses developed by Sybase Corporation which became part of SAP AG.

New!!: Microsoft SQL Server and Adaptive Server Enterprise · See more »

ADO.NET

ADO.NET is a data access technology from the Microsoft.NET Framework that provides communication between relational and non-relational systems through a common set of components.

New!!: Microsoft SQL Server and ADO.NET · See more »

Application programming interface

In computer programming, an application programming interface (API) is a set of subroutine definitions, protocols, and tools for building software.

New!!: Microsoft SQL Server and Application programming interface · See more »

Application software

An application software (app or application for short) is a computer software designed to perform a group of coordinated functions, tasks, or activities for the benefit of the user.

New!!: Microsoft SQL Server and Application software · See more »

Ashton-Tate

Ashton-Tate (Ashton-Tate Corporation) was a US-based software company best known for developing the popular dBASE database application.

New!!: Microsoft SQL Server and Ashton-Tate · See more »

Assembly (CLI)

Defined by Microsoft for use in recent versions of Windows, an assembly in the Common Language Infrastructure (CLI) is a compiled code library used for deployment, versioning, and security.

New!!: Microsoft SQL Server and Assembly (CLI) · See more »

Asynchronous I/O

In computer science, asynchronous I/O (also non-sequential I/O) is a form of input/output processing that permits other processing to continue before the transmission has finished.

New!!: Microsoft SQL Server and Asynchronous I/O · See more »

B-tree

In computer science, a B-tree is a self-balancing tree data structure that keeps data sorted and allows searches, sequential access, insertions, and deletions in logarithmic time.

New!!: Microsoft SQL Server and B-tree · See more »

Binary large object

A Binary Large OBject (BLOB) is a collection of binary data stored as a single entity in a database management system.

New!!: Microsoft SQL Server and Binary large object · See more »

BMP file format

The BMP file format, also known as bitmap image file or device independent bitmap (DIB) file format or simply a bitmap, is a raster graphics image file format used to store bitmap digital images, independently of the display device (such as a graphics adapter), especially on Microsoft Windows and OS/2 operating systems.

New!!: Microsoft SQL Server and BMP file format · See more »

Business intelligence

Business intelligence (BI) comprises the strategies and technologies used by enterprises for the data analysis of business information.

New!!: Microsoft SQL Server and Business intelligence · See more »

Business Intelligence Development Studio

Business Intelligence Development Studio (BIDS) is the former IDE from Microsoft, and was used to develop data analysis and Business Intelligence solutions utilizing the Microsoft SQL Server Analysis Services, Reporting Services and Integration Services.

New!!: Microsoft SQL Server and Business Intelligence Development Studio · See more »

C (programming language)

C (as in the letter ''c'') is a general-purpose, imperative computer programming language, supporting structured programming, lexical variable scope and recursion, while a static type system prevents many unintended operations.

New!!: Microsoft SQL Server and C (programming language) · See more »

C Sharp (programming language)

C# (/si: ʃɑːrp/) is a multi-paradigm programming language encompassing strong typing, imperative, declarative, functional, generic, object-oriented (class-based), and component-oriented programming disciplines.

New!!: Microsoft SQL Server and C Sharp (programming language) · See more »

C++

C++ ("see plus plus") is a general-purpose programming language.

New!!: Microsoft SQL Server and C++ · See more »

Checksum

A checksum is a small-sized datum derived from a block of digital data for the purpose of detecting errors which may have been introduced during its transmission or storage.

New!!: Microsoft SQL Server and Checksum · See more »

Cloud computing

Cloud computing is an information technology (IT) paradigm that enables ubiquitous access to shared pools of configurable system resources and higher-level services that can be rapidly provisioned with minimal management effort, often over the Internet.

New!!: Microsoft SQL Server and Cloud computing · See more »

Comma-separated values

In computing, a comma-separated values (CSV) file is a delimited text file that uses a comma to separate values.

New!!: Microsoft SQL Server and Comma-separated values · See more »

Common Language Runtime

The Common Language Runtime (CLR), the virtual machine component of Microsoft's.NET framework, manages the execution of.NET programs.

New!!: Microsoft SQL Server and Common Language Runtime · See more »

Comparison of data modeling tools

This article is a comparison of data modeling tools which are notable, including standalone, conventional data modeling tools and modeling tools supporting data modeling as part of a larger modeling environment.

New!!: Microsoft SQL Server and Comparison of data modeling tools · See more »

Comparison of object-relational database management systems

This is a comparison of object-relational database management systems (ORDBMSs).

New!!: Microsoft SQL Server and Comparison of object-relational database management systems · See more »

Comparison of relational database management systems

The following tables compare general and technical information for a number of relational database management systems.

New!!: Microsoft SQL Server and Comparison of relational database management systems · See more »

Computer cluster

A computer cluster is a set of loosely or tightly connected computers that work together so that, in many respects, they can be viewed as a single system.

New!!: Microsoft SQL Server and Computer cluster · See more »

Computer data storage

Computer data storage, often called storage or memory, is a technology consisting of computer components and recording media that are used to retain digital data.

New!!: Microsoft SQL Server and Computer data storage · See more »

Concurrency control

In information technology and computer science, especially in the fields of computer programming, operating systems, multiprocessors, and databases, concurrency control ensures that correct results for concurrent operations are generated, while getting those results as quickly as possible.

New!!: Microsoft SQL Server and Concurrency control · See more »

Concurrent computing

Concurrent computing is a form of computing in which several computations are executed during overlapping time periods—concurrently—instead of sequentially (one completing before the next starts).

New!!: Microsoft SQL Server and Concurrent computing · See more »

Concurrent user

In computer science, the number of concurrent users for a resource in a location, with the location being a computing network or a single computer, refers to the total number of people using the resource within a predefined period of time.

New!!: Microsoft SQL Server and Concurrent user · See more »

Data buffer

In computer science, a data buffer (or just buffer) is a region of a physical memory storage used to temporarily store data while it is being moved from one place to another.

New!!: Microsoft SQL Server and Data buffer · See more »

Data integration

Data integration involves combining data residing in different sources and providing users with a unified view of them.

New!!: Microsoft SQL Server and Data integration · See more »

Data mining

Data mining is the process of discovering patterns in large data sets involving methods at the intersection of machine learning, statistics, and database systems.

New!!: Microsoft SQL Server and Data mining · See more »

Data Mining Extensions

Data Mining Extensions (DMX) is a query language for data mining models supported by Microsoft's SQL Server Analysis Services product.

New!!: Microsoft SQL Server and Data Mining Extensions · See more »

Data warehouse

In computing, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for reporting and data analysis, and is considered a core component of business intelligence.

New!!: Microsoft SQL Server and Data warehouse · See more »

Database

A database is an organized collection of data, stored and accessed electronically.

New!!: Microsoft SQL Server and Database · See more »

Database index

A database index is a data structure that improves the speed of data retrieval operations on a database table at the cost of additional writes and storage space to maintain the index data structure.

New!!: Microsoft SQL Server and Database index · See more »

Database schema

The database schema of a database system is its structure described in a formal language supported by the database management system (DBMS).

New!!: Microsoft SQL Server and Database schema · See more »

Database server

A database server is a server which houses a database application that provides database services to other computer programs or to computers, as defined by the client–server model.

New!!: Microsoft SQL Server and Database server · See more »

Database trigger

A database trigger is procedural code that is automatically executed in response to certain events on a particular table or view in a database.

New!!: Microsoft SQL Server and Database trigger · See more »

Deadlock

In concurrent computing, a deadlock is a state in which each member of a group is waiting for some other member to take action, such as sending a message or more commonly releasing a lock.

New!!: Microsoft SQL Server and Deadlock · See more »

Debug code

Debug code is computer code introduced to a computer program to test for errors or to help determine the cause of an error.

New!!: Microsoft SQL Server and Debug code · See more »

Decision tree learning

Decision tree learning uses a decision tree (as a predictive model) to go from observations about an item (represented in the branches) to conclusions about the item's target value (represented in the leaves).

New!!: Microsoft SQL Server and Decision tree learning · See more »

Declarative programming

In computer science, declarative programming is a programming paradigm—a style of building the structure and elements of computer programs—that expresses the logic of a computation without describing its control flow.

New!!: Microsoft SQL Server and Declarative programming · See more »

Docker (software)

Docker is a computer program that performs operating-system-level virtualization also known as containerization.

New!!: Microsoft SQL Server and Docker (software) · See more »

Encryption

In cryptography, encryption is the process of encoding a message or information in such a way that only authorized parties can access it and those who are not authorized cannot.

New!!: Microsoft SQL Server and Encryption · See more »

Extract, transform, load

In computing, extract, transform, load (ETL) refers to a process in database usage and especially in data warehousing.

New!!: Microsoft SQL Server and Extract, transform, load · See more »

GIF

The Graphics Interchange Format, better known by its acronym GIF, is a bitmap image format that was developed by a team at the bulletin board service (BBS) provider CompuServe led by American computer scientist Steve Wilhite on June 15, 1987.

New!!: Microsoft SQL Server and GIF · See more »

Git

Git is a version control system for tracking changes in computer files and coordinating work on those files among multiple people.

New!!: Microsoft SQL Server and Git · See more »

Graphical user interface

The graphical user interface (GUI), is a type of user interface that allows users to interact with electronic devices through graphical icons and visual indicators such as secondary notation, instead of text-based user interfaces, typed command labels or text navigation.

New!!: Microsoft SQL Server and Graphical user interface · See more »

Heap (data structure)

In computer science, a heap is a specialized tree-based data structure that satisfies the heap property: if P is a parent node of C, then the key (the value) of P is either greater than or equal to (in a max heap) or less than or equal to (in a min heap) the key of C. The node at the "top" of the heap (with no parents) is called the root node.

New!!: Microsoft SQL Server and Heap (data structure) · See more »

IFilter

An IFilter is a plugin that allows Microsoft's search engines to index various file formats (as documents, email attachments, database records, audio metadata etc.) so that they become searchable.

New!!: Microsoft SQL Server and IFilter · See more »

Import and export of data

The import and export of data is the automated or semi-automated input and output of data sets between different software applications.

New!!: Microsoft SQL Server and Import and export of data · See more »

Input/output

In computing, input/output or I/O (or, informally, io or IO) is the communication between an information processing system, such as a computer, and the outside world, possibly a human or another information processing system.

New!!: Microsoft SQL Server and Input/output · See more »

Integrated development environment

An integrated development environment (IDE) is a software application that provides comprehensive facilities to computer programmers for software development.

New!!: Microsoft SQL Server and Integrated development environment · See more »

Intelligent code completion

Intelligent code completion is a context-aware code completion feature in some programming environments that speeds up the process of coding applications by reducing typos and other common mistakes.

New!!: Microsoft SQL Server and Intelligent code completion · See more »

Internet protocol suite

The Internet protocol suite is the conceptual model and set of communications protocols used on the Internet and similar computer networks.

New!!: Microsoft SQL Server and Internet protocol suite · See more »

Inverted index

In computer science, an inverted index (also referred to as postings file or inverted file) is an index data structure storing a mapping from content, such as words or numbers, to its locations in a database file, or in a document or a set of documents (named in contrast to a forward index, which maps from documents to content).

New!!: Microsoft SQL Server and Inverted index · See more »

Join (SQL)

An SQL join clause combines columns from one or more tables in a relational database.

New!!: Microsoft SQL Server and Join (SQL) · See more »

JPEG

JPEG is a commonly used method of lossy compression for digital images, particularly for those images produced by digital photography.

New!!: Microsoft SQL Server and JPEG · See more »

Library (computing)

In computer science, a library is a collection of non-volatile resources used by computer programs, often for software development.

New!!: Microsoft SQL Server and Library (computing) · See more »

Linux

Linux is a family of free and open-source software operating systems built around the Linux kernel.

New!!: Microsoft SQL Server and Linux · See more »

List of CLI languages

CLI Languages are computer programming languages that are used to produce libraries and programs that conform to the Common Language Infrastructure (CLI) specifications.

New!!: Microsoft SQL Server and List of CLI languages · See more »

List of relational database management systems

This is a list of relational database management systems.

New!!: Microsoft SQL Server and List of relational database management systems · See more »

Managed code

Managed code is computer program code that requires and will execute only under the management of a Common Language Runtime virtual machine, typically the.NET Framework, or Mono.

New!!: Microsoft SQL Server and Managed code · See more »

Massively parallel

In computing, massively parallel refers to the use of a large number of processors (or separate computers) to perform a set of coordinated computations in parallel (simultaneously).

New!!: Microsoft SQL Server and Massively parallel · See more »

Message queue

In computer science, message queues and mailboxes are software-engineering components used for inter-process communication (IPC), or for inter-thread communication within the same process.

New!!: Microsoft SQL Server and Message queue · See more »

Microsoft

Microsoft Corporation (abbreviated as MS) is an American multinational technology company with headquarters in Redmond, Washington.

New!!: Microsoft SQL Server and Microsoft · See more »

Microsoft Access

Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.

New!!: Microsoft SQL Server and Microsoft Access · See more »

Microsoft Analysis Services

Microsoft SQL Server Analysis Services, SSAS, is an online analytical processing (OLAP) and data mining tool in Microsoft SQL Server.

New!!: Microsoft SQL Server and Microsoft Analysis Services · See more »

Microsoft Azure

Microsoft Azure (formerly Windows Azure) is a cloud computing service created by Microsoft for building, testing, deploying, and managing applications and services through a global network of Microsoft-managed data centers.

New!!: Microsoft SQL Server and Microsoft Azure · See more »

Microsoft Azure SQL Database

Microsoft Azure SQL Database (formerly SQL Azure, SQL Server Data Services, SQL Services, and Windows Azure SQL Database) is a managed cloud database (SaaS) provided as part of Microsoft Azure.

New!!: Microsoft SQL Server and Microsoft Azure SQL Database · See more »

Microsoft Press

Microsoft Press is the publishing arm of Microsoft, usually releasing books dealing with various current Microsoft technologies.

New!!: Microsoft SQL Server and Microsoft Press · See more »

Microsoft Visual Studio

Microsoft Visual Studio is an integrated development environment (IDE) from Microsoft.

New!!: Microsoft SQL Server and Microsoft Visual Studio · See more »

Microsoft Windows

Microsoft Windows is a group of several graphical operating system families, all of which are developed, marketed, and sold by Microsoft.

New!!: Microsoft SQL Server and Microsoft Windows · See more »

Microsoft Word

Microsoft Word (or simply Word) is a word processor developed by Microsoft.

New!!: Microsoft SQL Server and Microsoft Word · See more »

MSDE

Microsoft SQL Server Data Engine (MSDE, also Microsoft Data Engine or Microsoft Desktop Engine) is a relational database management system developed by Microsoft.

New!!: Microsoft SQL Server and MSDE · See more »

MultiDimensional eXpressions

Multidimensional Expressions (MDX) is a query language for online analytical processing (OLAP) using a database management system.

New!!: Microsoft SQL Server and MultiDimensional eXpressions · See more »

Multiversion concurrency control

Multiversion concurrency control (MCC or MVCC), is a concurrency control method commonly used by database management systems to provide concurrent access to the database and in programming languages to implement transactional memory.

New!!: Microsoft SQL Server and Multiversion concurrency control · See more »

Mutual exclusion

In computer science, mutual exclusion is a property of concurrency control, which is instituted for the purpose of preventing race conditions; it is the requirement that one thread of execution never enter its critical section at the same time that another concurrent thread of execution enters its own critical section.

New!!: Microsoft SQL Server and Mutual exclusion · See more »

Naive Bayes classifier

In machine learning, naive Bayes classifiers are a family of simple "probabilistic classifiers" based on applying Bayes' theorem with strong (naive) independence assumptions between the features.

New!!: Microsoft SQL Server and Naive Bayes classifier · See more »

Named pipe

In computing, a named pipe (also known as a FIFO for its behavior) is an extension to the traditional pipe concept on Unix and Unix-like systems, and is one of the methods of inter-process communication (IPC).

New!!: Microsoft SQL Server and Named pipe · See more »

Neural network

The term neural network was traditionally used to refer to a network or circuit of neurons.

New!!: Microsoft SQL Server and Neural network · See more »

Object composition

In computer science, object composition (not to be confused with function composition) is a way to combine simple objects or data types into more complex ones.

New!!: Microsoft SQL Server and Object composition · See more »

OLAP cube

In database engineering in computing, OLAP cube is a term that typically refers to a multi-dimensional array of data.

New!!: Microsoft SQL Server and OLAP cube · See more »

OLE DB

OLE DB (Object Linking and Embedding, Database, sometimes written as OLEDB or OLE-DB), an API designed by Microsoft, allows accessing data from a variety of sources in a uniform manner.

New!!: Microsoft SQL Server and OLE DB · See more »

Online analytical processing

Online analytical processing, or OLAP, is an approach to answering multi-dimensional analytical (MDA) queries swiftly in computing.

New!!: Microsoft SQL Server and Online analytical processing · See more »

Open Database Connectivity

In computing, Open Database Connectivity (ODBC) is a standard application programming interface (API) for accessing database management systems (DBMS).

New!!: Microsoft SQL Server and Open Database Connectivity · See more »

Optimistic concurrency control

Optimistic concurrency control (OCC) is a concurrency control method applied to transactional systems such as relational database management systems and software transactional memory.

New!!: Microsoft SQL Server and Optimistic concurrency control · See more »

OS/2

OS/2 is a series of computer operating systems, initially created by Microsoft and IBM under the leadership of IBM software designer Ed Iacobucci.

New!!: Microsoft SQL Server and OS/2 · See more »

PDF

The Portable Document Format (PDF) is a file format developed in the 1990s to present documents, including text formatting and images, in a manner independent of application software, hardware, and operating systems.

New!!: Microsoft SQL Server and PDF · See more »

Petabyte

The petabyte is a multiple of the unit byte for digital information.

New!!: Microsoft SQL Server and Petabyte · See more »

Platform as a service

Platform as a Service (PaaS) or application platform as a Service (aPaaS) or platform base service is a category of cloud computing services that provides a platform allowing customers to develop, run, and manage applications without the complexity of building and maintaining the infrastructure typically associated with developing and launching an app.

New!!: Microsoft SQL Server and Platform as a service · See more »

Portable Network Graphics

Portable Network Graphics (PNG, pronounced or) is a raster graphics file format that supports lossless data compression.

New!!: Microsoft SQL Server and Portable Network Graphics · See more »

Primitive data type

In computer science, primitive data type is either of the following.

New!!: Microsoft SQL Server and Primitive data type · See more »

Proprietary software

Proprietary software is non-free computer software for which the software's publisher or another person retains intellectual property rights—usually copyright of the source code, but sometimes patent rights.

New!!: Microsoft SQL Server and Proprietary software · See more »

Query optimization

Query optimization is a function of many relational database management systems.

New!!: Microsoft SQL Server and Query optimization · See more »

Query plan

A query plan (or query execution plan) is an ordered set of steps used to access data in a SQL relational database management system.

New!!: Microsoft SQL Server and Query plan · See more »

Red Hat Enterprise Linux

Red Hat Enterprise Linux (RHEL) is a Linux distribution developed by Red Hat and targeted toward the commercial market.

New!!: Microsoft SQL Server and Red Hat Enterprise Linux · See more »

Regression analysis

In statistical modeling, regression analysis is a set of statistical processes for estimating the relationships among variables.

New!!: Microsoft SQL Server and Regression analysis · See more »

Relational database

A relational database is a digital database based on the relational model of data, as proposed by E. F. Codd in 1970.

New!!: Microsoft SQL Server and Relational database · See more »

Relational database management system

A relational database management system (RDBMS) is a database management system (DBMS) based on the relational model invented by Edgar F. Codd at IBM's San Jose Research Laboratory.

New!!: Microsoft SQL Server and Relational database management system · See more »

Report Definition Language

Report Definition Language (RDL) is a standard proposed by Microsoft for defining reports.

New!!: Microsoft SQL Server and Report Definition Language · See more »

Revoscalepy

revoscalepy is a machine learning package in Python created by Microsoft.

New!!: Microsoft SQL Server and Revoscalepy · See more »

RevoScaleR

RevoScaleR is a machine learning package in R created by Microsoft.

New!!: Microsoft SQL Server and RevoScaleR · See more »

Rounding

Rounding a numerical value means replacing it by another value that is approximately equal but has a shorter, simpler, or more explicit representation; for example, replacing $ with $, or the fraction 312/937 with 1/3, or the expression with.

New!!: Microsoft SQL Server and Rounding · See more »

Scripting language

A scripting or script language is a programming language that supports scripts: programs written for a special run-time environment that automate the execution of tasks that could alternatively be executed one-by-one by a human operator.

New!!: Microsoft SQL Server and Scripting language · See more »

Select (SQL)

The SQL SELECT statement returns a result set of records from one or more tables.

New!!: Microsoft SQL Server and Select (SQL) · See more »

Shared memory

In computer science, shared memory is memory that may be simultaneously accessed by multiple programs with an intent to provide communication among them or avoid redundant copies.

New!!: Microsoft SQL Server and Shared memory · See more »

Software

Computer software, or simply software, is a generic term that refers to a collection of data or computer instructions that tell the computer how to work, in contrast to the physical hardware from which the system is built, that actually performs the work.

New!!: Microsoft SQL Server and Software · See more »

SQL

SQL (S-Q-L, "sequel"; Structured Query Language) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).

New!!: Microsoft SQL Server and SQL · See more »

SQL CLR

SQL CLR or SQLCLR (SQL Common Language Runtime) is technology for hosting of the Microsoft.NET common language runtime engine within SQL Server.

New!!: Microsoft SQL Server and SQL CLR · See more »

SQL compliance

|| |- ! F021 || Basic information schema || || || || || || || || |- | F021–01 || COLUMNS view || || || || || Also includes MySQL-specific extension columns || || || |- | F021–02 || TABLES view || || || || || || || || |- | F021–03 || VIEWS view || || || || || || || || |- | F021–04 || TABLE_CONSTRAINTS view || || || || || || || || |- | F021–05 || REFERENTIAL_CONSTRAINTS view || || || || || || || || |- | F021–06 || CHECK_CONSTRAINTS view || || || || || || || || |- ! F031 || Basic schema manipulation || || || || || || || || |- | F031–01 || CREATE TABLE statement to create persistent base tables || || || || || || || || |- | F031–02 || CREATE VIEW statement || || || || || || || || |- | F031–03 || GRANT statement || || || || || || || || |- | F031–04 || ALTER TABLE statement: ADD COLUMN clause || || || || || || || || |- | F031–13 || DROP TABLE statement: RESTRICT clause || || || || || || || || |- | F031–16 || DROP VIEW statement: RESTRICT clause || || || || || || || || |- | F031–19 || REVOKE statement: RESTRICT clause || || || || || || || || |- ! F041 || Basic joined table || || || || || || || || |- | F041–01 || Inner join (but not necessarily the INNER keyword) || || || || || || || || |- | F041–02 || INNER keyword || || || || || || || || |- | F041–03 || LEFT OUTER JOIN || || || || || || || || |- | F041–04 || RIGHT OUTER JOIN || || || || || || || || |- | F041–05 || Outer joins can be nested || || || || || || || || |- | F041–07 || The inner table in a left or right outer join can also be used in an inner join || || || || || || || || |- | F041–08 || All comparison operators are supported (rather than just.

New!!: Microsoft SQL Server and SQL compliance · See more »

SQL Server Compact

Microsoft SQL Server Compact (SQL CE) is a compact relational database produced by Microsoft for applications that run on mobile devices and desktops.

New!!: Microsoft SQL Server and SQL Server Compact · See more »

SQL Server Express

Microsoft SQL Server Express is a version of Microsoft's SQL Server relational database management system that is free to download, distribute and use.

New!!: Microsoft SQL Server and SQL Server Express · See more »

SQL Server Integration Services

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks.

New!!: Microsoft SQL Server and SQL Server Integration Services · See more »

SQL Server Management Studio

SQL Server Management Studio (SSMS) is a software application first launched with Microsoft SQL Server 2005 that is used for configuring, managing, and administering all components within Microsoft SQL Server.

New!!: Microsoft SQL Server and SQL Server Management Studio · See more »

SQL Server Reporting Services

SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft.

New!!: Microsoft SQL Server and SQL Server Reporting Services · See more »

Standard Libraries (CLI)

The Common Language Infrastructure (CLI) includes the Standard Libraries in order to encapsulate a large number of common functions, such as file reading and writing, XML document manipulation, exception handling, application globalization, network communication, threading and reflection, which makes the programmer's job easier.

New!!: Microsoft SQL Server and Standard Libraries (CLI) · See more »

Stored procedure

A stored procedure (also termed proc, storp, sproc, StoPro, StoredProc, StoreProc, sp, or SP) is a subroutine available to applications that access a relational database management system (RDBMS).

New!!: Microsoft SQL Server and Stored procedure · See more »

SUSE Linux Enterprise

SUSE Linux Enterprise Server (SLES) is a Linux-based operating system developed by SUSE.

New!!: Microsoft SQL Server and SUSE Linux Enterprise · See more »

Sybase

Sybase was an enterprise software and services company that produced software to manage and analyze information in relational databases.

New!!: Microsoft SQL Server and Sybase · See more »

Tabular Data Stream

Tabular Data Stream (TDS) is an application layer protocol, used to transfer data between a database server and a client.

New!!: Microsoft SQL Server and Tabular Data Stream · See more »

Terabyte

The terabyte is a multiple of the unit byte for digital information.

New!!: Microsoft SQL Server and Terabyte · See more »

Thesaurus

In general usage, a thesaurus is a reference work that lists words grouped together according to similarity of meaning (containing synonyms and sometimes antonyms), in contrast to a dictionary, which provides definitions for words, and generally lists them in alphabetical order.

New!!: Microsoft SQL Server and Thesaurus · See more »

TIFF

Tagged Image File Format, abbreviated TIFF or TIF, is a computer file format for storing raster graphics images, popular among graphic artists, the publishing industry, and photographers.

New!!: Microsoft SQL Server and TIFF · See more »

Total cost of ownership

Total cost of ownership (TCO) is a financial estimate intended to help buyers and owners determine the direct and indirect costs of a product or system.

New!!: Microsoft SQL Server and Total cost of ownership · See more »

Transact-SQL

Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to the SQL (Structured Query Language) used to interact with relational databases.

New!!: Microsoft SQL Server and Transact-SQL · See more »

Type safety

In computer science, type safety is the extent to which a programming language discourages or prevents type errors.

New!!: Microsoft SQL Server and Type safety · See more »

Type system

In programming languages, a type system is a set of rules that assigns a property called type to the various constructs of a computer program, such as variables, expressions, functions or modules.

New!!: Microsoft SQL Server and Type system · See more »

Ubuntu (operating system)

Ubuntu (stylized as ubuntu) is a free and open source operating system and Linux distribution based on Debian.

New!!: Microsoft SQL Server and Ubuntu (operating system) · See more »

User interface

The user interface (UI), in the industrial design field of human–computer interaction, is the space where interactions between humans and machines occur.

New!!: Microsoft SQL Server and User interface · See more »

View (SQL)

In a database, a view is the result set of a stored query on the data, which the database users can query just as they would in a persistent database collection object.

New!!: Microsoft SQL Server and View (SQL) · See more »

Visual Basic .NET

Visual Basic.NET (VB.NET) is a multi-paradigm, object-oriented programming language, implemented on the.NET Framework.

New!!: Microsoft SQL Server and Visual Basic .NET · See more »

Web service

The term web service is either.

New!!: Microsoft SQL Server and Web service · See more »

Windows Internal Database

Windows Internal Database (codenamed WYukon, sometimes referred to as SQL Server Embedded Edition) is a variant of SQL Server Express 2005–2014 that is included with Windows Server 2008 (SQL 2005), Windows Server 2008 R2 (SQL 2005), Windows Server 2012 (SQL 2012), Windows Server 2012 R2 (SQL 2012) and Windows Server 2016 (SQL 2014) and is included with other free Microsoft products released after 2007 that require an SQL Server database backend.

New!!: Microsoft SQL Server and Windows Internal Database · See more »

Windows Metafile

Windows Metafile (WMF) is an image file format originally designed for Microsoft Windows in the 1990s.

New!!: Microsoft SQL Server and Windows Metafile · See more »

Windows NT

Windows NT is a family of operating systems produced by Microsoft, the first version of which was released in July 1993.

New!!: Microsoft SQL Server and Windows NT · See more »

Windows Server

Windows Server is a brand name for a group of server operating systems released by Microsoft.

New!!: Microsoft SQL Server and Windows Server · See more »

Windows service

In Windows NT operating systems, a Windows service is a computer program that operates in the background.

New!!: Microsoft SQL Server and Windows service · See more »

Workflow

A workflow consists of an orchestrated and repeatable pattern of business activity enabled by the systematic organization of resources into processes that transform materials, provide services, or process information.

New!!: Microsoft SQL Server and Workflow · See more »

World Wide Web

The World Wide Web (abbreviated WWW or the Web) is an information space where documents and other web resources are identified by Uniform Resource Locators (URLs), interlinked by hypertext links, and accessible via the Internet.

New!!: Microsoft SQL Server and World Wide Web · See more »

XML

In computing, Extensible Markup Language (XML) is a markup language that defines a set of rules for encoding documents in a format that is both human-readable and machine-readable.

New!!: Microsoft SQL Server and XML · See more »

XML for Analysis

XML for Analysis (abbreviated as XMLA) is an industry standard for data access in analytical systems, such as OLAP and data mining.

New!!: Microsoft SQL Server and XML for Analysis · See more »

XQuery

XQuery (XML Query) is a query and functional programming language that queries and transforms collections of structured and unstructured data, usually in the form of XML, text and with vendor-specific extensions for other data formats (JSON, binary, etc.). The language is developed by the XML Query working group of the W3C.

New!!: Microsoft SQL Server and XQuery · See more »

.NET Framework

.NET Framework (pronounced dot net) is a software framework developed by Microsoft that runs primarily on Microsoft Windows.

New!!: Microsoft SQL Server and .NET Framework · See more »

Redirects here:

Data Source Views, MS SQL, MS SQL Server, MS-SQL, MSSQL, Microsoft SQL, Microsoft SQL Server 2000, Microsoft SQL Server 2005, Microsoft SQL Server 2008, Microsoft SQL Server 2008 R2, Microsoft SQL Server Compare Tools, Microsoft SQL server, Microsoft Sql Server, Microsoft sql server, Ms sql server, Mssql, Port 1433, Pubs (database), SQL 6.5, SQL 7.0, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2014 CAB, SQL Server 2014 ISO, SQL Server 2016, Sql Server 2000, Sys.sysobjects.

References

[1] https://en.wikipedia.org/wiki/Microsoft_SQL_Server

OutgoingIncoming
Hey! We are on Facebook now! »