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 4 of 7
Browse additional SQL Server for C# and .NET articles from the DotNetNews archive.
SQL Server for C# and .NET articles
Page 4 of 7
Newest first
-
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 »
-
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-sharpcorner.com 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-sharpcorner.com 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:
dotnetfullstackdev.medium.com 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.com Issue #280
What is Hybrid Cache in .NET 9.0?
-
Entity Framework is a $100 Million Mistake ( We Use Dapper + Raw SQL)
isitvritra101.medium.com Issue #270
Your database queries are costing you users.
-
SQL Server Index Fragmentation: What It Is and How to Fix
c-sharpcorner.com 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...
-
Entity Framework or Dapper: which one is better for .NET/C#?
medium.com Issue #270
There’s no right answer. Each of these ORMs has its own strengths. However, to figure out which one is more suitable for you at the moment…
-
-
Indexing Internals for Developers and DBAs
visualstudiomagazine.com Issue #270
Microsoft’s Bradley Ball dives into the inner workings of SQL Server indexing to help developers and DBAs speak the same language, avoid common pitfalls, and boost performance with smarter, more inten...
-
SQL Server Features: A Comprehensive Guide for Developers
c-sharpcorner.com Issue #268
Mastering Advanced SQL Server Features: A Comprehensive Guide for Developers
-
Bulk Inserts in .NET: Fast, Lock-Friendly with SqlBulkCopy
medium.com Issue #266
Import millions of records in SQL Server with batching for maximum throughput and minimal locking.
-
Mastering Common Table Expressions (CTEs) in SQL Server
c-sharpcorner.com Issue #266
This article explains SQL Server Common Table Expressions (CTEs), covering benefits, performance, best practices, and real-world examples, helping developers simplify complex queries, improve readabil...
-
SQL Server CLR Integration: Development, Deployment, Security, Architecture, Patterns, and Real-World Use Cases
c-sharpcorner.com Issue #266
Explore SQL Server CLR Integration’s power to bridge .NET and relational databases. Learn best practices, security, and real-world use cases to build scalable, secure, high-performance data-driven app...
-
Building an Invoice Entry System with Angular, ASP.NET Core, Dapper, CQRS, and SQL Server
c-sharpcorner.com Issue #265
Learn how Vibe Coding revolutionizes retail merchandising by replacing static seasonal plans with AI-powered, multi-agent systems that detect trends, align inventory, adjust pricing, and personalize c...