X-Nico

4 unusual facts about Microsoft SQL Server


FIT Issue Management

It features a proprietary flat file database, but can also connect to any JDBC compliant database such as Oracle, MySQL and MS-SQL with the optional database module.

Grendel's Cave

Grendel's Net conducted their development as an experiment in Classic ASP and Microsoft SQL 6.0 programming for the World Wide Web.

SQL Server Pro

SQL Server Pro, however, focuses more on Microsoft's relational database management system than Windows IT Pro, which has a broader focus.

Standard Compression Scheme for Unicode

SQL Server 2008 R2 uses SCSU to compress Unicode values stored in nchar(n) and nvarchar(n) columns, achieving space savings between 15% and 50%, depending on the language of the data.


Advanced Query Tool

Data Base Management Systems of which AQT is aware of the catalog structure include IBM DB2, Oracle, Microsoft SQL Server, Postgres, MySQL, Sybase, and Informix.

Business Intelligence Development Studio

Business Intelligence Development Studio (BIDS) is the former IDE from Microsoft, and was used to develop data analysis and Business Intelligence solutions utilizing the Microsoft SQL Server Analysis Services, Reporting Services and Integration Services.

Business Intelligence Markup Language

Biml authored BI assets can currently be used by the BIDS Helper add-on for Microsoft SQL Server Business Intelligence Development Studio (BIDS) and the Varigence Mist integrated development environment; both tools translate Biml metadata into SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) assets for the Microsoft SQL Server platform.

CollabMobile

It supports connection to following data sources: MSSQL Server, Oracle, PostgreSQL, MySQL, SQL Server Analysis Services, Microsoft Excel, Amazon Redshift, CSV files.

Electronic discovery

The most common are Relational Database Management Systems (RDBMS) that are capable of handling large volumes of data such as Oracle, IBM DB2, Microsoft SQL Server, Sybase, and Teradata.

Forte 4GL

Being an enterprise application development system, Forté 4GL supported close linkage to a number of different relational database systems, including Oracle, Sybase, Microsoft SQL Server, Informix, and DB2.

Honker Union

As proof of concept exploit code for the SQL Server bug utilised by SQL Slammer, written by David Litchfield, was found in the Honker Union website, it was speculated that the worm was spread by Honker Union.

Microsoft COM+ IMDB

Microsoft's COM+ division's IMDB solution never made it passed Windows 2000 Beta release, because it was squelched by Microsoft's SQL Server division.

NetVault Backup

An enterprise solution, it supports many server, application platforms and protocols such as UNIX, Linux, Mac OS X, Microsoft Windows, VMware, Microsoft Hyper-V, Oracle, Sybase, Microsoft SQL Server, NDMP, Oracle ACSLS, IBM DAS/ACI, Microsoft Exchange Server, DB2, Informix, MySQL, Lotus Domino, and Teradata.

OpenPDC

These adapters can be configured using any one of three supported database systems: Microsoft SQL Server, MySQL, and Microsoft Access.

Randall C. Kennedy

Kennedy discovered an undocumented change in the protocol used by the Microsoft SQL Server Net-Lib component from named pipes to TCP/IP in Microsoft Data Access Components 2.6 that was fixed in the subsequent version 2.7).

SQLObject

SQLObject supports a number of common database backends: included in the distribution are MySQL, PostgreSQL, SQLite, Sybase SQL Server, MaxDB, Microsoft SQL Server and Firebird.


see also

Belfield, Dublin

Only some specialized activities remained until recently in Dublin, such as: IT support for Bank of Ireland and Microsoft PSS, the Premier and Professional Support service center for Microsoft on Windows Core and Platform, Exchange, Microsoft SQL Server and SharePoint products.

SRID

In spatially enabled databases (such as IBM DB2, IBM Informix, Microsoft SQL Server, MySQL, Oracle, Teradata, PostgreSQL and SQL Anywhere), SRIDs are used to uniquely identify the coordinate systems used to define columns of spatial data or individual spatial objects in a spatial column (depending on the spatial implementation).

SSMS

SQL Server Management Studio, a tool for configuring, managing, and administering all components within Microsoft SQL Server

VI Technology

The enterprise test solution consists of a server module built on Microsoft SQL Server database with extensions for SQL Server Reporting Services and interfaces to standard automated test software including National Instruments LabVIEW, TestStand, LabWindows/CVI, and Microsoft Visual Studio .