Updating the PowerShell Kernel in Azure Data Studio

Updating the PowerShell Kernel in Azure Data Studio

In my previous post, I discussed an issue I encountered where comments caused strange issues in a PowerShell notebook in Azure Data Studio. I opened an issue in GitHub about this, and got some very prompt feedback from a member of the team. It turns out I did not have the latest version of the PowerShell Kernel running on my machine. The latest version is currently 0.1.3, and I had 0.1.2. Upgrading appears to have solved this issue for me - yay! This solution also raises the issue that there is no notification from Azure Data Studio that a PowerShell…
Read More
Strange PowerShell Notebook Behavior When Comments Are Involved

Strange PowerShell Notebook Behavior When Comments Are Involved

This is not the blog post I was intending to write. I started off writing about a different topic, and had some code that I wanted to share in a PowerShell Notebook. Getting that notebook to behave like it should have, however, is another story entirely and worthy of its own post - this one. PowerShell Notebooks are a great new feature in Azure Data Studio, first becoming available in the November 2019 release. Like SQL notebooks, PowerShell notebooks are based on Jupyter Notebooks format, which are interactive documents containing text and executable code blocks. Having some working PowerShell code…
Read More
Saving to Excel in Azure Data Studio

Saving to Excel in Azure Data Studio

Azure Data Studio continues to grow on me. I previously wrote about getting my favorite keyboard shortcuts to work, which made me very happy, but now for a feature I love even more - saving result sets to Excel! Yes, I know, spreadsheets can be evil. They can even be places where good datasets go to die, but it's important to remember that they're a necessary evil. Sometimes you just need a result set in a spreadsheet, whether you want it to be in one or not. In SQL Server Management Studio, there's no single-step way to save a result…
Read More
Getting SSMS Keyboard Shortcuts in Azure Data Studio

Getting SSMS Keyboard Shortcuts in Azure Data Studio

Azure Data Studio (formerly Microsoft SQL Operations Studio) is Microsoft's new "cross-platform, lightweight tool for modern database development and operations." It is not a replacement for SQL Server Management Studio (not yet anyway), but I can see it becoming one over time. It is under constant development and improvement, and if you tried it back when it was first released and didn't like it, I urge you to give it another spin. I find myself using it more and more because I really like the feel of it. One thing about Azure Data Studio I'm not too keen about, though,…
Read More