This is a wiki for tips regarding business intelligence and database tools.

Power BI:

• Calendar Table
• Power Query M snippets
• Tabular Editor Script Snippets

SSIS

• SSIS SQL query on Excel file
• SSIS Display info from script task/component (FireInformation)
• SSIS Run SQL queries in Script Task

SQL Server

• SQL Server data dictionary
• SQL Server parse JSON
• SQL Server Queries to generate queries
• SQL Server See sessions and running queries
• SQL Server Recover dropped objects (tables, views...)