The Intransigent Data Blog

A selection of development tools for database and data warehouse work.  I have tried to indicate where uac elevation is required to install them.

SQL Server

• Poor SQL http://poorsql.com SQL formatting (online)
• Poor Man’s T-SQL  formatter Visual Studio extension (CTRL K + C)  (no uac)
• Poor Man’s T-SQL Formatter SSMS Extension (uac)
• Sentry One Plan Explorer  https://www.sentryone.com/plan-explorer (uac)

Analysis Services

• Dax Studio essential for analysing DAX queries https://www.sqlbi.com/tools/dax-studio/   (uac)
• BISM Normalizer   Visual Studio extension.  Schema compare and merge for SSAS Tabular models. Rationalises the JSON hell. (no uac)
• Tabular editor  will appear as a menu in PowerBI.  More useful for overcoming limitations of PowerBI than for tabular models designed in VS. (uac)

General

• Greenshot. Screen capture with annotation and obfuscationfeatures.  https://greenshot.org.  (no uac – normally)