DotNet By Ajay

Practical tips, tutorials & insights from the .NET Ecosystem 🚀 { C# • ASP.NET Core • Azure • Angular • AI-Assisted Dev } Building smarter with Cursor AI & GitHub Copilot ⚡

DotNet By Ajay — New: ES2025 cheat-sheet is live!

Home

Life Notes ▾

Thoughts Reflections Poetry

Quiz Corner ▾

Quizzes GK

My Reads

About Me

May 31, 2026

LeetCode 185: Department Top Three Salaries | SQL DENSE_RANK Solution Explained with Example

Problem Statement

We need to find all employees whose salary belongs to the top 3 unique salaries within their department.

A high earner is an employee whose salary is among the top three distinct salaries in their department.

Categories: Coding Interview, Database Problems, DENSE_RANK, LeetCode, LeetCode 185, MySQL, PostgreSQL, SQL, SQL Interview Questions, Window Functions

August 6, 2025

🤖 What is AI?

A Simple Guide to Artificial Intelligence

We keep hearing about AI everywhere these days — from news headlines to our mobile apps. But what exactly is it?

Categories: .NET Dev Corner, AI, Artificial Intelligence, Beginner Friendly, Computer Vision, Machine Learning, NLP, Robotics, Simple Tech Guides, Technology Basics, What is AI

June 18, 2025

🚀 ADO.NET - Deep Dive into ExecuteScalar()

Categories: .NET Dev Corner, .NET Interview Questions, ADO.NET, C# Best Practices, C# Database Operations, Data Access in .NET, ExecuteNonQuery, ExecuteReader, ExecuteScalar, Performance Optimization, Scalar Queries, SqlCommand

June 17, 2025

🛠️ Step-by-Step Logging in .NET using Serilog

Logging with Serilog in .NET

Categories: .NET Core, .NET Dev Corner, ASP.NET Core, C# Development, Dev Tutorial, Logging in .NET, Logging Middleware, Serilog, Serilog Logging, Structured Logging, Visual Studio

June 16, 2025

📢 Microsoft Weekly Brief – Latest .NET & Azure Highlights (Week of June 10–16, 2025)

Categories: .NET 9, .NET Dev Corner, Azure Updates, Dev Tools, Developer Brief, GitHub Copilot, Microsoft Dev News, Microsoft Weekly, Visual Studio 2025, Weekly Tech Updates

Newer Posts Older Posts Home

Subscribe to: Posts (Atom)

Labels

.Net .NET 8 .NET 9 .NET Architecture .NET Basics .NET Best Practices .NET Core .NET Dev Corner .NET DEV CORNER BY AJAY .NET Development .NET Fundamentals .NET Interview Questions .Net Terminology .NET Tips .NET Tutorial 'new' expression 20 Best SQL Editor Tools of 2020 Access Modifiers ADO.NET AI Ajay Gangwar ajayapril1991 App Service Application Insights AppSettings Artificial Intelligence as operator Asp.Net ASP.NET Core ASP.NET Tutorial Async Await Azure Deployment Azure Updates Beginner Friendly Beginner Tutorials Best Practices Best SQL Editor Tools Beware Beware of Fake Offers and Hoax calls from fraudsters / miscreants C Program C# C# 13 C# 9.0 C# Basics C# Best Practices C# Database Operations C# Development C# Fundamentals C# Interview C# Interview Questions C# OOP C# Tips C# Tutorial Clean Architecture Clean Code CMDCommand Code Optimization Coding Best Practices Coding Fundamentals Coding Interview Coding Practices Coding Thoughts Coding Tips Common Table Expression Computer Vision Configuration Management CSharp CSharp Basics CSharp Interview Questions CTE Custom Middleware Data Access in .NET Database Database Best Practices Database Development Database Problems DateTime Format DENSE_RANK Dependency Injection Dev Journal Dev Tips Dev Tools Dev Tutorial Developer Brief Developer Diary Developer News Developer Tips Developer Tools Difference Between DropDownList EF Core Encapsulation Entity Framework Core ExecuteNonQuery ExecuteReader ExecuteScalar Fake Offers FastStone FastStone Capture Folder Organization Fraudsters General Knowledge GitHub Actions GitHub Copilot Grace Period HackerRank Hoax calls How to create another table using existing table? HTML IConfiguration IDE0090 in keyword Inheritance Interface internal Interview Question Interview Questions Introduction of C# is operator JAVA JavaScript jQuery Knowledgable LeetCode LeetCode 185 LIC LIC Premium Payments LINQ List of 20 Best SQL Editor Tools Logging Logging in .NET Logging in C# Logging Middleware Logging Tutorial Machine Learning Max-Length Memory Management Method Overloading Method Overriding Difference Between Method Parameters Microsoft Dev News Microsoft Updates Microsoft Weekly Middleware Mind IT Miscreants Multiline Textbox Multiple Inheritance Multiple Interface MySQL NLP Null Handling Object Oriented Programming OOP OOP's OOP's Interview Question out keyword Pass by Reference Pattern Matching Performance Monitoring Performance Optimization Performance Tuning Personal Insight PostgreSQL private Productivity Project Structure protected public Query Optimization Real World .NET Recursive CTE ref keyword Reference Type Request Pipeline Robotics Scalar Queries Sealed Class Sealed Method Secure Coding Serail Key Serilog Serilog Logging Shadowing Simple Tech Guides Software Solution Design SQL SQL Interview SQL Interview Question SQL Interview Questions SQL Performance SQL Server SQL Server | Auto-Increment SQL Server | Distinct Clause SQL Server | SQL Server Agent Jobs SQL Server Agent Jobs SQL Server Jobs SQL Server Management Studio SQL Tips SqlCommand SSMS Stack vs Heap Struct vs Class Structured Logging Technology Basics toUpperCase() Tutorial Tuesday Type Casting Type Checking Unhandled Exception Validate Validate Email Address Value Type VB.Net Virtu Vision Of .Net Visual Studio Visual Studio 2025 Visual Studio Messages VS Extensions Web API Wednesday Wisdom Weekly Brief Weekly Reflection Weekly Tech Updates What is AI What is ASP.NET? What is name of text editor in window to type your SQL queries? What is OOP in C#? What is the Vision Of .Net? Window Functions

Powered by Blogger.