Plan Explorer (SentryOne) – get enhanced execution plan diagrams for queries inside Azure Data Studio.Redgate SQL Search (Redgate) – search for and within objects across multiple databases.Redgate SQL Prompt (Redgate) – get access to snippets and powerful formatting options.Database Administration Tool Extensions for Windows (Microsoft) – get direct access to SSMS, including Properties and Generate Scripts.On my Windows development virtual machines I use all of the above extensions, as well as: whoisactive (Microsoft) – get dashboard insights based on the popular sp_WhoIsActive, written by Adam Machanic.Visual Studio IntelliCode (Microsoft) – show recommended code completion tips based on context.SSMS Keymap (Kevin Cunnane) – use your favourite SSMS shortcuts in Azure Data Studio.sp_executesql to SQL (Pejman Nikram) – convert dynamic T-SQL to regular T-SQL for troubleshooting queries.SQL Server Schema Compare (Microsoft) – compare DACPAC files and databases, and apply changes.SQL Server Profiler (Microsoft) – trace queries, but don’t be fooled by the name: this actually uses Extended Events.SQL Server Import (Microsoft) – the Import Flat File Wizard from SSMS, but in Azure Data Studio.SQL Server Dacpac (Microsoft) – manage data-tier applications, working with DACPAC and BACPAC files.SQL Server Agent (Microsoft) – manage, configure and troubleshoot SQL Agent jobs.Server Reports (Microsoft) – get useful performance-related insights, including tempdb.Schema Visualization (Jens Hunt) – visualize database schemas in Azure Data Studio using mermaid.js.SandDance for Azure Data Studio (msrvida) – visually explore, understand, and present your data.Query History (Microsoft) – keep a record of past executed queries.PowerShell (Microsoft) – write and run PowerShell scripts with rich language support including syntax highlighting and IntelliSense.PostgreSQL (Microsoft) – connect, query, and manage Postgres databases with Azure Data Studio.Poor SQL Formatter (WSR Publishing, Inc) – use the popular Transact-SQL code formatter created by Tao Klerks.New Database (Kevin Cunnane) – add a “New Database” option when right-clicking on the Databases folder.MSSQL Db Insights (matticusau) – provide additional dashboard widgets to give you insight into your SQL Server instance.Machine Learning (Microsoft) – manage packages and models, make predictions, and create notebooks to run experiments for SQL databases.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |