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.
193 articles Updated Page 5 of 8
Browse additional SQL Server for C# and .NET articles from the DotNetNews archive.
SQL Server for C# and .NET articles
Page 5 of 8
Newest first
-
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...
-
Entity Framework or Dapper: which one is better for .NET/C#?
Medium 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
Visual Studio Magazine 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# Corner Issue #268
Mastering Advanced SQL Server Features: A Comprehensive Guide for Developers
-
Bulk Inserts in .NET: Fast, Lock-Friendly with SqlBulkCopy
Medium 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# Corner 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# Corner 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# Corner 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...
-
Building an ASP.NET GridView with DatePicker Filter and WebMethod Dropdown
C# Corner Issue #262
Learn how to build a dynamic ASP.NET GridView with a DatePicker filter and a dropdown populated using WebMethod from SQL Server using C# and AJAX for real-time filtering.
-
On .NET Live | Supercharge your SQL development with modern .NET
YouTube Issue #262
.NET 8 vs .NET 9: Migration Guide and Best Practices
-
COALESCE vs. ISNULL: Better NULL Handling in .NET Apps
itnext.io Issue #259
Compare COALESCE and ISNULL to write cleaner, portable SQL for your .NET data layers. Continue reading on ITNEXT »
-
Monitor Performance by Using the Query Store
C# Corner Issue #259
Query Store in SQL Server helps monitor query performance over time by storing execution plans, runtime stats, and wait times. It enables troubleshooting, plan forcing, and tracking regressions effect...
-
Supercharged Performance with SQL Partitioning & C#: One Strategy, Multiple Tables
Medium Issue #258
Scenario:
-
On .NET Live | Supercharge your SQL development with modern .NET
YouTube Issue #258
Designing Modular Caching Layers in .NET Applications
-
Announcing General Availability of UNISTR function and ANSI SQL || Operator in Azure SQL
Microsoft Dev Blogs Issue #257
We’re excited to announce the General Availability (GA) of two long-standing capabilities that address critical needs for SQL developers and enterprise customers in Azure SQL Database and Azure SQL Ma...