Advanced EF Core
Advanced techniques for Entity Framework Core including performance optimization and complex mapping.
Advanced techniques for Entity Framework Core including performance optimization and complex mapping.
Functional comparison and selection criteria for Azure SQL Database and Azure SQL Managed Instance
How to check SQL Server clustered indexes, non-clustered indexes, index seek/scan, and execution plans
High-performance data access using Dapper Micro-ORM.
Managing database schema changes and versioning with EF Core Migrations.
Overview of deadlocks, query patterns that cause them, and countermeasures
Explains dotnet ef, a CLI tool for managing Entity Framework Core migrations and database operations.
SQL Server index fragmentation, reorganization, rebuilding, and concerns about using GUIDs as primary keys
Causes, impact, and solutions for parameter sniffing issues in SQL Server