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

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.  A better experience for editing tabular models than PowerBI or Visual Studio. (uac for installer, but executables can be run direct)

Working with data

General

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