Blog about Microsoft Data Platform and Azure cloud. Powered by seeQuality sp. z o.o.
We continue our adventure with the Visual Studio database project. Today, we’ll take a look at the sqlpackage.exe tool, which will allow us to automate the deployment of the project to the target Microsoft Fabric warehouse. I warmly invite you and, from here, encourage you to subscribe to stay up-to-date with our materials. Before we […]
We continue our adventure with the Fabric Warehouse and database project in Visual Studio Code. In the first part, we discussed how to create a database project, add changes to it, and publish them to the target server. Today, we’ll expand on this concept a bit and explain how to use pre-deployment and post-deployment scripts—welcome […]
Nowadays, it has become standard to develop database solutions for Microsoft Fabric Warehouse, SQL Server or Azure SQL using Visual Studio Code. This tool with its extensions, when combined with version control systems like Git, provides not only a stable but also an efficient working environment. In this article, I will demonstrate how to set […]
One of the common questions that come from data warehouse developers when they switch to a lakehouse approach in Microsoft Fabric or Azure Databricks is “how to restore our solution”. It is a pretty important question because in the old days of relational databases, it was very easy to restore, and sometimes this technique was […]