Creating a SQL Azure database
To do ETL, we need to have a source to query data and a target (often called a sink) to land the transformed data. Our first recipe will create a simple SQL Azure database that will be used as both the source and sink in all recipes of this chapter.
Getting ready
In Chapter 1, Getting Started with Azure and SSIS 2019, you were shown how to install SQL Server on-premises, SQL Server Management Studio (SSMS), and Visual Studio 2019 with the SSIS extension. This chapter will show you how to set up SQL Server in Azure and the recipes will use this version of SQL Server.
How to do it…
In a browser, go to the Microsoft Azure portal using the following URL: https://portal.azure.com/#home.
On the main portal page, we'll create a resource group to group all Azure services together. It's much easier to find and manage them later.:
- From the main portal page, click on the + sign to create a new resource, as shown in the...
