How to Show SQL Server Data in a Delphi DBGrid (FireDAC Step by Step)
Show SQL Server data in a Delphi DBGrid with FireDAC: query, data source and grid, columns, search, sorting, editing, totals and FetchOptions.
Show SQL Server data in a Delphi DBGrid with FireDAC: query, data source and grid, columns, search, sorting, editing, totals and FetchOptions.
How to find SQL Server deadlocks in the system_health session, read the deadlock graph, fix the usual causes (table order, indexes, UPDLOCK, short transactions) and retry error 1205 safely.
The same Laravel queries written with Eloquent, the Query Builder and raw SQL, the SQL each one sends to MySQL, how to fix N+1 queries, safe bindings, and a simple rule for choosing.
How to compare this month with last month and with the same month last year in SQL: LAG for month-over-month, a safe date join for year-over-year, year-to-date totals, and the missing-month trap.
Delphi exception handling explained: try..except vs try..finally, catching specific exceptions, raise and re-raise, custom exceptions, FireDAC errors.
Temp table, table variable or CTE? How each one really works in SQL Server, why table variables can get a 1-row estimate, why a CTE can run twice, and a simple rule for choosing.
OOP in Delphi for beginners: classes, objects, properties, constructors, try..finally with Free, inheritance, virtual methods and TObjectList.
Use parameters in Delphi SQL queries with FireDAC and ADO: ParamByName, data types, NULLs, dates, LIKE, INSERT, and how they stop SQL injection.
Our review of Designing Data-Intensive Applications, 2nd edition, by Martin Kleppmann and Chris Riccomini: what it covers, who it is for, and whether to upgrade.
How to turn rows into columns in SQL: conditional aggregation that works everywhere, the SQL Server PIVOT operator, dynamic pivot, and two ways to unpivot (without losing NULLs).