Applies to: SQL Server (all supported versions) SSIS Integration Runtime in Azure Data Factory This tutorial walks you through the process to extract the Employees collection from the sample Northwind OData service (https://services.odata.org/V3/Northwind/Northwind.svc/), and then load it into a flat-file. 1. Create an Integration Services project Launch SQL Server Data Tools or Visual Studio. Click File, point to New, and click Project. In the New Project dialog box, Read More
How to Import Data from OData to Azure Data Factory
by Gauri Mahajan In this article, we will learn how to use Azure Data Factory to import data from OData APIs on Azure storage repositories. Introduction Data practice has the following major part – Data Collection, Data Preparation and Curation, Data Management, and Data Consumption. Typically, data consumption is viewed as a practice of accessing data Read More
How to Set up SQL Data Sync Between Databases in Azure SQL Database and SQL Server
In this tutorial, you learn how to set up SQL Data Sync by creating a sync group that contains both Azure SQL Database and SQL Server instances. The sync group is custom configured and synchronizes on the schedule you set. The tutorial assumes you have at least some prior experience with SQL Database and SQL Read More
How to Do Lookups with Returning Multiple Column Values
This is the first post in a series where we’ll talk about how to use the FILTER function as an alternative to lookup functions including VLOOKUP. Why? Well, as we’ll discover in this series, the FILTER function offers several key benefits. For example, FILTER supports: Multiple return columns Multiple lookup columns Multiple matching row values In this first post, we’ll see Read More
Features Comparison: Azure SQL Database and Azure SQL Managed Instance
APPLIES TO: Azure SQL Database Azure SQL Managed Instance Azure SQL Database and SQL Managed Instance share a common code base with the latest stable version of SQL Server. Most of the standard SQL language, query processing, and database management features are identical. The features that are common between SQL Server and SQL Database or SQL Managed Read More
Upwork vs. Fiverr: Which Freelance Job Site is Best?
We take a deep dive into freelance service platforms, and here we look at key differences between Upwork vs. Fiverr. By Lena Borrelli Remote work is increasingly taking off as technological developments continue to change and shape how we live and, more importantly, how we earn. Freelance job sites have become a new lifeline to both Read More