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.
208 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?
Microsoft Dev Blogs 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
Round The Code 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# Corner 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# Corner Issue #492
Compare PostgreSQL vs SQL Server for .NET apps.
-
We Moved from SQL Server to PostgreSQL in a .NET
Medium 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 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 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
Microsoft Dev Blogs 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 9
Newest first
-
FabCon and SQLCon 2026 in Barcelona: Building the data foundation for Microsoft Copilot and agents
Microsoft Azure - Arun Ulag Issue #574
Microsoft Fabric and SQL innovations announced at FabCon and SQLCon Barcelona 2026 help organizations build trusted data foundations for AI. The post FabCon and SQLCon 2026 in Barcelona: Building the ...
-
SQLAlchemy 2.1 brings built-in support for mssql-python
Microsoft Dev Blogs - Matt Hyon Issue #574
We're pleased to share that SQLAlchemy 2.1.0 is now generally available, with built-in support for mssql-python, Microsoft's Python driver for SQL Server. You can now use it with SQLAlchemy's ORM and ...
-
How to Prevent Duplicate API Requests in ASP.NET Core Using Idempotency Keys
C# Corner Issue #574
Learn how to prevent duplicate ASP.NET Core API operations with idempotency keys, request validation, stored responses, and SQL Server persistence.
-
Azure SQL: Choosing the Right Platform for Your SQL Server Workload
C# Corner - Skant Gupta Issue #573
PENDING REVIEW: MICROSOFT ARTICLE UNRETRIEVABLE (INSUFFICIENT FULL TEXT)
-
Public Preview: Auto-pause and auto-resume for Azure SQL Database Hyperscale Serverless
Microsoft Tech Community - kendalvandyke Issue #573
PENDING REVIEW: MICROSOFT ARTICLE UNRETRIEVABLE (HTTP 403). Auto-pause and auto-resume are now available in public preview for Azure SQL Database Hyperscale databases using the Serverless compute tier...
-
DiskANN Vector Index and Vector Search Are Now Generally Available in Azure SQL
Microsoft Dev Blogs - Pooja Kamath Issue #572
Today, we are announcing the general availability of DiskANN Vector Index & Search across Azure SQL Database, Azure SQL Managed Instance with the always-up-to-date update policy, and SQL database in M...
-
How to Add Health Checks to an ASP.NET Core Application
C# Corner Issue #571
Learn to add ASP.NET Core health checks, verify SQL Server connectivity, and expose separate liveness and readiness endpoints for production monitoring.
-
What's new across Microsoft SQL at SQLCon/FabCon Europe 2026
Microsoft Dev Blogs - Anna Hoffman Issue #571
Live From Barcelona Woo! I’m posting this live from the first ever European SQLCon (joint conference with FabCon EU), and the second ever SQLCon. The energy here is great, as the community comes toget...
-
MSSQL Extension for VS Code: New Getting Started Page, Agent skills, SQL Formatter, and more
Microsoft Dev Blogs - Yo-Lei Chen Issue #571
Get started faster with common SQL workflows and resources in one place. The MSSQL extension for VS Code v1.46 introduces a new Getting Started page experience in Public Preview with quick actions, gu...
-
Azure SQL Migration: How to Assess SQL Server Before Moving to Azure
C# Corner - Skant Gupta Issue #570
PENDING REVIEW: MICROSOFT ARTICLE UNRETRIEVABLE (INSUFFICIENT FULL TEXT)
-
Azure SQL Automatic Index Compaction: Less Index Maintenance
C# Corner - Niharika Gupta Issue #568
-
1B row vector search in less than a second with Azure SQL Database Hyperscale | Data Exposed
YouTube - Microsoft Developer Issue #567
Learn about vector indexing in Microsoft SQL from the PM and engineering team. ✅ Chapters: 0:00 Intro to Product Management and Engineering vector team 1:13 What things were customers asking for. Exam...
-
A Birthday Is Not a Timestamp
Medium - Subhankar karmakar Issue #566
The Angular, ASP.NET Core, and SQL Server mistake that turns October 15 into October 14, and the design change that fixes it.
-
Complete Guide: Securing MS SQL Server on Ubuntu with Fail2Ban
C# Corner - Sardar Mudassar Ali Khan Issue #562
-
Azure SQL Data Sync After a Database Restore: Troubleshooting Leftover Sync Metadata
Microsoft Tech Community - Mohamed_Baioumy_MSFT Issue #560
Recently, I worked on an interesting Azure SQL Data Sync issue that I thought was worth sharing with the community. The scenario looked straightforward at first: a database had been restored from anot...
-
The Real Cost of Returning the Identity Value in EF Core
Medium - Anton Martyniuk Issue #555
When you insert thousands of rows into SQL Server with Entity Framework Core, performance drops quickly. Continue reading on CodeX »
-
PostgreSQL to SQL Field Notes: Date & Time
Microsoft Dev Blogs - Jerry Nixon Issue #554
Welcome to SQL First, welcome to SQL! You're going to like this. Upgrading from PostgreSQL is real work, and depending on your old PostgreSQL, that process ca
-
Agentic RAG and chat completion in the Microsoft SQL engine | Data Exposed
YouTube - Microsoft Developer Issue #550
Learn how you can use various capabilities within Microsoft SQL (SQL Server, Azure SQL, SQL DB in Fabric) to do things like chat completion, and integrate with Microsoft Foundry, Gateway, and Teams. ✅...
-
EF Core vs Dapper vs ADO.NET: Stop Picking Sides, Start Picking the Right Tool
Medium - Santanu Chandra Issue #550
Three ways to talk to SQL Server from .NET, what each one really costs you, and how to choose without starting a religious war in your…
-
E4: Optimize performance and scalability with Azure SQL Database Hyperscale
YouTube 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
Microsoft Dev Blogs 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 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 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# Corner 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 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 ...