Sometimes in life you have to do things you really don’t like to do. Such as extracting data from a SharePoint List. Usually I use SSIS and the OData source component for this task, as described in one of my most popular articles ever: Reading SharePoint Lists with Integration Services 2017 (I’m not kidding). However, […]
Tag: azure
Cloudbrew 2019 – Slides
Cloudbrew 2019 is over and it was a great event. Great speakers and a big audience. Even in my session there were a lot of attendees, which I found a bit surprising, because at general tech events there tend to be less people in the data tracks. Not this time however, I nicely filled room […]
Speaking Engagements End 2019
Currently I have two conferences in the pipeline. The first is our local DataMinds Connect, the biggest Microsoft data platform conference of the BeNeLux. I’ll be giving a session about the Snowflake cloud data warehouse on Azure, which is pretty much the same one as the one I gave for DataGrillen. The agenda of DataMinds […]
The Azure-SSIS IR Startup Time
UPDATE: here’s an official blog post going in more technical detail on how they achieved the improvements in startup time If you want to run SSIS packages in Azure Data Factory, you need the Azure SSIS Integration Runtime (quite the mouthful), which is basically a cluster of virtual machines handling the packages like an SSIS […]
Migrating SSIS to Azure – Slidedeck (Techorama 2019)
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
Speaking at Techorama 2019
I’m delighted to announce I’ll be giving a talk at Techorama 2019. It’s one of the best events I’ve ever been to and I’ll be in the good company of Grant Fritchey, Jen Stirrup, Pinal Dave and Brent Ozar (+ many others)! That’s right, the line-up for the data platform is amazing, so be sure […]
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 […]
Speaking at DataGrillen 2019
I’m delighted to announce I’m selected to speak at the 2019 edition of SQLGrillen DataGrillen. This is a German conference with the catchy tagline “Data, beer und Bratwurst”. I will be talking about the cloud datawarehouse Snowflake (hosted on Azure). The abstract: The era of cloud data warehousing has finally begun. Gone are the days […]
Issue while using SQLCompare against Azure SQL DB
I’ve encountered an issue while trying to compare a local SQL Server database against an Azure SQL DB using Redgate SQLCompare. When trying to specify my credentials, I got the following error: “Unable to load adalsql.ddl”. Following that link actually leads you to a helpful page, where you can download the Active Directory Authentication Library […]
Two Small Tips for Working with Azure
Very quick blog post about two tips for working with Azure (hence the title of course). I recently started up a project where the data warehouse needed to be fully in the cloud. This was an Azure SQL Database, not Azure Data Warehouse. The size of the DWH was just not big enough (although Microsoft […]