![]() It's as if I have a tab embedded in my notebook that just runs the code inside this rectangular blog. This is a code block like in any other query, but it's self contained. This will give me the view below, in which I can now write T-SQL code. I'll click the "+ Code" link in the notebook. Let's start with code, because many of us write code. You can click on either of the words, but in the menu bar at the top there are also buttons for adding text or code cells. You can interleave code and text, but they are separate elements that format in whatever order you've placed them. A cell is essentially a section of your notebook document. ADS lets you know that you can add code or text to a cell, whatever that is. When the notebook opens, there's nothing to see, but a little guidance on how to begin. This is a first class object like a file or other item in ADS. We use File | New and select New Notebook. We can create a notebook just like we create any other object. I'll only cover T-SQL, but I assume things work similarly with PostgreSQL. This is the March 2019 release and contains notebooks with both T-SQL and PGSQL capabilities. You need a version of Azure Data Studio that is 1.5.1 or later. The past is the past, and we can now move forward. This is a technology that ought to have been embedded in Word, Excel, and other places in the past, but it hasn't been. When I first heard that we were getting T-SQL notebooks, I was excited. A notebook makes it easy to link lots of docs and code together. It's really a fantastic tool for teaching or sharing information between people, which is something I've struggled to do with other DBAs and developers. Notebooks are an open data format, essentially a an application that you use to write some document, but they contain live code elements that allow you to embed programs, images, results, and more inside of them. ![]() I've used them to experiment and document how things work, allowing me to easily follow along again. Not all of my notebooks are public, but I do like them in terms of a way to structure the flow of some concept. I've actually been doing a little work with Azure Notebooks and have written a few blogs. ![]() I've learned from Python and Jupyter Notebooks are a way of capturing a number of different code items with text and sharing the information with others. I've been using notebooks for a few years in different parts of my work. Editor Tips and Tricks for Azure Data Studio.Getting Comfortable Writing Code in Azure Data Studio.I've written a few articles on how ADS works, shown here: I've gotten more comfortable with the tool, and while I still like SSMS, there are some features in ADS that I prefer. You can download the tool and read those articles to learn about how to use this in writing code. In this one, I wanted to cover a very interesting feature that was added to the March 2019 release of ADS. I covered a basic orientation and a more in depth one on some of the code writing features. I've written a few articles on how the tool works, and I've got a few more coming. Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. ![]()
0 Comments
Leave a Reply. |