SQL Server - Curated .NET Articles & Tutorials

Curated .NET news, articles, and tutorials about SQL Server, drawn from .NET News Daily issues.

93 curated issues

Introducing Apache Arrow Support in mssql-python

mssql-python now supports fetching SQL Server data directly as Apache Arrow structures - a faster and more memory-efficient path for anyone working with SQL Server data in Polars, Pandas, DuckDB, or a...

Featured in Issue #455 May 13, 2026

Issue also covered: Azure, Clean Architecture, C#, .NET 10, .NET MAUI, Minimal APIs, OpenAI, Performance

Read this issue →

Microsoft SQL Security Across the MAESTRO Stack: Building Secure Agentic AI with Defense-in-Depth

Artificial Intelligence is evolving rapidly. What began as simple prompt-and-response systems is now transforming into fully autonomous, agentic AI architectures capable of reasoning, orchestrating to...

Featured in Issue #459 May 19, 2026

Issue also covered: ASP.NET Core, Azure, Cosmos DB, C#, .NET 10, EF Core, GitHub Copilot, OpenAI

Read this issue →

Ergonomic ADO.NET

Types and extensions to help improve your ADO.NET code

Featured in Issue #447 May 04, 2026

Issue also covered: ASP.NET Core, C#, Design Patterns, ML.NET, Performance, Security, Solid Principles

Read this issue →

Slowly Changing Dimensions: The complete SQL guide

Data warehouses are designed to answer one key question: what happened, and what did things look like at that time? This is where Slowly…

Featured in Issue #442 April 27, 2026

Issue also covered: ASP.NET Core, Blazor, Clean Architecture, C#, .NET Framework, EF Core, GitHub Copilot, OpenAI

Read this issue →

Still writing long SQL queries for every database operation?

What if you could interact with your database using simple C# code?

Featured in Issue #437 April 20, 2026

Issue also covered: Azure, Clean Architecture, C#, .NET Core, EF Core, OpenAI, Performance, Semantic Kernel

Read this issue →

How C# Strings Silently Kill Your SQL Server Indexes in Dapper

A common Dapper pattern that causes SQL Server to ignore your indexes and scan entire tables.

Featured in Issue #414 March 18, 2026

Issue also covered: ASP.NET Core, Dapper, .NET 10, EF Core, MediatR, Performance, Source Generators, Visual Studio Code

Read this issue →

Dealing with DB Null: Solving the Object cannot be cast from DB Null to other types Error in C#

Safely handle DBNull values in C# when querying databases like Oracle or SQL Server. Prevent InvalidCastExceptions with practical examples and extension methods.

Featured in Issue #409 March 11, 2026

Issue also covered: ASP.NET Core, Azure, Clean Architecture, C#, Design Patterns, .NET Core, EF Core, OpenAI

Read this issue →

Dealing with DB Null: Solving the Object cannot be cast from DB Null to other types Error in C#

Safely handle DBNull values in C# when querying databases like Oracle or SQL Server. Prevent InvalidCastExceptions with practical examples and extension methods.

Featured in Issue #405 March 05, 2026

Issue also covered: AOT, ASP.NET Core, Azure, Clean Architecture, C#, Design Patterns, EF Core, ML.NET

Read this issue →

Time Travel in Azure SQL with Temporal Tables

Applications often need to know what data looked like before. Who changed it, when it changed, and what the previous values were. Rebuilding that history in application code is tedious and error prone...

Featured in Issue #395 February 19, 2026

Issue also covered: ASP.NET Core, Azure, Blazor, C#, Domain-Driven Design, .NET 10, .NET Core, Performance

Read this issue →

Azure SQL Managed Instance just got WAY faster - Meet Next gen GP | Data Exposed

Microsoft Azure SQL: https://aka.ms/msazuresqlyt In this episode, Anna Hoffman and Uros Milanovic explain how you get lower latency, higher throughput and IOPS, more storage and databases per instanc...

Featured in Issue #391 February 13, 2026

Issue also covered: Azure, Clean Architecture, CQRS, C#, Design Patterns, .NET 8, .NET Core, EF Core

Read this issue →

Enable Soft Delete in Azure SQL

