database Resources

Related resources for database

Efficient Bulk Data Retrieval in EF Core Using Extensions
Deepika Sawant
1d
Entity Framework Core – Code First Approach
Ajay Narkhedkar
2d
SQL Server 2025: Features, Enhancements, and What It Means for Modern Databases
samaira
2d
Entity Framework Core – Database First Approach
Ajay Narkhedkar
2d
Optimize MySQL Queries in Java for Better Performance
Saurav Kumar
1w
Asynchronous Programming (Async / Await) in C# and .NET Core
Ajay Narkhedkar
1w
How to Improve Entity Framework Core Query Performance?
Ananya Desai
1w
SQL Server Database Mail Setup and SMTP Configuration Guide
Maria Prince
1w
Profiling Query Regression After Release
Rajesh Gami
1w
How to Reduce Lock Contention in SQL Server Financial Ledger Tables
Rajesh Gami
1w
Optimizing Audit Queries by Time-Keyed Clustering
Rajesh Gami
2w
Archive Partition Sliding Window Strategy
Rajesh Gami
2w
Essential Database Optimization Tips for High-Performance Applications
Vishal Gami
2w
Detecting Unused or Redundant Indexes Automatically in SQL Server
Rajesh Gami
2w
Eliminating Triggers with Better Data Flow Design: A Complete Guide
Rajesh Gami
2w
Optimizing Bulk Import Pipelines with Minimal Logging: A Complete Guide
Rajesh Gami
2w
Optimizing Bulk Import Pipelines with Minimal Logging
Rajesh Gami
2w
Reducing API Response Time Using ASP.NET Core API: A Complete Guide
Rajesh Gami
2w
Columnstore Index Tuning For Mixed Workloads In SQL Server
Rajesh Gami
2w
Accelerating Large Delete Operations With Batching
Rajesh Gami
2w
Detecting And Fixing Memory Spills To TempDB In SQL Server
Rajesh Gami
2w
SQL vs NoSQL: Strategy and System Design Considerations for Modern Data Platforms
Abhishek Yadav
2w
Efficient Soft-Delete Models Without Query Degradation in SQL Server | A Practical Guide for High-Volume OLTP Systems
Rajesh Gami
2w
SQL Materialized Views for Complex Aggregates in SQL Server | Practical Guide with Real-World Patterns
Rajesh Gami
2w
🧱 Lesson 5 - Working with PostgreSQL (Multi-Database Setup)
Farrukh Rehman
2w
10 Most Common SQL Server Mistakes Every Developer Should Avoid
Amit Mohanty
2w
Solving TempDB Bottlenecks in High-Volume Inserts
Rajesh Gami
2w
Improving Slow Scalar Functions Using Inline Table-Valued Functions
Rajesh Gami
2w
Replacing ORM Generated Inefficient SQL in Hot Paths
Rajesh Gami
2w
Partition-wise Parallelism Optimization for Very Large Tables
Rajesh Gami
2w
SQL Server Basics for Web Developers: What You Must Know Before Starting
Vishal Gami
2w
Beginner Guide to Writing SQL Queries for Full-Stack Projects
Vishal Gami
2w
Stored Procedures: What They Are & Why Beginners Should Use Them
Vishal Gami
2w
Connecting ASP.NET Core to SQL Server: A Simple Walkthrough
Vishal Gami
2w
Refactoring N+1 Queries in Transactional Systems
Rajesh Gami
2w
Query Rewrite to Remove RBAR (Row‑By‑Agonizing‑Row) Patterns
Rajesh Gami
2w
Mastering Real-Time Analytics with SQL Server 2025 using In-Memory OLTP & Columnstore Indexes
Abhishek Yadav
2w
Continuous Index Tuning System (CITS): A Self-Optimizing SQL Server Index Management Engine
Rajesh Gami
2w
Entity Framework Core (EF Core) Health Checks — A Complete Guide
Abhishek Yadav
2w
Last-Minute SQL Interview Revision Guide – Part 1 (Keys, Data Types & Constraints)
Raj Bhatt
3w
How to Optimize Slow SQL Queries | Beginner-Friendly Techniques with Practical Developer Case Study
Vishal Gami
3w
How to Use TRY…CATCH for Error Handling in SQL Server
Vishal Gami
3w
Introduction to Normalization — How to Design Better Databases | SQL Server
Vishal Gami
3w
SQL Views vs Stored Procedures vs Functions — What’s the Difference?
Vishal Gami
3w
How to Create Stored Procedures in SQL Server | Beginner to Intermediate Practical Guide
Vishal Gami
3w
Workload Analyzer: Predict SQL Query Performance Using ML Models
Rajesh Gami
3w
Workload Analyzer — Predict SQL Query Performance Using ML Models
Rajesh Gami
3w
Auto-Repair Engine (Detect Broken Foreign Keys, Orphan Records, Mismatched Totals)
Rajesh Gami
3w
Understanding Indexes in SQL Server — What, Why, and When to Use Them?
Vishal Gami
3w
How to Write SQL Queries Every Beginner Should Know
Vishal Gami
3w
SQL Server Basics: Tables, Primary Keys, Foreign Keys — Explained Simply
Vishal Gami
3w
Mastering Dependency Injection in ASP.NET Core – Complete Beginner to Advanced Guide
Ajay Narkhedkar
3w
🧱 Lesson 4 - Adding SQL Server Support (Multi-Database Setup)
Farrukh Rehman
3w
Smart Index Lifecycle Manager (Auto-Create, Auto-Drop, Usage Tracking in SQL Server)
Rajesh Gami
3w
🧱 Lesson 3 - Integrating MySQL (First Database)
Farrukh Rehman
3w
20 Essential Terms to Understand When Building RAG (Retrieval-Augmented Generation) Applications
Nitin Pandit
3w
SQL Server Data Federation (Split Big Tables Across Databases but Query as One)
Rajesh Gami
3w
Creating a SQL Rule Engine Table (Validation Conditions Executed Dynamically)
Rajesh Gami
3w
Designing an Attribute-Value-Store (AVS) Engine inside SQL for Dynamic Fields
Rajesh Gami
3w
Using SQL Server in Express.js: A Complete Guide
Abhishek Yadav
3w
Intelligent Query Router: Routing Reads to Replicas and Writes to Primary for High-Performance Systems
Rajesh Gami
3w
Performance Tuning Case Study: Optimizing 10 Slow SQL Server Queries Step-by-Step
Rajesh Gami
4w
Creating a SQL-Based Notification System (Trigger + Queue Table)
Rajesh Gami
4w
How to Create Azure Cosmos DB Resources for NoSQL by using .NET Client Library?
Pankajkumar Patel
4w
SQL Server Functions in .NET Core (with EF Core)
Cynthia Sathuragiri
4w
Microsoft Fabric Brings an AI-Powered Unified Data Estate for All Databases
Vijay Kumari
4w
Implementing Change Data Capture (CDC) and Syncing Two Databases (SQL Server + .NET)
Rajesh Gami
4w
Build a Chatbot with Python and LangChain – Full Developer Guide
Rohit Gupta
4w
Implementing Row-Level Security (RLS) for Multi-Tenant Data (SQL Server + ASP.NET Core)
Rajesh Gami
4w
How to Create Azure Cosmos DB Resources by using the Azure Portal?
Pankajkumar Patel
Nov 17
Integrating Vector Databases (like Pinecone) in ASP.NET Core Search
Rajesh Gami
Nov 17
Efficient Data Partitioning in SQL Server: A Practical Guide for Tables with Millions of Records
Ck Nitin
Nov 15
Designing Multi-Tenant Architecture in ASP.NET Core using EF Core
Rajesh Gami
Nov 13
Data Synchronization Between Cloud and On-Prem SQL Databases
Rajesh Gami
Nov 12
Advanced Techniques for Semantic Search Using Embeddings in Python
Rohit Gupta
Nov 11
Using AI to Suggest Database Indexing Strategies in SQL Server: Intelligent Optimization for High-Performance Applications
Rajesh Gami
Nov 11
Optimizing EF Core Queries for Large Data Applications | ASP.NET CORE
Rajesh Gami
Nov 10
📊 Building a Centralized Reporting Database Using Linked Servers in SQL Server
Vipin Mittal
Nov 10
🧩 Integrating SQL Server with Excel and Access Databases: A Complete Step-by-Step Guide
Vipin Mittal
Nov 10
FastAPI + LLMs: Building a Scalable AI Backend
Rohit Gupta
Nov 07
Advanced RAG in Python with FastAPI – Multi-Source Retrieval and Evaluation
Rohit Gupta
Nov 07
Implementing Database Audit Logging Using Triggers in Oracle
Sandhiya Priya
Nov 07
Migrating from SQL Server 2016/2019 to SQL Server 2025 or Azure SQL: A Complete Developer’s Guide
Rajesh Gami
Nov 06
Securing SQL Server: Best Practices, Threat Detection, Encryption & Access Controls
Rajesh Gami
Nov 05
SQL Server Indexing Strategies for Faster Query Execution
Rajesh Gami
Nov 05
Automating Bank Statement Analysis with LLMs & RAG Techniques
Rohit Gupta
Nov 04
The Overlooked Link Between Security and Performance in SQL Server
Nikolaos Kantzelis
Nov 04
SQL Injection in Laravel: Understanding, Exploiting, and Preventing Attacks
Sam Bishop
Nov 03
Redis: The Fastest In-Memory Data Store Powering Modern Applications
Rishima
Nov 03
SQL Server Security Best Practices for Developers
Rajesh Gami
Oct 31
Writing High-Performance Stored Procedures in SQL Server
Rajesh Gami
Oct 31
Common Mistakes Developers Make in SQL Queries (and How to Fix Them)
Rajesh Gami
Oct 31
SQL Server 2025 – What’s New & What’s Changed
Rajesh Gami
Oct 31
SQL Commenting Best Practices: Benefits, Standards & Examples
Raj Bhatt
Oct 30
🧾 Dynamic ActiveX Report Using Database in Angular
Vipin Mittal
Oct 26
🎯 Top SQL Server Queries Asked in Interviews (With Examples)
Ck Nitin
Oct 25
PostgreSQL Architecture and Deployment: A Technical Overview with Azure Integration
Deepika Sawant
Oct 24
Chapter 25: Advanced Browser Features: Web Workers & IndexedDB
Akshay Amin
Oct 24
Part III - Best Practices for Handling Connection Strings in C#
Vinoth Xavier
Oct 24
Using Managed Identity with Azure Functions to Connect to Azure SQL Database
Tuhin Paul
Oct 23

