Tag: db

Jun 14 2020

Business Intelligence

SQLServer : disable inactive logins

by mattias

2 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

May 16 2020

Business Intelligence

Power BI for SQL Server Agent jobs

by mattias

4 Comments

In a SQLServer datawarehouse you might have a lot of jobs scheduled through SQL Server Agent. There is little out of the box visibility on the status of those jobs,...

db, email, etl, power bi, PowerBI, SQLServer

Apr 04 2018

Azure, Navision

Navision powered by Azure SQL DB

by mattias

No Comments

Get the best from both world: use the rich features of the native Navision software and rely on the performance and reliability of Azure services. To do that, I’m assuming you...

azure, azure sql db, backup, db, keyfile, migrate, migration, navision, portal, sql