4 ms·
>SQL Server... There's an annoying difference between 'Azure SQL Database' and 'Azure SQL Managed Instance'. I recall the Managed Instance does support timezon
by yyyk 3y ago
>SQL Server...
There's an annoying difference between 'Azure SQL Database' and 'Azure SQL Managed Instance'. I recall the Managed Instance does support timezones and SSAS, while the ordinary offering also misses other useful stuff like Resource Governors.
- jiggawatts 3y agoManaged instance has time zones, but not SSAS. It does have SSIS, but only via Azure Data Factory. This means you need additional VMs and the performance is much worse because there’s always an extra network hop.