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.
175 articles Updated Page 3 of 7
Browse additional SQL Server for C# and .NET articles from the DotNetNews archive.
SQL Server for C# and .NET articles
Page 3 of 7
Newest first
-
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…
-
Optimistic Locking vs Pessimistic Locking with EF Core (.NET 9): The Clear, Battle-Tested Guide
medium.com Issue #338
.NET Day on Agentic Modernization Coming Soon
-
233× Faster — No Raw SQL Required!
medium.com Issue #338
📚 Found this article useful? You’ll love what I have in my store — Shop Now.
-
.NET’s SqlBulkCopy with Python
cortlandgoffena.medium.com Issue #338
If you’ve ever used Python to interact with SQL Server, you know that Python is treated like a 3rd party citizen. If you’re using…
-
Using sortable UUID / GUIDs in Entity Framework
steven-giesel.com Issue #338
.NET 9 introduced Guid.CreateVersion7() / Guid.CreateVersion7(DateTimeOffset) methods to create sortable UUIDs / GUIDs based on the time of their creation. This can be particularly useful in databases...
-
SQL Server 2025 Embraces Vectors: setting the foundation for empowering your data with AI
devblogs.microsoft.com Issue #332
SQL Server 2025 marks a major milestone in database innovation by introducing native support for VECTOR data types and vector functions. These are now fully available in the freshly released SQL Serve...
-
SQL Server Indexing Strategies for Faster Query Execution
c-sharpcorner.com Issue #326
Boost SQL Server query speed! Master indexing: clustered, non-clustered, composite, filtered, columnstore. Optimize performance & avoid common pitfalls. A must-read!
-
Why I Skip Primary Constructors In C#
medium.com Issue #325
I choose to skip primary constructors altogether, at they offer no real benefit beyond syntactic sugar. Shorter doesn't necessarily mean…
-
Recursive Fibonacci Function in C#
c-sharpcorner.com Issue #325
Explore the recursive Fibonacci sequence implementation in C# WebForms! Learn with code examples, algorithm breakdown, and understand recursion in web development.
-
Building a REST API with .NET and SQL Server — The Clean Way
medium.com Issue #324
When I first started building APIs in .NET, I thought the goal was simple: get data from SQL Server and return it as JSON. It worked — but…
-
How SQL Server Enables Retrieval-Augmented Generation (RAG) Workflows: Embeddings, Vector Indexing & More
c-sharpcorner.com Issue #324
SQL Server 2025 enables Retrieval-Augmented Generation (RAG) workflows with vector indexing, embeddings, and AI integration. Build intelligent, data-driven apps!
-
How Learning SQL Can Open Doors in the Age of Data
trevoirwilliams.com Issue #321
Every click, swipe, and purchase creates data. Every business, from a tiny online shop to global tech giants, is swimming in it. But here’s the catch: only a small percentage of people actually know h...
-
Implementing Vector Search in Your Application with SQL Server 2025 | Data Exposed: MVP Edition
youtube.com Issue #320
Microsoft Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. He is recognized as a VMWare vExpert and a Microsoft Data Platform MVP...
-
MSDTC in C#: Distributed Transaction Explained with Example
c-sharpcorner.com Issue #320
Explore MSDTC in C# for managing distributed transactions across multiple resources like SQL databases. Ensure atomicity: all operations succeed or fail together. Learn with examples!
-
Stop Storing JSON as Text: EF 10 Makes It Native
medium.com Issue #314
Explore EF 10’s support for SQL Server’s new JSON data type Continue reading on .Net Programming »
-
The Great EF Core Trap: ValueGeneratedOnAddOrUpdate vs ValueGeneratedOnAdd
medium.com Issue #314
Why the heck is my ValueGenerator not firing on update?!” If you’ve ever screamed this into your keyboard while staring at your entity…