SQL With Server - Microsoft Relational Database Management System (DBMS). This is a full-featured database, primarily designed to compete with Oracle Database (DB) and MySQL.
A relational database management system is a program that allows you to create, update and administer an information array. Most commercial DBMSs use the structured query language to access the database, although SQL was invented after the development of the relational model and was not needed to use it.
Oracle, IBM DB2 Microsoft SQL Server. , , , . , SQL.
SQL With Server?
RBDMS, SQL Server ANSI SQL — . T-SQL — . SQL Server Management Studio (SSMS) ( Enterprise Manager) 32- 64- . SQL Server 1980- Sybase Inc., SAP. Sybase Unix- -. Microsoft Ashton-Tate Corp., Microsoft SQL Server, OS/2 1989 .
1989 1.0 Microsoft. SQL With Server Sybase. Microsoft - Sybase 1990- , Microsoft SQL Server. 2000, 2005 2008 , .
:
1995 2016 Microsoft 10 SQL Server. , Microsoft , , Oracle Database, DB2 . Microsoft SQL Server , , -, .
SQL 2012 Server :
Company — , Web. .
Standart — . .
Working group — . - .
Express — . . Access.
Microsoft SQL 2008 Server , . : , Express, 10 . Microsoft , SQL Server, , .
(SQL) - . , , . SQL, .
1970- IBM , SQL Relational Software Inc. ( Oracle Corporation) 1979 . SQL , (ANSI). , ANSI SQL, SQL*Plus (Oracle) Transact-SQL.
SELECT SQL- (GUI). GUI , , .
:
SELECT, SELECT, FROM, WHERE ORDER BY.
(DML) , SELECT INSERT, DELETE UPDATE, , BEGIN TRANSACTION, SAVEPOINT, COMMIT ROLLBACK.
(DDL) . DDL CREATE, ALTER, TRUNCATE DROP.
(DCL) . GRANT REVOKE.
NewSQL — ?
NewSQL — , (SQL) NoSQL. SQL NoSQL, NewSQL .
2011 , SQL, NewSQL (OLTP), , , (ACID). NewSQL , , .
VoltDB - NewSQL, 50 , SQL, , NoSQL.
SQL Server BI
SQL Server Business Intelligence (BI) - , . IDE Business Intelligence Development Studio (BIDS) Microsoft SQL Server, Visual Studio 2010 SQL Server Data Tools - Business Intelligence.
Microsoft SQL Server -, . Visual Studio - .
SQL Server 2017 - Python , . SQL Server R (In-Database) R Python. Windows , Linux.
- , , . , , .
— , . . , , . , .
, . , , . , , - . , :
SQL Server
, SQL Server , , . . , , , ACID .
Microsoft SQL Server SQL Server Database Engine, , . , , , , , , , . , , Database Engine.
SQL Server
, Microsoft SQL Server, 1 (SP1) SQL Server 2016, , 2016:
Always Encrypted, ;
, ;
, .
SQL Server,
Microsoft , - (BI) SQL Server. R Services Machine Learning Services, 2016, Analysis Services — , BI , , BI.
Microsoft SQL Server SQL Server, . : SQL Server Management Studio , .