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.
189 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 8
Newest first
-
E4: Optimize performance and scalability with Azure SQL Database Hyperscale
youtube.com Issue #543
Bob and Anna demo Azure SQL Database Hyperscale’s unique architecture, including independent scaling for compute and storage to help manage changing application demands without disruptions. 0:00: Intr...
-
Advocating for Uptime: The 6 Phases of Change
devblogs.microsoft.com Issue #543
Schema change is inevitable. We do not get everything right the first time, and even when we do, the world around the database keeps changing. Requirements mature, products evolve, and assumptions tha...
-
E3: Build AI apps with Azure SQL Database Hyperscale
youtube.com Issue #543
Bob and Anna demo how to use vector embeddings and vector indexes in Azure SQL Database Hyperscale for more efficient semantic search and retrieval capabilities. 0:00: Introduction: AI in Azure SQL 0:...
-
Tackle real database changes with SQL projects in VS Code | Data Exposed
youtube.com Issue #543
In this Data Exposed episode, we go beyond SQL projects setup and into the day-to-day challenges of making deployable database changes in VS Code. See how IntelliSense catches errors quickly, how refa...
-
Azure SQL Developer Container: Building Offline .NET Development Environments
c-sharpcorner.com Issue #541
Learn how to use the Azure SQL Developer container to build local and offline .NET development environments with consistent database behavior for development and CI/CD.
-
The End of Index Maintenance? | Data Exposed
youtube.com Issue #540
Automatic index compaction (currently in public preview across Azure SQL DB, MI, and SQL database in Fabric) is a game changer for index maintenance. Learn how. ✅ Chapters: 0:00 intro 0:30 what's the ...
-
Filtering EF Core by a Large List: The 2,100 Parameter Wall
codewithmukesh.com Issue #540
EF Core 10 changed how Contains sends a list to SQL Server. Here is the real parameter ceiling, what happens when you cross it, and benchmarks for every fix.
-
SQL Decomposition in a Nutshell
devblogs.microsoft.com Issue #538
Application developers already know what happens when one method does everything: it becomes difficult to read, test, reason over, and safely change. We use patterns like decomposition, encapsulation,...
-
Microsoft.Data.SqlClient Retry Logic: Building Resilient .NET SQL Server Applications
c-sharpcorner.com Issue #535
Learn how to use Microsoft.Data.SqlClient retry logic in .NET to handle transient SQL Server connection failures, improve application resilience, and build reliable database applications.
-
Try the new SqlClient and Retry connections natively
devblogs.microsoft.com Issue #534
The 2002 release of the original .NET Framework shipped ADO.NET and System.Data.SqlClient, the driver for SQL Server that gave .NET applications a standard connection approach. Over the years, updates...
-
Beware of ValueGeneratedOnAdd when using EF
josef.codes Issue #531
How a self-generated GUID had EF marking my brand-new claims as Modified instead of Added, and the one line of config that fixed it.
-
Build Modern and AI-Ready Apps with SQL and GitHub Copilot in VS Code
youtube.com Issue #530
Learn how to go from local development to cloud deployment with a fully functional, AI-ready application powered by SQL Server. In this session, you’ll see how GitHub Copilot in VS Code streamlines da...
-
SQL and AI for Developers in Action
youtube.com Issue #529
Come see the Microsoft team show you the latest innovations for SQL, ground to cloud to fabric, to help you build AI applications securely with your data. This will be a heavy demo-oriented session so...
-
Build a .NET 10 Web API - Minimal APIs, EF Core & SQL Server
roundthecode.com Issue #527
Build a .NET 10 Web API with Minimal APIs, Entity Framework Core and SQL Server, using Clean Architecture and FluentValidation.
-
Beyond Embeddings: Practical Vector Search with DiskANN in SQL Server
youtube.com Issue #526
Vector support in SQL Server opens the door to modern semantic search scenarios—but embeddings alone are rarely enough. In this session, you’ll learn how to store, index, and query vector data in SQL ...
-
Your best friend: BlockOnPossibleDataLoss=True
devblogs.microsoft.com Issue #524
Let's start with an admission: developers all hate BlockOnPossibleDataLoss. It is the bane of a smooth development workflow, as significant schema changes can block deployment because of BlockOnPossib...
-
How to Prevent and Handle SQL Deadlocks in .NET Applications
malshikay.medium.com Issue #522
Deadlocks are a common problem in applications that work with databases.
-
SQL Server Vector Search: Benchmarking EF Core Workloads
c-sharpcorner.com Issue #521
Benchmark SQL Server vector search with EF Core. Explore exact vs. approximate search, performance factors, and best practices for RAG.
-
Database Performance in .NET
medium.com Issue #521
In Part 1, I wrote about boundaries. In Part 2, I wrote about aggregates and invariants. In Part 3, I wrote about domain events. In Part 4…
-
How to Resolve SQL Server Error 40 ("Could Not Open a Connection to SQL Server")
c-sharpcorner.com Issue #519
Resolve SQL Server Error 40 in ASP.NET Core. Troubleshoot connection issues with Entity Framework Core, connection strings, and configuration.
-
Common Mistakes in Manual SQL Database Recovery - Know What Not To Do
c-sharpcorner.com Issue #516
Avoid common SQL database recovery mistakes. Learn best practices for manual recovery, when to use specialized tools, and prevent data loss.
-
Refactor your database with SQL projects in VS Code
devblogs.microsoft.com Issue #514
SQL database projects are a fundamental tool for keeping your database in source control, tracking changes and collaborating on quickly evolving database needs. Not to be forgotten, their superpower i...
-
Understanding Entity Framework Core Migrations
c-sharpcorner.com Issue #511
Master Entity Framework Core Migrations for seamless database schema management. Keep your database in sync with evolving C# models using the Code First approach.
-
Entity Framework Core 11 Migrations: Best Practices for Production Deployments
c-sharpcorner.com Issue #505
Master EF Core 11 migrations for production. Learn best practices for safe deployments, avoiding downtime, and ensuring data integrity.
-
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...