Tag "SSDT"

Synapse 0 Comments

Synapse Analytics workspace – deployment challenges

Azure Synapse Analytics is not just “another service” in the Azure. It’s very comprehensive set of tools rather than one-goal-tool (like Azure Key Vault or even Storage Account). On the

SSDT: Scripting static data from SQL Server (video)

Out of the box, SSDT covers objects on a database level, like tables, stored procedures, views, functions, etc. That means schema only. In many cases, there is a need to

DevOps 10 Comments

Deployment of Microsoft SQL database with Azure DevOps

Hello, data folks! I have published several articles about databases and their maintenance in SSDT project on the blog. One of the posts explained step by step how to import

Last Week Reading 0 Comments

Last Week Reading (2019-11-10)

Hello all! An extraordinary week has just passed. Two big conferences took place in the USA, PASS Summit and Ignite, where Microsoft announced plenty of new products or updates. Keynotes

Script and deploy the data for database from SSDT project

This post is a part of the series about SSDT and database project leveraging Visual Studio. We already know that SSDT can cover all objects but only on a database

DevOps 0 Comments

SSDT (SqlPackage) thread crashes with error when publishing

In this post, I will show you one of the scenarios when SSDT (SQL Server Data Tools) can fail unexpectedly while publishing database project to target server or preparation of

Last Week Reading 0 Comments

Last Week Reading (2018-12-23)

The Christmas is coming. But before we start the festive time and sit down to the Christmas Eve dinner – a few articles to feed up our brains (before we

Last Week Reading 0 Comments

Last week reading (2018-11-11)

Hello folks, how are you today? It was a very comprehensive week and many of my friends returned home after PASS Summit. As always, PASS Summit is the event where you

DevOps 10 Comments

How to create DACPAC file?

In this post, I will explain what the DACPAC is and how to create it. In the previous post in DevOps series, I described how to create a new, empty

SQLSaturday 1 Comment

SQLSaturday #656 Denmark – we were there!

It was a great weekend in Copenhagen. Kamil and I had the opportunity to give lectures during #656 SQL Saturday. I started in the morning talking about the U-SQL and

  • 1
  • 2