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 […]
Tag: azure
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 […]