MSSQL

From RemObjects Software

Jump to: navigation, search

This is a Technical Glossary entry
Feel free to add your notes to this topic below.


Microsoft SQL Server is a relational database management system (RDBMS) produced 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.

Features

  • Hosted CommonLanguage Runtime
  • Native XML Support
  • ADO.NET version 2.0
  • Security Enhancements
  • Transact-SQL Enhancements
  • Reliable Messaging for Asynchronous Applications
  • Visual Studio Integration
  • Web Services
  • Embedded Reports
  • Full-Text Search Enhancements
  • Database Mirroring
  • Online Restore
  • Online Indexing Operations
  • Fast Recovery
  • Standards-based Information Access
  • SQL Server Management Studio
  • Dedicated Administrator Connection
  • Snapshot Isolation
  • Data Partitioning
  • Replication Enhancements
  • Analysis Services
  • Integration Services (SSIS)
  • Data Mining
  • Reporting Services
  • Clustering Support
  • Key Performance Indicators
  • Scalability and Performance
  • Report Builder
  • Proactive Caching
  • Integration with the Microsoft Office System

External links

Retrieved from "http://wiki.remobjects.com/wiki/MSSQL"
Personal tools