Microsoft SQL Server is a commercial database management system (DBMS) developed by Microsoft in cooperation with Sybase. It uses Transact-SQL as the query language and is used to work with small and medium size databases. The system actively uses cloud technologies, provides security and fast data synchronization. Windows Azure SQL Database Data Sync technology allows you to create a two-way connection between the server and the cloud with reliable encryption algorithms. Referring to the tests of the National Institute of Standards and Technology (NIST), Microsoft states that this platform contains the least number of vulnerabilities compared to its counterparts.
Essentially, the Transact-SQL platform used by this platform is an implementation of ANSI/ISO for the SQL language, which contains several important extensions. Microsoft SQL Server provides high "uptime" and performance when working with databases. The platform also contains tools for hybrid transactional-analytical processing in real time. They help implement different scenarios and operational analytics. Unfortunately, this feature is not available for all types of licenses, and there are a lot of such SQL Server - Microsoft offers several "editions" of its platform for different purposes and budgets.
Using Microsoft SQL Server you can reduce the cost of storing cold data (those that do not require constant access). Stretch technology provides the ability to extend large SQL Server tables to Microsoft Azure.
- Less vulnerabilities than other relational database management systems (RDBMS);
- Real-time operational analytics capability;
- Ensuring quick access to cold data;
- Extend large SQL Server tables to Microsoft Azure with SQL Server Stretch technology;
- use of Transact-SQL query language, which is an implementation of the ANSI/ISO standard.