Skip to content

Data Engineering with Salim Saeedi

AWS and Azure Musings

  • About

admin

Using MERGE for SCD Type 2 with multiple updates

December 24, 2020 by admin

Below is the typical MERGE statement for SCD Type 2: Since a MERGE statement cannot update more than one match at a time, in scenarios which the source contains historical data that for each matching key (per ON statament) may need more than 1 action in a single merge statement run (e.g. one INSERT and … Read more

Categories Tutorial Tags MERGE, scd, slowly changing dimension, SQL Leave a comment

Dynamic 365 Audit History Export through Power BI

December 18, 2020 by admin

Dynamic 365 provides an Audit History in all pages. In case you need to export these data or have a query to the data, Dynamics API provides this access. In Power BI, OData Feed enables this access. In order to achieve this: Use OData source and point it to “audits” entity. Refer to Microsoft’s Web … Read more

Categories Tutorial Tags audit history, audit log, dynamics, export, Power BI Leave a comment

Pipenv dependency resolution procedure

May 9, 2020 by admin

Problem: You are trying to install or uninstall a python package via pipenv and receive: “Warning: Your dependencies could not be resolved. You likely have a mismatch in your sub-dependencies.”

Categories Tutorial Tags dependency, mismatch, pipenv, pipfile, pipfile.lock, python, resolution Leave a comment

Power BI Dynamic Filters

January 7, 2020 by admin

How a filter in Power BI can be dynamic and reflect other slicers and interaction in the dashboard?

Categories Tutorial Tags dynamic, filter, Power BI, slicer Leave a comment

Setting up Azure DevOps for Git Version Control

January 7, 2020 by admin

How to set up Azure DevOps for Git Version Control

Categories Tutorial Tags azure, devops, git, version control, visual studio Leave a comment

Return Value in SSIS OLE DB Command

January 7, 2020 by admin

Problem In SSIS, OLE DB Command is used as a part of Data Flow to run SQL codes to transform data. Is it possible to use one of the parameters as a return value? Solution Returning values in SSIS OLE DB Command task is possible but the limitation is you can only return one value … Read more

Categories Tutorial Tags ETL, OLE DB, SSIS Leave a comment

Prevent Concurrent runs for a SQL Stored Procedure

January 7, 2020 by admin

Suppose you have a SQL Stored Procedure and need to prvenet users or processes to run it concurrently.

Categories Tutorial Tags Concurrency, Lock, SQL, Stored Procedure Leave a comment

Shrink SQL Database

January 7, 2020January 7, 2020 by admin

How to shrink a SQL Database and manage log file size?

Categories Tutorial Tags log, shrink, SQL Leave a comment

An AWS Solution for a small tweeting app

January 9, 2020January 6, 2020 by admin

A tutorial to develop an application using AWS services to send tweets on a regular basis – based on data in a database.

Categories Tutorial Tags API Gateway, AWS, Lambda, VPC Leave a comment

Recent Posts

  • Using MERGE for SCD Type 2 with multiple updates
  • Dynamic 365 Audit History Export through Power BI
  • Pipenv dependency resolution procedure
  • Power BI Dynamic Filters
  • Setting up Azure DevOps for Git Version Control

Recent Comments

    Archives

    • December 2020
    • May 2020
    • January 2020

    Categories

    • Tutorial
    © 2021 Data Engineering with Salim Saeedi • Built with GeneratePress