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 Page 3 of 9
Browse additional SQL Server for C# and .NET articles from the DotNetNews archive.
SQL Server for C# and .NET articles
Page 3 of 9
Newest first
-
AI-Powered Database Schema Evolution Using Entity Framework Core
C# Corner 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# Corner 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# Corner 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 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# Corner 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# Corner 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 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 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 Issue #483
GUID v7 in SQL Server: Performance Benefits, Limitations, and Best Practices
-
Building AI-Powered SQL Assistants with Semantic Kernel and .NET
C# Corner 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 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# Corner 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# Corner 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
Software Engineering 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# Corner 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
Network Programming in .NET 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
elmah.io Blog - .NET Technical tutorials/guides and new features 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# Corner Issue #474
Learn SQL Server performance tuning techniques including indexing, query optimization, execution plans, statistics management, and database best practices.
-
Give your Agent memory with SQL Server and Microsoft Agent Framework | Data Exposed
YouTube Issue #468
3:20 context provider and history provider with Microsoft Agent Framework 5:04 more details on the history provider and how Microsoft Agent Framework helps
-
Microsoft SQL Security Across the MAESTRO Stack: Building Secure Agentic AI with Defense-in-Depth
Microsoft Dev Blogs Issue #459
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...
-
Introducing Apache Arrow Support in mssql-python
Microsoft Dev Blogs Issue #455
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...
-
-
Slowly Changing Dimensions: The complete SQL guide
Medium Issue #442
Data warehouses are designed to answer one key question: what happened, and what did things look like at that time? This is where Slowly…
-
The Real Cost of Returning the Identity Value in EF Core
Dev Tips Issue #442
Learn why EF Core SaveChanges becomes slow when inserting thousands of rows when returning identity values and how BulkInsert and BulkInsertOptimized from Entity Framework Extensions deliver up to 23x
-
Still writing long SQL queries for every database operation?
Medium Issue #437
What if you could interact with your database using simple C# code?