Skip to content

Mattias De Smet

Microsoft BI and Azure solved cases
  • Azure
  • Business Intelligence
  • Navision
  • Contact
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
Jun 16 2020
Business Intelligence

SSAS : Locale Error while processing cube

by mattias
No Comments
In the past I came across two strange errors when processing a cube: Locale 8129 not supported – this was just a warning, processing succeeded. Still, it didn’t radiate confidence....
analysis services, cube, device attached, not functioning, processing, registry, sql, SQLServer, ssas
Jun 14 2020
Business Intelligence

SQLServer : disable inactive logins

by mattias
No Comments
SQLServer doesn’t have a functionality to expire accounts if they have not been used for a certain amount of time. Sometimes this can come in handy, e.g. in an environment...
administration, datawarehouse, db, dba, disable, history, login, logon, sql, sqlagent, SQLServer, table, trigger, tsql
Jun 07 2020
Business Intelligence

Create REST API on SQLServer database

by mattias
No Comments
In the past SQLServer offered native webservice support, but this was deprecated in SQLServer 2008 and recommended to be replaced with WCF or .Net custom application. Since many applications require...
.net, access_token, api, authorization, bearer, controller, database, db, get, json, oauth2, register, SQLServer, swagger, swashbuckle, test, web

Posts navigation

1 2 … 4

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

BMC logoBuy me a coffee

Categories

  • Azure (6)
  • Business Intelligence (10)
  • Navision (3)

Tags

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

BMC logoBuy me a coffee

Mattias De Smet

Microsoft BI and Azure solved cases
2020 Mattias De Smet