A computer database is a structured collection of records or data that is stored in a computer system. A database relies upon software to organize the storage of data. In other words, the software models the database structure in what are known as database models (or data models) using a Relational database management system (RDMS).
MS SQL Server is a relational database management system (RDBMS) produced by Microsoft. A lot of differents applications can be connected to it (Navision, Project Server, SharePoint, Access, Excel, Internet site...). Its primary query language is Transact-SQL that permits to create triggers and and stored procedures. It also includes a Business Intelligence Development Studio (BIDS) used for developing data analysis solutions utilizing the Microsoft SQL Server Analysis Services, Reporting Services and Integration Services.
Databases