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 5 of 7
Browse additional SQL Server for C# and .NET articles from the DotNetNews archive.
SQL Server for C# and .NET articles
Page 5 of 7
Newest first
-
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...
-
SQL Best Practices from a .NET Core Developer’s Lens — What I Wish I Knew Earlier
medium.com Issue #253
https://medium.com/@sunita.rawat.cgi/sql-best-practices-from-a-net-core-developers-lens-what-i-wish-i-knew-earlier-b954a8b83a41
-
Temp Tables vs CTEs in SQL Server: What You Should Really Know
c-sharpcorner.com Issue #250
https://www.c-sharpcorner.com/article/temp-tables-vs-ctes-in-sql-server-what-you-should-really-know/
-
Code First vs. Database First: A Pragmatic Guide for Modern Software Engineers
medium.com Issue #241
https://medium.com/@MatinGhanbari/code-first-vs-database-first-a-pragmatic-guide-for-modern-software-engineers-29ac04f1daa1
-
🚀 Automating SQL Server Database Backups and Remote Table Sync
c-sharpcorner.com Issue #241
https://www.c-sharpcorner.com/article/automating-sql-server-database-backups-and-remote-table-sync/
-
Boost SQL Server Performance in .NET: The Hybrid Index Strategy (Part 3)
itnext.io Issue #240
https://itnext.io/boost-sql-server-performance-in-net-the-hybrid-index-strategy-part-3-ebaf40397ed2?source=rss------dotnet-5
-
Why You Must Switch from System.Data.SqlClient to Microsoft.Data.SqlClient Now
medium.com Issue #236
https://medium.com/@nagarajvela/why-you-must-switch-from-system-data-sqlclient-to-microsoft-data-sqlclient-now-3d9ba2a8b9c2
-
How Indexed Views Cut SQL Server Dashboard Load Time by 93% (Part 2)
itnext.io Issue #235
https://itnext.io/how-indexed-views-cut-sql-server-dashboard-load-time-by-93-part-2-82a0463ba462
-
How to Collaboratively Work with SQL Server 2025, Visual Studio Code, and GitHub Copilot (Step-by-Step Guide)
c-sharpcorner.com Issue #225
https://www.c-sharpcorner.com/article/how-to-collaboratively-work-with-sql-server-2025-visual-studio-code-and-github/
-
Build modern data applications with SQL Server 2025 | Data Exposed
youtube.com Issue #220
https://www.youtube.com/watch?v=pckjd-5rT9M
-
Horizontal vs Vertical Partitioning in SQL
c-sharpcorner.com Issue #218
https://www.c-sharpcorner.com/article/horizontal-vs-vertical-partitioning-in-sql/
-
A story of collaborating agents: chatting with your database the right way
devblogs.microsoft.com Issue #218
https://devblogs.microsoft.com/azure-sql/a-story-of-collaborating-agents-chatting-with-your-database-the-right-way/
-
Transactional Messaging in .NET: Integrating Brighter’s Outbox Pattern with SQL Server and RabbitMQ
medium.com Issue #218
https://medium.com/@actor-swe/transactional-messaging-in-net-integrating-brighters-outbox-pattern-with-sql-server-and-rabbitmq-181ae87212cd
-
Use Copilot to Create and Edit Power Fx formulas
c-sharpcorner.com Issue #218
https://www.c-sharpcorner.com/article/use-copilot-to-create-and-edit-power-fx-formulas/
-
Debunking the "Filter Early, JOIN Later" SQL Performance Myth
milanjovanovic.tech Issue #217
https://www.milanjovanovic.tech/blog/debunking-the-filter-early-join-later-sql-performance-myth
-
Using Oracle with Entity Framework
nodogmablog.bryanhogan.net Issue #211
https://nodogmablog.bryanhogan.net/2025/05/using-oracle-with-entity-framework/