Microsoft SQL Server
From RemObjects Wiki
This is a Technology topic
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.
There are several versions and editions, of which 2008 is the latest. SQL server 2005 has a native XML type.
Contents |
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
Editions
- Compact Framework
- Express edition to be usable as a redistributable small database server
- Developer edition
- Server and enterprise edition.
