MS SQL

What’s the cost of a Microsoft SQL database?

For Microsoft SQL databases, there is a £9.99 monthly charge for a 1GB database. This covers the Microsoft licensing cost.

How do I manage my Microsoft SQL database?

We recommend using SQL Server Management Studio (SSMS) for managing your Microsoft SQL databases.

This industry-standard software provides a comprehensive environment for Microsoft SQL database creation, access, configuration, development, and other management features. It includes a variety of components including visual database tools, code and text editors, object management, boilerplate text management, and more. With SSMS you can deploy, monitor, and upgrade the data-tier components used by your applications, as well as build queries and scripts.

SSMS also helps you download and back up your MS SQL databases, which we recommend you do at regular intervals in the interests of best practice security.

You can download the software for free on the Microsoft SSMS download page.

To connect remotely you will need to use Server 'mssql.gigocp.com'.

What is MS-SQL?

Microsoft SQL Server is a relational database management system (RDMS) developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications. These applications may run either on the same computer or on another computer across a network, such as the internet.

A relational database management system means two things. First, data stored inside SQL Server will be housed in a 'relational database', and second, the SQL Server is an entire 'management system', not just a database. SQL itself stands for Structured Query Language. This is the language used to manage and administer the database server.