How to work with Python in Azure Data Studio
Learn how to use Python code with Azure Data Studio to work with SQL Server data.
2022-10-03
4,837 reads
Azure Data Studio
Query History and Server Reports in Azure Data Studio
Introduction to Query history and server reports i...
2022-03-14
3,874 reads
The Central Management Servers Extension in Azure Data Studio
Learn how to use Azure Data Studio to access a Central Management Server.
2022-03-07
1,444 reads
How to Compare Tables in Azure Data Studio
Learn about the Schema Compare feature in Azure Data Studio.
2022-02-21
6,880 reads
2022-02-14
3,992 reads
PostgreSQL in Azure using the Azure Data Studio Extension
Learn how to create a PostgreSQL database and work with it from Azure Data Studio.
2022-02-07
2,180 reads
PostgreSQL in Azure Data Studio
Learn how to install PostgreSQL and using Azure Data Studio to work with it.
2022-01-31
4,983 reads
SQL Server Dacpac in Azure Data Studio
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
7,575 reads
Is SQL Server Profiler in Azure Data Studio?
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
4,466 reads
Introduction to SQL Jobs in Azure Data Studio
Learn how to work with SQL Agent Jobs in Azure Data Studio.
2021-12-13
7,000 reads
Blogs
Converting Types in C#
By Steve Jones
I am not a great software developer. I’m OK, and I do know how...
Daily Coping 22 Mar 2023
By Steve Jones
Today’s coping tip is to appreciate your hands and all the things they do...
FIRST Robotics Competition 2023 - World Championships!
By alevyinroc
On to the FIRST Robotics Competition 2023 World Championship Last week I wrote about...
Forums
Query based on sorting based on month
SELECT BusinessEntityID,FirstName,MiddleName,LastName, YEAR(OrderDate) AS OrderYear, DATENAME(MM,OrderDate) AS OrderMonth FROM Person.Person Pp INNER...
SSRS 2017 - SSRS 2019 migration
I am after some advice, I have completed a SSRS migration 2017 - 2019. ...
Fixing a mismatched collation on MSDB
Hi, I've been tasked with finding out why we've been unable to patch the...
Ask SSC