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 5 of 9
Browse additional SQL Server for C# and .NET articles from the DotNetNews archive.
SQL Server for C# and .NET articles
Page 5 of 9
Newest first
-
Recursive Fibonacci Function in C#
C# Corner 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 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# Corner 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
Code With Trev | Blog 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 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# Corner 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 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 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# Corner 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
Visual Studio Magazine 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# Corner 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# Corner 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 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# Corner 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# Corner 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# Corner 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 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 »
-
How I Fixed a .NET Dashboard That Got 300% Slower Overnight
itnext.io Issue #292
Query Store helped me trace regressions, plan changes, and missing indexes — no APM or guesswork required. Continue reading on ITNEXT »
-
Designing, Securing, and Optimizing SQL Server: A Realistic E-Commerce Example
C# Corner Issue #286
Learn schema design principles, indexing strategies for query tuning, and efficient ETL processes for data loading. Implement robust backup and recovery plans, secure your database with role-based acc...
-
Find High-Usage Queries and Stored Procedures in SQL Server
C# Corner Issue #283
Identify the SQL statements and stored procedures that burn the most CPU, IO, and time using SQL Server DMVs—plus quick scripts, filters, and tips to fix them.
-
From SQL Stored Procs to Pure LINQ/Lambda in .NET:
Medium Issue #280
You’ve built everything in Microsoft SQL Server with stored procedures — fast, predictable, and close to the metal. Now you want the same…
-
Creating smart prompts for Azure SQL Copilot to expose the pain | Data Exposed: MVP Edition
YouTube Issue #280
What is Hybrid Cache in .NET 9.0?
-
Entity Framework is a $100 Million Mistake ( We Use Dapper + Raw SQL)
Medium Issue #270
Your database queries are costing you users.
-
SQL Server Index Fragmentation: What It Is and How to Fix
C# Corner Issue #270
Index fragmentation slows SQL Server queries by disrupting data order. This article explains its causes, types, and impact, while offering practical steps to detect, fix, and prevent fragmentation for...