When we're considering SQL Server deployment, we can use SQL Server either on-premises or in the cloud as a service. There are several different cloud offerings for SQL Server. We'll concentrate on the offerings in Microsoft Azure. Azure SQL Database is a managed cloud database, which went live around 2010. SQL Database is available as:
- A single instance
- A managed databases in elastic pool
- A managed instance
Azure SQL Database shares the code with the SQL Server Database engine, which allows for a code compatibility to some extent (some features or code are not available in the cloud service). While the on-premise SQL Server requires manual patching and upgrades to deliver new features, those are seamlessly delivered ...
