A server-side software application that enables databases conformant to a relational data model to be created, managed and queried. Information, most commonly text may be stored as one or more records contained within a table. The table may exist in isolation or have some relationship to other tables. Information may be manipulated using a set of T-SQL or ANSI SQL commands. Several editions of SQL Server are available, including SQL Server Compact, Developer, Embedded, Enterprise, Evaluation, Express and Fast Track.
- Service Broker
- Replication Services using transaction, merge, or snapshot replication
- Analysis functionality to perform data mining, OLAP and other services
- Report generation services
A&H use case 1 description:
The Dafydd ap Gwilym project used an SQL Server 2000 database to store poetry written by the 14th Century Welsh poet, Dafydd ap Gwilym.
A&H use case 2 description:
The Beazley Archive has used Microsoft SQL Server 2000 to publish a database of Athenian figure-decorated pottery created between 626BC and 300BC.
A&H use case 3 description:
The Italian Academies project has used Microsoft SQL Server 2000 to store and publish information on Italian Academies of the late Renaissance and early modern periods (1530-1650) and their relationship to book production, printing and publishing in this period.
Data structuring and enhancement:
Software/programming languages used: