ADT in this case is way to go, because have good integration with version control. Second feature is the one which allows to check any object definition on the go in code.įor those who are not DBA (as i am) would be interesting to store and deploy code in GIT.
This is very useful, for instance, when you want drop database, but can not remember definition (do not drop any production db here). First one, gives templates and hints for working with database objects. That is where IntelliSense and Peek Definition comes into play. When you as DBA want to quickly write some T-SQL code it is not always easy to remember syntax and table definition from heart. Just try this one out – copy this article into ADT notebook.
Azure data studio export full#
You can even copy full article from internet and paste it with all formatting into notebook. Third example – make impressive presentation with notebooks. You prepare notebook and ask client to run it on his environment (where you do not have access) and save results in notebook to send it back to you. Second example – Run queries on foreign environment :). You can even easily transform your existing code into well formatted notebook with pictures and text – just click “Export as Notebook”. Since PowerShell is supported you are almost fully covered. Required steps can be powered by pictures and code. Power of notebooks can be useful in several cases.įor instance – notebooks can be used as instructions for disaster recovery (DR). But don’t forget about markdown language. You dont like how it looks? No problem, just switch to “Split View” and edit text in HTML way. Notebooks are formatted text and code blocks which can be formatted as you wish. In my opinion, this is one of the most powerful feature.
0 kommentar(er)
