Microsoft SQL
Microsoft SQL
Server is a relational database management system. Its
primary query language is Transact-SQL, an implementation of
the ANSI/ISO standard Structured Query Language
(SQL) used by both Microsoft and Sybase.
Microsoft SQL Server uses a variant
of SQL called T-SQL, or Transact-SQL, an implementation of
SQL-92. T-SQL mainly adds additional syntax for use in stored
procedures, and affects the syntax of transaction support.
SQL Server includes support for
database mirroring and clustering. 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. 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 triggers.
Microsoft and other vendors
provide a number of
software development tools designed to allow business
applications to be developed using 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.
We can design and engineer
databases based on your business model and provide tools and
interfaces that can be used to mine your business data. We also
have experience in database persistence and create custom
persistence frameworks and algorythms which can be used to
predict patterns and trends from your data.
Please contact us for more
information.