Intro
T-SQL on Azure — It’ a kind of magic in Data Engineering world.
I love Queen, but could you use T-SQL as Data Engineer? I think, I can help you.
You can use loops and conditional statements in T-SQL. Only ?
The answer is NO!
But what else ?
So, we can draw maps, prepare and query XML files, create reports and much more.
Start
If you want to follow me please read Microsoft Article about how to design a relational database in a single database within Azure SQL Database https://docs.microsoft.com/bs-latn-ba/azure/sql-database/sql-database-design-first-database.
In this tutorial, you learn how to use the Azure portal and SQL Server Management Studio (SSMS) to:
- Create a single database using the Azure portal
- Set up a server-level IP firewall rule using the Azure portal
- Connect to the database with SSMS
- Create tables with SSMS
- Bulk load data with BCP
- Query data with SSMS
Here I am using the same database. So, create database or only read the article and let’s go!