Sometimes applications need to remove data without actually losing it. Soft delete keeps rows in the database while making them invisible to normal application access. This is especially valuable when...

Featured in Issue #389 February 11, 2026

Issue also covered: C#, Design Patterns, .NET 10, EF Core, GitHub Copilot, OAuth, OpenAI, Performance

Read this issue →

REST APIs, Vectors, and AI in SQL Server 2025 | Data Exposed: MVP Edition

In this episode, Ben Weissman, a Microsoft MVP and Data Platform expert, dives in REST APIs, vectors, and AI in SQL Server 2025. Microsoft Most Valuable Professionals, or MVPs, are technology experts ...

Featured in Issue #384 February 04, 2026

Issue also covered: ASP.NET Core, Authentication, Azure, Clean Architecture, Domain-Driven Design, .NET 10, EF Core, ML.NET

Read this issue →

REST APIs, Vectors, and AI in SQL Server 2025 | Data Exposed: MVP Edition

In this episode, Ben Weissman, a Microsoft MVP and Data Platform expert, dives in REST APIs, vectors, and AI in SQL Server 2025. Microsoft Most Valuable Professionals, or MVPs, are technology experts ...

Featured in Issue #383 February 03, 2026

Issue also covered: ASP.NET Core, Authentication, Azure, C#, .NET 10, .NET 8, EF Core, OAuth

Read this issue →

DiskANN: An overview of vector indexing in Azure SQL and Fabric SQL | Data Exposed

Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt

Featured in Issue #374 January 21, 2026

Issue also covered: .NET Aspire, Azure, C#, .NET 10, .NET 8, .NET Core, GitHub Copilot, System.Text.Json

Read this issue →

Semantic Reranking with Azure SQL, SQL Server 2025 and Cohere Rerank models

Supporting re‑ranking has been one of the most common requests lately. While not always essential, it can be a valuable addition to a solution when you want to improve the precision of your results. U...

Featured in Issue #367 January 12, 2026

Issue also covered: Azure, Blazor, C#, Design Patterns, .NET 10, .NET 9, EF Core, .NET MAUI

Read this issue →

EF Core Bulk Data Retrieval: 5 Methods You Should Know

Learn how to efficiently retrieve large datasets in Entity Framework Core without hitting SQL Server's 2,100 parameter limit. Discover 5 bulk data retrieval methods from Entity Framework Extensions th

Featured in Issue #355 December 25, 2025

Issue also covered: ASP.NET Core, Authentication, C#, Dapper, Docker, .NET 10, .NET Framework, EF Core

Read this issue →

⚡ How a Missing SQL Index Crashed a High-Traffic .NET E-Commerce Platform

Discover how a single missing SQL index crashed a high-traffic .NET e-commerce platform and the lessons for real-world architecture.

Featured in Issue #347 December 15, 2025

Issue also covered: ASP.NET Core, Azure, Clean Architecture, C#, Design Patterns, .NET 10, .NET 8, EF Core

Read this issue →

⚡ Extremely FAST Paging With Cursor Pagination & Index Seek

SQL Server • PostgreSQL • MySQL • MongoDB Compared — with Full .NET 9 Code (Part 1)

Featured in Issue #342 December 08, 2025

Issue also covered: ASP.NET Core, Azure, Clean Architecture, C#, Dapper, Domain-Driven Design, Design Patterns, .NET 10

Read this issue →

Optimistic Locking vs Pessimistic Locking with EF Core (.NET 9): The Clear, Battle-Tested Guide

.NET Day on Agentic Modernization Coming Soon

Featured in Issue #338 December 02, 2025

Issue also covered: AutoMapper, Clean Architecture, CQRS, C#, Dapper, Domain-Driven Design, Design Patterns, .NET 10

Read this issue →

SQL Server 2025 Embraces Vectors: setting the foundation for empowering your data with AI

SQL Server 2025 marks a major milestone in database innovation by introducing native support for VECTOR data types and vector functions. These are now fully available in the freshly released SQL Serve...

Featured in Issue #332 November 24, 2025

Issue also covered: ASP.NET Core, Azure, .NET Core, EF Core, JWT, .NET MAUI, OAuth

Read this issue →

SQL Server Indexing Strategies for Faster Query Execution

