what is ms-sql?
Microsoft SQL is a database created and used by Microsoft . Its primary query language is Transact-SQL, an implementation of the ANSI/ISO standard Structured Query Language (SQL) used by both Microsoft and Sybase. SQL Server is commonly used by businesses for small- to medium-sized databases, but the past five years have seen greater adoption of the product for larger enterprise databases.
According to Microsoft, future versions of SQL Server aim to make data management self-tuning, self organizing, and self maintaining with the introduction of SQL Server Always On technologies, to provide near-zero downtime. Microsoft also aims to intrinsically support many digital data formats, including pictures, audio, video and other multimedia data. In current versions, such multimedia data can be stored as BLOBs (binary large objects), but they are generic bitstreams. Intrinsic awareness of multimedia data will allow specialized functions to be performed on them. Better support for unstructured and semi-structured data is planned as well.
advantages of ms-sql
• security
• advanced security
• enhances productivity
|