DataSunrise Data and Database Security for Microsoft SQL Server
DataSunrise Security Suite for Microsoft SQL Server is fully compatible with Microsoft’s database because it supports the most of company’s proprietary technologies utilized in this RDBMS:
- TDS Proxy
- SMP + TDS Proxy (MARS support)
- SSL over TDS or SMP + TDS proxy
- Sniffing for all protocol combinations (TDS, SMP+TDS, SSL+SMP+TDS)
- SSL ciphers control
- SQLBatch analysis, blocking and masking
- RPCBatch analysis, blocking and masking
- Asynchronous queries analysis (pipelining)
MS SQL Server 2005, 2012, 2014, 2016, V12 (Azure)
About Microsoft SQL Server
SQL Server is a RDBMS developed by Microsoft Corporation. Historically, MS SQL Server was a modification of Sybase SQL Server for IBM OS/2 operating system developed during joint project between Microsoft, Ashton-Tate and Sybase. Later Microsoft and Sybase separated and developed separate projects.
SQL Server supports various data types, including primitive data type and user-defined composite (UDT). Besides tables the database can store other types of objects, including views, stored procedures, indexes and constraints along with transactions log.
For data exchange between server and client TDS protocol is used. TDS packets can be transferred via transport-layer protocols (TCP/IP, named pipes, shared memory). SQL Server supports ODBC and JDBC interfaces as well.
SQL Server uses Transact-SQL (T-SQL) language to process queries. This language was developed during Microsoft and Sybase joint project and is shared with Sybase SQL Server database.