Topics

Efficient Bulk Data Retrieval in EF Core Using Extensions

Entity Framework Core – Code First Approach

SQL Server 2025: Features, Enhancements, and What It Means for Modern Databases

Entity Framework Core – Database First Approach

Optimize MySQL Queries in Java for Better Performance

Asynchronous Programming (Async / Await) in C# and .NET Core

How to Improve Entity Framework Core Query Performance?

SQL Server Database Mail Setup and SMTP Configuration Guide

Profiling Query Regression After Release

How to Reduce Lock Contention in SQL Server Financial Ledger Tables

Optimizing Audit Queries by Time-Keyed Clustering

Archive Partition Sliding Window Strategy

Essential Database Optimization Tips for High-Performance Applications

Detecting Unused or Redundant Indexes Automatically in SQL Server

Eliminating Triggers with Better Data Flow Design: A Complete Guide

Optimizing Bulk Import Pipelines with Minimal Logging: A Complete Guide

Optimizing Bulk Import Pipelines with Minimal Logging

Reducing API Response Time Using ASP.NET Core API: A Complete Guide

Columnstore Index Tuning For Mixed Workloads In SQL Server

Accelerating Large Delete Operations With Batching

Detecting And Fixing Memory Spills To TempDB In SQL Server

SQL vs NoSQL: Strategy and System Design Considerations for Modern Data Platforms

