Azure data studio vs vscode9/20/2023 ![]() ![]() Now if only I could integrate all this with Emacs somehow.ĮDIT: alas, it does not seem to want to install correctly on Slackware, whether via ADS' extensions manager or by manually downloading/installing the VSIX package. It'd be awesome to have a properly-good one-stop shop for all my SQL-finagling needs. I wonder if it's possible to create extensions for arbitrary ODBC and/or JDBC connections? If so, then that'd be yet another thing I could manipulate with ADS (our ERP exposes its database via a presumably-proprietary DB protocol for which they provide their own ODBC and JDBC connectors). It's both among the few Electron (I think?) apps I like and among the few Microsoft products I like.īeing able to use the same tool for Postgres would be awesome (we use both Postgres and Redshift here, too) I've long felt that SQL Server's a god-awful DB with awesome tooling while PostgreSQL's an awesome DB with god-awful tooling, and now I'm looking forward to finally getting the best of both worlds. ![]() The built-in support for CSV and JSON dumps has been incredibly handy, too. I’d love to hear if you have started using this yet and what your suggestions for setting up my environment are.I've been using ADS for a couple months now at work (since we've switched to a new warehouse management system that uses SQL Server for its database) and it's been pretty great as a cross-platform replacement for SSMS. There’s going to be a lot more to learn about this tool as I start using this but I’m looking forward to it. I’m a light theme person so I think I’ll stick with the default for right now. You can use the Up/Down arrows to get the preview. I am one of the rare techies who doesn’t like working on a black background by default, but I thought I’d play around to see what I liked. The last thing I wanted to do was set up the Color theme. But this seems like a great reference as I’m learning everything. Once I start playing more, I’ll figure what else to add – whether customize myself or add an extension. You can do a search to narrow down the results if you are feeling overwhelmed: Searching for F5 ![]() NOTE – there is an extension for porting over the popular SSMS shortcuts over. Now that I have some extensions set up, I took a look at the Keyboard Shortcuts. When I clicked on Install, it brought me to the GitHub page where I followed the directions to install: Not all extensions automatically install. But I know I will keep an eye out for when they’re ready. For some reason, I’m a little nervous for some of the ones that are still in preview. I’ll definitely be adding more in the future. Where do I want to start? I decided to start by adding these: Microsoft has green stars in the corner of the Extensions they recommend. David Bland has several posts about his set up as well. Some searching led me to this post by Buck Woody, which has a list of what he uses the most. ![]() I did a quick Google search to see which extensions people recommend. I knew there were a lot of Extensions, but seeing the list is quite different. If you want the full list, see Microsoft’s Github wiki page. There are multiple places you can find the Extensions – an icon on the side or from the Settings icon or the view Menu. There is section for customize on the welcome screen: Now it’s time to start setting this up for my personal use. When it finished the update, Azure Data Studio opened right up again. I also found that under the Window Menu option. When I clicked on the Icon, I saw the option: Restart to Update. As I had just been updating everything else on my personal laptop, I figured it was a good time to do this. But this is what I saw:Īs I said, it had been a while. I still have it set up to have it show the welcome page when it starts. It had been a while since I had installed ADS or updated it or probably even opened it to be honest. I can already see how useful that is so I want to play with that ability more as well. Plus I like the idea that I can use one tool for SQL and for PowerShell. After seeing others use Azure Data Studio for demos, I like the way it can add comments around the various code sections in notebooks so I decided that I want to use it for my sessions as well. But it’s hard to just jump to a new tool without having a goal. I attended Vicky Harp’s ( t) session about SQL Server tools at PASS Summit and I really appreciated what I was seeing. I’ve been wanting to work more with Azure Data Studio for a while. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |