SQL query to find referencing Tables by column name

Find Tables by Column names in SQL Server

Drop all tables in a specific schema

Find Database size in SQL

Build SQL connection string in powershell using SqlConnectionStringBuilder

Build SQL connection string in powershell

Lets see how we can do the batch update in sql server without killing resources

How to batch update millions of record in SQL Server

A practical system for pre-loading AI with the right information to eliminate guessing and get consistent, architecture-aligned code from Cursor IDE.

Context Engineering - My System for Getting Consistent Output from Cursor

Learn how to implement distributed locking for scheduled background tasks in .NET when scaling Azure App Service to multiple instances. Prevent duplicate  processing with industry-standard patterns.

When scaling Azure App Service to multiple instances, scheduled background tasks can run simultaneously causing duplicate processing. This post covers industry-standard solutions using proven libraries and patterns.

Distributed Locking in .NET: Preventing Duplicate Processing When Scaling Azure App Service

Understand why using .Result on async calls in ASP.NET Core can cause thread pool starvation in Azure App Service, how to identify it from metrics, and how to fix it with async all the way.

Sync-over-async with .Result can silently destroy throughput in Azure App Service by blocking request threads. Learn the failure pattern, symptoms, and the production-safe fix.

Thread Pool Starvation in .NET: Why Sync-over-Async Breaks Azure App Service

A comprehensive guide to Model Context Protocol (MCP). Learn what it is, how it works, and why it's revolutionizing AI tool integration with visual diagrams.

What is MCP - Model Context Protocol and Why Does It Matter?

Master strategic prompt engineering and custom instructions to boost your development productivity by 10x with GitHub Copilot.

The Complete Guide to GitHub Copilot Instructions and Prompt Files

A concise guide to IReadOnlyCollection<T> in .NET. what it is, when to use it, and how it compares to other collection interfaces.

What is IReadOnlyCollection<T> in .NET?

In this post, I share the real strategies that have helped me, as a full-stack developer, get the most out of Claude Code. I walk you through how I use project context, multi-agent workflows, DevOps integration, and smart prompt engineering to seriously boost my productivity. You’ll find the exact command templates and practical tips I rely on to make AI a seamless part of my daily workflow—so you can work smarter, move faster, and get better results with Claude Codeas your coding partner.

How I Supercharge My Workflow with Claude Code: Essential AI Productivity Tips for Developers

A step-by-step guide to increase Tomcat maxParameterCount in Azure App Service to handle large forms and query strings

Configuring Tomcat in Azure App Service: Increase maxParameterCount

A step-by-step guide to configuring Cursor IDE to connect with Supabase using the Model Context Protocol for enhanced AI-powered database interactions

How to Connect Cursor IDE with Supabase Using Model Context Protocol (MCP)

Using app_offline.htm to display a maintenance page during Azure App Service deployments

How to Show a Maintenance Page in Azure App Service During Deployment

Explore how the Options Pattern in .NET provides a clean, type-safe way to manage configuration settings through strongly-typed classes, dependency injection integration, and flexible validation options. Learn to implement this pattern for more maintainable and testable application configuration.

Understanding the Options Pattern in .NET

Explore advanced techniques to extend the built-in Dependency Injection system in .NET, including custom service providers, decorator patterns, conditional registration, and more to handle complex dependency scenarios in large applications.

Extending Dependency Injection in .NET

Learn how to make specific rows in an Oracle APEX Interactive Grid read-only based on column values like status using the Allowed Row Operations Column feature. This simple technique improves data integrity by preventing edits on completed items.

Oracle APEX: Make Interactive Grid Rows Read-Only Based on Column Value

A guide to resolving OpenSSL errors in Node.js 20 for Next.js projects

Resolving OpenSSL Error in Node.js 20 for Next.js Projects

Distributed systems are complex, requiring careful planning and design to handle challenges like data consistency, fault tolerance, and scalability. Below are 30 essential patterns in distributed systems

30 essential design patterns for distributed systems

One common challenge in software development is organizing the code to be clear and easy to work with. This is where different architectural styles, like Clean Architecture and Vertical Slice Architecture, come into play.

Clean Architecture and Vertical Slice Architecture