Boost SQL Server query speed! Master indexing: clustered, non-clustered, composite, filtered, columnstore. Optimize performance & avoid common pitfalls. A must-read!

Featured in Issue #326 November 14, 2025

Issue also covered: ASP.NET Core, Authentication, Azure, C#, Dapper, .NET 9, JWT, OAuth

Read this issue →

Why I Skip Primary Constructors In C#

I choose to skip primary constructors altogether, at they offer no real benefit beyond syntactic sugar. Shorter doesn't necessarily mean…

Featured in Issue #325 November 13, 2025

Issue also covered: ASP.NET Core, Azure, Blazor, C#, .NET 10, GitHub Actions, OpenTelemetry, Performance

Read this issue →

Building a REST API with .NET and SQL Server — The Clean Way

When I first started building APIs in .NET, I thought the goal was simple: get data from SQL Server and return it as JSON. It worked — but…

Featured in Issue #324 November 12, 2025

Issue also covered: ASP.NET Core, Azure, Blazor, Clean Architecture, C#, Docker, .NET 8, .NET 9

Read this issue →

How Learning SQL Can Open Doors in the Age of Data

Every click, swipe, and purchase creates data. Every business, from a tiny online shop to global tech giants, is swimming in it. But here’s the catch: only a small percentage of people actually know h...

Featured in Issue #321 November 07, 2025

Issue also covered: Application Insights, ASP.NET Core, .NET Aspire, Authentication, AutoMapper, Azure, C#, .NET 10

Read this issue →

Implementing Vector Search in Your Application with SQL Server 2025 | Data Exposed: MVP Edition

Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. He is recognized as a VMWare vExpert and a Microsoft Data Platform MVP...

Featured in Issue #320 November 06, 2025

Issue also covered: .NET Aspire, Authentication, AutoMapper, Azure, Azure DevOps, Clean Architecture, C#, Domain-Driven Design

Read this issue →

Stop Storing JSON as Text: EF 10 Makes It Native

Explore EF 10’s support for SQL Server’s new JSON data type Continue reading on .Net Programming »

Featured in Issue #314 October 29, 2025

Issue also covered: ASP.NET Core, C#, .NET 10, EF Core, Performance, Visual Studio

Read this issue →

Automating User Allotment Data Processing from Emails Using C# and SQL Server

Automate allotment data processing from emails using C# and SQL Server. This tutorial shows how to read emails, download CSVs, and update your database automatically.

Featured in Issue #313 October 28, 2025

Issue also covered: ASP.NET Core, Authentication, Authorization, Azure, Azure Functions, Clean Architecture, Cosmos DB, CQRS

Read this issue →

Implementing Azure Arc for SQL Server

Managing SQL Server across hybrid and multi-cloud environments has long posed a challenge for database administrators. To help meet that challenge, Gilda Alvarez will explain the nuts and bolts at the...

Featured in Issue #310 October 23, 2025

Issue also covered: ASP.NET Core, Azure, Azure DevOps, Azure Functions, CQRS, C#, Design Patterns, .NET 9

Read this issue →

Auditing Changes in EF Core: Track Who Updated What and When

A step-by-step guide to logging who updated what and when in your .NET applications.

Featured in Issue #309 October 22, 2025

Issue also covered: Application Insights, ASP.NET Core, Azure, Clean Architecture, C#, Domain-Driven Design, Docker, .NET 9

Read this issue →

🚀 Master SQL Server Transaction Log Management — The Smart, Secure, Automated Way!

Master SQL Server transaction log management! Stop runaway log files from consuming disk space. Learn a safe, automated approach to manage log growth without breaking your backup chain. Includes a fre...

Featured in Issue #308 October 21, 2025

Issue also covered: ASP.NET Core, Azure, CQRS, C#, .NET 10, Performance, Security

Read this issue →

Next-Level SQL in VS Code: GitHub Copilot, Containers & more | Data Exposed

Learn how to enhance your SQL development experience with GitHub Copilot, SQL Server containers, and Fabric in this episode of Data Exposed. To wrap things up, we showcase the latest deployment featur...

Featured in Issue #296 October 03, 2025

