Azure Data Studio Features in 20 Minutes - Vicky Harp

[Music] hi i'm vicki harp i'm the pm manager for the sql server tools and experiences team at microsoft and i'm going to see if i can show you 20 features of azure data studio in only 20 minutes all right here we go so my goal today is to see if i can show you 20 different features of azure data studio in 20 minutes now there's a lot of features that you can see that you need deeper dives and some of those you'll be able to see elsewhere here at bits but i thought for those of you who are maybe taking a look at azure data studio for the first time it might be a little bit fun to just get a really quick tour of a lot of the different things you could do and then go look for a deeper dive into some of those things so to begin with this is azure data studio it's a cross-platform open source editor for sql server and the rest of the azure data platform you can use it on mac windows and linux and you can download it from the microsoft document site and you can also get it from github it is open source and it's based on vs code so this is the insider's edition which is the daily build and you can also use the stable which is released monthly with updates uh this has been ga for about two years now as of uh this fall and uh we look forward to making many more features in the months and years to come so starting with feature number one i'm going to demonstrate the command palette this is an interesting and important thing to know about whenever you're working on azure data studio so i'm going to hit ctrl shift p and you're going to see this thing pop up here which is a list of recently used commands and as well something that i can use to type and so that will help me go into item number two which is themes so if i can type that go color theme and you can see here we're able to change the color theme so if you prefer to have dark if you prefer to have uh maybe red or solarized or if you would like to have something that's got a high contrast for for visibility you can pick all of that there and you can also download additional features if you like so i'm just going to go with the default light for now as i go on to feature number three i'll go again to the command palette and go to keyboard shortcuts so keyboard open keyboard shortcuts now i could also have gotten there by clicking down here and going to keyboard shortcuts so here is where you can go through and change what all of these things are so i'm hitting ctrl shift p for command palette but maybe i don't care for that maybe i can change it i can change uh all of these different things to be something more comfortable you can also download extensions that change this out so that you can have it more akin to what you're used to in say ssms i'm using the default uh key commands here but this is all editable for you so next thing that i want to show that's kind of more of a basic of of the product is the terminal so we have an editor here if i hit control and then uh the i guess tilde key i bring up here this command palette or this command terminal so i can uh here i'm in powershell i can change over to command by typing cmd go to command clear screen you know run my my commands etc and then i can actually add additional ones so maybe i want a powershell one and a command shell both open at the same time to be working in those different languages you can do that and you can access these as you're working which is really convenient rather than tabbing out to another experience you can do powershell you can do uh you know your local command whether it bash or windows you can do python you can do lots of different shell activities right here so let's go to item number five which is the connections view so if i click here over here in this viewlets area you can see i have a couple connections already registered for both sql server and postgresql so if i want to add a new connection i go and pick the connection type i can add the server pick the authentication etc and so i can see my my list of different connections here and then once they're in there it's a possible for me to go and view them and browse through them just as you might be familiar with with other tools i'm able to go all the way down to the columns of particular tables and from here i can go and access by right-clicking different manageability options and lots of different other features that are related to that particular database or uh server type going on to item number six we have deployments so let's say that you these are the ones you've got but you'd like to deploy something new so if i go up here to this dot dot dot hit new employ deployment i have the option of deploying a number of different things and this is a constantly shifting a list we're consistently adding more but for example i could choose sql on windows a sql container instance a big data cluster and then going into our azure arc look for more of these deployment experiences to land very soon this will just take you through an easy wizard which lets you deploy uh the data service of your choice so getting into now that we've got these connections what are we going to do with them we'll go to number uh 7 which is the query editor so let me hit new query so here we have our very traditional query editor i'm going to do my select star from sysdot databases and you can see our little uh extra intellisense running along there i'm going to run that and you can see we've got the result set i'm going to hide this for size we can see our ability to export to csv excel json save as xml etc so we've got uh the good full-featured traditional sql editor there with that we do have the ability to use intellisense which is our item number eight which uh you can see as i'm typing along here it's just databases and then you also have the ability to use something called snippet so let's say i want to do create and here i've got this create you know sql create database so hit that and it's going to let me say test database and you can see this is a full snippet that already has some uh sql pre created for you these snippets are something that you can create for yourself again go to your trusty command palette go to snippets and you can configure user snippets for the language of your choice so you can say i want to have uh new snippets for let's go down here to sql and then create whatever it is that you run frequently that you want to have kind of added to intellisense to help you get up and running quickly so let's say that you have done some work here uh one of the important things that you want to do in a contemporary environment is source control it so we do have git integration right here so you see i don't have a open uh get repository so i'm going to initialize a new repository and now it's got all the files in my directory here that i've got i've got my file list here and now they're all uh basically been initialized as a git repository so if i go over here and pick any given file i can let's say this blocking file i can see the changes are all showing up here and would be ready for me to pretty easily go and and do my commits pushes pulls branches etc so that's our uh our next feature there so moving on from there the um query editor is is very similar to what we're used to with uh other tools like say ssms but uh one of the real special sources for azure data studio is the ability also to use notebooks so if i have this select star from sysdot databases let's say i want to add a little bit of stuff here i can say this shows a list of databases that and then say this is a list of objects and again select star from assist.all objects so if i run that traditionally what would happen is i would have you know if i could control s save i would save this as a sql file and then if i wanted to share this with someone i would have to individually export each of these tables and then give them the combination of those three files here's my sql file here's csv one and here's csv2 so what a notebook attempts to do is pull all of that together so let me put these together and let me put a little statement in here then i'm going to hit export as notebook and you can see this is the notebook version of the same thing i'm going to connect it over here to my same server i'm going to edit this make it look a little nicer say i'm going to make this be a heading or let's say databases list this shows a list of databases so we have this nice human readable uh section up here and then i've got my uh executable code here so if i run that you have that code around this you've got this code i can also hit run all should i want to and now when i save this as a notebook when someone then opens it later they get this entire experience all together so um still have those export options in here you've still got a lot of the functionality you would expect from the query editor including that intellisense but you've got the ability to share it source control it and and work with it in in really a different and fairly contemporary way we've got the ability for you to uh you know edit your mark down here and uh that will really help you to you know if i wanted to learn to do you know folds and and italics and everything like that that's all built in here for you and so a lot of the workflows around azure data studio are built around this concept of using these notebooks which has turned out to be very popular among our sql users so from notebooks are in the jupiter parlance they're related to uh you know this concept called a kernel and then there's these uh attached to location so here i've been using the sql kernel but we've also got these other languages that are supported we've got cousteau pi spark spark python and powershell so you can choose the language that you're choosing to run in and then in the attach to case in the case of something like sql this is the server where you would run it to run now notebooks are an open source concept and another open source concept that is related to this is something called a jupiter book which is our feature number 12. so if i go over here to this this is my list of notebooks and you can see these are individual files i can click through but if i wanted to have a large number of uh notebooks kind of gathered together similar to a onenote experience i would want to use something called the jupiter book so if i go back to my trust command palette and put jupiter books you can see we're shipping with the sql server 2019 guide which is both a useful guide and also a good way to see how jupiter books work so here we can see i've just opened this jupiter book and it's sort of a um chapter and and page version of things so i can go to the welcome page i can go to these different troubleshooters and i can run all of these you can take these links i can go previous and next on different pages and really work through maybe a larger troubleshooting guide without having to have everything in a super long notebook so this is another concept that comes with azure data studio and again comes from the open source world as well so being open source one of the things that we really want to do is enable users and and companies to edit azure data studio as they like so one of the main things that we have to enable that is this extension marketplace so through the extensions marketplace we have you know something on the order of 60 extensions available uh both microsoft and external parties are able to make new functionality for azure data studio and make it available to you so we have a number of interesting extensions that we've shipped from microsoft we have a number of interesting extensions from from our partners and they're listed here and i've got some that are installed i've got some that are recommended you can see i've got the ability to do central management servers we've got different things from our partners um in in the monitoring world and we've got things like the support for different languages are built down here into the extension mechanism so for the remainder of our time i thought i'd show you a couple of the interesting extensions you might want to pull in to customize after data studio for the way that you use it so the first one i wanted to show you is sand dance so sand dance is a visualizer uh let's see i've got some license data here for dog licenses so if i hit view and sand dance this is a nice visualizing tool to let you go through your your data let's let it load for a second here so here i've got some csv data and i'm able to see here all the different license types and you know maybe i'm not real happy with the way this is so i'm going to go over to say i want to see maybe a grid view of it i want to view it by a color of dog i want to facet it by license type i want to go over here to a tree map i want to group by you color it by dog name i want to you know really explore my data you know in different ways so this is the sand dance visualizer it's one of our extensions uh we also have support for additional data platforms in here so if i go to postgres uh one of them let me save us some time i've got it listed here a postgres sql so we have support for postgresql we're adding additional support for things like acousto and so you're able to add that support in here uh so here you can see i have a postgresql instance and we're able to use notebooks with it use the pre-editor everything that you would with sql server you're able to use with the other data platforms uh an important recent one that we've added is a sql project support so if i go down here to uh sql server i'm sure it's in here somewhere we have yeah sql database project so if you've been using ssdt for visual studio and you're using database projects to source control and manage your schemas you're able to do that now in azure data studio so there's actually an entire session on that we have as well the ability to do dac back so i can go to jackpack sql server backpack is listed here along with sql schema compare so even independent of using a database project i can go over here and say i want to use a digital application wizard and i can create a a backpack or a backpack from that given database just like this so that's a popular feature as well uh backup and restore is something that we actually ship as an extension and then that's something where i can just do my simple you know backup and restore experiences as you would expect the reason that something as fundamental as backup and restore is shipped as an extension is because by shipping it as an extension we're able to independently version that functionality separate from the rest of the uh application so if for example you have an environment where you're not doing backup and restore you could remove it but more likely the case is that you might have an out-of-band update to that functionality like the backup restore functionality that came along separately from the rest of it so that's kind of architecturally how it works for even some of the things that you might consider really fundamental to the application they're actually part of it so among some of the other ones that we'll go into and i'm just going to very quickly slide through them as we do have the sql server profiler uh we also have the ability to do flat file imports so i can do import wizard and then the import wizard is very similar to what we have in in ssms where you're able to actually do kind of a two-click import from say a flat file rather than having to go through the large ssis window and then the last thing that i want to demonstrate among these is what we call the the dba pack let me close this i admin pack for sql server and that's not it that is not it either i'm going to take a pause and see if we can edit there and so finally what i want to show you in our future number 20 if i've got it correct here is that you are actually able to cross-integrate with uh ssms if you do have ssms co-installed and you're on windows if i go to this properties windows here and we'll give it a second to load it's actually going to open the dialog from ssms in azure data studio so you can see we've got kind of our old favorite experience from the properties window from ssms and it's available here in azure data studio if you have the two products installed together so we've got lots more features than these 20. this is just kind of the ones that i wanted to show you in this very quick session so i encourage you to give azure data studio a try just go to uh the uh your favorite search engine search azure data studio and you can download either stable or insiders and get started if you've got any feedback for us please let us know thanks so much [Music]

Channel: SQLBits

Views: 674

Keywords: Azure SQL Database, Deploying, Developing, On-prem, SQL 2019

Id: ybnb_PRs0Cg

Length: 18min 54sec (1134 seconds)

Published: Tue May 11 2021