Skip to content

Data Engineering with Salim Saeedi

AWS and Azure Musings

  • About

Month: January 2020

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

  • Databricks not recognizing updated Service Principal Secret
  • Inline Try-Catch for Azure Data Factory activity output
  • Using MERGE for SCD Type 2 with multiple updates
  • Dynamic 365 Audit History Export through Power BI
  • Pipenv dependency resolution procedure

Recent Comments

    Archives

    • August 2022
    • March 2021
    • December 2020
    • May 2020
    • January 2020

    Categories

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