Skip to content

Mattias De Smet

Microsoft BI and Azure solved cases
  • Azure
  • Business Intelligence
  • Navision
  • Contact
Jun 16 2020
Business Intelligence

SSAS : Locale Error while processing cube

by mattias
5 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
Jun 03 2020
Azure, Business Intelligence

Azure SQL DB: setup AD Authentication

by mattias
No Comments
Follow below steps to allow Azure AD users and groups to connect to your Azure SQL database: create a User in Azure AD optionally: create a Group in Azure AD...
active directory, ad, authentication, azure, db, external provider, group, sql, user
Jun 01 2020
Azure

Azure : Change VM RDP port number

by mattias
No Comments
Here are three easy ways to change your RDP port number of an Azure VM. 1. Azure Portal This is a good way when you don’t want to login to...
azure, compute, os, port, portal, portnumber, powershell, rdp, scripting, vm

Posts navigation

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

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