A Fine Slice Of SQL Server
Taiob Ali shows us how you can hide the results and messages panes in Azure Data Studio:
I know CTRL+R works for the same when using SQL Server Management Studio (SSMS). That hotkey did not work in Azure Data Studio (ADS). Knowing how brilliant technologists Derik is, I realized that a standard google search will not work.
I know ADS is an open-source project. Someone might have requested this feature already.
That functionality is in there, as Taiob shows.
Comments closedHasan Savran builds an Azure Data Studio notebook to query SQL Server from Python:
SQL Kernel is the default language, to query database with Python change SQL to Python 3. Probably, you will see the following message if this is the first time you are trying this. You need to install Python packages to be able to run python scripts. I have Visual Studio installed on my machine and I already have Python, I taught I could to use it by clicking “Use existing Python installation”. I was wrong, I couldn’t. This option looks for local installation files and when I point to Visual Studio Python files, it throws error in the middle of the installation. So, I will ignore this option for now.
In ADS, I haven’t gotten “Use existing Python location” to work either, so Hasan’s not alone in that regard.
Comments closedKevin Chant points out a change to Azure Data Studio:
I talked about the using the wizard in the Insiders build to deploy Big Data Cluster in that post. You can read that post in detail here.
Now, as well as deploying Big Data Clusters you can also use the wizard to deploy SQL Server container images locally using Docker.
Read on for notes about the process.
Comments closedRob Sewell inverts the “Use Azure Data Studio to create Powershell notebooks” mantra:
This module contains only 3 commands at present
* Convert-ADSPowerShellForMarkdown
This will create the markdown link for embedding PowerShell code in a Text Cell for a SQL Notebook as described in this blog post
* New-ADSWorkBookCell
This command will create a workbook text cell or a code cell for adding to the New-ADSWorkBook command
* New-ADSWorkBook
This will create a new SQL Notebook using the cell objects created by New-ADSWorkBookCell
Click through for an example.
Comments closedAaron Nelson announces a new feature in Azure Data Studio:
In order to get all the nice intellisense and tab completion features of the PowerShell language inside your PowerShell Notebooks, be sure to install the PowerShell extension from the Azure Data Studio marketplace.
At this point, the biggest remaining language is R, though I’d love to see F# support as well (hey, Azure Notebooks offers F# support).
Comments closedDave Bland takes us through some of the formatting options available in Azure Data Studio notebooks:
When working in a Notebook you have two types of cells, text and code. The focus of this post is how to format the text cell. Of course text goes into this cell so that part is easy and of course the text can say anything you would like to say. When we work with text in Word, there is a format tool bar that we can use to make it look like we want it. The text cells do not have this toolbar.
You might be asking, without the format toolbar, does that mean we can’t format the text? That answer is no….we can still format the text, we just need to do it slightly different. Rather than use a toolbar, we need to use characters.
There’s a lot of power in Markdown.
Comments closedAlan Yu announces the newest release of Azure Data Studio:
With the November release of Azure Data Studio, we have added three key features:
– PowerShell kernel support
– Collapsible code cells
– Output toolbar for save output actions
There are plenty of other additions as well. Adding Powershell kernel support is interesting…but I still want F#.
Comments closedDave Bland shows how you can keep from losing code when you close Azure Data Studio:
After working on a query for a long time, we want to make sure that we save the changes we have made. I have lost hours of work over the years because I didn’t save the changes. Azure Data Studio has a few features that can help prevent this from happening.
Read on to learn how. With SSMS, this had historically been the domain of third-party plugins, but it’s built into VS Code and ADS.
Comments closedDave Bland shows how you can find out-of-date extensions in Azure Data Studio:
As you add more and more extensions to Azure Data Studio, keeping them up to date could present a challenge. Of course we will want to install all the extensions that we think might be helpful to us. Luckily Azure Data Studio has a nice way to let us know if there is an extension that is out of date.
Click through to see how.
Comments closedAlan Yu announces the October 2019 release of Azure Data Studio:
While fixing a bug involving copying rows and columns from the results grid, we ended up creating an innovative copy/paste experience with the results grid.
Typically, when you select random cells individually, pasting this into a grid like in Excel will prevent the pasting. However, we’ve implemented a logical pattern that would support this type of pasting. This works by ignoring columns and rows that are not selected, and nulling columns and rows that were not included in the copy parameters.
I really like that copy-paste functionality. Time to go update…
Comments closed