Microsoft BI Tools
Blog about Microsoft Business Intelligence: Azure, Power Platform, SQL Server and related matter
Stories
(Move to ...)
Publish ADF via DevOps
Monitor ADF in Power BI
▼
Topics
(Move to ...)
Azure Analysis Services
Azure Automation
Azure Data Factory
Azure DevOps
Azure Key Vault
Azure Logic Apps
Azure Synapse
Microsoft Power Apps
Microsoft Power Automate
Microsoft Power BI
▼
Showing posts with label
SQL
.
Show all posts
Showing posts with label
SQL
.
Show all posts
Sunday, 5 December 2021
Delta Lake support in Azure Synapse Analytics
›
Case Delta Lake is already widely used in Azure Data Bricks, but now it is also available in Synapse Analytics. How can I use it there to s...
Monday, 5 July 2021
SQL Snack: Create readonly DB user in Azure SQL DB
›
Case I want to create a SQL Server user in my Azure SQL Database that can only read tables and view from a specific schema so I can use it ...
Thursday, 23 March 2017
Loading tables by using BIML and meta architecture
›
Case How can we simplify the process of loading database tables and reduce the time needed to create SSIS packages. Solution There are...
Tuesday, 21 February 2017
Use BIML and csv files to create tables
›
Case The case is about importing flat files (CSV’s) without the necessity of metadata. Because BIML always checks if the tables are access...
1 comment:
Sunday, 29 January 2017
Create and populate Time Dimension
›
Case We have sensors in our building that output data every minute which we want to use in a dimensional model. Therefore we need a Time Di...
›
Home
View web version