Issue also covered: ASP.NET Core, Authentication, Azure, Blazor, C#, Docker, EF Core, GitHub Copilot

Read this issue →

SQL Server 2025 Isn’t Just a Database — It’s Your New AI Platform

Tired of managing a dozen different services just to add AI features like semantic search or RAG to your application? SQL Server 2025 is… Continue reading on Towards Dev »

Featured in Issue #292 September 29, 2025

Issue also covered: ASP.NET Core, .NET Aspire, Authentication, Azure, C#, Design Patterns, .NET 10, EF Core

Read this issue →

Designing, Securing, and Optimizing SQL Server: A Realistic E-Commerce Example

Learn schema design principles, indexing strategies for query tuning, and efficient ETL processes for data loading. Implement robust backup and recovery plans, secure your database with role-based acc...

Featured in Issue #286 September 17, 2025

Issue also covered: AOT, ASP.NET Core, Azure, Azure Functions, Benchmarking, C#, .NET 8, EF Core

Read this issue →

Find High-Usage Queries and Stored Procedures in SQL Server

Identify the SQL statements and stored procedures that burn the most CPU, IO, and time using SQL Server DMVs—plus quick scripts, filters, and tips to fix them.

Featured in Issue #283 September 12, 2025

Issue also covered: ASP.NET Core, Authentication, Authorization, Azure, Blazor, Clean Architecture, C#, .NET 8

Read this issue →

From SQL Stored Procs to Pure LINQ/Lambda in .NET:

You’ve built everything in Microsoft SQL Server with stored procedures — fast, predictable, and close to the metal. Now you want the same…

Featured in Issue #280 September 09, 2025

Issue also covered: .NET Aspire, Azure, C#, .NET 10, Minimal APIs, ML.NET, Performance, Security

Read this issue →

Entity Framework is a $100 Million Mistake ( We Use Dapper + Raw SQL)

Your database queries are costing you users.

Featured in Issue #270 August 26, 2025

Issue also covered: ASP.NET Core, Blazor, CQRS, C#, Dapper, Domain-Driven Design, .NET 10, .NET 9

Read this issue →

SQL Server Features: A Comprehensive Guide for Developers

Mastering Advanced SQL Server Features: A Comprehensive Guide for Developers

Featured in Issue #268 August 22, 2025

Issue also covered: ASP.NET Core, Azure, C#, .NET 9, .NET Core, EF Core, GitHub Copilot, Native AOT

Read this issue →

Bulk Inserts in .NET: Fast, Lock-Friendly with SqlBulkCopy

Import millions of records in SQL Server with batching for maximum throughput and minimal locking.

Featured in Issue #266 August 20, 2025

Issue also covered: Application Insights, ASP.NET Core, Authentication, Azure, C#, .NET Core, EF Core, GitHub

Read this issue →

Building an Invoice Entry System with Angular, ASP.NET Core, Dapper, CQRS, and SQL Server

Learn how Vibe Coding revolutionizes retail merchandising by replacing static seasonal plans with AI-powered, multi-agent systems that detect trends, align inventory, adjust pricing, and personalize c...

Featured in Issue #265 August 19, 2025

Issue also covered: AOT, ASP.NET Core, Azure, Clean Architecture, CQRS, C#, Dapper, Domain-Driven Design

Read this issue →

Building an ASP.NET GridView with DatePicker Filter and WebMethod Dropdown

Learn how to build a dynamic ASP.NET GridView with a DatePicker filter and a dropdown populated using WebMethod from SQL Server using C# and AJAX for real-time filtering.

Featured in Issue #262 August 14, 2025

Issue also covered: ASP.NET Core, Azure, C#, .NET 10, .NET 9, .NET Core, GitHub Copilot, .NET MAUI

Read this issue →

COALESCE vs. ISNULL: Better NULL Handling in .NET Apps

Compare COALESCE and ISNULL to write cleaner, portable SQL for your .NET data layers. Continue reading on ITNEXT »

Featured in Issue #259 August 11, 2025

Issue also covered: ASP.NET Core, C#, .NET 10, Performance, Security, Source Generators, Unit Testing, Visual Studio

Read this issue →

Supercharged Performance with SQL Partitioning & C#: One Strategy, Multiple Tables

