Skip to content

Mattias De Smet

Microsoft BI and Azure solved cases
  • Azure
  • Business Intelligence
  • Navision
  • Contact
Jan 30 2023
Business Intelligence

PowerBI : Manage dataset access requests

by mattias
No Comments
When a PowerBI report gets more and more popular, all kind of users start requesting access to a report. Your PowerBI developers made the dataset, setup Row Level Security, and...
bi, dataset, PowerBI, security
Aug 28 2022
Business Intelligence

SQL : split delimited field in columns

by mattias
No Comments
These days of PowerQuery, Spark and other query tools there are quite a range of options available to split delimited fields, but what if you have a table in your...
0NF, database, db, delimited, json, normalisation, sql, SQLServer
Aug 27 2022
Business Intelligence

SQL : CLR to do base36 decoding

by mattias
No Comments
Always wanted to escape the set based world of SQL and get back to that good old .Net procedural (even object oriented) experience for a quick calculation? Let me show...
assembly, database, datawarehouse, db, etl, sql, SQLServer, tsql
Aug 22 2022
Azure

Azure : Cheap static webserver

by mattias
No Comments
A small nifty feature in Azure storage accounts allows you to use them as a web server for static pages. Much cheaper alternative than setting up an Azure VM with...
azure, static, storage, storage account, web, website
Aug 21 2022
Azure

SQL : Move tempdb to D:

by mattias
No Comments
When you install SQLServer on an Azure virtual machine, you can take advantage of the D: drive that comes with such a VM. Its characteristics are that it is local,...
azure, database, datawarehouse, db, dba, sql, SQLServer, tempdb, vm

Posts navigation

1 2 … 5

Curious technological cases present themselves to me in my day to day life. While solving them, I write down my findings and hope I can help others with this summary.

Read more

Buy me a coffee

Categories

  • Azure (11)
  • Business Intelligence (13)
  • Navision (4)

Tags

session azure port email Master Data Services PowerBI rdp function powerautomate analysis services devops os maximum administration queue datawarehouse server flow tsql .net security etl web trigger portal navision tsal db dba business rules upgrade vm json usage dax automation sql SQLServer ssis database bi portnumber notification optimize ssas
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Subscribe

  • January 2023
  • August 2022
  • June 2020
  • May 2020
  • April 2020
  • April 2018
  • March 2018

Buy me a coffee

Mattias De Smet

Microsoft BI and Azure solved cases
2020 Mattias De Smet