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

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