AAlex Morgan1d ago · 8 min readHow to Investigate Unexpected SQL Server Data Changes Using Transaction LogsA database record disappears. A customer table contains an unexpected update. An application changes values that nobody remembers modifying. For a SQL Server administrator, investigating these situatisql-database-insights.hashnode.dev
AAtash DasOct 15 · 11 min readSAP Disaster Recovery Architecture — When Each Tool Earns Its PlaceAbstract SAP disaster recovery on AWS is rarely one technology — it's a stack, and picking the wrong tool at any single layer breaks the whole plan. This piece starts with AWS's own architecture patteatashdas.hashnode.dev
Sspipaliya8Oct 12 · 6 min readEF Core Any vs Count: Which One Is Better for Existence Checks?When working with Entity Framework Core (EF Core), we often need to check whether a record exists in the database. For example: Does a student already exist? Has an email address already been registsudhirpipaliya.hashnode.dev
NNahid MahmudOct 2 · 6 min readMy SQL Learning Journey: Day 1 & Day 2 — Mastering SELECT & ConstraintsAs 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 1nahid-mahmud555.hashnode.dev
DDan WeaverOct 1 · 11 min readHybrid code search on Azure SQL and SQL Server 2025, end to endAzure 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 togdanweaver.hashnode.dev
Sspipaliya8Sep 19 · 17 min readEF Core Projection: How Select Can Improve Query PerformanceWhen 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 sudhirpipaliya.hashnode.dev
Sspipaliya8Sep 14 · 13 min readEF 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 sudhirpipaliya.hashnode.dev
Sspipaliya8Sep 7 · 12 min readEF 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.Disudhirpipaliya.hashnode.dev
Sspipaliya8Sep 2 · 9 min readWhy Database Indexes Matter for EF Core PerformanceEntity 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 performancesudhirpipaliya.hashnode.dev
Sspipaliya8Aug 18 · 7 min read10 Common LINQ Mistakes That Hurt EF Core PerformanceLINQ 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 databassudhirpipaliya.hashnode.dev
