Introduction This article will introduce you to the SQL Server Dacpac in Azure Data Studio. We will also learn about the Bacpac. In the Azure Data Studio, we have an extension named SQL Server Dacpac which allows us to deploy, extract Dacpacs, create a database from a Bacpac and export a schema and data to […]
2022-01-17
12,734 reads
Introduction Do we have the SQL Profiler in Azure Data Studio? In a previous article, we compared SSMS and Azure Data Studio. Now we will compare the new SQL Profiler against the old one. If you check the SQL Server Profiler documentation, you will find that SQL Profiler is deprecated and that that feature will […]
2021-12-20
5,066 reads
Learn how to work with SQL Agent Jobs in Azure Data Studio.
2021-12-13
9,795 reads
Learn how you can get better charting in Azure Data Studio with SandDance.
2021-12-06
2,481 reads
Learn about the history and different versions of Integration Services (SSIS) in SQL Server.
2021-11-12
9,060 reads
Introduction I have to admit that I love SSMS. It is a great tool, and I felt furious when a colleague mentioned that Azure Data Studio will replace SSMS in the long run. In this new article, we will talk about the main differences between Azure Data Studio and SSMS. We will see if my […]
2021-11-10
24,904 reads
In this article, we will learn how to work with PolyBase using Azure SQL DWH.
2020-12-25 (first published: 2017-08-21)
3,116 reads
In the part 18, we created a Cube based on the Azure Data Warehouse. In this new chapter, we will work with the cube, create backups and show some tips to restore.
2020-05-29 (first published: 2017-10-23)
3,002 reads
In this new article, we will learn how to create a cube extracting data from ADWH.
2020-05-22 (first published: 2017-10-09)
2,423 reads
This time we will compare different solutions to copy system folders using different SSIS tasks.
2019-11-22 (first published: 2017-05-09)
13,594 reads
By Steve Jones
This is my last week of the year working (I guess I come back...
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
I am getting the below error when I execute a SQL command in SQL...
I am getting the below error when I execute a SQL command in SQL...
Hi everyone. I have this table and this information. (left side of the image)...