Figure 1. In the above demo, I included all the tables in my Azure SQL Database (AdventureWorksLT) and asked Copilot to build a query to show me sales by sales rep and product color.

You also don't have to specify a name for your history table, but anonymous tables make me uncomfortable so I've assigned the name SalesOrderHistorical to my table. In Azure SQL Database you can also ...

If organizations use zone-redundant databases with the Azure SQL Database service under the Business Critical tier (also known as "Premium"), then they can now be eligible for a 99.995 percent SLA.