MSSQL

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.