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 2 of 7
Browse additional SQL Server for C# and .NET articles from the DotNetNews archive.
SQL Server for C# and .NET articles
Page 2 of 7
Newest first
-
GUID v7 in SQL Server: Performance Benefits, Limitations, and Best Practices
medium.com Issue #483
GUID v7 in SQL Server: Performance Benefits, Limitations, and Best Practices
-
Building AI-Powered SQL Assistants with Semantic Kernel and .NET
c-sharpcorner.com Issue #482
Build AI-powered SQL assistants with Semantic Kernel and .NET to unlock data insights. Empower users with natural language queries and secure data access.
-
UUID v7 in SQL Server: Can You Really Use It? (The Limitation Nobody Tells You About) Deep Dive
medium.com Issue #482
By Pankaj Ikhar — Solution Architect | Mentor | Coach #LearnWithPankaj | Follow for Career Growth & Interview Preparation
-
How to Build AI-Powered Data Analysts Using Semantic Kernel and .NET
c-sharpcorner.com Issue #482
Build AI-powered data analysts with Semantic Kernel and .NET. Understand natural language, query data, and generate actionable business insights.
-
📖 Building a Web-Based Timesheet Management System in ASP.NET Core
c-sharpcorner.com Issue #480
Build a robust ASP.NET Core MVC timesheet system with SQL Server. Features include entry, allocation, approvals, auth, reporting & deployment.
-
Aspire Azure SQL deployment bug
damienbod.com Issue #478
This week, I was updating my Aspire applications after the latest release and I ran into a deployment bug for my test deployments. I could no longer deploy the database to Azure SQL. I got the followi...
-
Database Sharding in .NET Applications: Benefits, Challenges, and Implementation
c-sharpcorner.com Issue #477
Unlock .NET app scalability with database sharding. Learn benefits, challenges, and implementation strategies for high-growth applications.
-
Thread Pool Exhaustion in ASP.NET: The Async Database Trap
blog.dotnetframework.org Issue #477
If you’ve ever migrated a working ASP.NET application from synchronous database calls to async, and suddenly found yourself hitting connection pool timeouts under load, you’ve likely fallen into one o...
-
The complete guide to mastering Dapper micro-ORM in .NET
blog.elmah.io Issue #476
For developers who want to taste ORM but don't want to leave SQL either, Dapper is a perfect choice. Dapper runs SQL queries like ADO.NET but returns results as C# objects, like Entity Framework Core....
-
SQL Server Performance Tuning Techniques for Modern Applications
c-sharpcorner.com Issue #474
Learn SQL Server performance tuning techniques including indexing, query optimization, execution plans, statistics management, and database best practices.
-
Give your Agent memory with SQL Server and Microsoft Agent Framework | Data Exposed
youtube.com Issue #468
3:20 context provider and history provider with Microsoft Agent Framework 5:04 more details on the history provider and how Microsoft Agent Framework helps
-
Microsoft SQL Security Across the MAESTRO Stack: Building Secure Agentic AI with Defense-in-Depth
devblogs.microsoft.com Issue #459
Artificial Intelligence is evolving rapidly. What began as simple prompt-and-response systems is now transforming into fully autonomous, agentic AI architectures capable of reasoning, orchestrating to...
-
Introducing Apache Arrow Support in mssql-python
devblogs.microsoft.com Issue #455
mssql-python now supports fetching SQL Server data directly as Apache Arrow structures - a faster and more memory-efficient path for anyone working with SQL Server data in Polars, Pandas, DuckDB, or a...
-
-
Slowly Changing Dimensions: The complete SQL guide
medium.com Issue #442
Data warehouses are designed to answer one key question: what happened, and what did things look like at that time? This is where Slowly…
-
The Real Cost of Returning the Identity Value in EF Core
antondevtips.com Issue #442
Learn why EF Core SaveChanges becomes slow when inserting thousands of rows when returning identity values and how BulkInsert and BulkInsertOptimized from Entity Framework Extensions deliver up to 23x
-
Still writing long SQL queries for every database operation?
medium.com Issue #437
What if you could interact with your database using simple C# code?
-
How C# Strings Silently Kill Your SQL Server Indexes in Dapper
consultwithgriff.com Issue #414
A common Dapper pattern that causes SQL Server to ignore your indexes and scan entire tables.
-
Dealing with DB Null: Solving the Object cannot be cast from DB Null to other types Error in C#
c-sharpcorner.com Issue #409
Safely handle DBNull values in C# when querying databases like Oracle or SQL Server. Prevent InvalidCastExceptions with practical examples and extension methods.
-
Smarter Queries Start Here: Vector Search in SQL Server & Azure SQL DB
youtube.com Issue #409
How to Crop and Compress Images in PowerPoint Using C#
-
Dealing with DB Null: Solving the Object cannot be cast from DB Null to other types Error in C#
c-sharpcorner.com Issue #405
Safely handle DBNull values in C# when querying databases like Oracle or SQL Server. Prevent InvalidCastExceptions with practical examples and extension methods.
-
Smarter Queries Start Here: Vector Search in SQL Server & Azure SQL DB
youtube.com Issue #405
How to Crop and Compress Images in PowerPoint Using C#
-
Time Travel in Azure SQL with Temporal Tables
devblogs.microsoft.com Issue #395
Applications often need to know what data looked like before. Who changed it, when it changed, and what the previous values were. Rebuilding that history in application code is tedious and error prone...
-
Azure SQL Managed Instance just got WAY faster - Meet Next gen GP | Data Exposed
youtube.com Issue #391
Microsoft Azure SQL: https://aka.ms/msazuresqlyt In this episode, Anna Hoffman and Uros Milanovic explain how you get lower latency, higher throughput and IOPS, more storage and databases per instanc...
-
Enable Soft Delete in Azure SQL
devblogs.microsoft.com Issue #389
Sometimes applications need to remove data without actually losing it. Soft delete keeps rows in the database while making them invisible to normal application access. This is especially valuable when...