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 8 of 9
Browse additional SQL Server for C# and .NET articles from the DotNetNews archive.
SQL Server for C# and .NET articles
Page 8 of 9
Newest first
-
Entity Framework Core Tips: Reduce SQL Server Size and Improve Performance
Medium Issue #177
https://medium.com/@yusufsarikaya023/entity-framework-core-tips-reduce-sql-server-size-and-improve-performance-77e650ae1ec2
-
Create Foreign Keys Dynamically in SQL Server Database
C# Corner Issue #176
https://www.c-sharpcorner.com/article/create-foreign-keys-dynamically-in-sql-server-database/
-
Integrating Elasticsearch with .NET, SQL Server, and Blazor for Advanced Search and Filtering
Medium Issue #176
https://medium.com/@robhutton8/integrating-elasticsearch-with-net-sql-server-and-blazor-for-advanced-search-and-filtering-5d688e84485c
-
Enhancing Search Capabilities in SQL Server and Azure SQL with Hybrid Search and RRF Re-Ranking
Microsoft Dev Blogs Issue #176
https://devblogs.microsoft.com/azure-sql/enhancing-search-capabilities-in-sql-server-and-azure-sql-with-hybrid-search-and-rrf-re-ranking/
-
Explaining Tanspose DataTable Data in C#
C# Corner Issue #176
https://www.c-sharpcorner.com/article/explaining-tanspose-datatable-data-in-c-sharp/
-
Efficient SQL Query to Remove Duplicates with ROW_NUMBER
C# Corner Issue #172
https://www.c-sharpcorner.com/blogs/efficient-sql-query-to-remove-duplicates-with-rownumber
-
Top 20 SQL Best Practices Every Developer Should Follow
csharp.com Issue #172
https://www.csharp.com/blogs/top-20-sql-best-practices-every-developer-should-follow
-
SQL Optimization: Filter Data Before or During a JOIN?
C# Corner Issue #171
https://www.c-sharpcorner.com/Blogs/sql-optimization-filter-data-before-or-during-a-join
-
Performance, security, and tooling
DotNetNews Issue #167
A varied roundup of .NET guides on performance, API security, Azure basics, testing, Blazor, MAUI, and observability for working developers.
-
Understanding Parameter Sniffing in SQL Server
csharp.com Issue #166
https://www.csharp.com/article/understanding-parameter-sniffing-in-sql-server/
-
Understanding SQL Execution Plans
csharp.com Issue #159
https://www.csharp.com/article/understanding-sql-execution-plans/
-
Temp Tables vs. Table Variables vs. CTEs: Which One Should You Really Use?
Medium Issue #156
https://medium.com/@riturajpokhriyal/temp-tables-vs-table-variables-vs-ctes-which-one-should-you-really-use-b427679038cd
-
Efficient SQL Query to Remove Duplicates with ROW_NUMBER
csharp.com Issue #147
https://www.csharp.com/Blogs/efficient-sql-query-to-remove-duplicates-with-rownumber
-
Boost SQL Server Performance with Memory-Optimized Tables
csharp.com Issue #146
https://www.csharp.com/article/boost-sql-server-performance-with-memory-optimized-tables/
-
EF Core 8 & .NET 9 Raw SQL Queries: The Ultimate Guide to Unmapped Types
Medium Issue #146
https://medium.com/@ashokreddy343/ef-core-8-net-9-raw-sql-queries-the-ultimate-guide-to-unmapped-types-1837b225afe2
-
Reduce NULL Storage in SQL Server with Sparse Columns
csharp.com Issue #135
https://www.csharp.com/article/reduce-null-storage-in-sql-server-with-sparse-columns/
-
Logging, CQRS, and DI in .NET
DotNetNews Issue #100
A mixed .NET roundup covering logging, CQRS, saga and DI patterns, ASP.NET Core performance, Azure OpenAI, and SQL Server ETL tips.
-
.NET 9 performance and caching tips
DotNetNews Issue #93
Issue #93 mixes .NET 9 speed notes, SQL Server and Fabric data pieces, ASP.NET Core guidance, and practical caching and DI advice.
-
Azure Functions, Copilot, and package updates
DotNetNews Issue #88
Issue #88 mixes Azure Functions, GitHub Copilot chat in Visual Studio, Central Package Management, SQL Server restore tactics, and .NET security updates.
-
ASP.NET Core, .NET 9 and DevOps picks
DotNetNews Issue #75
A varied issue covering .NET 9 Task.WhenEach, ASP.NET Core BFF and async APIs, GitHub Actions deployment, SQL, Dapper, and performance tips.
-
ASP.NET Core, SQL Server, and C# 13 updates
DotNetNews Issue #73
This issue covers caching, API versioning, middleware, SQL Server obfuscation, and fresh language/runtime updates across the .NET stack.
-
DI, EF Core, and Visual Studio updates
DotNetNews Issue #58
A varied .NET roundup with dependency injection, EF Core SQL Server setup, Visual Studio upgrade guidance, and practical C# tips.
-
ASP.NET security and API testing
DotNetNews Issue #50
Issue #50 covers password protection, HttpClient patterns, validation, integration testing, versioning, logging, JSON, and SQL tips for .NET teams.
-
Routing, caching, and package picks
DotNetNews Issue #49
A varied .NET roundup covering MVC routing, cache invalidation, SQL Server table-valued parameters, feature flags, and handy NuGet tools.
-
AI building blocks, tests, and SQL tuning
DotNetNews Issue #47
A mixed .NET lineup covering Microsoft.Extensions.AI, Verify for assertions, performance tuning, paging patterns, and SQL security.