Talking about notebook, the most famous product would be: Project Jupyter. People used Jupyter Notebook for learning and executing python through web-based that provide rich display and interaction between programmers and users😎.
Microsoft was inspired by the Jupyter. The have portal kernel: SQL that enable people write down notebook of SQL on Azure Data Studio.
Get the latest Azure Data Studio here.Installed the package and open the SQL notebook via: File ➡ New Notebook.
Then select kernel: SQL and attach to your database connection for this notebook.
We have three sections for the notebook:
Section A: Text area, you could write down any markdown language for the area.
Section B: Code area. that means you could coding with SQL script here and after complete you could press F5 to execute your script the executing result will display in Section C.
Section C: Result area. Display your SQL script or command in the area, you could easily export the result table in diverse format: excel/json/xml...(Just right click your mouse over this section).The final step was to save your notebook in your disk (extension with .ipynb). So you could share the notebook with your teams or clients😃.
Please note that if you want to save and reduce the volume of your notebook file, you could just save your Text and Code area only (Wipe the results).The Azure Data Studio is more light weight than SQL Server Management Studio, Azure Data Studio support cross platform ability and this kind of notebook built-in indeed decrease the communication cost between people (With description text section, plus code snippet and results area that explain almost everything for the reader👍).
Reference
- sqlservercentral.com/articles/using-notebooks-in-azure-data-studio
- https://docs.microsoft.com/zh-tw/sql/azure-data-studio/faq?view=sql-server-ver15
