![]() Webinar Q&A Q: With the availability of Power Query in Excel, why would anyone use ADS for reporting/graphing? Excel is so much better.Ī: There are over 300 million users of Excel worldwide, and many business analysts are using SQL Server. If you missed the webinar, you can view it here.ĭuring the webinar, Warwick and I received a lot of great questions, which we answered below in case they are helpful to you. I recently teamed up with Warwick Rudd ( Data Platform MVP and Principal Consultant at SQL Masters Consulting, for the webinar, “ Introduction to Azure Data Studio and the Plan Explorer Extension.” We introduced attendees to ADS and Plan Explorer and provided an informative demo that illustrated: SentryOne Plan Explorer, the free and wildly popular SQL Server query tuning tool, now has a powerful extension for ADS, giving you the ability to run as a standalone application, from SSMS, and from ADS. Unfortunately you’ll have to wait until the next release of ADS to see your extension go live in the marketplace (unless you use the insider versions) as the marketplace list it’s included in the application code.Azure Data Studio (ADS) is a lightweight, browser-based query tool that enables access to all Microsoft on-premises and cloud data platforms from clients running Windows, macOS, and Linux. There are no specific instructions, the point is to just copy/paste the previous entry in the JSON file and add your specific information, nothing too crazy for someone that already managed to create your own extension. To include your extension in the marketplace, right now, you’ll have to modify these files (they have their own dedicated branch in the repository) in the ADS GitHub repository and make a pull request in order to get them included in the next release. The process is still a bit tricky, hopefully the marketplace will be standardized as the VSCode one soon enough. In this way your VSCE is ready to publish to the marketplace, whenever it will be seamless for ADS How to publish your extension right now Paste the Access Token generated in the 1st step.Type the following in the terminal: vsce login.Later on, you’ll have to type the following to use your publisher from your machine: Create a publisher in the Manage Publishers page.If you want to register a publisher as an individual, you’ll have to do the following: In the tutorials above, the publisher name is left as the default value (Microsoft), this is probably because, as stated above, the publish feature isn’t yet present for ADS extensions.įor my SQL Server Diagnostic Book, I wanted to use my own publisher name, in order to be ready to publish whenever the feature gets implemented, and to reserve my publisher ID this was actually the most difficult part of the whole extension authoring The publish process isn’t still supported for ADS extensions, hence you cannot directly publish them to the Marketplace like it’s possible with VS Code extensions (on which ADS is based on)Īt the moment the marketplace onboarding is still a manual process, managed via Pull Requests in the ADS Github repository, hence an extension will be published in the marketplace only if your PR gets accepted in time for the next release of ADS, I’m working on it. The whole process is based around the command line, using tools like npm, yo and vsce, however, you don’t have to be a proper Node.js dev to take advantage of this new tool in fact, I know nothing about web development and look at me creating extensions and how-to articles □ Missing Features Microsoft has produces some pretty good documentation about the whole process: In my previous post I’ve detailed how you can now access a Book remotely, now, if you want the book to be actually installed in your ADS instance, you can install it as an extension!įollow this link for the SQL Server Diagnostic Book as an extension, in this post we’ll look at the feature in a general way. The recently released Extension Generator for Azure Data Studio has opened up yet another way to ship Notebooks and Books to ADS allowing you to easily author your extensions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |