![]() The news: A new extension is in preview to allow connecting Azure Data Studio to Log Analytics as if you were connecting to a SQL database. On Using Power BI to Query Log Analytics I made demonstrations with Power BI, bringing log analysis to another level. Comparing to the new feature I’m about to show this will seems like something from stone age. On Connecting to Log Analytics using Azure Data Studio and KQL I introduced a solution to make Log Analytic queries in Python notebooks using Azure Data Studio. This deserves more in depth analysis, which probably will be broken down in blog articles. On Saving Money with Log Analytics I mentioned how important log analytics is for azure clouds. You need to dig into old blogs I wrote before to fully understand how interesting this new extension is. The snippets feature offers a speed increase that goes a long way toward making SQL feel fluent, even when it’s not the user’s primary language.Log Analytics and Azure Data Studio: New Extension - Simple Talk Skip to content Press tab to accept the IntelliSense and the body of the snippet will be immediately populated into the query editor, including tab-able placeholders for user-entered values. Their shortcuts will be made available by IntelliSense after saving. Here, you’ll find a JSON document that you can customize with all your well-used and poorly-remembered queries. These operations require a quick Google search on the best of days.Īzure Data Studio’s snippets feature may be its golden selling point for many casual users. INSERT and UPDATE can be anxiety-inducing, and some have never even attempted an ALTER TABLE. Typing SELECT queries can be cumbersome enough for developers who prefer to keep SQL out of sight and out of mind. In general, the look and feel of the application is much more sleek and modern than the old-school SSMS experience. Let the SSMS “Programmability” folder, with its endless scrolling procedure names, recede into the past like a bad dream.Ĭolor-coded server groups with matching editor tab colors are also a benefit to developers who want to keep things organized at a glance. This convenience works for table definitions too, and is a game-changer for many developers. Type the name of a stored procedure, then press F12 to instantly open the definition. Close the application and open it again to find all your tabs auto-saved. Similar to VS Code, ctrl+p lets you search for files and issue other commands. Press ctrl+k,s to open a list of customizable keyboard shortcuts. (It is based on Visual Studio Code, and the similarities are prevalent.) Start typing in the query editor and you will immediately bask in the comforting glow of IntelliSense, which works more reliably across server environments than what SSMS offers. The first benefits you will notice, as a developer making a foray into SQL, are the ways in which Azure Data Studio makes your experience feel familiar. While it may not be suited to DBA work, Azure Data Studio is right up the alley of many devs who need to write queries, create or alter the occasional table, and read and manage stored procedures. The first thing you’ll likely do is choose from one of several soothing dark mode themes, before working up the confidence to write your first query. While Azure Data Studio doesn’t offer quite the feature set of SSMS, it more than makes up the difference with user-friendliness.ĭevelopers familiar with Visual Studio Code will feel right at home with the user experience. Enter Azure Data StudioĪzure Data Studio (previously SQL Operations Studio) is a free, lightweight desktop app from Microsoft that serves as a somewhat pared-down companion to the more full-featured SQL Server Management Studio (SSMS). The remedy? Tools that make the process painless. Unfortunately for many, data resides at the foundation of software, and spending time in SQL can be unavoidable. Often, we are willing to undergo a significant amount of pain and inconvenience to avoid writing a short query, never mind an entire stored procedure. Developers and SQL go together like peanut butter and creeping existential dread. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |