The image below is an example of an Azure SQL database configuration used with the SiteAudit Data Publisher.

The important things to note about the configuration is that is uses a General Purpose tier database that is Serverless. This is the most cost-effective choice. Additionally, ensure that the Auto-pause delay is configured to reduce cost when the database is not in use. The recommendation is to configure this for 1 hour, meaning that the database will be paused after 1 hour of inactivity. The database will become active when it is accessed; however, it will take approximately 1 minute after it is first accessed to become active.

The database size and cores can be configured as shown in the image below and adjusted as needed. It is recommended to periodically review the database size and this can be increased/reduced based as needed.

Azure SQL Database Connection String

The SiteAudit Data Publisher requires the SQL connection string to know where to publish data. This can be obtained from the Azure SQL database overview. Share this information with your SiteAudit administrator.

Sample SQL database connection string
"ConnectionString": "Server=myazureserver.database.windows.net,1433;Initial Catalog=mycustomer;Persist Security Info=False;User ID=myuser;Password=mypassword;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"

Azure SQL Database Configuration