data access
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
SQL Server C# is the focus of this topic page. SQL Server for C# and .NET is part of the data-access layer most .NET apps rely on, whether the store is relational or document-oriented. Intermediate and senior .NET developers use this hub to scan practical writing without treating every link as an endorsement.
Recurring subtopics in recent issues include SQL Server C#, SQL Server .NET, T-SQL .NET, and EF Core SQL Server. Those themes are drawn from titles and excerpts in the newest archive entries for this tag, not from a marketing outline.
Expect publisher tutorials, release notes, architecture write-ups, and field notes linked from DotNetNews issues. Start here is a short editorial shortlist for SQL Server for C# and .NET; the archive list is chronological and larger. Secondary angles such as SQL Server C# and SQL Server .NET appear when the archive actually covered them. Nearby reading often overlaps with Entity Framework Core and Dapper for C# and .NET.
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
Compare PostgreSQL vs SQL Server for .NET apps.
-
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.
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.