Tag feed

#sql-server

839 posts1,269 followers

Explore Hashnode

Alternatives

Trending tags this week

NMNahid Mahmudnahid-mahmud555.hashnode.devOct 2 · 6 min read

My SQL Learning Journey: Day 1 & Day 2 — Mastering SELECT & Constraints

As part of my continuous technical growth and preparation for backend development, data engineering, and database-focused roles, I've started documenting my structured SQL learning journey. If you're

0

DWDan Weaverdanweaver.hashnode.devOct 1 · 11 min read

Hybrid code search on Azure SQL and SQL Server 2025, end to end

Azure SQL and SQL Server 2025 both have a native VECTOR type, a DiskANN index, and VECTOR_SEARCH. The documentation covers the syntax for each one. It does not cover what happens when you put them tog

0

Sspipaliya8sudhirpipaliya.hashnode.devSep 19 · 17 min read

EF Core Projection: How Select Can Improve Query Performance

When working with Entity Framework Core, one of the easiest ways to accidentally retrieve more data than necessary is to load complete entities. For example: var students = await context.Students

0

Sspipaliya8sudhirpipaliya.hashnode.devSep 14 · 13 min read

EF Core Include vs Select: Which One Should You Use?

When working with Entity Framework Core, developers often use Include() to load related data. But there is another powerful approach: Select() So which one should you use? The answer depends on what

0

Sspipaliya8sudhirpipaliya.hashnode.devSep 7 · 12 min read

EF Core Query Splitting vs Single Query: Which One Should You Use?

Entity Framework Core makes it very easy to load related data using Include() and ThenInclude(). For example: var students = await context.Students .Include(x => x.Standard) .Include(x => x.Di

0

Sspipaliya8sudhirpipaliya.hashnode.devSep 2 · 9 min read

Why Database Indexes Matter for EF Core Performance

Entity Framework Core makes it easy to query data using LINQ. But even a well-written EF Core query can become slow when your database grows. One of the most important factors behind query performance

0

Sspipaliya8sudhirpipaliya.hashnode.devAug 18 · 7 min read

10 Common LINQ Mistakes That Hurt EF Core Performance

LINQ makes querying data with Entity Framework Core simple and readable. But simple-looking LINQ code doesn't always mean efficient database queries. Some LINQ patterns can cause: Unnecessary databas

0

STSagar Thosarsagarthosar.hashnode.devAug 17 · 17 min read

Database Migration: Discovery Before Execution

Every database migration article seems to love the exciting stuff. Which tool should you use? How does block-level replication work? How can you get the cutover down to a few minutes? Should you go se

0

AGAbu Ghufran (GridPHP)gridphp.hashnode.devAug 10 · 3 min read

Modernizing 10-Year-Old PHP Applications Without Breaking the Monolith

If you maintain a legacy PHP application built 8–10 years ago—whether in custom PHP, CodeIgniter, Yii, or an older version of Laravel—you’ve likely faced the inevitable pressure: "We need to modernize

0

Sspipaliya8sudhirpipaliya.hashnode.devAug 6 · 5 min read

Why Calling ToList() Too Early Can Hurt EF Core Performance

If you've worked with Entity Framework Core, you've probably used ToListAsync() hundreds of times. There's nothing wrong with using it—but calling it too early in your query can significantly impact y

0

#sql-server

Search Hashnode

#sql-server

Explore Hashnode

Trending tags this week

My SQL Learning Journey: Day 1 & Day 2 — Mastering SELECT & Constraints

Hybrid code search on Azure SQL and SQL Server 2025, end to end

EF Core Projection: How Select Can Improve Query Performance

EF Core Include vs Select: Which One Should You Use?

EF Core Query Splitting vs Single Query: Which One Should You Use?

Why Database Indexes Matter for EF Core Performance

10 Common LINQ Mistakes That Hurt EF Core Performance

Database Migration: Discovery Before Execution

Modernizing 10-Year-Old PHP Applications Without Breaking the Monolith

Why Calling ToList() Too Early Can Hurt EF Core Performance