SQL Server

The latest articles related to SQL Server

SQL Server Integration Services – Extensibility and programmability

Users may write code to define their own connection objects, log providers, transforms, and tasks. SSIS features a programmable object model that allows developers to write their own hosts for package execution. Such a host can respond to events, start and stop packages, and so on. The object model also allows developers to create, store, [...]

Professional Association for SQL Server – Introduction

Professional Association for SQL Server, also known as PASS, is the global community for Microsoft SQL Server professionals. An independent, not-for-profit, user-run association, PASS was founded in 1999 with funds from Microsoft and Computer Associates. PASS is run by a Board of Directors, elected by PASS members for two-year terms. There are currently over 200 [...]

Partial index – Support

In SQL Server, this type of index is called a ”filtered index”. Partial indexes have been supported in PostgreSQL since version 7.2, released in February 2002. MySQL as of version 5.4 does not support partial indexes. Adapted from the Wikipedia article Partial index, under the G. N. U. Free Documentation License. Please also see http://en.wikipedia.org/wiki

PCBoard – PCBoard Metaworlds

Metaworlds was an attempt by CDC to establish a BBS-like environment on the Internet, basically a closed mailbox in HTML format online. Access to the content was only possible for registered users who had to authenticate themselves with username and password to access the system. Metaworlds supported the parallel operation with the standard ANSI based [...]

Microsoft SQL Server – Tools

SQLCMD SQLCMD is a command line application that comes with Microsoft SQL Server, and exposes the management features of SQL Server. It allows SQL queries to be written and executed from the command prompt. It can also act as a scripting language to create and run a set of SQL statements as a script. Such [...]

Microsoft SQL Server – Programmability

T-SQL T-SQL (Transact-SQL) is the primary means of programming and managing SQL Server. It exposes keywords for the operations that can be performed on SQL Server, including creating and altering database schemas, entering and editing data in the database as well as monitoring and managing the server itself. Client applications that consume data or manage [...]

Liberum Help Desk – Features

* Completely web-based interface * Windows authentication or integrated database authentication * E-mail updates with case notes and solutions * Automatic case routing base on ticket category * Reporting on support rep activity and case categorization * Written in Active Server Pages and VBScript * May use Microsoft SQL Server or Microsoft Access as a [...]

Microsoft Dynamics NAV – Features

As of 2006, NAV is licensed using the “Business Ready License” (BRL) model. The customer purchases user sessions, which have access to certain parts of the system included. There are two types of user – Business Essentials (BE) and Advanced Management (AM); AM provides access to more functionality than BE. Under the previous licensing model, [...]

Autocomplete – In database query tools

Autocompletion in database query tools allows the user to autocomplete the table names in an SQL statement and column names of the tables referenced in the SQL statement. As text is typed into the editor, the context of the cursor within the SQL statement provides an indication of whether the user needs a table completion [...]

Tabular Data Stream – Introduction

Tabular Data Stream (TDS) is an application layer protocol, used to transfer data between a database server and a client. Initially designed and developed by Sybase Inc. for their Sybase SQL Server relational database engine in 1984, and later by Microsoft in Microsoft SQL Server. Adapted from the Wikipedia article Tabular Data Stream, under the [...]









Go To Top »