SQL Server for C# and .NET Articles, Tutorials & News
SQL Server for C# and .NET articles, tutorials, and news from the DotNetNews archive.
165 articles Updated
Start here
Editor picks for SQL Server
-
T-SQL Hygiene: What's the Big Deal with SET NOCOUNT ON?
devblogs.microsoft.com Issue #501
One of those database hygiene topics that seems minor until you understand the cumulative effect.
-
Track every EF Core record change with temporal tables
roundthecode.com Issue #499
Temporal tables remain one of the most useful underused SQL Server features, and this walks through the EF Core side clearly.
-
Building AI-Powered Database Query Optimization Tools with SQL Server and .NET
c-sharpcorner.com Issue #493
An interesting blend of SQL Server performance work and AI-assisted tuning; promising if grounded in actual execution data.
-
PostgreSQL vs SQL Server for Modern .NET Applications
c-sharpcorner.com Issue #492
A familiar comparison, but still relevant when teams are picking defaults for new systems.
-
We Moved from SQL Server to PostgreSQL in a .NET
medium.com Issue #483
Real migration writeups are always more useful than abstract comparisons, especially when they include cost and operational reasons.
-
GUID v7 in SQL Server: Performance Benefits, Limitations, and Best Practices
medium.com Issue #483
GUID v7 is getting attention for good reason, but the limitations matter as much as the upside.
-
Give your Agent memory with SQL Server and Microsoft Agent Framework | Data Exposed
youtube.com Issue #468
Interesting if you’re tracking agent memory patterns and want a relational option with SQL Server behind it.
-
Introducing Apache Arrow Support in mssql-python
devblogs.microsoft.com Issue #455
Not .NET-specific, but useful if you move SQL Server data into analytical pipelines and care about transfer efficiency.
SQL Server C# from the DotNetNews archive, curated for .NET developers who already ship production code. This is a reading list pulled from daily issues, not a substitute for the official docs on SQL Server for C# and .NET.
Use Start here for the editorial shortlist, then browse Latest or the full archive when you need more depth. Coverage leans toward SQL Server C#, SQL Server .NET, T-SQL .NET. Recent pieces worth opening: “T-SQL Hygiene: What’s the Big Deal with SET NOCOUNT ON?” and “Track every EF Core record change with temporal tables”.
Latest
Newest SQL Server from the archive
- T-SQL Hygiene: What's the Big Deal with SET NOCOUNT ON?
devblogs.microsoft.com Issue #501
- Track every EF Core record change with temporal tables
roundthecode.com Issue #499
- EF Core and Azure SQL Database: A Step-by-Step Guide
antondevtips.com Issue #498
-
EF Core Interceptors: The Complete Guide (.NET 10)codewithmukesh.com Issue #497
- PostgreSQL vs SQL Server for Modern .NET Applications
c-sharpcorner.com Issue #492
-
AI-Powered Database Schema Evolution Using Entity Framework Corec-sharpcorner.com Issue #490
Archive
Page 1 of 7
Newest first
-
T-SQL Hygiene: What's the Big Deal with SET NOCOUNT ON?
devblogs.microsoft.com Issue #501
Perhaps you have seen SET NOCOUNT ON; at the beginning of a stored procedure and wondered why it is there. By default, SQL Server uses SET NOCOUNT OFF;, which sends messages such as “(10 rows affected...
-
Track every EF Core record change with temporal tables
roundthecode.com Issue #499
Learn how to track every change to your EF Core records using SQL Server temporal tables, with examples for querying the history. The page Track every EF Core record change with temporal tables appear...
-
EF Core and Azure SQL Database: A Step-by-Step Guide
antondevtips.com Issue #498
A step-by-step guide to using EF Core with Azure SQL Database - create the database in Azure Portal, connect and run migrations, add transient-fault resilience, and switch to passwordless Microsoft En
-
EF Core Interceptors: The Complete Guide (.NET 10)
codewithmukesh.com Issue #497
Learn EF Core interceptors in .NET 10 - all 7 types, how to register them, and how to add audit fields, soft deletes, and the current user without breaking dependency injection.
-
Bypassing the .NET GC: How I Hit 2.3 Million OPS With a C#-Native Embedded Database
medium.com Issue #496
DataVo v0.1 Alpha: an open-source, zero-allocation SQL + vector engine that runs in-process, no native extensions required.
-
Building AI-Powered Database Query Optimization Tools with SQL Server and .NET
c-sharpcorner.com Issue #493
Build AI-powered SQL Server query optimization tools with .NET. Automate performance analysis, detect bottlenecks, and get intelligent recommendations.
-
PostgreSQL vs SQL Server for Modern .NET Applications
c-sharpcorner.com Issue #492
Compare PostgreSQL vs SQL Server for .NET apps. Explore licensing, performance, cloud, JSON, and scalability to choose the best fit.
-
AI-Powered Database Schema Evolution Using Entity Framework Core
c-sharpcorner.com Issue #490
Enhance database schema evolution with Entity Framework Core and AI. Reduce risks, improve performance, and automate documentation for safer migrations.
-
Building AI-Powered SQL Query Performance Advisors with Entity Framework Core
c-sharpcorner.com Issue #490
Build AI-powered SQL query advisors with Entity Framework Core to automatically detect bottlenecks, optimize performance, and boost application responsiveness.
-
Building an AI-Driven Database Query Performance Analyzer with .NET and SQL Server
c-sharpcorner.com Issue #490
Build an AI-driven .NET and SQL Server analyzer to boost database query performance, reduce troubleshooting time, and enhance application responsiveness.
-
30 EF Core Interview Questions That Actually Get Asked in 2026
codewithmukesh.com Issue #488
30 real EF Core interview questions with great answers, red flags, and follow-ups. N+1, change tracking, migrations, concurrency - updated for EF Core 10.
-
Mastering .NET Interviews – Part 6: Entity Framework & Data Access
c-sharpcorner.com Issue #487
Master .NET interviews: Dive into Entity Framework (EF) & data access. Learn EF Core, LINQ, migrations, transactions, and common interview questions.
-
Building Autonomous Database Optimization Assistants with .NET and Azure AI
c-sharpcorner.com Issue #486
Build autonomous database optimization assistants with .NET and Azure AI. Enhance performance, reduce manual effort, and enable proactive management.
-
Migrating 200 Million Records in .NET: From Row-by-Row to a Crash-Safe Batched Pipeline
medium.com Issue #485
A real-world walkthrough of how we rewrote a data migration four times before it was production-ready
-
We Moved from SQL Server to PostgreSQL in a .NET
medium.com Issue #483
We moved one of our .NET systems from SQL Server to PostgreSQL mainly to reduce licensing cost and simplify our cloud setup.
-
GUID v7 in SQL Server: Performance Benefits, Limitations, and Best Practices
medium.com Issue #483
GUID v7 in SQL Server: Performance Benefits, Limitations, and Best Practices
-
Building AI-Powered SQL Assistants with Semantic Kernel and .NET
c-sharpcorner.com Issue #482
Build AI-powered SQL assistants with Semantic Kernel and .NET to unlock data insights. Empower users with natural language queries and secure data access.
-
UUID v7 in SQL Server: Can You Really Use It? (The Limitation Nobody Tells You About) Deep Dive
medium.com Issue #482
By Pankaj Ikhar — Solution Architect | Mentor | Coach #LearnWithPankaj | Follow for Career Growth & Interview Preparation
-
How to Build AI-Powered Data Analysts Using Semantic Kernel and .NET
c-sharpcorner.com Issue #482
Build AI-powered data analysts with Semantic Kernel and .NET. Understand natural language, query data, and generate actionable business insights.
-
📖 Building a Web-Based Timesheet Management System in ASP.NET Core
c-sharpcorner.com Issue #480
Build a robust ASP.NET Core MVC timesheet system with SQL Server. Features include entry, allocation, approvals, auth, reporting & deployment.
-
Aspire Azure SQL deployment bug
damienbod.com Issue #478
This week, I was updating my Aspire applications after the latest release and I ran into a deployment bug for my test deployments. I could no longer deploy the database to Azure SQL. I got the followi...
-
Database Sharding in .NET Applications: Benefits, Challenges, and Implementation
c-sharpcorner.com Issue #477
Unlock .NET app scalability with database sharding. Learn benefits, challenges, and implementation strategies for high-growth applications.
-
Thread Pool Exhaustion in ASP.NET: The Async Database Trap
blog.dotnetframework.org Issue #477
If you’ve ever migrated a working ASP.NET application from synchronous database calls to async, and suddenly found yourself hitting connection pool timeouts under load, you’ve likely fallen into one o...
-
The complete guide to mastering Dapper micro-ORM in .NET
blog.elmah.io Issue #476
For developers who want to taste ORM but don't want to leave SQL either, Dapper is a perfect choice. Dapper runs SQL queries like ADO.NET but returns results as C# objects, like Entity Framework Core....
-
SQL Server Performance Tuning Techniques for Modern Applications
c-sharpcorner.com Issue #474
Learn SQL Server performance tuning techniques including indexing, query optimization, execution plans, statistics management, and database best practices.