Category: Azure Data Studio

Alan Yu announces a new release of SQL Operations Studio:

SQL Operations Studio was announced for Public Preview on November 15th at Connect(), and this August release is the ninth major update since the announcement. If you missed it, the July release announcement is available here.

Highlights for this release include the following.

• Announcing the SQL Server Import extension

• SQL Server Profiler Session management

• New community extension: First responder kit

• Quality of Life improvements: Connection strings

• Bug bash galore

That’s a nice set of improvements this month.

Jay Robinson shows how you can configure SQL Operations Studio to run Powershell with the click of two buttons:

As I’ve used SQL Operations Studio more and more, I’ve also been finally using PowerShell in more situations. Given that I like the editor and that there’s a built-in terminal, I’ve been running those in my Ops Studio instance. But for a while I didn’t have a slick way of running an entire PowerShell file in the terminal. Usually, I’d just Ctrl+A/Ctrl+C/Ctrl+V, which is a bit awkward.

But among all the other ways you can customize Ops Studio, you have a lot of control over the key mappings. One way to edit these mappings is to pull up the Command Pallette (Ctrl+Shift+P) and start typing “key”, and you’ll see “Preferences: Open Keyboard Shortcuts”. You’ll also see it mentions the Ctrl+K/Ctrl+S shortcut. This will bring you to the basic Keyboard Shortcuts window, where you’ll need to click “keybindings.json”. Either way, just like Ops Studio’s overall settings (and VSCode’s, for that matter), you get a JSON file you can now tweak. Actually, two of them, with the defaults on the left and your own settings on the right.

Read on to see Jay’s mapping and an explanation of what he’s doing.

Kendra Little gave a quiz on SQL Operations Studio and is now sharing the answers:

Question 2: To toggle a BLOCK comment, the built-in shortcut is…

Answer: Shift+Alt+A

• Correct: 43 (27%)
• Incorrect: 118 (73%)

I think a lot of folks who use SSMS regularly and don’t use VSCode may not know what I meant by the question, because SSMS doesn’t have this functionality (or if it does, I’ve never figured out the shortcut!)

Check out all of the answers and build up those SQLOps skills.

Kendra Little shows how you can change the code highlight color in SQL Operations Studio:

One of my major uses of SQL Ops studio will be demonstrating code in webcasts and videos, so it’s important to me to be able to set a high-contrast highlight for lines of code.

SQL Ops Studio is based on VSCode, which is very flexible, so I suspected there was a way to do this already. Also, there is a lot of documentation out there on VSCode already, so I searched on “VSCode change highlight color” to help find my way to the solution.

But I figured that lots of folks starting out with SQL Ops Studio may not know that, and that this post might be a good introduction to how to change things like this – as well as how to find things by searching for “vscode”!

Good info.

Alan Yu announces the June release of SQL Operations Studio:

The June public preview release is focused on improving our Extensibility experience with the release of new extensions as well as addressing top GitHub issues.

Highlights for this build include the following.

• SQL Server Profiler for SQL Operations Studio Preview extension initial release

• Azure SQL Data Warehouse extension

• Edit Data Filtering and Sorting

• SQL Server Agent for SQL Operations Studio Preview extension enhancements for Jobs and Job History views

• Build your own SQL Ops Studio extension

• Visual Studio Code Refresh

• Fix GitHub Issues

I saw “SQL Server Profiler” and started wondering what was going on, until Alan explained that it’s actually the lightweight Extended Events profiler and not the heavyweight beast we know and love and/or hate.

Alan Yu announces the latest release of SQL Operations Studio:

Highlights for this build include the following.

• Announcing Redgate SQL Search extension available in Extension Manager

• Community Localization available for 10 languages: German, Spanish, French, Italian, Japanese, Korean, Portuguese, Russian, Simplified Chinese and Traditional Chinese!

• GDPR-compliant build has reduced telemetry collection, improved opt-out experience and in-product links to Privacy Statement

• Extension Manager has improved Marketplace experience to easily discover community extensions

• SQL Agent extension Jobs and Job History view improvement

• Updates for whoisactive and Server Reports extensions

• Fix GitHub Issues

Click through for more details and be sure to grab the latest update.

Alan Yu announces the April release of SQL Operations Studio:

Highlights for this build include the following.

• Public preview release of SQL Agent extension

• Added new extensions and improved existing extensions

  • Improvements to Server Reports Extension
  • Release of SSMS Keymap extension
  • Release of AlwaysOn Insights extension
  • Release of MSSQL Instance Insights
  • Release of MSSQL Db Insights

• Added Visual Studio Code 1.21 platform source code refresh

  • Improved large and protected file support for saving Admin protected and >256M files within SQL Ops Studio
  • Integrated Terminal splitting to work with multiple open terminals at once
  • Reduced installation on-disk file count footprint for faster installs and startup times

• Continue to fix GitHub issues

There’s a lot in here.

Prashanth Jayaram shows how to build a custom widget in SQL Operations Studio, using database growth metrics as an example:

In this article, you will learn the following:

• Introduction to SQL Operations Studio

• How to run a custom SQL query and view it as a chart

• How to use default and custom widgets

• Various panes and options in SSOS

• Explain the different chart options

• Create a custom insight

• Details to define a custom widget step by step

• And more…

Building these dashboard widgets is pretty easy, and Prashanth shows it step by step.