SSMS 18.1: Schedule your SSIS Packages in Azure Data Factory
Schedule your SSIS Packages with SSMS in Azure Data Factory(ADF) This week SQL Server Management Studio version 18.1 was released, which can be downloaded from here. In version 18.1 the Database diagrams are back and from now on we can also schedule SSIS Packages in...
Azure SQL Data Warehouse: Reserved Capacity versus Pay as You go
How do I use my Reserved Capacity correctly? Update 11-11-2020: This also applies to Azure Synapse SQL Pools. In my previous article you were introduced, how to create a Reserved Capacity for an Azure SQL Datawarehouse (SQLDW). Now it's time to take a look at how this...
Azure SQL Data Warehouse: How to setup Reserved Capacity
Purchase your Azure SQL Datawarehouse Reservation Since a few weeks you can buy Reserved Capacity for an Azure SQL Datawarehouse (SQLDW). This Reservation can save you up to 65% on the normal Pay as You go rates with a 3 year pre-commit. A pre-commit of 1 year...
New Microsoft Azure Certifications
Microsoft Certification by Solution Area Handy overview of the new Microsoft Azure Certifications. More details can be found here Feel free to leave a comment
How to check your SQL Server Quota in Azure?
Azure Subscription Usages for SQL Server Last week we reached our Logical server Quota in Azure. By default you're only allowed to add 20 Logical Servers, but we wanted to have some more for testing purposes.Microsoft Support You can submit a support ticket trough...
Rerun Pipeline activities in Azure Data Factory
Rerun Pipeline activities in ADF! As of today you can rerun or partially, yes you’re reading it correct partially, rerun you Azure Data Factory pipeline.Where you previously had to run the entire Pipeline again, you can now run a part of the Pipeline. This can save a...
Are you using Azure DevOps?
Azure DevOpsMore and more users are starting with Azure DevOps. Azure DevOps can be used for up to 5 users free of charge and is therefore a great start to start a project. Build and Release I will not describe what Azure DevOps can do, because that is too much to...
Azure DevOps and Azure Feature Pack for Integration Services
Azure Feature Pack for Integration ServicesAzure Blob Storage A great addition for SSIS is using extra connectors like Azure Blob Storage or Azure Data Lake Store which are added by the Azure Feature Pack. This Pack needs to be installed on your local machine. Are...
Collection of all ADF Mapping Data Flow videos
ADF Mapping FlowDid you use the Dataflow preview functionality in Azure Data Factory? This has recently be renamed to Mapping Data Flows. All video's which the ADF team has created, are collected. Start Here: ADF Data Flow: Overview ADF Data Flow: Data Flow...
Azure Data Factory: Generate Pipeline from the new Template Gallery
Last week I mentioned that we could save a Pipeline to GIT. But today I found out that you can also create a Pipeline from a predefined Solution Template.Template Gallery These template will make it easier to start with Azure Data Factory and it will reduce...