Scenario:

Featured in Issue #258 August 08, 2025

Issue also covered: ASP.NET Core, Blazor, C#, .NET Core, EF Core, GitHub Copilot, JWT, Performance

Read this issue →

Announcing General Availability of UNISTR function and ANSI SQL || Operator in Azure SQL

We’re excited to announce the General Availability (GA) of two long-standing capabilities that address critical needs for SQL developers and enterprise customers in Azure SQL Database and Azure SQL Ma...

Featured in Issue #257 August 07, 2025

Issue also covered: .NET Aspire, Authentication, Authorization, Azure, C#, .NET 10, EF Core, GitHub Copilot

Read this issue →

Repeater Control in ASP.NET Web Forms with C#

Learn how to use the Repeater control in ASP.NET Web Forms with C# to display IPO data from a SQL Server database. This lightweight, customizable control is ideal for simple, flexible, HTML-driven dat...

Featured in Issue #256 August 06, 2025

Issue also covered: ASP.NET Core, Azure, CQRS, Dapper, .NET 9, EF Core, .NET MAUI, MediatR

Read this issue →

SQL Best Practices from a .NET Core Developer’s Lens — What I Wish I Knew Earlier

https://medium.com/@sunita.rawat.cgi/sql-best-practices-from-a-net-core-developers-lens-what-i-wish-i-knew-earlier-b954a8b83a41

Featured in Issue #253 August 01, 2025

Issue also covered: ASP.NET Core, Azure, C#, .NET 9, GitHub Copilot, Performance, Visual Studio Code

Read this issue →

Temp Tables vs CTEs in SQL Server: What You Should Really Know

https://www.c-sharpcorner.com/article/temp-tables-vs-ctes-in-sql-server-what-you-should-really-know/

Featured in Issue #250 July 29, 2025

Issue also covered: ASP.NET Core, Clean Architecture, .NET 9, EF Core, GitHub Copilot, Performance, RabbitMQ, Redis

Read this issue →

Code First vs. Database First: A Pragmatic Guide for Modern Software Engineers

https://medium.com/@MatinGhanbari/code-first-vs-database-first-a-pragmatic-guide-for-modern-software-engineers-29ac04f1daa1

Featured in Issue #241 July 16, 2025

Issue also covered: Authentication, Azure, Blazor, CQRS, C#, Design Patterns, .NET 10, EF Core

Read this issue →

Boost SQL Server Performance in .NET: The Hybrid Index Strategy (Part 3)

https://itnext.io/boost-sql-server-performance-in-net-the-hybrid-index-strategy-part-3-ebaf40397ed2?source=rss------dotnet-5

Featured in Issue #240 July 15, 2025

Issue also covered: ASP.NET Core, Authentication, Azure, C#, .NET Core, JWT, OpenAI, Performance

Read this issue →

Why You Must Switch from System.Data.SqlClient to Microsoft.Data.SqlClient Now

https://medium.com/@nagarajvela/why-you-must-switch-from-system-data-sqlclient-to-microsoft-data-sqlclient-now-3d9ba2a8b9c2

Featured in Issue #236 July 09, 2025

Issue also covered: ASP.NET Core, Authentication, AutoMapper, Azure, C#, .NET Core, EF Core, .NET MAUI

Read this issue →

How Indexed Views Cut SQL Server Dashboard Load Time by 93% (Part 2)

https://itnext.io/how-indexed-views-cut-sql-server-dashboard-load-time-by-93-part-2-82a0463ba462

Featured in Issue #235 July 08, 2025

Issue also covered: ASP.NET Core, Azure, C#, Design Patterns, .NET Core, OpenAI, Performance, Semantic Kernel

Read this issue →

How to Collaboratively Work with SQL Server 2025, Visual Studio Code, and GitHub Copilot (Step-by-Step Guide)

https://www.c-sharpcorner.com/article/how-to-collaboratively-work-with-sql-server-2025-visual-studio-code-and-github/

Featured in Issue #225 June 24, 2025

Issue also covered: ASP.NET Core, Authentication, C#, Design Patterns, .NET Core, .NET Framework, EF Core, GitHub

Read this issue →

Build modern data applications with SQL Server 2025 | Data Exposed

