You even have the option to change the notebook kernel from SQL to other languages such as Spark, Python or PowerShell.
Execution plan azure data studio code#
Take your audience through the notebooks, add markdown, and run each code cell in isolation.
Another perfect use case for notebooks is training and presentations. They can then send you the notebook, including the results-a great option to have. Maybe you have a helpdesk function where you send scripts for customers to run and troubleshoot. Unlike plain old SQL files, Azure Data Studio saves the results of your queries along with the code. Sure, you can add comments to SQL files, but markdown is a far better experience. Do you have runbooks for tasks such as disaster recovery? Notebooks are perfect here, where you can annotate, comment and add links to communicate your process. You can add both code and markdown to describe, enrich and document your work for yourself and to share with others. But would you walk out on Centre Court with a wooden racket? You cannot be serious.įive reasons you should download and experiment with Azure Data Studio today:Īzure Data Studio supports notebooks, my favourite feature. It’s now as comfortable as an old pair of slippers, and you don’t want to change. Firstly installed via media as client tools, then latterly via an independent download with release cadence of its own. Microsoft then produced SQL Server Management Studio (SSMS) as your one-stop shop for all SQL Server needs. That might just have been relating to my TSQL though, who knows? The second was also named by a friend and ex-colleague as merely " The Mangler”. The second was for management tasks, such as taking GUI backups. The first was for queries (funnily enough). Once upon a time, we had two tools to manage SQL Server: If you haven’t used it yet, I recommend you check it out ( ). Azure Data Studio is the new (ish) open-source, cross-platform tool from Microsoft to manage and interact with your SQL Servers or PostgreSQL instances.
0 kommentar(er)
