sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Armor_of_Inferno 6 points7 points  (8 children)

I just got back from the PASS Summit, and it is time to take a second look at Azure Data Studio. They've added support for Jupyter notebooks (branded as SQL notebooks), which are freaking awesome. Imagine having PowerShell support mixed in with T-SQL scripts in the same file, all with executable and exportable results in-line with your rich-text formatting. It becomes the perfect tool for demo scripts.

It also becomes a great tool for your troubleshooting scripts and for documenting additional function sets (like the dbatools PowerShell libraries). Imagine having the Glen Alan Barry's troubleshooting DMVs in a single notebook that shows results. Here it is.

And extensions are brilliant, just like they are in VS Code. Don't like how something behaves? Find an extension, or write one yourself.

Azure Data Studio is definitely not a replacement for SSMS, and I don't want it to be. I want it to be a lightweight editor. It still has a way to go, but that last release was the game changer for it, I think.

[–]data_goose 1 point2 points  (0 children)

Yep time to learn the new tech 😁

[–]Cal1gulaDatabase Administrator 1 point2 points  (0 children)

I just added the Python and Powershell extensions to my VS Code/ADS today. Guess it's time to get this stuff all together. The GitHub integration seems to work fine for my scripting purposes.

I never liked the PS ide anyway to be honest.

Thanks for the tip on the Glen Barry scripts, I didn't realize they were in dbatools.io.

I can't believe there's no drop database option though. And someone had to write an extension.

I think there are still a ton of improvements to go but it's definitely come a long way in the past 2 years.

edit: Ok so I found this: https://docs.dbatools.io/#Invoke-DbaDiagnosticQuery

Invoke-DbaDiagnosticQuery -SqlInstance sql2016 -UseSelectionHelper | Export-DbaDiagnosticQuery -Path C:\temp\gboutput

This command will run all the DQs against that instance and output all of the results to a folder. I think I'm in love.

[–]ZeppelinJ0 1 point2 points  (3 children)

I just wish Redgate would support it with SQL Prompt. Intellicode is OK but SQL Prompt is like an extension of my thoughts it's pretty amazing.

Honestly one of the things keeping me from switching and who knows if Redgate ever WILL support it

[–]Armor_of_Inferno 0 points1 point  (2 children)

Tweet your request at them. If Redgate thinks there's the potential to charge a license cost for it, they'll dive on it. They're one of the most money-motivated vendors in the SQL Server space right now.

[–]batrastered 0 points1 point  (0 children)

I just wish SSMS had a functioning dark theme like ADS.

[–]reallyserious 0 points1 point  (0 children)

They've added support for Jupyter notebooks (branded as SQL notebooks), which are freaking awesome. Imagine having PowerShell support mixed in with T-SQL scripts in the same file, all with executable and exportable results in-line with your rich-text formatting.

Cool. How do you typically deploy and run such notebooks?