Techorama 2019 is over and it was a blast, as usual. Neatly organised, great speakers and fantastic content. I delivered a session on Migrating SSIS to Azure (Data Factory). You can find the slidedeck on SlideShare: Migrating SSIS to the cloud from KoenVerbeeck
Category: SSIS
SSIS 2019 has arrived!
It is not a joke: SSIS is available for Visual Studio 2019 as a preview. Whoa, hold on. SQL Server 2019 hasn’t been released yet? But there’s already an SSIS 2019? Didn’t we have to wait months after the release of SQL Server 2017 before we had an SSIS version for Visual Studio 2017? Yes, […]
SSIS and Data Quality Webcast
On Thursday the 2nd of May, I’ll be giving a webcast for MSSQLTips.com about data quality and SSIS. The abstract: SQL Server Integration Services (SSIS) has been around for more than a decade in the Microsoft Data Platform stack. It’s a widely used ETL tool, allowing you to integrate and transform data from various sources. […]
Webinar: Migrating SQL Server Integration Services to the Cloud
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 […]
SSIS and Pentaho – A Quick Comparison
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 […]
Community Engagements Second Half of 2018 – It’s all about Biml
I have a couple of community engagements coming up in the second half of 2018 and I’d like to share an overview with you. Some might remember my Biml meetup session at the start of this year. Basically I turned this session into two talks: an introduction to Biml and a more advanced talk about […]
Installing SSDT for Visual Studio 2017
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 […]
Introduction to Biml – Webinar
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 […]
Change SSAS Tabular Data Source using TOM
We’ve all been there. You made some adjustments to your Tabular model and you deploy it to the production server using Visual Studio. Whoops, you forgot to change the server name in the data sources, so now your Tabular model in production is trying to read from the test database. Either it crashes – depending […]
Session Materials – Biml DataMinds
All of the materials for my Biml session for DataMinds.be can be downloaded from Github: the slidedeck (it’s only 12MB :)) a .sql file with the DDL statements to create objects (schema, tables, views, stored procs, functions) in a database called Biml (which you have to create yourself). Along with some metadata in those tables. […]