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 4 of 9
Browse additional SQL Server for C# and .NET articles from the DotNetNews archive.
SQL Server for C# and .NET articles
Page 4 of 9
Newest first
-
How C# Strings Silently Kill Your SQL Server Indexes in Dapper
Kevin W. Griffin - Azure & .NET Architect 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# Corner 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 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# Corner 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 Issue #405
How to Crop and Compress Images in PowerPoint Using C#
-
Time Travel in Azure SQL with Temporal Tables
Microsoft Dev Blogs 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 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
Microsoft Dev Blogs 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 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 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 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
Microsoft Dev Blogs 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
Dev Tips 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 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 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# Corner 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 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 Issue #338
.NET Day on Agentic Modernization Coming Soon
-
233× Faster — No Raw SQL Required!
Medium Issue #338
📚 Found this article useful? You’ll love what I have in my store — Shop Now.
-
.NET’s SqlBulkCopy with Python
Medium 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 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
Microsoft Dev Blogs 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# Corner 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 Issue #325
I choose to skip primary constructors altogether, at they offer no real benefit beyond syntactic sugar. Shorter doesn't necessarily mean…