About company Our development services Portfolio. Case studies Support Testimonials Contacts Brutka Ltd: web site development and custom software development

Portfolio


Industry
Software Solution
Application Type
Technology Domain


Phrase of the day


When people begin to philosophize they seem to think it necessary to make themselves artificially stupid.
When people begin to philosophize they seem to think it necessary to make themselves artificially stupid.
Bertrand Russell

MS SQL Server


Microsoft SQL Server is a (RDBMS) relational database management system 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. Today 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.
MS SQL Server uses a variant of SQL called T-SQL, or Transact-SQL, an implementation of SQL-92 (the ISO standard for SQL, certified in 1992) with some extensions. T-SQL mainly adds additional syntax for use in stored procedures, and affects the syntax of transaction support. (Note that SQL standards require Atomic, Consistent, Isolated, Durable or "ACID" transactions.) MS SQL Server and Sybase/ASE both communicate over networks using an application-level protocol called Tabular Data Stream (TDS). The TDS protocol has also been implemented by the FreeTDS project [2] in order to allow more kinds of client applications to communicate with MS SQL Server and Sybase databases. MS SQL Server also supports Open Database Connectivity (ODBC).
Microsoft's primary competition includes Oracle and IBM DB2. Microsoft is currently ranked third in revenue marketshare among these major database vendors considering all platforms, though it sells more than its competitors considering only the Windows market.[4]

A major competitive differentiator is that SQL Server runs solely on Microsoft Windows-based operating systems. As a result, the relative strength and viability of SQL Server is directly affected by the relative strengths and weaknesses of the Microsoft platform, unlike Oracle and DB2 which both run on numerous platforms, including Windows and Linux. IBM tends to fare decently in the mid-range market and dominates the high-end market, particularly with its z/OS version of the DB2 database, which is preeminent for enterprise OLTP[citation needed]. However, many large organizations run two or even all three of these vendors' products in some combination. Other commercial competitors include Teradata, Sybase, IBM Informix, and Adabas.

Recently, open source cross-platform databases such as MySQL, PostgreSQL and Firebird have further increased the competition among database vendors. These databases offer no-cost and low-cost licensing and, for many clients, offer enough functionality for their database needs. Microsoft has offered a free version of its database (SQL Server Express Edition in version 2005, MSDE in prior versions). Both Oracle and IBM now also offer free versions of their databases — 10g Express Edition and DB2 Express-C, respectively.

More about MS SQL Server >>