SQL Server

SQL Server
Database background

Microsoft SQL Server is a relational database from Microsoft. Its origins are in Sybase SQL Server, when Microsoft and Sybase jointly created a version of it for IBM OS/2. When Sybase and Microsoft parted ways, Microsoft reserved the SQL Server name for all releases of the software on Microsoft operating systems. Somewhat ironically, Sybase later had to rename its own product to Sybase Adaptive Server Enterprise to avoid confusion with Microsoft SQL Server.

We support SQL Server directly in our products! You don't need separate drivers and can immediately connect to your database.

While Microsoft SQL Server 7.0 and 2000 still extended and modified the Sybase database server code, starting with SQL Server 2015 Microsoft completely rewrote the codebase, meaning the product no longer contains any original Sybase code.

Microsoft SQL Server is an extremely popular database, with a level of adoption similar to Oracle and MySQL. Oracle is still used more often for the largest enterprise installations, as it was designed from the start as a distributed database system.

SQL Server is the database engine of choice for many Microsoft .NET developers because it integrates tightly with Microsoft Visual Studio and simplifies application development. Starting with SQL Server 2005, SQL Server can even host the Microsoft .NET Framework runtime itself, allowing stored procedures, functions, and triggers to be written in .NET languages such as C# and VB.NET.

One of Microsoft SQL Server’s strengths is the inclusion of powerful business intelligence technologies. These include Analysis Services (for OLAP and data mining), Reporting Services, and Integration Services (ETL tools used for data import, integration, and data warehousing).

SQL Server data types we support

INTEGRAL:
bigintintsmallinttinyint
DECIMAL:
decimal (numeric)doublefloat (real)moneysmallmoney
TEXT:
charncharntextvarchar (sysname)nvarchar(max)textvarcharvarchar(max)
BINARY:
binarybittimestampvarbinary
DATE/TIME:
datedatetimedatetime2datetimeoffsetsmalldatetimetime
LARGE OBJECTS:
geographygeometryimagentextnvarchar(max)textvarbinary(max)varchar(max)xml
OTHER:
dynamicobjecthierarchyidsql_varianttableuniqueidentifier