https://www.youtube.com/watch?v=pckjd-5rT9M

Featured in Issue #220 June 17, 2025

Issue also covered: C#, EF Core, GitHub Copilot, Minimal APIs, Performance, Visual Studio

Read this issue →

Horizontal vs Vertical Partitioning in SQL

https://www.c-sharpcorner.com/article/horizontal-vs-vertical-partitioning-in-sql/

Featured in Issue #218 June 13, 2025

Issue also covered: Azure, C#, Performance, Serilog

Read this issue →

Debunking the "Filter Early, JOIN Later" SQL Performance Myth

https://www.milanjovanovic.tech/blog/debunking-the-filter-early-join-later-sql-performance-myth

Featured in Issue #217 June 12, 2025

Issue also covered: ASP.NET Core, Authentication, Design Patterns, .NET 9, .NET Core, JWT, ML.NET, OAuth

Read this issue →

Using Oracle with Entity Framework

https://nodogmablog.bryanhogan.net/2025/05/using-oracle-with-entity-framework/

Featured in Issue #211 June 04, 2025

Issue also covered: Azure, C#, Design Patterns, EF Core, .NET MAUI, OpenAI, Performance, Security

Read this issue →

New AI Features in SQL Server 2025

https://devblogs.microsoft.com/azure-sql/new-ai-features-in-sql-server-2025/

Featured in Issue #206 May 28, 2025

Issue also covered: ASP.NET Core, Azure, C#, Design Patterns, .NET Core, EF Core, GitHub Copilot, Minimal APIs

Read this issue →

Mastering Named, Positional, and Input/Output Parameters in Stored Procedures with EF Core

https://www.c-sharpcorner.com/article/mastering-named-positional-and-inputoutput-parameters-in-stored-procedures-wi/

Featured in Issue #204 May 26, 2025

Issue also covered: Azure, Azure Functions, Blazor, Cosmos DB, C#, Design Patterns, .NET 9, EF Core

Read this issue →

Mastering Time Zone Comparison in C# 12 and .NET 8 with SQL Server

https://medium.com/@ashokreddy343/mastering-time-zone-comparison-in-c-12-and-net-8-with-sql-server-2817c4e3110e

Featured in Issue #195 May 13, 2025

Issue also covered: ASP.NET Core, .NET Aspire, Blazor, C#, .NET 9, EF Core, JWT, OpenAI

Read this issue →

Efficiently and Elegantly Modeling Embeddings in Azure SQL and SQL Server

https://devblogs.microsoft.com/azure-sql/efficiently-and-elegantly-modeling-embeddings-in-azure-sql-and-sql-server/

Featured in Issue #194 May 12, 2025

Issue also covered: Azure, Domain-Driven Design, EF Core, GitHub Copilot, Kafka, OpenTelemetry, Performance

Read this issue →

Building an E-Commerce Chatbot in ASP.NET Using SQL Server

https://www.c-sharpcorner.com/blogs/building-an-ecommerce-chatbot-in-asp-net-using-sql-server

Featured in Issue #192 May 08, 2025

Issue also covered: ASP.NET Core, Azure, Clean Architecture, C#, Event Sourcing, Performance, REST API, Security

Read this issue →

Dapper Micro ORM: A Lightweight Alternative to Stored Procedures

https://medium.com/@dharmikginoya/dapper-micro-orm-a-lightweight-alternative-to-stored-procedures-333163650d19

Featured in Issue #191 May 07, 2025

Issue also covered: ASP.NET Core, Azure, Azure DevOps, Azure Functions, Cosmos DB, C#, Dapper, Design Patterns

Read this issue →

EF Core 9 with SQL Server: Temporal Tables and Owned Entities

https://gunesramazan.medium.com/using-temporal-tables-and-owned-entities-in-sql-server-with-ef-core-9-8b539c5054ca

Featured in Issue #190 May 06, 2025

Issue also covered: C#, .NET 10, .NET 9, .NET Core, EF Core, ML.NET, OpenAI, Performance

Read this issue →

Advanced Database Programming with C# 14 and Microsoft SQL Server

https://www.c-sharpcorner.com/article/advanced-database-programming-with-c-sharp-14-and-microsoft-sql-server/

