A Fine Slice Of SQL Server
In Feb 2021 release, Azure Data Studio (v1.26.1) has added parameterized URI execution. See the “Preview of passing parameters through URI” section and the Parameterization of Notebooks in Azure Data Studio on Microsoft Docs.
So, in total there are three ways of executing parameterized notebook (from another notebook). Check out the demo files here:
Click through for the notebooks.
Comments closedSteve Jones shares some advice:
I really like Visual Studio Code. The more I use it, the more I get comfortable in it, and the more I appreciate the design and flow of using the editor. I didn’t feel that way early on, preferring the comfort of Visual Studio, but now I most often use VS Code.
The other day I saw an article from one of the PMs for the product, with a number of tips and tricks. I like some of these, and have already found a few to be handy in my work.
Click through for more info. Switching to a new IDE can be challenging, but searching out tips and tricks like this can smooth out the transition period bumpiness and potentially unlock efficiencies you wouldn’t even have known about.
Comments closedAlan Yu announces the February 2021 release of Azure Data Studio:
The key highlights to cover this month include:
– Added new notebook improvements
– Added improvements to Azure Arc extension.
– New extension updates.
– Bug Fixes.For a list of complete updates, refer to the Azure Data Studio release notes.
Click through for details on each of these.
Comments closedDeborah Melkin contrasts SQL Server Management Studio with Azure Data Studio:
Honestly, the vast majority of my time is split between Management Studio (SSMS) or Azure Data Studio. I’m pretty simple\straightforward this way. I started playing a lot more with Azure Data Studio over the past year, but I find I’m not able to make the switch to using it full time. It really depends on the task that I need to do.
So what tasks do I do often and which tool do I use?
The plus side for Azure Data Studio is that it’s far enough along that some of these choices are difficult to make. The minus side is that it’s still often on the losing end. I’d expect that shift to continue over the next couple of years as the product matures and becomes a good product for database developers.
Comments closedElizabeth Noble continues a series:
I’ve been spending the past couple of weeks going over how to add your database to source control using Azure Data Studio and Database Projects. This week I show you how you can build and deploy your Database Projects using Azure Data Studio.
Click through for the video.
Comments closedElizabeth Noble continues a series of videos on database projects in Azure Data Studio:
This week, we’ll talk about one of the easier ways to deploy your database changes. One of the benefits of database projects is that they can generate data-tier applications (DAC). The data-tier applications can be bundled into what is called a DACPAC. This is a collection of files that can be used to deploy your database.
Click through for the video.
Comments closedJulie Koesmarno shows us the rules of linking notebooks in Azure Data Studio:
When writing a notebook, it can be very handy to be able to refer to a specific part to a notebook and allow the readers to jump to that part, i.e linking or anchoring. Using this technique, you can also create an index list or a table of contents or cross-referencing to parts of other notebooks too. Check out my demo notebook for this linking topic, from MsSQLGirl Github Repo.
Read on for those rules.
Comments closedElizabeth Noble has a new video for us:
In this week’s YouTune video, I show how you can clone (import) a repository (database code) from GitHub all within Azure Data Studio. This is a great feature that helps make database source control more accessible to individuals who may not have access or be comfortable using Visual Studio or VS Code.
Click through for the video.
Comments closedDrew Skwiers-Koballa gives us an update on where SQL Server tooling is at:
The December releases of Azure Data Studio 1.25 and SQL Server Management Studio (SSMS) 18.8 are now generally available. Additionally, the mssql extension for Visual Studio Code has recently been updated to version 1.10.0. Read on to learn more about each of these updates and grab the latest versions of SSMS, Azure Data Studio, or the mssql extension for VS Code.
Read on to learn more.
Comments closedJulie Koesmarno shows off some new functionality in Azure Data Studio:
This blog post covers examples of cross-cluster and cross-service querying, including handy syntax, code snippets and notebooks that you can use in Azure Data Studio.
As some of you may already know, Kusto (KQL) extension is available in Azure Data Studio, which allows you to explore Azure Data Explorer (ADX) more natively. ADX also supports cross-cluster and cross-service queries between ADX, Azure AppInsights and Azure Log Analytics. This cross- service query preview feature is documented in Query data in Azure Monitor using Azure Data Explorer.
Click through for the demos.
Comments closed