Skip to content
Clear Thinking in Data, Cloud, and AI

Clear Thinking in Data, Cloud, and AI


Practical insights from real-world engineering experience

  • Home
  • About Me
  • LinkedIn

FIFO calculation using Excel

Common usage is stock & inventory valuation for tracking and taxation purpose.

FIFO Inventory Valuation in Excel

DAX : Inventory or Stock Valuation using FIFO

FavoriteLoadingAdd to favorites

Author: Shahzad Khan

Software developer / Architect View all posts by Shahzad Khan

Author Shahzad KhanPosted on December 30, 2021December 30, 2021Categories App ServicesTags excel

Post navigation

Previous Previous post: Word searching/matching in SQL Server
Next Next post: Afghani chicken karahi

Search

Recent Posts

  • TLS on a Simple Dockerized WordPress VM (Certbot + Nginx)
  • Writing code is over
  • Rebuilding My Personal Blog on Azure: Lessons From the Trenches
  • IDesign Method: An Overview
  • Design Principles and Patterns

Archive

  • ►2026 (5)
    • ► January (5)
      • TLS on a Simple Dockerized WordPress VM (Certbot + Nginx)
      • Writing code is over
      • Rebuilding My Personal Blog on Azure: Lessons From the Trenches
      • IDesign Method: An Overview
      • Design Principles and Patterns
  • ►2025 (35)
    • ► November (2)
      • AI and Developer Productivity
      • Building the Bridge Between AI and the Real World
    • ► October (1)
      • AI and Developer Productivity
    • ► September (1)
      • Azure Function Flex Consumption Plan and Key Vault
    • ► August (1)
      • Macbook Pro 2019 Blank Screen problem
    • ► July (3)
      • ZoomIt - Screen zoom and annotation
      • Git Branching Strategies
      • Natural Language AI-Powered Smart UI
    • ► June (5)
      • How to run SonarQube Analysis in Visual Studio Console
      • Azure AppInsights integration in Blazor WASM
      • Supervised and Unsupervised Learning
      • Training, Validation and Test Data in Machine Learning
      • Export SonarQube issues (community edition) in Excel File
    • ► May (5)
      • Install SonarQube using Docker
      • When to use ConfigureAwait(true/false)
      • .NET Code Analysis with Roslyn Analyzers
      • Front-End Development Trends
      • Conditional Nested Validation with FluentValidation
    • ► April (3)
      • Recommended UI Approaches for Azure AI Services Output
      • Sharing a Single Model Across Multiple Child Components in Blazor WebAssembly
      • AI and Nvidia's chips relationship
    • ► February (5)
      • Show/Hide element in Blazor WebAssembly
      • Convert Enum to List in C#
      • StateHasChanged() vs InvokeAsync(StateHasChanged) in Blazor WebAssembly
      • 400 vs 422 response in post action
      • Blazor WebAssembly and Antiforgery token
    • ► January (9)
      • Attribute Routing in ASP.NET Web API 2
      • Cloud computing
      • Enable Microsoft Entra-only authentication with Azure SQL
      • Changing user password for PaaS SQL Server instance
      • Azure Data Factory
      • What is Microsoft Fabric?
      • idTokenClaims vs accessTokenClaims
      • Extending HttpClient With Delegating Handlers in ASP.NET Core
      • App Registration vs Enterprise Applications
  • ►2024 (70)
    • ► December (3)
      • Last Run Date on a Stored Procedure in SQL Server
      • Using varchar(MAX) vs TEXT on SQL Server
      • finding all stored procedures that is calling functions
    • ► November (1)
      • SQL Server database backup restore on lower version
    • ► October (3)
      • Angular build errors
      • How to prevent Visual Studio from compiling TypeScript
      • How to use jQuery with Angular
    • ► September (3)
      • ‏Matter and Thread - What's the difference?
      • Installing USWDS in Angular
      • Ho to fix "ng: command not found"
    • ► August (16)
      • Bluetooth Ranges
      • Difference between Amps and Volts?
      • ChatGPT Answer to Home Assistant
      • Re-Create ESPHome encryption key
      • Zigbee Network Analyzer
      • Simple steps to replace your favicon icon in Angular
      • Capture child component click event in parent component
      • Serving data with Angular Material
      • JSON conventions and defaults
      • Angular Story - GetAngular
      • Angular Development – Sample Angular Side
      • Property '...' has no initializer and is not definitely assigned in the constructor
      • Angular Development – Sample Server Side
      • Angular Development - Break and Fix
      • Angular Development - Getting Started
      • VLAN and Routing with Unraid
    • ► July (5)
      • Manually Change Home Assistant IP Address
      • Zigbee Channel
      • How MATTER (Smart home standard) works?
      • What is ESPHome?
      • SQL Query to get server IP address
    • ► June (8)
      • Color Temperature & Brightness Level of Philips Hue Scenes
      • How bright are Philips Hue light bulbs?
      • Switching between Azure Subscriptions
      • Azure PowerShell and Azure CLI
      • Azure Microservices
      • Azure Core Service
      • Azure Networking
      • Electric Precision Screwdriver Set
    • ► May (13)
      • SQL Temp Table Drop/Create
      • C# tip (Primary Constructor)
      • Copy live WordPress Site and Run inside Docker container
      • jQuery.param()
      • Upgrade Debian from bullseye to bookworm and PVE7 to PVE8
      • What is a Pem file and how does it differ from other OpenSSL Generated Key File Formats?
      • Using Razor, how do I render a Boolean to a JavaScript variable?
      • Uninstall and Reinstall Angular
      • Angular 17 Local Install
      • Unraid Active Directory Integration
      • What does --net=host option in Docker command really do?
      • Store Complex Object in TempData
      • Passing TempData value from controller to controller
    • ► April (3)
      • Video Recording
      • Treegrid Row Filter
      • JavaScript equivalent to C# String.Format
    • ► March (4)
      • UBUNTU disk size increase
      • nameof expression (C# reference)
      • Default value for a boolean parameter in JavaScript function
      • How Much to Spend on an SSL Certificate
    • ► February (3)
      • Empty Functions in JavaScript
      • Empty JavaScript functions
      • Why I Switched from 1099 to S Corp (and How It Impacted My Freelance Business)
    • ► January (8)
      • Bringing Code Cleanup on Save To Visual Studio 2022 
      • Development-time IIS support in Visual Studio for ASP.NET Core
      • Bootstrap wizard examples
      • How to embed a Power BI Report Server report into an ASP.Net web application
      • Troubleshooting SSL Certificate Binding on SSRS/PBIRS
      • JavaScript Promises
      • Asynchronous JavaScript
      • JavaScript Callbacks
  • ►2023 (135)
    • ► December (19)
      • Creating multi-column Dropdown in ASP.NET Core
      • Software Design Principles
      • LINQ Operators
      • Design Pattern Groups
      • Guidelines for Choosing and Applying Design Pattern
      • Loading and re-loading jQuery Datatble with Ajax
      • Javascript setTimeout
      • jQuery DataTable Column Selector
      • Adding Images in Azure DevOps Wiki
      • How to change SVG style?
      • Nested tables in jQuery DataTable
      • How to clone c# list?
      • DataTables: Cannot read property 'length' of undefined
      • DataTables.js → How to update your data object for AJAX JSON data retrieval
      • Remove a Class from an HTM Element
      • The character + is converted into "&#x2B" in base64 encoded data
      • The Intersection Observer API: Practical Examples
      • Front End UI Components Suite
      • Bootstrap Tree View
    • ► November (22)
      • Bootstrap sticky table head
      • Modifying Exported DataTables Data
      • Showing and Hiding Long Data in a DataTable
      • DataTables Example Using an Ajax Callback
      • DataTables Example Using reduce()
      • Extracting Data from a DataTables Table
      • jQuery DataTables - Key Documentation Pages
      • jQuery DataTables
      • UML Diagram
      • Cognitive complexity theory with example
      • Using TransactionScope multiple times
      • Base class implementing interface
      • Model binding for HTTP GET requests
      • Web Application Authentication
      • Code with Engineering Playbook
      • document.getElementById vs jQuery $()
      • Hide default search in DataTables
      • Using Silkgrid
      • How do i check if an element is hidden in jQuery
      • How to add close button to bootstrap card
      • Difference between Bootstrap 4 and Bootstrap 5 
      • ASP.NET Core Telerik UI Configuration
    • ► October (20)
      • SessionStorage property in JavaScript
      • How to add link parameters in ASP.NET core
      • Clean Shave: Razor Pages for Web Forms Developers
      • Page is Dirty using JavaScript
      • Rice recipes
      • Sweet recipes
      • Reading XmlDocument fragment
      • A Simple 2-Column Layout in Razor
      • JSON Example
      • Expression Design - tips and tricks
      • SVG Path and Path Data
      • Bootstrap Multiselect
      • Joining Operator: GroupJoin
      • Action, Func and Expression
      • Fonts vs PNG transparent images
      • Cascading Dropdown List
      • Other recipes
      • Software explained in common words
      • Afghan Recipes - Multiple
      • Easy Rice Pancakes Recipe For Tiffin
    • ► September (25)
      • Haleem or Daleem recipe
      • Pivot C# Array or DataTable: Convert a Column To a Row with LINQ
      • All about EJS TreeGrid
      • Self-Signed Certificate Error when installing jQuery Types for Typescript
      • How can I change background color of razor syntax in cshtml
      • Polling vs. Long Polling vs. WebSocket vs. Server-Sent Events
      • Pivot a JavaScript Array: Convert a Column to a Row
      • Best Free and Open-Source JavaScript Data Grid Libraries and Widgets
      • Typescript basics
      • Mutton paya recipe - BakraEid special
      • Convert List of DerivedClass to List of BaseClass
      • Getting all types that implement an interface
      • When to use <> instead of ()
      • Generics in C#
      • Tree View control with JavaScript and Knockout for large trees
      • Add Typescript to ASP.NET Core
      • primitive vs reference types in JavaScript
      • Kadhi (Buttermilk Curry)
      • How to Convert OBS MKV to MP4 Efficiently on Windows?
      • Unbind Git references from project
      • Create folders inside Branches in Azure Devops
      • Search all tables, find primary keys with id, identity and auto-increment in SQL Server
      • Overcoming browser throttling of setInterval executions
      • LINQ Distinct. How To Get Distinct Values From A Collection Using LINQ.
      • Is it possible to add index on temp tables ?
    • ► August (5)
      • Javascript debugging doesn't work in razor pages
      • jQuery form validation
      • TransactionScope Async Thread Fail
      • Bootstrap uses rem and em instead of px. Why?
      • Bundling and Minification in ASP.NET Core
    • ► July (8)
      • Kabuli (Afghani) Pulao Recipe || Beef Afghani Pulao
      • Web Apps Performance Testing
      • Arrow function in JavaScript
      • DB Schema and Permissions
      • Chicken Shawrma (Desi style)
      • Paratha (Asian butter/Oil bread)
      • Paratha (Asian butter bread)
      • PowerShell and CLI command pattern
    • ► April (9)
      • Change visible status based on if array is empty or not in knockout.js
      • Knockout debugging
      • What is the difference between $root and $parent in Knockout?
      • Knockout Boolean binding not working
      • Knockout fromJS simple example
      • What is UVA Summer Medical Leadership Program (SMLP) ?
      • C# list to anonymous type with new properties
      • Create your own web font with just the icons you need
      • How to use the new Bootstrap Icons v1.10 web font
    • ► March (16)
      • Unit testing in C# using Moq Framework
      • Tips to repair Sense screen detached
      • Unordered list without bullets
      • Difference between an array and an object in JavaScript
      • Dapper Transaction
      • <a href="https://stackoverflow.com/questions/41426658/es6-how-to-access-a-static-getter-from-an-instance">ES6: How to access a static getter from an instance</a>
      • Knockoutjs context debugger
      • Fibonacci Sequence Number
      • SQL Server String Split and Agg function
      • Best JavaScript Framework
      • ICONS fonts Vs SVG ICONS
      • Chrome Debugging tips
      • JavaScript Namespaces
      • Front End Plugins
      • JavaScript quick sheet
      • JSON path is not properly formatted. Unexpected character '#' is found at position 2
    • ► February (7)
      • Json object from Razor model in Javascript
      • what @Html.Raw() and Json.Encode() does
      • URL Matching in C#
      • Quick layout using pre-defined Json Data
      • JSON from Controller to View in ASP.NET MVC Core and avoid XSS
      • Open Source Licenses
      • EF and Dapper Read performance
    • ► January (4)
      • Philips Hue vs Kasa
      • Computer Graphic Cards
      • Proxmox alert configuration via gmail
      • Intel NUC's on edge - Case Study
  • ►2022 (108)
    • ► December (1)
      • Yellow triangle in Visual Studio Package References
    • ► November (15)
      • What is X.509 certificate?
      • Azure DevOps .NETFramework Version not found
      • Using appsettings.json in Asp.net core 6 Program.cs file
      • <strong>What is a Builder Pattern?</strong>
      • ASP.NET Core Dependency Injection Simple Example
      • How To Update Raspberry Pi
      • Hosting application targeting multiple framework
      • Version of .Net Framework, IIS App Pool is using?
      • What are progressive web apps? Best Progressive Web App list
      • Secure App in Azure App Service without change App code
      • Possible values of empty json
      • Convert Json String to C# object
      • Ajax request other than Get and Post
      • Throw exception on server side and handle in jQuery AJAX post call
      • Calculate your household energy usage in kWh
    • ► October (16)
      • Working with different type of WebClient to consume Web API
      • Serilog ASP.NET 6 configuration
      • Azure App services debugging and monitoring
      • Best practice for securing web API endpoint
      • Ajax Request: Response to preflight request doesn't pass access control check
      • FIDO2 and WebAuthn
      • JavaScript Callback function
      • How single page application works
      • Debounce and Throttle in JavaScript
      • SQL Cursor - Forward Only vs Fast Forward
      • Case sensitive search on a case insensitive sql server
      • Customizing ADO
      • What's a Reverse Proxy
      • Hidden / Invisible Characters
      • JavaScript: How to construct an array of json objects using map
      • Method vs Linq based query syntax example
    • ► September (13)
      • Delete a local git branch
      • Simplifying ADO.NET Code in .NET 6
      • AutoMapper in .NET 6
      • The current net sdk does not support targeting net 6.0
      • Simple Knockout sample
      • Use LibMan with ASP.NET Core in Visual Studio
      • Visual Studio Task List Feature
      • JSON Circular Reference Loop Error running Raw SQL in Web API using EF Core
      • Standard Practice to Create Repository
      • How to add gitignore file in existing solution using Visual Studio
      • Resolve the issue of request matched multiple endpoints in .NET Core Web API
      • Swagger configuration
      • Angular13 and .NET 6 – Getting started
    • ► August (9)
      • Working with packages and libraries in .NET Core
      • Adding byte to byte array
      • Data Points - Shrink EF Models with DDD Bounded Contexts
      • SQL Server transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements
      • SSDT Installation
      • How to re-generate Azure QR Code
      • Pass parameters to action method in ASP.NET Core
      • Executing Raw SQL Queries using EF Core
      • Stop tracking the files that should be ignored in Git
    • ► July (1)
      • Windows security settings
    • ► May (5)
      • Using fieldset legend with bootstrap
      • Find all columns with a specific column name in database
      • What is transcoding?
      • Difference between 802.3af, 802.3at and 802.3bt PoE?
      • Kitchari Recipe
    • ► April (8)
      • Software Architects — Fundamental Path knowledgebase
      • Get file path in .net core from wwwroot folder
      • Lacha Pratha لچھا پراٹھا
      • Dahi Bhallay Better than Market 
      • create virtual machine from existing windows 10 pc
      • Decode JWT Token
      • JSON token with best practices
      • Cache VS Session VS cookies?
    • ► March (15)
      • Handle back-slash “\” in Razor View and JavaScript
      • Pass data to controller using jQuery
      • A Brief Introduction to Cat6 vs Cat6a vs Cat7 vs Fiber
      • ASP.NET Web Site or ASP.NET Web Application?
      • Search string array in collection using LINQ
      • Hide/Show Div with javascript
      • Use TempData or ViewBag to render HTML
      • Return values from HttpContext.Current.User.Principal and WindowsIdentity.GetCurrent()
      • Access to XMLHttpRequest from origin has been blocked by CORS policy...
      • How .NET and SQL Server Handle Dates and Times
      • ASP.NET Core Middleware Configuration settings access
      • UDM Pro commands
      • Protected web api configuration
      • How to use AppSettings.json in Azure Web App and Web API?
      • Certification
    • ► February (4)
      • Cannot start the web project because administrative privilege's are required..
      • The Web Application Project is configured to use IIS
      • Cloud key upgrade
      • Karachi Biryani
    • ► January (21)
      • Chicken wings karahi
      • Setting Traefik on unRAID
      • SQL Server basic command
      • Move Pi-Hole databases and list to different location
      • Setting up Pi-hole as a recursive DNS server solution
      • Docker vs Podman
      • Kabuli Pulao Recipe
      • Allow root SSH into Linux
      • Cloud key gen2 plus stretch apt sources
      • Linux file permissions
      • Git Merge in VS2019
      • Insert results of SPROC into temp table
      • SQL Server Merge Statement
      • DNS - NSLOOKUP what is the meaning of the non-authoritative answer?
      • Extract numeric values from text in SQL Server
      • SQL Server window functions
      • Change Windows 10 DNS settings using Command Prompt
      • You'll need a new app to open this microsoft-edge - server 2019 - Microsoft Community
      • Re-purpose Cloud Key Gen2 Plus for Pi-Hole
      • Scan docker containers for log4j/Log4Shell exploit
      • Setup wireguard on Unraid
  • ►2021 (220)
    • ► December (20)
      • Afghani chicken karahi
      • FIFO calculation using Excel
      • Word searching/matching in SQL Server
      • Peshawari Kheer
      • Karachi Biryani
      • Window server core configuraiton
      • PowerShell and Gui
      • Disk size calculation
      • Excel dropdown list with number and text
      • Server is ethernet connected on LAN, means exposed to the internet?
      • IEnumerable vs IQueryable
      • All about LINQ operators
      • Handling custom dataset in C#
      • Different ways to check a null object
      • C# Design Pattern
      • JavaScript frequently used functions
      • Using vanilla ADO.NET
      • What does "where T : class, new()" mean?
      • nuget package restore
      • Project targeting multiple framework in .NET
    • ► November (19)
      • Clarification on development framework in .NET
      • Best practices for designing REST API
      • Sharing libraries between .Net Core and .Net Framework applications
      • Azure hosted wordpress site
      • Visual Studio licensing and pricing
      • Install and configure Git for windows
      • Reflection - What are the benefits
      • Rest API HATEOAS (Hypermedia as the Engine of Application State)
      • Project post-build event command to copy files to a local folder or network share in VS
      • Return multiple values to a method caller
      • Convert a Console App to Class Library
      • How to load assembly in SSIS script task that isn't in the GAC
      • Using class library in SSIS Projects without GAC installation
      • Sending email using SMTP
      • Using email template to compose and send emails
      • Dataset is empty, no tables in Dataset
      • Dynamic type and Expando Object class
      • Appending two string builders
      • The transaction log for database 'SampleDb' is full due to 'LOG_BACKUP'.
    • ► October (10)
      • No space left on drive - debian
      • Using SSIS to pull data in chunks from remote server
      • SSIS Package Performance and Timeout Exception
      • How to get SQL Data in chunks from remote server
      • C# expression trees
      • How to check computer specs
      • Remove all spaces from strings using sql
      • SQL Server Transaction block
      • SSIS Foreach Loop Folder as variable
      • How to create midnight datetime
    • ► September (13)
      • Drop orphan users – internal.object.permissions
      • jQuery Ajax - tips
      • Dapper - ORM example list
      • Database Isolation Levels and locking hints
      • Get base url in javascript
      • SSIS Script component - Get Blob Data column
      • Login failed. The login is from an untrusted domain
      • SQL Server database stuck in Restore state
      • Return a Json Object from another function call
      • SSIS Excel Data Source Column overriding
      • SSIS Expression Sample List
      • Parameterize ADO.NET Source in Data Flow
      • Store and Read Objects from Session in ASP.NET Core
    • ► August (13)
      • Dataset and Data Tables (a refresher)
      • Remove single quote from strings
      • Get File Extension using T-SQL
      • Handy reference for Bootstrap
      • Object Variable conversion to Table or List
      • Using Shared Projects in ASP.NET
      • SSIS Project Target .NET Framework
      • Using SSIS Script task with Object variable and ADO Data Set
      • Continue Foreach loop after task failure in SSIS
      • Cross Apply and Outer Apply
      • How to Add a custom field in Azure DevOps
      • Throw exceptions in SQL and C#
      • C# component to read Excel data using OleDb in SSIS
    • ► July (7)
      • Send email in .NET Core using Mailkit and office 365
      • Difference between mit, gpl and apache software license
      • Don’t’ fail parent package if child package fails
      • Backup calendars and contacts in outlook
      • SQL Date Conversion from different data types
      • Login with RDP to a Windows Azure VM using Azure AD
      • Manage another user (service account) credentials for network access
    • ► June (40)
      • Loading stored procedure results into tables
      • Steps to perform when relocating to a different city/state
      • SQL Server NULL or empty value checking
      • Select Date between Two Date Columns
      • Does Azure charge for stopped VMs?
      • Visual Studio Debugger Failed to launch debug adapter
      • SQL Method to convert to neart 1000 integer
      • View effective permission of single user
      • Read, Write and Execute permission to SQL Login
      • Azure DevOps Force Permission is required to delete a branch
      • SQL Server Change Data Capture
      • Unbind solution from TFS
      • How to make a bootable USB?
      • Find computer model and serial number
      • Azure DevOps free tier max out, buying license for additional user
      • How to Drop Orphan User in SQL Server (Msg 15138)
      • Why the SQL Agent Jobs are failing after database restore
      • Shortcuts to run window command with elevated permission
      • FIND AND REPLACE using Regular Expression in SSMS
      • Updating SSIS packages for specific SQL server version
      • Start Debugging vs Start Without Debugging
      • LEAD (Next) and LAG (Previous) Analytic function
      • Configure Azure DevOps for SSIS Projects
      • Azure SQL Database (PaaS) Backup/Restore
      • Windows 10 screenshots
      • Fix Name Pipes Provider, Error: 40
      • jQuery selector change not firing
      • Allow users to add favorite posts in wordpress
      • How to confirm Access Database Engine (ACE Driver) is installed on Database Server
      • Possible ways to run SSIS Packages
      • Read Excel Data using C#
      • Fix DT_TEXT and DT_NTEXT Read only behavior in Script Component
      • Large Text import from Excel using SSIS
      • UML Activity diagram
      • Large text import from Flat File using SSIS
      • How to get Azure QR Code?
      • Off-Site Backup of UDM Pro
      • How to secure Azure VM
      • Azure DevOps Git Clone error
      • Connect your organization to Azure Active Directory
    • ► May (32)
      • Prevent spam on your entry level Blog
      • SQL Server Agent configuration to run SSIS Packages
      • Incoming Client certificate in Azure App Service?
      • Release pipeline for Azure Storage
      • How to query last restore dates of databases
      • Self-Signed Certificate in Certificate Chain Error
      • SSIS Project Deployment Model
      • Creating Repo and adding project using UI
      • Intro Crypto Currency
      • Simple Repository Sample
      • jQuery click event on view load
      • AutoMapper in ASP.NET Core
      • Send Email after Release Deployment in Azure DevOps
      • Rack cabinet listing
      • Why it's so hard to buy PS 5 console?
      • Serilog Logging in ASP.NET Core
      • SQL Server integration services environment setup
      • Counting elements in arrays and List
      • SSIS: Object variable
      • SSIS: Script task for connecting ADO.NET and Populating Data Table
      • KeyValue pair class
      • Using LINQ methods to compare objects of custom type
      • SSIS: Read Excel Tables
      • Azure DevOps Commit error: Object reference not set to an instance of an object
      • All Excel - Programmatically Reading/Writing
      • SSIS: Converting a string to byte-array
      • SSIS: Use Sql connection inside script component
      • Download Excel Files
      • Load Bootstrap tabs dynamically
      • Video chat application challenges
      • Copy data from one DB to second DB using Script
      • Copy BLOB (binary data) from one DB to second DB using script
    • ► April (12)
      • Simplest way to test Node.js is working
      • ASP.NET Core Configuration
      • Angular walks through in ASP.NET Core project
      • jQuery click not working
      • JavaScript Object Patterns
      • JavaScript Inheritance
      • JavaScript Constructors and Prototypes
      • JavaScript Objects
      • JavaScript Functions
      • JavaScript Reference types
      • JavaScript Primitive (value) types
      • Handling special characters in the data using SQL server
    • ► March (51)
      • Uncaught Reference Error: jQuery is not defined
      • Use Powershell to export SQL Blob column data
      • Filestream in SQL Server
      • Store and retrieve BLOB data without File stream
      • Excel LinkServer not working in SQL Server
      • Execute SSIS Package from SPROC
      • What If Report Phishing is Missing in outlook?
      • Adding a separate email account as an owner subscription
      • VM Reserved instance
      • Install Angular9 or latest version using PowerShell
      • Connecting an Azure WebApp to a SQL Server VM inside a VNet
      • Azure stencils for Visio
      • Installing PowerShell and Az moduel for Azure
      • DistributedCom error when running SSIS package on windows box
      • My Blogger Site
      • How to run SSIS Packages from Web
      • 32 bit and 64 bit office side by side
      • CS2001 Missing AssemblyAttributes.cs when executing SSIS package deployed to the server
      • enabling / disabling xp_cmdshell
      • Multiple environments, do I need Azure Key Vault for each environment?
      • Restrict Web App Access to selected IPV4 addresses
      • Can I move an app resource from one region to another region?
      • Copy an existing pipeline
      • Azure Storage redundancy
      • Azure App Service plan
      • Azure Key Vault Delete and Purge
      • Secure Azure Key Vault
      • Azure Key Vault with Azure Apps
      • Setup SSIS proxy account
      • Introduction to stocks, housing market
      • Login is from an untrusted domain and cannot be used with integrated authentication
      • Unsupported project error for SSIS project
      • How to verify SQL Server is using NTLM / Kerberos authentication
      • Azure Virtual Network concepts and best practices
      • Azure example of tagging
      • Prevent accidental changes by using resource locks
      • Control Access to cloud resource using RBAC
      • Hosting multiple domains under one app service
      • Azure SQL Databases
      • Azure SQL Database Models and pricing
      • Azure Security and Encryption
      • Does Azure commercial follow FEDRAMP guidelines?
      • Testing youtube
      • Check and change PHP version in Azure WordPress App service
      • Windows Snip & Sketch alternative
      • Single database and Managed Instance comparison
      • ngTemplate, ng-Content, ngContainer, *ngTemplateOutlet
      • Azure database connection string
      • Branching flow using UI
      • Azure DevOps Branching and Release Flow Guide For beginners'
      • Create repository and upload main branch
    • ► February (3)
      • Run an SSIS package from SSMS with Transact-SQL
      • How to run ssis package in asp.net core application?
      • Edit script in SSIS is not working
  • ►2020 (15)
    • ► November (1)
      • Entity Framework Core tools reference .NET Core CLI
    • ► October (4)
      • Cheapest Development Environment for Azure Kubernetes Service
      • Docker run returns Cannot assign requested address error
      • Steps to enable MSDTC on Windows Server
      • MAC OS tips
    • ► September (4)
      • How to stop Azure Data factory pipeline
      • What does it mean that Azure Cosmos DB is multi-model?
      • Difference between SSIS, Azure Data Factory and Azure Data Bricks
      • How to Read blob file from Microsoft Azure Storage with .NET Core
    • ► July (2)
      • How to split string in SQL Server
      • Microservice and Idempotent method
    • ► June (4)
      • An overview of Azure SQL Database and SQL Managed Instance security capabilities
      • The 7Ws Framework
      • Data projects design that reflects ETL approach
      • Hello world!

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Categories

  • AI & ML (8)
  • App Services (309)
  • Data Design (104)
  • Dev Ops (107)
  • Food (21)
  • Security (25)
  • Smart Home (14)
  • Uncategorized (39)

Blog Disclaimer

The information in this weblog is provided “AS IS” with no warranties, and confers no rights.
…
The content of this blog does not represent the thoughts, intentions, plans or strategies of the organizations I am linked to. It is solely my opinion.
…
Feel free to challenge me, disagree with me, or tell me I’m completely nuts in the comments section of each blog entry, but I reserve the right to delete any comment for any reason whatsoever (abusive, profane, rude, or anonymous comments)
….
so keep it polite, please.

Featured Articles

  • Store and retrieve BLOB data without File stream (1130)
  • Resolve the issue of request matched multiple endpoints in .NET Core Web API (979)
  • Create repository and upload main branch (961)
  • Expression Design - tips and tricks (924)
  • Entity Framework Core tools reference .NET Core CLI (899)
  • Prevent spam on your entry level Blog (843)
  • SSIS Project Target .NET Framework (745)
  • Azure DevOps Branching and Release Flow Guide For beginners' (730)
  • Hosting application targeting multiple framework (716)
  • Can I move an app resource from one region to another region? (713)
  • Setting up Pi-hole as a recursive DNS server solution (710)
  • EF and Dapper Read performance (709)
  • Access to XMLHttpRequest from origin has been blocked by CORS policy... (697)
  • How to add gitignore file in existing solution using Visual Studio (696)
  • FIND AND REPLACE using Regular Expression in SSMS (694)
  • Secure Azure Key Vault (661)
  • Hello world! (654)
  • Release pipeline for Azure Storage (647)
  • SSIS Foreach Loop Folder as variable (630)
  • Dahi Bhallay Better than Market  (626)

Tag Cloud

  • ADO (6)
  • ai (6)
  • angular (19)
  • asian (18)
  • asp.net (44)
  • asp.net core (13)
  • azure administration (7)
  • Azure Cloud Architect (3)
  • Azure Key Vault (5)
  • azure vm (3)
  • Blazor WebAssembly (6)
  • BLOB (7)
  • bootstrap (9)
  • Branch and Release flow (3)
  • c# (54)
  • c#; ef core (3)
  • css (11)
  • datatables (8)
  • design pattern (6)
  • docker (5)
  • excel (4)
  • framework (4)
  • Git (10)
  • guide (3)
  • HTML (6)
  • JavaScript (83)
  • jQuery (15)
  • json (5)
  • knockout (7)
  • lab (16)
  • LINQ (9)
  • linux (9)
  • ml (3)
  • powershell (5)
  • smart home (12)
  • SQL Agent (4)
  • SQL server (61)
  • SSIS (42)
  • SSL (4)
  • SVG Icon (4)
  • typescript (3)
  • visual studio (24)
  • Web API (6)
  • window os (11)
  • wordpress (7)

Recent Comments

  • Shahzad Khan on Prevent spam on your entry level Blog

Ranked by users

  • Your favorites will be here.
  • Home
  • About Me
  • LinkedIn
Clear Thinking in Data, Cloud, and AI © 2020–2026 All rights reserved.