For quite some time now, there’s been the possibility to lift-and-shift your on-premises SSIS project to Azure Data Factory. There, they run in an Integration Runtime, a cluster of virtual machines that will execute your SSIS packages. In the beginning, you only had the option to use the project deployment model and host your SSIS […]
Tag: syndicated
Publish Database Fails – Script File could not be found
A small blog post for anyone who stumbles across this issue (and for my future self, should I forget the solution). I was working on some tables in SSDT and I tried to publish changes to the database on my local machine. I got a build error because I created a clustered index on the […]
Exporting Environment Variables out of the SSIS Catalog
Sometimes when you’ve created a SSIS catalog, along with folders, environments and environment variables, you want this content on another server. Unfortunately, you can only script out these objects in SSMS at the moment you’re creating them (thus right before you clikc ‘OK’ to confirm). Once the objects are created, you can no longer script […]
Converting a Datetime to UTC
I was in a need of converting some datetime values (of which I know the actual timezone) to UTC dates. A quick Google search showed me that most results on the first page were simply wrong. Most of them used this trick: Seems nifty, but they forgot about daylight savings time. If I run the […]
Optimize for Unknown for Inline Table-Valued Functions
I had a curious performance issue today. An inline table-valued function (iTVF) was performing poorly for some parameter sets, and quite fast for other parameter values. In short, this one is fast: This one is slow: Turns out SQL Server used a plan with a hash join in the fast query, and a nested loop […]
Speaking at GroupBy Conference – Spring 2020
I’m excited to announce I’ll be speaking at the virtual GroupBy conference this year. Thanks everyone who voted! I’ll be speaking at the European day on May 12th at 10AM UTC. My submitted session with the most votes was: The modern Cloud Data Warehouse – Snowflake on Azure (you can find more information about this […]
Cool Stuff in Snowflake – Part 12: IS DISTINCT FROM
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share. It might be some SQL function that I’d really like to be in SQL Server, it might be something else. Often you want to check the […]
Switching between different Azure Data Factory environments
When working with Azure Data Factory, it’s possible you have multiple ADF environments. For example, you can have one for dev, one for test and one for production. Unfortunately, the functionality to switch between them is a bit hidden in the user interface. One might assume you could find it in the breadcrumbs in the […]
Reading a SharePoint List with Azure Logic App
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, […]
Quickly Editing Data in SSMS
WARNING: do not do this in production. A quick blog post on a SSMS trick: how to quickly edit data. Sometimes you directly want to manipulate data without having to write a SQL statement. For example, in the development environment you want to modify a value in a column to test out a scenario, or […]