Efficient Soft-Delete Models Without Query Degradation in SQL Server | A Practical Guide for High-Volume OLTP Systems

SQL Materialized Views for Complex Aggregates in SQL Server | Practical Guide with Real-World Patterns

🧱 Lesson 5 - Working with PostgreSQL (Multi-Database Setup)

10 Most Common SQL Server Mistakes Every Developer Should Avoid

Solving TempDB Bottlenecks in High-Volume Inserts

Improving Slow Scalar Functions Using Inline Table-Valued Functions

Replacing ORM Generated Inefficient SQL in Hot Paths

Partition-wise Parallelism Optimization for Very Large Tables

SQL Server Basics for Web Developers: What You Must Know Before Starting

Beginner Guide to Writing SQL Queries for Full-Stack Projects

Stored Procedures: What They Are & Why Beginners Should Use Them

Connecting ASP.NET Core to SQL Server: A Simple Walkthrough

Refactoring N+1 Queries in Transactional Systems

Query Rewrite to Remove RBAR (Row‑By‑Agonizing‑Row) Patterns

Mastering Real-Time Analytics with SQL Server 2025 using In-Memory OLTP & Columnstore Indexes

Continuous Index Tuning System (CITS): A Self-Optimizing SQL Server Index Management Engine

Entity Framework Core (EF Core) Health Checks — A Complete Guide

