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,601 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,053 reads
Learn how to work with SQL Agent Jobs in Azure Data Studio.
2021-12-13
9,714 reads
Learn how you can get better charting in Azure Data Studio with SandDance.
2021-12-06
2,473 reads
Learn about the history and different versions of Integration Services (SSIS) in SQL Server.
2021-11-12
8,981 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,665 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,109 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)
2,994 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,420 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,562 reads
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I have an application team that is insisting on daily (and for some, weekly)...
i see this in the definition of a linked server on our wh sql...
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers