Aug
01
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)