Pipenv dependency resolution procedure
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.”
Power BI Dynamic Filters
How a filter in Power BI can be dynamic and reflect other slicers and interaction in the dashboard?
Setting up Azure DevOps for Git Version Control
How to set up Azure DevOps for Git Version Control
Return Value in SSIS OLE DB Command
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
Prevent Concurrent runs for a SQL Stored Procedure
Suppose you have a SQL Stored Procedure and need to prvenet users or processes to run it concurrently.
Shrink SQL Database
How to shrink a SQL Database and manage log file size?
An AWS Solution for a small tweeting app
A tutorial to develop an application using AWS services to send tweets on a regular basis – based on data in a database.