serving the solutions day and night

Pages

Showing posts with label Azure SQL. Show all posts
Showing posts with label Azure SQL. Show all posts

Wednesday, August 5, 2020

SQL Server Stretch Database

Stretch Database
Data can be split between on-premises and cloud storage. 

With Stretch Database, cold/audit data is kept in the cloud and data remains available for users to
query, might be a small amount of additional latency associated with queries. Data in the cloud is backed up automatically. 

With Stretch Database, active data is kept on-premises for maximum performance and reduce storage requirements both for data and backups (it run quicker than standard backups). 

It requires no changes to new or existing TSQL queries. 


Saturday, April 18, 2020

Azure SQL

Search Azure SQL
3 Options to Choose