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 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
-
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...
-
Building an ASP.NET GridView with DatePicker Filter and WebMethod Dropdown
c-sharpcorner.com 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.com 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-sharpcorner.com 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
dotnetfullstackdev.medium.com Issue #258
Scenario:
-
On .NET Live | Supercharge your SQL development with modern .NET
youtube.com Issue #258
Designing Modular Caching Layers in .NET Applications
-
Announcing General Availability of UNISTR function and ANSI SQL || Operator in Azure SQL
devblogs.microsoft.com 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...
-
🔴 VS Code Live - Boost Your SQL Development in VS Code: GitHub Copilot, Containers, and More
youtube.com Issue #257
How to Outsource ASP.NET Development Successfully: A 2025 Guide
-
Announcing SQLDBEntityNotifier: Effortless Real-Time SQL Server Change Tracking for .NET
medium.com Issue #257
I’m excited to announce the release of SQLDBEntityNotifier, a lightweight, event-driven .NET library for SQL Server change tracking…
-
Repeater Control in ASP.NET Web Forms with C#
c-sharpcorner.com Issue #256
Learn how to use the Repeater control in ASP.NET Web Forms with C# to display IPO data from a SQL Server database. This lightweight, customizable control is ideal for simple, flexible, HTML-driven dat...