Databases

Create an MSSQL database Add a SQL Server database in the Control Panel; its main user is created automatically. Add database users Create a separate login for each application or a read-only user, and change passwords. Find your connection string Where to copy the connection string for ASP.NET, Entity Framework and other clients. Connect with SQL Server Management Studio Connect to your database remotely from SSMS. Allow remote access to a database Enable connections from outside and restrict them to your IP addresses. Use an encrypted connection (SSL/TLS) Encrypt the connection to SQL Server and fix certificate trust errors. Back up an MSSQL database Create a backup on demand and download the .bak file. Restore an MSSQL database Restore from one of your backups or from a .bak file you upload. Export a local database to a .bak file Prepare a backup of your development database so it can be restored on the hosting. Import a .sql script Run a large SQL script against your database with the Import tool. Run a T-SQL query in the Control Panel Execute ad-hoc scripts with the built-in Run T-SQL editor, and its limits. Increase the disk space of a database Check how much space a database uses and add more when it is full. Tables, database files and shrink See table sizes, reclaim unused space and empty a database. Database uses too much CPU Find and fix the queries that overload your database. View and kill database sessions See open connections and disconnect a stuck application. Check who connects to your database Review logins, IP addresses and applications in the Access log. Schedule a T-SQL task Run a T-SQL statement automatically on a schedule. Dates and time zones The server time zone cannot be changed - how to work with time zones in your application. Change collation and compatibility level What the two settings do and how to change them safely.

Create a MySQL database Add a MySQL database in the Control Panel; its main user is created automatically. Connect to a MySQL database Connection details for your application, MySQL Workbench and other clients. Back up and restore a MySQL database Create backups, download them and restore a database from a file.

Create a PostgreSQL database Add a PostgreSQL database in the Control Panel; its main user is created automatically. Connect to a PostgreSQL database Connection details for your application, pgAdmin and other clients. Back up and restore a PostgreSQL database Create backups, download them and restore a database from a file.

Manage a database in the browser Open WebMSSQL, WebMySQL or WebPGSQL to browse tables and run queries without installing anything. Connect Power BI to your database Use your hosted database as a data source in Microsoft Power BI. Rename a database Set a friendly name and description, or change the real name on the server. Move a database to another region or subscription Change the datacenter or subscription of a database and what happens during the transfer. Delete a database What is removed and how to delete a database safely.