Category Archives: Azure SQL Database

Migrate from on-prem SQL server to Azure SQL Database

This blog describes the various approaches you can use to migrate an on-premises SQL Server database to Azure SQL Database. In this migration process you migrate both your schema and your data from the SQL Server database in your current … Continue reading

Posted in Azure SQL Database, SQL Server, SQLServerPedia Syndication | 2 Comments

HA/DR for Azure SQL Database

Azure SQL Database is a relational database-as-a-service in the cloud.  It uses a special version of Microsoft SQL Server as its backend that is nearly identical to SQL Server (see Azure SQL Database Transact-SQL differences).  While there are many benefits … Continue reading

Posted in Azure SQL Database, SQLServerPedia Syndication | 2 Comments

Copying data from Azure Blob Storage

In a previous blog I talked about copying on-prem data to Azure Blob Storage (Getting data into Azure Blob Storage).  Let’s say you have copied the data and it is sitting in Azure Blob Storage (or an Azure Data Lake) … Continue reading

Posted in Azure, Azure SQL Database, Azure SQL DW, Data Lake, PolyBase, SQLServerPedia Syndication | Comments Off on Copying data from Azure Blob Storage

Creating a large data warehouse in Azure

Microsoft Azure provides you two options when hosting your SQL Server-based data warehouse: Microsoft Azure SQL Database and SQL Server in Azure Virtual Machine.  Which one is appropriate based on the size of the data warehouse?  What are some hardware features to … Continue reading

Posted in Azure, Azure SQL Database, Data warehouse, SQLServerPedia Syndication | 8 Comments

SQL Azure (renamed Microsoft Azure SQL Database)

SQL Azure is a cloud-based service from Microsoft that uses a special version of SQL Server as its backend.  SQL Azure helps to ease provisioning and deployment of multiple databases.  Developers do not have to install, setup, patch or manage any … Continue reading

Posted in Azure SQL Database, SQLServerPedia Syndication | Comments Off on SQL Azure (renamed Microsoft Azure SQL Database)