| Table of Contents |
|---|
SQL Server editions
...
- SQL Server 2014
- SQL Server 2016
- SQL Server 2017
- SQL Server 2019
- SQL Server 2022
- Azure SQL Database
- Azure SQL Managed Instance
...
First of all, in order to check if the SQL Server Agent service is running on the SQL server and for storing historical index usage for optimal maintenance, the user needs the View Server State permission for the SQL server.
...
- SQL Server
- SQL Server Browser if named instances are used
- SQL Server Agent to run the maintenance jobs (not available on Express Edition and Azure SQL Database)
Language, collation,
...
case sensitivity, and other settings
- The user account, configured in Verba to access the database (SQL Server user or domain user) must have the Default Language configured to English. For more information on creating a login and configuring the default language, see https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/create-a-login
- The system supports any collation with the following requirements:
- The system does not support Case Sensitive (CS) databases, nor servers, the collation has to be Case Insensitive (CI) and the Server has to be Case Insensitive (CI) too.
- Other collation configuration options can be specified according to the specific requirements
For more information on collation, see https://docs.microsoft.com/en-us/sql/relational-databases/collations/collation-and-unicode-support
- The Recursive Triggers Enabled configuration must be False
Azure SQL Requirements and Limitations
| Azure SQL Database | Azure SQL Managed Instance | |
|---|---|---|
| Authentication | Only SQL Server authentication is supported | Only SQL Server authentication is supported |
| SQL Agent Job | Not supported, jobs will be executed by the web application | Supported |
| Linked Server | Not supported | Supported |
| Max database size | https://learn.microsoft.com/en-us/azure/azure-sql/database/resource-limits-vcore-single-databases?view=azuresql | Up to currently available instance storage size (depending on the number of vCores). https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits?view=azuresql |
| Max tempdb size | https://learn.microsoft.com/en-us/azure/azure-sql/database/resource-limits-vcore-single-databases?view=azuresql | General Purpose: Limited to 24 GB/vCore Business Critical: Up to currently available instance storage size https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/resource-limits?view=azuresql |
...