Skip to main content
Under the kover of business intelligence
  • Home
  • Copyright
  • About

Category: Business Intelligence

New Management Hub in Azure Data Factory

June 11, 2020September 9, 2020 Koen Verbeeck Leave a comment

I wanted to manually start an Azure-SSIS Integration Runtime in ADF, so I went to the edit section and then to connections. But instead of showing me my linked services (which is the default tab), it showed me this message instead: My curiosity was awakened. By clicking on “Open management hub”, you are taken to […]

Read More

Webinar: Migrating SQL Server Integration Services to the Cloud

February 21, 2019March 8, 2019 Koen Verbeeck Leave a comment

I will be doing a webinar for MSSQLTips.com about migrating your on-premises SSIS solutions to the Azure cloud. Specifically, the Azure-SSIS integration runtime environment in Azure Data Facture. The webinar is Thursday the 7th of March at 8PM UTC. The abstract: Integration Services is a mature ETL product that has been around for more than […]

Read More

Snowflake Database – First Impressions

November 5, 2018September 10, 2020 Koen Verbeeck 2 Comments

At my recent project I’ve had the pleasure of working with Snowflake database (no, not the modelling technique) for the first time. Snowflake is a native cloud data warehouse, which means it is built for the cloud from the ground up. It’s not a conversion of an existing database or appliance into a cloud model; […]

Read More

SSIS and Pentaho – A Quick Comparison

October 17, 2018October 17, 2018 Koen Verbeeck 4 Comments

I’ve been working with SSIS for a decade now (all versions, 2005 right until 2017), but it’s been just until recently that I got my hands on Pentaho Data Integration (PDI). PDI is the ETL tool of the Pentaho suite and is maybe most commonly known as kettle. You’ve got an Enterprise edition (which ain’t […]

Read More

Book Review – Learning Pentaho Data Integration 8 CE

September 26, 2018September 26, 2018 Koen Verbeeck Leave a comment

Yes, you’re reading that right. A book not about the Microsoft BI stack. At a project, Pentaho Data Integration (PDI) was used as an ETL tool. To get to know this tool a little better, I bought the book Learning Pentaho Data Integration 8 CE (Third Edition) by the author Maria Carina Roldán. For those of […]

Read More

Installing SSDT for Visual Studio 2017

June 19, 2018June 21, 2018 Koen Verbeeck 1 Comment

I had SSDT for VS 2017 installed some time ago, but due to some issues I had to uninstall it. I also have SSDT for VS 2015 installed, as an add-on in Visual Studio 2015 Enterprise (because that’s the only way to get TFS working in VS 2015). I tried to re-install SSDT 2017 (stand-alone […]

Read More

Introduction to Biml – Webinar

May 29, 2018May 29, 2018 Koen Verbeeck Leave a comment

On Thursday June 7th I’ll be giving a webinar for MSSQLTips.com (7PM UTC). The topic is Introduction to Biml – Generating your SSIS packages from scratch. In this webinar, I’ll introduce the Biml language and its concepts and show you how you can generate multiple SSIS packages using metadata. The abstract: Working on your 20th staging […]

Read More

Book Review – Analyzing Data with Microsoft Power BI and Power Pivot for Excel

March 15, 2018March 16, 2018 Koen Verbeeck 1 Comment

As preparation for my session at Techorama.be about data modeling in self-service BI, I decided to read the book Analyzing Data with Microsoft Power BI and Power Pivot for Excel by Marco Russo and Alberto Ferrari. The title is quite a mouthful but it gets the point across: the book mostly deals with how to correctly build […]

Read More

T-SQL Tuesday #100!

March 13, 2018March 12, 2018 Koen Verbeeck Leave a comment

The monthly blog party is back and we’ve reached the mythical number 100. The host of this month is the Creator himself: Adam Machanic (blog | twitter). The topic is the future: what will the world be like when it’s T-SQL Tuesday #200? The very first T-SQL Tuesday was over eight years ago, which was […]

Read More

Migrate SSRS 2017 to Power BI Report Server

March 8, 2018April 12, 2018 Koen Verbeeck 5 Comments

UPDATE: The blog post doesn’t make this exactly clear, but fiddling around with the report database to get the upgrade working isn’t supported by Microsoft. However, someone from the SSRS team told me the March 2018 release of Power BI Report Server has fixed some bugs, so you should try to upgrade the normal way. […]

Read More

Posts pagination

1 2 3 Older posts

Feed

RSS

Social

  • Twitter
  • LinkedIn

MVP

Microsoft Data Platform MVP

star schema all the things
Get your star schema merchandise

Author of the Year 2014/2020/2023

Support this blog and buy me a beer

Recent Posts

  • Redgate SQL Prompt in SSMS 21
  • Execute Fabric Data Pipeline from Azure Data Factory
  • Azure Data Factory Pipeline Debugging Fails with BadRequest
  • Call a Fabric REST API from Azure Data Factory
  • Cool Stuff in Snowflake – Part 14: Asynchronous Execution of SQL Statements

Categories

  • Azure (25)
  • Azure Data Factory (25)
  • Azure Devops (4)
  • Book Review (26)
  • Business Intelligence (29)
  • Events (56)
  • Fabric (19)
  • Power BI (41)
  • Professional Development (9)
  • Snowflake (14)
  • SQL Server (113)
    • MDS (8)
    • SSAS (12)
    • SSIS (46)
    • SSRS (13)
    • TSQL (9)
  • Varia (37)
  • Twitter
  • LinkedIn
  • Home
  • Copyright
  • About
Under the kover of business intelligence All rights reserved. Theme by Colorlib Powered by WordPress