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 Page 2 of 7
Browse additional SQL Server for C# and .NET articles from the DotNetNews archive.
SQL Server for C# and .NET articles
Page 2 of 7
Newest first
-
Give your Agent memory with SQL Server and Microsoft Agent Framework | Data Exposed
youtube.com 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
devblogs.microsoft.com 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
devblogs.microsoft.com 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.com 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
antondevtips.com 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.com Issue #437
What if you could interact with your database using simple C# code?
-
How C# Strings Silently Kill Your SQL Server Indexes in Dapper
consultwithgriff.com Issue #414
A common Dapper pattern that causes SQL Server to ignore your indexes and scan entire tables.
-
Dealing with DB Null: Solving the Object cannot be cast from DB Null to other types Error in C#
c-sharpcorner.com Issue #409
Safely handle DBNull values in C# when querying databases like Oracle or SQL Server. Prevent InvalidCastExceptions with practical examples and extension methods.
-
Smarter Queries Start Here: Vector Search in SQL Server & Azure SQL DB
youtube.com Issue #409
How to Crop and Compress Images in PowerPoint Using C#
-
Dealing with DB Null: Solving the Object cannot be cast from DB Null to other types Error in C#
c-sharpcorner.com Issue #405
Safely handle DBNull values in C# when querying databases like Oracle or SQL Server. Prevent InvalidCastExceptions with practical examples and extension methods.
-
Smarter Queries Start Here: Vector Search in SQL Server & Azure SQL DB
youtube.com Issue #405
How to Crop and Compress Images in PowerPoint Using C#
-
Time Travel in Azure SQL with Temporal Tables
devblogs.microsoft.com Issue #395
Applications often need to know what data looked like before. Who changed it, when it changed, and what the previous values were. Rebuilding that history in application code is tedious and error prone...
-
Azure SQL Managed Instance just got WAY faster - Meet Next gen GP | Data Exposed
youtube.com Issue #391
Microsoft Azure SQL: https://aka.ms/msazuresqlyt In this episode, Anna Hoffman and Uros Milanovic explain how you get lower latency, higher throughput and IOPS, more storage and databases per instanc...
-
Enable Soft Delete in Azure SQL
devblogs.microsoft.com Issue #389
Sometimes applications need to remove data without actually losing it. Soft delete keeps rows in the database while making them invisible to normal application access. This is especially valuable when...
-
REST APIs, Vectors, and AI in SQL Server 2025 | Data Exposed: MVP Edition
youtube.com Issue #384
In this episode, Ben Weissman, a Microsoft MVP and Data Platform expert, dives in REST APIs, vectors, and AI in SQL Server 2025. Microsoft Most Valuable Professionals, or MVPs, are technology experts ...
-
REST APIs, Vectors, and AI in SQL Server 2025 | Data Exposed: MVP Edition
youtube.com Issue #383
In this episode, Ben Weissman, a Microsoft MVP and Data Platform expert, dives in REST APIs, vectors, and AI in SQL Server 2025. Microsoft Most Valuable Professionals, or MVPs, are technology experts ...
-
DiskANN: An overview of vector indexing in Azure SQL and Fabric SQL | Data Exposed
youtube.com Issue #374
Microsoft Azure SQL: https://aka.ms/msazuresqlyt Microsoft SQL Server: https://aka.ms/mssqlserveryt
-
Semantic Reranking with Azure SQL, SQL Server 2025 and Cohere Rerank models
devblogs.microsoft.com Issue #367
Supporting re‑ranking has been one of the most common requests lately. While not always essential, it can be a valuable addition to a solution when you want to improve the precision of your results. U...
-
EF Core Bulk Data Retrieval: 5 Methods You Should Know
antondevtips.com Issue #355
Learn how to efficiently retrieve large datasets in Entity Framework Core without hitting SQL Server's 2,100 parameter limit. Discover 5 bulk data retrieval methods from Entity Framework Extensions th
-
⚡ How a Missing SQL Index Crashed a High-Traffic .NET E-Commerce Platform
medium.com Issue #347
Discover how a single missing SQL index crashed a high-traffic .NET e-commerce platform and the lessons for real-world architecture.
-
Async, DI, and Blazor pitfalls
DotNetNews Issue #344
This issue covers async gotchas, DI guidance, Blazor Server memory leaks, EF Core queries, debugging tricks, and MAUI age verification.
-
⚡ Extremely FAST Paging With Cursor Pagination & Index Seek
medium.com Issue #342
SQL Server • PostgreSQL • MySQL • MongoDB Compared — with Full .NET 9 Code (Part 1)
-
Using ASP.NET Core Data Protection with SQL Server
c-sharpcorner.com Issue #342
Secure ASP.NET Core apps by storing Data Protection keys in SQL Server. Learn to encrypt data, manage keys, and ensure consistency across multiple servers.
-
From EF Core to Dapper — Is Raw SQL Worth the Hype?
medium.com Issue #342
📚 Found this article useful? You’ll love what I have in my store — Shop Now. What’s the story about? Everyone raves about Dapper’s raw…