Search for a command to run...
Articles tagged with #databases
There is a piece of EF Core advice that appears in almost every performance discussion: If the query is read-only, use AsNoTracking(). Its usually good advice. Tracking entities requires EF Core to
A recent pull request that came my way set alarm bells ringing. While reviewing the code, I spotted a familiar anti-pattern hiding in plain sight, a neat little loop that made multiple Entity Framework calls inside it. To some, it looked harmless eno...
Performance tuning has always been a critical yet challenging part of managing SQL Server databases. Traditionally, database administrators relied on manual monitoring, extensive logs, and trial and error methods to track down and resolve bottlenecks...
SQL Server has long been the go to relational database for businesses running applications on premises. With the rise of cloud computing, Microsoft introduced Azure SQL, a managed database service designed to offer flexibility, scalability, and reduc...