Last-Minute SQL Interview Revision Guide – Part 1 (Keys, Data Types & Constraints)

How to Optimize Slow SQL Queries | Beginner-Friendly Techniques with Practical Developer Case Study

How to Use TRY…CATCH for Error Handling in SQL Server

Introduction to Normalization — How to Design Better Databases | SQL Server

SQL Views vs Stored Procedures vs Functions — What’s the Difference?

How to Create Stored Procedures in SQL Server | Beginner to Intermediate Practical Guide

Workload Analyzer: Predict SQL Query Performance Using ML Models

Workload Analyzer — Predict SQL Query Performance Using ML Models

Auto-Repair Engine (Detect Broken Foreign Keys, Orphan Records, Mismatched Totals)

Understanding Indexes in SQL Server — What, Why, and When to Use Them?

How to Write SQL Queries Every Beginner Should Know

SQL Server Basics: Tables, Primary Keys, Foreign Keys — Explained Simply

Mastering Dependency Injection in ASP.NET Core – Complete Beginner to Advanced Guide

🧱 Lesson 4 - Adding SQL Server Support (Multi-Database Setup)

Smart Index Lifecycle Manager (Auto-Create, Auto-Drop, Usage Tracking in SQL Server)

🧱 Lesson 3 - Integrating MySQL (First Database)

20 Essential Terms to Understand When Building RAG (Retrieval-Augmented Generation) Applications

SQL Server Data Federation (Split Big Tables Across Databases but Query as One)

Creating a SQL Rule Engine Table (Validation Conditions Executed Dynamically)

Designing an Attribute-Value-Store (AVS) Engine inside SQL for Dynamic Fields

Using SQL Server in Express.js: A Complete Guide

Intelligent Query Router: Routing Reads to Replicas and Writes to Primary for High-Performance Systems

Performance Tuning Case Study: Optimizing 10 Slow SQL Server Queries Step-by-Step

Creating a SQL-Based Notification System (Trigger + Queue Table)

How to Create Azure Cosmos DB Resources for NoSQL by using .NET Client Library?

SQL Server Functions in .NET Core (with EF Core)

Microsoft Fabric Brings an AI-Powered Unified Data Estate for All Databases

Implementing Change Data Capture (CDC) and Syncing Two Databases (SQL Server + .NET)

Build a Chatbot with Python and LangChain – Full Developer Guide

Implementing Row-Level Security (RLS) for Multi-Tenant Data (SQL Server + ASP.NET Core)

How to Create Azure Cosmos DB Resources by using the Azure Portal?

Integrating Vector Databases (like Pinecone) in ASP.NET Core Search

Efficient Data Partitioning in SQL Server: A Practical Guide for Tables with Millions of Records

Designing Multi-Tenant Architecture in ASP.NET Core using EF Core

Data Synchronization Between Cloud and On-Prem SQL Databases

Advanced Techniques for Semantic Search Using Embeddings in Python

Using AI to Suggest Database Indexing Strategies in SQL Server: Intelligent Optimization for High-Performance Applications

Optimizing EF Core Queries for Large Data Applications | ASP.NET CORE

📊 Building a Centralized Reporting Database Using Linked Servers in SQL Server

🧩 Integrating SQL Server with Excel and Access Databases: A Complete Step-by-Step Guide