Featured in Issue #188 May 02, 2025

Issue also covered: ASP.NET Core, Azure, C#, Dapper, Design Patterns, Docker, EF Core, .NET MAUI

Read this issue →

SQL Server CLR Integration and SSIS Automation with C#

https://www.c-sharpcorner.com/article/sql-server-clr-integration-and-ssis-automation-with-c-sharp/

Featured in Issue #184 April 28, 2025

Issue also covered: ASP.NET Core, Azure, C#, Dapper, .NET 10, .NET 9, EF Core, Kafka

Read this issue →

Why would I add vectors to a relational database?

https://www.youtube.com/watch?v=vHhKEN7Ru_k

Featured in Issue #177 April 17, 2025

Issue also covered: ASP.NET Core, Azure, Azure Functions, Blazor, EF Core, Minimal APIs, OpenAI, Performance

Read this issue →

Create Foreign Keys Dynamically in SQL Server Database

https://www.c-sharpcorner.com/article/create-foreign-keys-dynamically-in-sql-server-database/

Featured in Issue #176 April 16, 2025

Issue also covered: .NET Aspire, Azure, Azure Functions, Blazor, C#, .NET 9, EF Core, GitHub Copilot

Read this issue →

Efficient SQL Query to Remove Duplicates with ROW_NUMBER

https://www.c-sharpcorner.com/blogs/efficient-sql-query-to-remove-duplicates-with-rownumber

Featured in Issue #172 April 10, 2025

Issue also covered: ASP.NET Core, AutoMapper, Azure, Blazor, C#, .NET Core, EF Core, GitHub Copilot

Read this issue →

SQL Optimization: Filter Data Before or During a JOIN?

https://www.c-sharpcorner.com/Blogs/sql-optimization-filter-data-before-or-during-a-join

Featured in Issue #171 April 09, 2025

Issue also covered: ASP.NET Core, C#, .NET 8, .NET 9, GitHub, Security, Visual Studio

Read this issue →

Understanding Parameter Sniffing in SQL Server

https://www.csharp.com/article/understanding-parameter-sniffing-in-sql-server/

Featured in Issue #166 April 02, 2025

Issue also covered: ASP.NET Core, Azure DevOps, C#, Design Patterns, .NET 10, GitHub Copilot, .NET MAUI, OpenAI

Read this issue →

Understanding SQL Execution Plans

https://www.csharp.com/article/understanding-sql-execution-plans/

Featured in Issue #159 March 24, 2025

Issue also covered: ASP.NET Core, Azure, Clean Architecture, C#, .NET Core, Event Sourcing, MediatR, Minimal APIs

Read this issue →

Temp Tables vs. Table Variables vs. CTEs: Which One Should You Really Use?

https://medium.com/@riturajpokhriyal/temp-tables-vs-table-variables-vs-ctes-which-one-should-you-really-use-b427679038cd

Featured in Issue #156 March 19, 2025

Issue also covered: ASP.NET Core, Azure, C#, Dapper, .NET 8, .NET 9, .NET MAUI, Minimal APIs

Read this issue →

Efficient SQL Query to Remove Duplicates with ROW_NUMBER

https://www.csharp.com/Blogs/efficient-sql-query-to-remove-duplicates-with-rownumber

Featured in Issue #147 March 06, 2025

Issue also covered: ASP.NET Core, C#, .NET 10, .NET Core, EF Core, GitHub, Performance, Security

Read this issue →

Boost SQL Server Performance with Memory-Optimized Tables

https://www.csharp.com/article/boost-sql-server-performance-with-memory-optimized-tables/

Featured in Issue #146 March 05, 2025

Issue also covered: ASP.NET Core, Azure, Azure Functions, CQRS, C#, .NET 9, .NET Core, EF Core

Read this issue →

Reduce NULL Storage in SQL Server with Sparse Columns

https://www.csharp.com/article/reduce-null-storage-in-sql-server-with-sparse-columns/

Featured in Issue #135 February 18, 2025

Issue also covered: ASP.NET Core, Benchmarking, C#, EF Core, .NET MAUI, Newtonsoft.Json, Performance, System.Text.Json

Read this issue →

Related topics