Category: Business Intelligence

Jun 07 2020

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...

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...

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,...

May 12 2020

Business Intelligence

Expressions on ConnectionString issue in SSIS 2019

by mattias

11 Comments

In SQLServer Integration Services, the use of Expressions to replace properties at runtime is very powerful. You can use it in combination with variables to pass parameters to queries, determine...

Apr 26 2020

Azure, Business Intelligence

Upgrade the Azure VM Windows OS

by mattias

1 Comment

Come the day you want to install SQLServer 2019, when the first prerequisite is to have Windows 2019 installed. Not to worry, until you discover that your Azure VM doesn’t...