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.
167 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
-
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…
-
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...