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 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
-
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…
-
Automating User Allotment Data Processing from Emails Using C# and SQL Server
c-sharpcorner.com Issue #313
Automate allotment data processing from emails using C# and SQL Server. This tutorial shows how to read emails, download CSVs, and update your database automatically.
-
Implementing Azure Arc for SQL Server
visualstudiomagazine.com Issue #310
Managing SQL Server across hybrid and multi-cloud environments has long posed a challenge for database administrators. To help meet that challenge, Gilda Alvarez will explain the nuts and bolts at the...
-
Using Linked Servers in SQL Server: A Complete Guide with Examples
c-sharpcorner.com Issue #310
Unlock seamless data integration with SQL Server Linked Servers! This guide provides a step-by-step walkthrough on configuring and querying remote data sources, including examples for SELECT, INSERT, ...
-
How to Recover a SQL Server Database in Emergency Mode (Step-by-Step)
c-sharpcorner.com Issue #310
Learn how to recover a SQL Server database stuck in EMERGENCY mode with this step-by-step guide. Discover how to diagnose corruption using DBCC CHECKDB, repair the database, and restore it to a normal...
-
Auditing Changes in EF Core: Track Who Updated What and When
medium.com Issue #309
A step-by-step guide to logging who updated what and when in your .NET applications.
-
Delete Single or Multiple Records from GridView in ASP.NET
c-sharpcorner.com Issue #309
Learn how to implement single and multiple record deletion in ASP.NET GridView using checkboxes, client-side validation, and a SQL Server stored procedure. This tutorial covers UI design with a GridVi...
-
🚀 Master SQL Server Transaction Log Management — The Smart, Secure, Automated Way!
c-sharpcorner.com Issue #308
Master SQL Server transaction log management! Stop runaway log files from consuming disk space. Learn a safe, automated approach to manage log growth without breaking your backup chain. Includes a fre...
-
CRUD Operations in ASP.NET C# with AngularJS and SQL Server
c-sharpcorner.com Issue #308
Master CRUD operations with ASP.NET C#, AngularJS, and SQL Server! This tutorial guides you through building a complete web application, connecting a dynamic AngularJS frontend to a robust ASP.NET Web...
-
Next-Level SQL in VS Code: GitHub Copilot, Containers & more | Data Exposed
youtube.com Issue #296
Learn how to enhance your SQL development experience with GitHub Copilot, SQL Server containers, and Fabric in this episode of Data Exposed. To wrap things up, we showcase the latest deployment featur...
-
SQL Server 2025 Isn’t Just a Database — It’s Your New AI Platform
towardsdev.com Issue #292
Tired of managing a dozen different services just to add AI features like semantic search or RAG to your application? SQL Server 2025 is… Continue reading on Towards Dev »