Microsoft SQL Server
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
SQL Server includes support for database mirroring and clustering,
failover, partitioning and snapshots.
Database mirroring, introduced in SQL Server 2005, allows creation
of mirrors (or replicas) of database contents, along with transaction
logs, on another instance of SQL Server, based on certain predefined
A SQL server cluster is a collection of identically configured
servers, which help distribute the workload among multiple servers.
All the servers share an identical virtual server name, and it is
resolved into the IP address of any of the identically configured
machines by the clustering runtime.
Automatic failover clustering is also available, in which the
workload of a server is transferred to another system in the event
of a system failure.
SQL server also supports data partitioning for distributed databases.
SQL Server 2005 also allows creation of snapshots, which are like
backup images that can be reverted back to when needed.
SQL Server supports three different data replication scenarios:
- Snapshot replication: Snapshots of a database
are pushed out to all replication subscribers of a server.
- Transaction replication: Changes to the database
are continually published out to clients.
- Merge replication: Synchronizing the database
with other servers participating in the replication. Changes to
all databases happen independently and during replication, the
changes are synchronized among all databases. Merge replication
includes in-built support for conflict resolution.
SQL Server 2005
SQL Server 2005 supports .NET Framework. In .NET, stored procedures
are written in any .NET language, using the entire set of libraries
available to the .NET Framework, as well the Common Type System.
Unlike other processes, .NET Framework hosted in SQL Server 2005
utilizes memory and thread management capabilities provided by SQL
Server, rather than using built in capabilities of Windows. This
gives better performance.
Also See SQL
Applications are developed using software development tools to
access the data stored by Microsoft SQL Server. Microsoft SQL Server
2005 now includes the common language runtime [CLR] component
for Microsoft .NET. Applications developed with .NET languages such
as VB.NET or C# can implement stored procedures and other functions.
Older versions of Microsoft development tools typically use APIs
to access Microsoft SQL Server functionality.
Next: Oracle DBMS
Back To Top
The World's Leading Guide To BI Strategy, Program & Technology
Database Index | Relational
Model | Object Model | Other
Models | DBMS | Contextual
Types | Microsoft SQL | Oracle
OODBMS | Data Warehouse | Teradata
ADW | Data Mart | MS
vs Teradata | Development Platforms
| ODBC | JDBC | SMP
| MPP | SN