Skip to content

Mattias De Smet

Microsoft BI and Azure solved cases
  • Azure
  • Business Intelligence
  • Navision
  • Contact
Aug 20 2022
Azure

Azure : Connect to Azure SQL database

by mattias
No Comments
Setting up an Azure SQL database is easy and fast, but you might bump into some problems connecting to it. I’ll share a couple of tools that you can use,...
azure, connection, database, db, errors, firewall, sql, SQLServer
Aug 19 2022
Azure, Navision

SQL : Configure automatic failover

by mattias
No Comments
Having some redundancy in your database infrastructure is essential to making sure your applications are accessible as much as possible. Even with a solid platform as Azure SQL database, you...
azure, database, db, failover, navision, primary, replica, sql
Aug 18 2022
Azure

Hiding secrets from Azure Functions

by mattias
No Comments
When creating Azure Functions in support of database related logic, or with any need to use a sensitive value, you probable already make sure you don’t store it in the...
azure, function, keyvault, security
Jun 28 2020
Business Intelligence

BI : Securing SSIS project deployments

by mattias
No Comments
When you’re sharing an on-premises SSIS server with multiple teams you’d want to segregate responsibilities to their projects. It’s not a much advertised feature of SSISDB, but it allows you...
bi, database, edw, etl, integration services, security, SQLServer, ssis, ssisdb
Jun 22 2020
Business Intelligence

SSAS : Unexpected root elements in Parent Child dimension

by mattias
No Comments
This article describes a bizar behavior of root elements in Parent Child dimensions. A Parent Child dimension is a dimension based on a self-referencing table, where each record (member) points...
analysis services, child, dimension, hierarchy, parent, parent child, server, sql, sql server, SQLServer, ssas

Posts navigation

1 2 3 … 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

powerautomate sql .net notification dax etl ssas session port usage business rules analysis services navision portal PowerBI queue vm maximum function server administration tsal email portnumber upgrade automation devops flow ssis Master Data Services dba json optimize bi security SQLServer web tsql db datawarehouse rdp trigger azure os database
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