How to use multiple Java versions in an Azure DevOps pipeline with a Windows Server 2019 and Visual Studio 2019 build agent

Managing Multiple Java Versions in Azure DevOps Pipeline on Windows Server 2019 with Visual Studio 2019 Build Agent

How to dynamically populate option values in manual GitHub Action parameters. It uses a GitHub Action designed to update the YAML file of the main action whenever changes are pushed to the branch. It also uses a script to read the current parameter values, compare them to the dynamic values, and update the YAML file if they differ. This strategy allows for real-time updates and dynamic population of choice parameters in your GitHub Actions.

Dynamically Populating Parameters in Manual GitHub Action

Go beyond traditional logging and make logs usefull

Structured logging in C#

Imagine having a robotic helper that constantly tests your apps to ensure they work perfectly for your customers. That is synthetic monitoring. It simulates user actions to check performance of the app, like a robot testing different parts of a car. It differs from real user monitoring, which relies on actual user interactions to gather data.

What is synthetic monitoring?

The discussion about whether to test private methods in software development is ongoing, and most experts suggest avoiding it in favor of testing isolated parts of code, as highlighted in this post about C#.

Should we Unit Test Private Methods?

Unlock the power of software refinement with Extract Function.

The Power of Refactoring : Extract Function

Health check implementation in Powershell.

Implement health check n Powershell

Creating test files of different sizes in Windows is essential for various purposes, such as testing storage devices or evaluating application performance. This blog post guides you through simple techniques to generate test files of specific sizes using built-in Windows tools, ensuring efficient testing and analysis without relying on third-party software.

Create Test files with different sizes in windows

Master the art of reverting a single file in Git with precision and elegance. Learn how to effortlessly undo unintended changes, maintain a clean commit history, and restore code integrity. Take control of your files and streamline collaboration with ease.

Cleansing the Code - Mastering Single File Reversion in Git

Explore how to use the BCP utility to export data from a SQL Server database and save it to a CSV file. Provide a step-by-step guide, explaining each component of the BCP command and how to execute it successfully, offering a beginner-friendly approach to automate the export process.

Exporting SQL Server Data using BCP Utility

Azure API Management simplifies API lifecycle management, offering design flexibility, robust security features, and advanced analytics. It acts as a gateway between backend services and client applications, providing scalability and visibility into API metrics. With Azure API Management, businesses can streamline API infrastructure while ensuring security and developer productivity.

Introduction to Azure API Management: Managing APIs Made Easy

Checking installed .Net frameworks in Powershell

How to check installed .Net Framework versions in Powershell

PowerShell is a powerful scripting language that can be used to automate various administrative tasks, including data management and analysis. In this article, we will show you how to export data from a SQL database to a CSV file using a SQL query and the command-line tool.

Exporting Data to CSV using SQL Query and PowerShell

Reading a CSV file and outputting its contents as a JSON file using PowerShell.

Powershell Read CSV file and out pull json file

Resolution for Error The server principal is not able to access the database under the current security context in SQL Server

The server principal is not able to access the database under the current security context in SQL Server

Aggregate Product in SQL Server

Partition SQL Server Tables with File Groups

SQL Server Database Partitioning

Delete Millions of Rows in a Table in SQL Server using

Delete Millions of Rows in a Table in SQL Server

Fixing the issue of  Error System.Data.Odbc.OdbcException ERROR [IM014] [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application  

The specified DSN contains an architecture mismatch between the Driver and Application

Deploy Azure storage account with a blob container and generate connection string with SAS token and update one of the web app’s settings with generated connection strings.

Deploy storage account and output connection string with SAS token using ARM template

Introduce new columns to Existing List of Tables in SQL server from a query.

Add new Columns to List of Tables in SQL Server

Top-Level Statement - programs without Main methods in C#

Get the Decimal result from deviding Integers in SQL Server

Integer Division Result in Decimal in SQL server

Indices and Ranges in C#

Upload directory to Azure Storage using AzCopy in linux

READ UNCOMMITTED transaction isolation level and NOLOCK in SQL server

All Posts

Find Tables by Column names in SQL Server

Drop all tables in a specific schema

Find Database size in SQL

Build SQL connection string in powershell

How to batch update millions of record in SQL Server