Tag: SQL

AzureDatabase

February release of Azure Data Studio is now available

image

The February release of Azure Data Studio is now available to download and includes the following key highlights:

  • Introducing Admin pack for SQL Server
  • Auto-sizing columns in results
  • Notebook UI improvements
  • Added Profiler filtering
  • Added Save as XML
  • Added Data-Tier Application Wizard improvements
  • Updates to the SQL Server 2019 Preview extension
  • Turned on results streaming by default
  • Deploy scripts
  • Bug fixes

For a list of the complete updates, refer to the release notes.

Download Azure Data Studio now!

References

https://cloudblogs.microsoft.com/sqlserver/2019/02/13/the-february-release-of-azure-data-studio-is-now-available/

Database

Installing Extensions in SQL Operations Studio

Just like VS Code, extensions provide more functionality to SQL Operations Studio. These extensions can come from Microsoft or the community.

Adding Extensions to SQL Operations Studio

1. Open the Extensions manager by going to the View menu and selecting Extensions. After clicking on the Extensions menu item, the Extensions navigation icon shows up on the left side. I’m not sure why this isn’t always available like it is in VS Code.

image

2. Browse and select an available extension. At this time there are 9 extensions available to choose from. 

image

3. Click on the green button to install the desired extension. In my case I’m trying to install RedGate SQL Search which is a tool I use in SQL Server Management Studio. This will download the extension but if you try to double click and run it, the installation will fail. Instead you need to install it from SQL Operations Studio.

4. From SQL Operations Studio, press Ctrl/Cmd+Shift+p, and type Extensions: Install from VSIX and then press enter.

image

5. You should then see a notification in the bottom right corner of SQL Operations Studio indicating the extension has successfully been installed.

image

Enjoy!

References

What is Microsoft SQL Operations Studio

Installing SQL Operations Studio

Extending the functionality of SQL Operations Studio